DEV: Disable migration advisory locks in dev and test environment.

DEV: Disable migration advisory locks in dev and test environment.

There is a bug in Rails that leaks an idle PG session which will prevent the dropping of the database.

diff --git a/config/database.yml b/config/database.yml
index c8f4494..32be426 100644
--- a/config/database.yml
+++ b/config/database.yml
@@ -6,6 +6,7 @@ development:
   pool: 5
   timeout: 5000
   checkout_timeout: <%= ENV['CHECKOUT_TIMEOUT'] || 5 %>
+  advisory_locks: false # Disable until https://github.com/rails/rails/issues/40029 has beeen resolved.
   host_names:
     ### Don't include the port number here. Change the "port" site setting instead, at /admin/site_settings.
     ### If you change this setting you will need to
@@ -36,6 +37,7 @@ test:
   min_messages: warning
   pool: 5
   timeout: 5000
+  advisory_locks: false # Disable until https://github.com/rails/rails/issues/40029 has beeen resolved.
   host_names:
     - test.localhost
 

GitHub sha: f08d440e

1 Like