We ran into this around session cookies when the cache went cold. I expected a tooling problem. It was an assumption in the schema. EXPLAIN and a short rollback window saved the afternoon. Writes slowed first, then a handful of reads timed out. Dropping the unused index and batching the backfill unblocked the queue. I now review write paths with the same care as the happy-path query.
We ran into this around background jobs during a traffic spike. I expected a tooling problem. It was an assumption in the schema. EXPLAIN and a short rollback window saved the afternoon. Writes slowed first, then a handful of reads timed out. Dropping the unused index and batching the backfill unblocked the queue. I now review write paths with the same care as the happy-path query.
We ran into this around CI pipelines after we split the monolith. I expected a tooling problem. It was an assumption in the schema. EXPLAIN and a short rollback window saved the afternoon. Writes slowed first, then a handful of reads timed out. Dropping the unused index and batching the backfill unblocked the queue. I now review write paths with the same care as the happy-path query.
We ran into this around session cookies after we split the monolith. I expected a tooling problem. It was an assumption in the schema. EXPLAIN and a short rollback window saved the afternoon. Writes slowed first, then a handful of reads timed out. Dropping the unused index and batching the backfill unblocked the queue. I now review write paths with the same care as the happy-path query.
We ran into this around background jobs while rolling back payments. I expected a tooling problem. It was an assumption in the schema. EXPLAIN and a short rollback window saved the afternoon. Writes slowed first, then a handful of reads timed out. Dropping the unused index and batching the backfill unblocked the queue. I now review write paths with the same care as the happy-path query.
We ran into this around session cookies on a quiet Sunday incident. I expected a tooling problem. It was an assumption in the schema. EXPLAIN and a short rollback window saved the afternoon. Writes slowed first, then a handful of reads timed out. Dropping the unused index and batching the backfill unblocked the queue. I now review write paths with the same care as the happy-path query.
We ran into this around CI pipelines on a quiet Sunday incident. I expected a tooling problem. It was an assumption in the schema. EXPLAIN and a short rollback window saved the afternoon. Writes slowed first, then a handful of reads timed out. Dropping the unused index and batching the backfill unblocked the queue. I now review write paths with the same care as the happy-path query.
We ran into this around background jobs after the replica failover. I expected a tooling problem. It was an assumption in the schema. EXPLAIN and a short rollback window saved the afternoon. Writes slowed first, then a handful of reads timed out. Dropping the unused index and batching the backfill unblocked the queue. I now review write paths with the same care as the happy-path query.
We ran into this around session cookies during a Friday deploy. I expected a tooling problem. It was an assumption in the schema. EXPLAIN and a short rollback window saved the afternoon. Writes slowed first, then a handful of reads timed out. Dropping the unused index and batching the backfill unblocked the queue. I now review write paths with the same care as the happy-path query.
We ran into this around CI pipelines during a Friday deploy. I expected a tooling problem. It was an assumption in the schema. EXPLAIN and a short rollback window saved the afternoon. Writes slowed first, then a handful of reads timed out. Dropping the unused index and batching the backfill unblocked the queue. I now review write paths with the same care as the happy-path query.
We moved session checks to the edge to cut latency on every page load. It worked in staging, then failed on preview deploys when cookies crossed domains. Clock skew between edge and origin made short-lived tokens look expired. We fixed cookie domains per environment and added skew-tolerant expiry. Median auth path dropped about 120ms, with fewer cold-start surprises. Lesson: test cookies across every environment before calling a migration done.
We moved session checks to the edge to cut latency on every page load. It worked in staging, then failed on preview deploys when cookies crossed domains. Clock skew between edge and origin made short-lived tokens look expired. We fixed cookie domains per environment and added skew-tolerant expiry. Median auth path dropped about 120ms, with fewer cold-start surprises. Lesson: test cookies across every environment before calling a migration done.