SQL/Database ErrorsError

55006

errorCodes.sql-55006.name

errorCodes.sql-55006.description

postgresql

database concurrency

What causes this error

errorCodes.sql-55006.cause

How to fix it

errorCodes.sql-55006.fix

Example

-- 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();

Official Documentation

Related Error Codes

SQL/Database ErrorsError

errorCodes.sql-22003.name

errorCodes.sql-22003.description

SQL/Database ErrorsError

errorCodes.sql-2d000.name

errorCodes.sql-2d000.description

SQL/Database ErrorsError

errorCodes.sql-23514.name

errorCodes.sql-23514.description

SQL/Database ErrorsError

SQLITE_RANGE (25)

errorCodes.sql-sqlite-range.name

errorCodes.sql-sqlite-range.description

SQL/Database ErrorsInfo

SQLITE_EMPTY (16)

errorCodes.sql-sqlite-empty.name

errorCodes.sql-sqlite-empty.description

SQL/Database ErrorsError

errorCodes.sql-22023.name

errorCodes.sql-22023.description