3 ms·
Running out of autoincrement primary keys. Happened at two companies I was at. Can't say I was responsible for the first one. The second one caught me off guard
by karmakaze 6y ago
Running out of autoincrement primary keys. Happened at two companies I was at. Can't say I was responsible for the first one. The second one caught me off guard, I didn't notice we were incrementing by 2's because all the id's were odd. If they were all even I would have picked up on it. Because of it we ran out in half the expected time so the plan we had got thrown out and we just winged it, in-place on prod machines. Luckily it was only for 'like's on a photo sharing platform, so we just black-holed the clicks, doing a local increment in the view for the person clicking until all the migrations completed many hours later.