MySQL Datetime Implicit Conversion Causing Full Table Scan
An indexed datetime column being ignored, resulting in a full table scan, is very often caused by comparing that column against a value MySQL has to implicitly...
Blog
All troubleshooting articles, newest first.
MySQL "Lock Wait Timeout Exceeded" Try Restarting Transaction
"Lock wait timeout exceeded" is different from a deadlock — it means your transaction waited the full configured timeout for a lock held by another...
MySQL "Out of Sort Memory" Error on Large Queries
MySQL's "out of sort memory" error means a query needing to sort a large result set (via ORDER BY, GROUP BY, or certain join operations) exceeded the memory...
Bash Script Fails With "$'\r': Command Not Found" (CRLF Line Endings)
The $'\r': command not found error is a strong, specific signal of Windows-style line endings (CRLF) in a script meant to run on Linux/Unix, which expects...
Bash set -e Not Exiting Script Inside Function or Subshell
set -e is meant to make a script exit immediately when any command fails, but its actual behavior has several well-documented, specific exceptions where a...
Linux Process Killed Automatically by System (Out of Memory)
A process that just stops running with no crash log, no error message, and no obvious cause is often a strong sign of the Linux kernel's OOM (Out of Memory)...
Linux SSH Connection Hangs on "Authenticating" or Drops Frequently
An SSH connection that hangs specifically during authentication, or that drops unexpectedly after connecting successfully, usually traces back to one of a...
Linux systemd Service Status "Degraded" After Restart
A system-wide "degraded" state in systemd means at least one unit (a service, a mount, a timer) failed to start or exited with an error — it's a summary...
Nginx 504 Gateway Timeout on Long-Running API Request
A 504 Gateway Timeout on a request that's legitimately slow (a large report generation, a heavy computation, a batch operation) means Nginx gave up waiting for...