4 ms·
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 go
by chasd00 5y ago
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.
- rrauenza 5y agoI was taught to also use a transaction and then check how many rows were affected before committing.
- sodality2 5y agoAs was Tom Scott: https://youtu.be/X6NJkWbM1xk https://youtu.be/X6NJkWbM1xk
- rrauenza 5y agoI wonder if archive.org was around enough back then to capture any of it.
- chasd00 5y agoMany mistakes were made prior in order to get her in the situation to begin with. The semicolon was just the icing on the cake.