I've had a corrupted index in PostgreSQL preventing a record to be found using one query but retrievable through another query not using the index, took some time to nail it. Recreating the index fixed it.
Quote Tweet
“Crashes are easy to debug. The truly sinister problems are more like brown-outs. They never trigger your monitoring. Nothing quite fails all the way, yet something isn’t working for users. An ominous backlog starts heading at you, like a freight train." ardentperf.com/2022/02/10/a-h
1
1
