Database: gitlab_paritions_dynamic tables blocking drop of schema

Summary

As of 551a78e7, attempting to perform rake gitlab:db:drop_tables will error out. Deploy and instance, and then perform gitlab-rake gitlab:db:drop_tables, where you will find an error out due to the relation of the tables.

Example Project

gitlab-org/charts/gitlab master pipelines

What is the current bug behavior?

gitlab-rake gitlab:db:drop_tables
rake aborted!
ActiveRecord::StatementInvalid: PG::DependentObjectsStillExist: ERROR:  cannot drop schema gitlab_partitions_dynamic because other objects depend on it
DETAIL:  table gitlab_partitions_dynamic.web_hook_logs_000000 depends on schema gitlab_partitions_dynamic
table gitlab_partitions_dynamic.web_hook_logs_202107 depends on schema gitlab_partitions_dynamic
table gitlab_partitions_dynamic.web_hook_logs_202108 depends on schema gitlab_partitions_dynamic
HINT:  Use DROP ... CASCADE to drop the dependent objects too.

git@gke-production-a4b9oa-toolbox-666c6d899d-5726r:/$ /scripts/db-migrate 
Checking database migrations are up-to-date
Performing migrations (this will initialized if needed)
psql:/srv/gitlab/db/structure.sql:1: ERROR:  schema "gitlab_partitions_dynamic" already exists
rake aborted!
failed to execute:
psql --set ON_ERROR_STOP=1 --quiet --no-psqlrc --file /srv/gitlab/db/structure.sql --single-transaction gitlabhq_production

Please check the output above for any errors and make sure that `psql` is installed in your PATH and has proper permissions.

What is the expected correct behavior?

Schemas as successfully cleared, so that a restoration can proceed.

Relevant logs and/or screenshots

• https://gitlab.com/gitlab-org/charts/gitlab/-/jobs/1847744942

Possible fixes

Add CASCADE to DROP SCHEMA calls within drop_tables function of lib/tasks/gitlab/db.rake