News for hackers. Stuff that matters.

A comment on Ask HN: Best “I brought down production” story?. Parent comment

Re:Ask HN: Best “I brought down production” story? by chasd00 on Saturday June 26, 2021 @11:29PM (#27648311)
I had a DBA call me on my way back from lunch absolutely sobbing after fat fingering a semicolon before the where clause while logged in to Prod as root.

we got things restored and back online in a couple of hours. I let her go home afterwards, heh she had suffered enough.

[ Parent | on HN ]
Re:Ask HN: Best “I brought down production” story? by rrauenza on Sunday June 27, 2021 @12:24AM (#27648570)
I was taught to also use a transaction and then check how many rows were affected before committing.
[ Parent | on HN ]
Re:Ask HN: Best “I brought down production” story? by sodality2 on Sunday June 27, 2021 @08:51AM (#27651183)
As was Tom Scott: https://youtu.be/X6NJkWbM1xk
[ Parent | on HN ]
Re:Ask HN: Best “I brought down production” story? by rrauenza on Tuesday June 29, 2021 @03:26PM (#27680594)
I wonder if archive.org was around enough back then to capture any of it.
[ Parent | on HN ]
Re:Ask HN: Best “I brought down production” story? by chasd00 on Sunday June 27, 2021 @09:17AM (#27651335)
Many mistakes were made prior in order to get her in the situation to begin with. The semicolon was just the icing on the cake.
[ Parent | on HN ]