Go Interface Conversion Panic (interface is X, Not Y)
An interface conversion panic means a type assertion assumed an interface value held a specific concrete type, but at runtime it actually held a different one...
Blog
All troubleshooting articles, newest first.
Postgres Connection Pool Leak With Node or Python App
A connection pool leak means your application is checking out database connections from the pool but not consistently returning them, so the pool gradually...
Postgres Index Not Being Used on LOWER or UPPER Query
A standard index on a text column doesn't get used when you wrap that column in LOWER() or UPPER() in a query, because a regular index is built on the raw...
Postgres "LOCK TABLE" Deadlock Waiting Forever
An explicit LOCK TABLE statement that just hangs, rather than producing Postgres's usual automatic deadlock error, usually means it's waiting on a lock held by...
PostgreSQL COPY Command Permission Denied on Server
A permission denied error on COPY almost always comes down to confusing server-side COPY (which reads/writes files on the database server's own filesystem,...
PostgreSQL Enum Type Migration Failing in Production
PostgreSQL enum migrations failing specifically in production, despite working fine in local testing, is almost always related to ALTER TYPE ... ADD VALUE's...
Docker Compose Override File Not Applying Environment Variables
When variables in a docker-compose.override.yml file don't seem to take effect, the cause is usually either the file not being picked up automatically due to a...
Docker Container Memory Limit Reached, Killed by OOMKiller
A container killed by the OOMKiller (Out-Of-Memory Killer) means it tried to use more memory than its configured limit allows, and the Linux kernel forcibly...
Docker Container Slow Performance on macOS (Docker Desktop)
Slow Docker performance specifically on macOS, especially with heavy file I/O like Node.js dependency installs or hot-reloading dev servers, comes down to how...