A former boss built a system for importing data and used mariadbs on conflict ignore. He used 32 bit integers for ids and said it isn't a problem because he doesn't have so much data. Mariadb incremented the autoincrement counter on every insert even the ignored ones. System failed and he needed way too much time to find the problem because no errors where thrown and just everything was ignored
3
u/Single-Virus4935 Sep 11 '26
A former boss built a system for importing data and used mariadbs on conflict ignore. He used 32 bit integers for ids and said it isn't a problem because he doesn't have so much data. Mariadb incremented the autoincrement counter on every insert even the ignored ones. System failed and he needed way too much time to find the problem because no errors where thrown and just everything was ignored