Browse incidents, troubleshooting guides, AI diagnostics, verified fixes and community discussions related to SQL.
## Environment PostgreSQL 13.8 on Debian 11 VM (8 vCPU, 32 GB RAM), primary and one logical replica on separate hosts; publisher uses pglogical extension for cross-datacenter replication; WAL archived to local filesystem; nightly bulk import job (CO...
## Environment Primary: PostgreSQL 13 on bare-metal (12 cores, 64GB), Logical replication slot streaming to replica on PostgreSQL 13; large table (~2 TB, 500M rows) in production; ALTER TABLE ADD COLUMN ... DEFAULT X NOT NULL executed during low-tra...
## Environment PostgreSQL 13.5 on Ubuntu 20.04, application server using libpq with prepared statements (persistent prepared transactions), workload: web app that uses a read step (SELECT ... FOR SHARE) under SERIALIZABLE isolation and later issues ...
## Environment Primary: MySQL 8.0.32 on Ubuntu 22.04 (binlog_format=ROW, binlog_checksum=CRC32), Replica: MySQL 8.0.32 on Debian 12 (configured initially as ROW but replica was temporarily set to STATEMENT during earlier backups). GTID-based replica...
## Environment MySQL 8.0.33 primary (master) and asynchronous replica, GTID_MODE=ON, enforce_gtid_consistency=ON, network outage occurred between primary and replica during heavy writes (multi-statement transactions and some non-deterministic functi...