RacerX@lemm.ee to Ask Lemmy@lemmy.world · 9 months agoWhat's the worst way you ever broke production?message-squaremessage-square4fedilinkarrow-up10arrow-down10file-text
arrow-up10arrow-down1message-squareWhat's the worst way you ever broke production?RacerX@lemm.ee to Ask Lemmy@lemmy.world · 9 months agomessage-square4fedilinkfile-text
minus-squaretquid@sh.itjust.workslinkfedilinkarrow-up0·edit-29 months agoOne time I was deleting a user from our MySQL-backed RADIUS database. DELETE * FROM PASSWORDS; And yeah, if you don’t have a WHERE clause? It just deletes everything. About 60,000 records for a decent-sized ISP. That afternoon really, really sucked. We had only ad-hoc backups. It was not a well-run business. Now when I interview sysadmins (or these days devops), I always ask about their worst cock-up. It tells you a lot about a candidate.
minus-squareKISSmyOS@feddit.delinkfedilinkarrow-up0·9 months agoI worked for a company where the testing database was also the only backup.
One time I was deleting a user from our MySQL-backed RADIUS database.
DELETE * FROM PASSWORDS;
And yeah, if you don’t have a WHERE clause? It just deletes everything. About 60,000 records for a decent-sized ISP.
That afternoon really, really sucked. We had only ad-hoc backups. It was not a well-run business.
Now when I interview sysadmins (or these days devops), I always ask about their worst cock-up. It tells you a lot about a candidate.
I worked for a company where the testing database was also the only backup.