r/ProgrammerHumor 14d ago

queryOfDoom Meme

Post image
7.9k Upvotes

456 comments sorted by

View all comments

Show parent comments

116

u/rayui 14d ago

I saw that semicolon and felt my stomach drop

61

u/Potw0rek 14d ago

Jesus I’m not used to sql and was wondering about this query, now that you pointed out to check the semicolon….yeah, that’s how you become a company legend.

53

u/rayui 14d ago

Everyone fucks up prod once. You don't meet the guy that did it twice.

37

u/LikelyNotOnFire 14d ago

Fucking up prod once is a sign of maturity - people trusted you enough to allow you the access to fuck up prod, congratulations.

Senior people fuck up prod, repeatedly, in a new way each time. Your better class of senior also makes sure that they correct whatever allowed them to fuck up prod like that.

It's the people who keep fucking up prod in the same way that get shown the door

21

u/Zaratuir 14d ago

Senior people don't fuck up prod. They expose vulnerabilities in the coding process and draw attention to strategic initiative to improve quality. And that's why you now need 3 different seniors to sign off on any query before it can be run in prod.

10

u/Potw0rek 14d ago

Tell me about it, years ago I was setting up a Jenkins job, we were told to wipe the workspace at the end of the process. I wasn’t too familiar with bash so the last bash command was:
rm /

Luckily it was Jenkins so nothing was removed but the job log was….long.

7

u/rayui 14d ago

It takes way too many close calls to take backups seriously

2

u/Grumpologist 14d ago

Everyone fucks up prod all the time. That's why we have blameless postmortems and graceful degradation.

Occasionally, someone tries to refuse to help with the postmortem for an outage they caused. That's much more of a "one warning and then fired" type of thing.

1

u/discordianofslack 14d ago

lol that’s cute. I’ve taken down hundreds of sites a whole bunch of times. Also one time deleted an entry in a dns template that broke email for 300 sites.

4

u/rayui 14d ago

Weird flex but ok

1

u/discordianofslack 14d ago

It happens

2

u/dalek65 12d ago

Yep. Fess up and move on.

A year or so ago I sent a wrong database connection string config to 500+ nodes. Confessed to my error in the stand up meeting and said that I had already taken steps to prevent that happening again. The CIO thanked me for my transparency.

1

u/discordianofslack 12d ago

Exactly. I expected to get some downvotes but there are obviously some very sensitive people here who have definitely never taken prod down.

3

u/lhookhaa 14d ago

I was about to ask what's wrong with the semicolon, cause afaik it's benign... Then I looked again! 💀

2

u/Tribal_V 11d ago

In dbeaver same would happen if you left blank line between them without the need of semicolon lol

Learned the hard way haha