55006 — Object In Use

Wat veroorzaakt deze fout

Another session has a lock or is actively using the object.

Hoe op te lossen

Wait for active queries to finish. Use pg_terminate_backend() if needed. Schedule DDL during maintenance windows.

-- object_in_use: cannot drop database being accessed
-- Disconnect other sessions first
SELECT pg_terminate_backend(pid) FROM pg_stat_activity
  WHERE datname = 'mydb' AND pid <> pg_backend_pid();