The 2 AM integer overflow
An event log's 32-bit auto-increment ID reaches 2,147,483,647 after about 18 months at 4 million events a day, and inserts fail silently. Why it stays quiet, the emergency fixes and how to choose, UUID and Snowflake IDs, and how to see the ceiling coming.
01 · 2 AM
CASE-005 · The Great ID Crisis: When Auto-Increment Hits the Mathematical Wall
2,147,483,647.
2 AM, cold coffee
It's 2 AM.
0:00 / 10:43