Roblox has been down for days and it’s not because of Chipotle

Re:Roblox has been down for days and it’s not because of Chi... by 1cvmask on Sunday October 31, 2021 @05:58PM (#29060849)

Do any other databases have similar issues to Postgres? Or this is specific to Postgres?

[ Parent | on HN ]

Re:Roblox has been down for days and it’s not because of Chi... by ElbertF on Sunday October 31, 2021 @06:35PM (#29061132)

Years ago I ran into this issue with MySQL, storing four billion rows with a unique ID.

[ Parent | on HN ]

Re:Roblox has been down for days and it’s not because of Chi... by arp242 on Sunday October 31, 2021 @11:24PM (#29062737)

This is a different issue. You ran out of IDs for your row identifier. The PostgreSQL issue is that every transaction has an ID; normally this is a fairly invisible internal thing you don't need to worry about, but in some edge cases this transaction ID can causes problems. You could, in theory, run in to this issue with just one row.

I don't know how MySQL or MariaDB handles this; AFAIK it doesn't have this issue.

[ Parent | on HN ]

Re:Roblox has been down for days and it’s not because of Chi... by dreyfan on Sunday October 31, 2021 @09:51PM (#29062318)

Was it because your primary key was an unsigned 32-bit integer and that’s not an “issue”.

[ Parent | on HN ]

Re:Roblox has been down for days and it’s not because of Chi... by ElbertF on Sunday October 31, 2021 @10:32PM (#29062501)

True. Not the same thing but an equally disastrous outcome.

[ Parent | on HN ]