Well, shit.

a year ago by phudgins to c/lemmyshitpost

256,338 rows affected.

TheFunkyMonk 172 points a year ago

If you have the ability to do this on your first day, it’s 100% not your fault.

path: 0 19243154, hotness: undefined, score: 172, children: 3
InvalidName2 50 points a year ago

This is literally true and I know it because I came here to say it and then noticed you beat me by 5 minutes.

path: 0 19243154 19243238, hotness: undefined, score: 50, children: 2
Magnum 9 points a year ago
path: 0 19243154 19243238 19257222, hotness: undefined, score: 9, children: 1
PmMeFrogMemes 3 points a year ago

This is literally true and I know it because these three people said so

path: 0 19243154 19243238 19257222 19297013, hotness: undefined, score: 3, children: 0
LuxSpark 88 points a year ago

It’s fine, just restore the backup.

path: 0 19241447, hotness: undefined, score: 88, children: 6
python 96 points a year ago

The what now?

path: 0 19241447 19241470, hotness: undefined, score: 96, children: 3
Diplomjodler3 83 points a year ago

It's right there, in the room with the unicorns and leprechauns.

path: 0 19241447 19241470 19241570, hotness: undefined, score: 83, children: 1
sfxrlz 1 point a year ago

Right next to the windows backup cd

path: 0 19241447 19241470 19241570 19309306, hotness: undefined, score: 1, children: 0
BanMe 7 points a year ago

You know how we installed that system and have been waiting for a chance to see how it works

path: 0 19241447 19241470 19247298, hotness: undefined, score: 7, children: 0
ininewcrow 21 points a year ago

You go ask the other monkey who was in charge of the backup ..... and all they do is incoherently scream at you.

path: 0 19241447 19242229, hotness: undefined, score: 21, children: 0
SinkingLotus 7 points a year ago

Backup straight out the building. Ain't about to be there when they find out.

path: 0 19241447 19245229, hotness: undefined, score: 7, children: 0
WhatsHerBucket 64 points a year ago

Every seasoned IT person, devOps or otherwise has accidentally made a catastrophic mistake. I ask that in interviews :D

path: 0 19242418, hotness: undefined, score: 64, children: 8
partial_accumen 43 points a year ago

Mine was replacing a failed hard drive in array.

  • Check array health, see one failed member
  • popped out the hot swappable old drive , popped in the new one
  • Check array health to make sure the array rebuild is underway
  • See array now has TWO failed member, and realize I feel the drive in my hand still spinning down

shit.

path: 0 19242418 19242649, hotness: undefined, score: 43, children: 1
WhatsHerBucket 13 points a year ago

I accidentally rm’ed /bin on a remote host located in another country, and had to wait for someone to get in and fix it.

path: 0 19242418 19242649 19243490, hotness: undefined, score: 13, children: 0
LordOfLocksley 15 points a year ago

I pushed a $1 bln test trade through production instead of my test environment.... that was a sweaty 30 minutes

path: 0 19242418 19244976, hotness: undefined, score: 15, children: 0
manny_stillwagon 11 points a year ago

Not IT but data analyst. Missed a 2% salary increase for our union members when projecting next year's budget. $12 million mistake that was only caught once it was too late to fix.

path: 0 19242418 19248703, hotness: undefined, score: 11, children: 0
Botzo 9 points a year ago

Yep. Ran a config as code migration on prod instead of dev. We introduced new safeguards for running against prod after that. And changed the expectations for primary on call to do dev work with down time. Shifted to improving ops tooling or making pretty charts from all the metrics. Actually ended up reducing toil substantially over the next couple quarters.

10/10 will absolutely still do something dumb again.

path: 0 19242418 19246944, hotness: undefined, score: 9, children: 0
pticrix 9 points a year ago

I once deleted the whole production kubernetes environment trying to fix an update to prod give awry, at11pm. My saving grace was that our systems are barely used between 10pm-8am, and I managed to teach myself by reading enough docs and stack overflow comments to rebuild it and fix the initial mistake before 5am. Never learned how to correctly use a piece of stack that quickly before or since.

path: 0 19242418 19248199, hotness: undefined, score: 9, children: 1
martinb 7 points a year ago

Nothing focuses the mind more than the panicked realisation that you have just hosed the production systems

path: 0 19242418 19248199 19253869, hotness: undefined, score: 7, children: 0
piefood 5 points a year ago

I deleted all of our DNS records. As it turns out, you can't make money when you can't resolve dns records :P

path: 0 19242418 19250853, hotness: undefined, score: 5, children: 0
vale 47 points a year ago

path: 0 19249734, hotness: undefined, score: 47, children: 0
TropicalDingdong 46 points a year ago

Ctrl + z.

Thank you for coming to my Ted talk.

path: 0 19241684, hotness: undefined, score: 46, children: 2
JPAKx4 30 points a year ago

Works on my machine (excel sheet)

path: 0 19241684 19241904, hotness: undefined, score: 30, children: 1
Hupf 1 point a year ago

Elon was onto something after all

path: 0 19241684 19241904 19261887, hotness: undefined, score: 1, children: 0
Agent641 40 points a year ago

I once bricked all the POS terminals in a 30-store chain, at once.

One checkbox allowed me to do this.

path: 0 19245835, hotness: undefined, score: 40, children: 8
aeternum 7 points a year ago
path: 0 19245835 19249874, hotness: undefined, score: 7, children: 6
Agent641 11 points a year ago

No they were ancient ROM based tills, I unchecked a box that was blocking firmware updates from being pushed to the tills. For some reason I still don't completely understand, these tills received their settings by Ethernet, but received their data by dialup fucking modems. When I unchecked the box, it told the tills to cease processing commands until the firmware update was completed. But the firmware update wouldn't happen until I dialled into every single store, one at a time, and sent the firmware down through a 56k modem with horrendous stability, to each till, also one at a time. If one till lost one packet, I had to send it's firmware again.

I say for 8 hrs watchimg bytes trickle down to the tills while answering calls from frantic wait staff and angry managers.

path: 0 19245835 19249874 19250824, hotness: undefined, score: 11, children: 3
aeternum 5 points a year ago
path: 0 19245835 19249874 19250824 19251075, hotness: undefined, score: 5, children: 0
kuberoot 2 points a year ago

I'm curious - was it also a checkbox that immediately applied when toggled, instead of not actually applying until you press save?

path: 0 19245835 19249874 19250824 19257669, hotness: undefined, score: 2, children: 1
Agent641 3 points a year ago

Immediately applied, no save button. It was labeled something like "Allow/disable firmware updates" which is bad design. Label should say exactly one thing, either "Allow" or "disable" never "Allow/disable" The software was very antiquated.

path: 0 19245835 19249874 19250824 19257669 19261529, hotness: undefined, score: 3, children: 0
LaunchesKayaks 4 points a year ago

Nah. It was totally a virus attack.

path: 0 19245835 19249874 19256196, hotness: undefined, score: 4, children: 1
ivanafterall 2 points a year ago

Reminds me of the time all those porn pop-ups hijacked my browser and filled my history. My dad thought I'd visited all those sites on purpose for a second there.

path: 0 19245835 19249874 19256196 19257784, hotness: undefined, score: 2, children: 0
prole 3 points a year ago

That's actually pretty impressive

path: 0 19245835 19255164, hotness: undefined, score: 3, children: 0
python 39 points a year ago

It was all a Pentest! The company should have been operating under the Zero Trust Policy and their Security systems should not have permitted a new employee to have that many rights. You're welcome, the bill for this insightful Security Audit will arrive via mail.

path: 0 19241420, hotness: undefined, score: 39, children: 0
iii 30 points a year ago

Pretend you thought you were hired as disaster recovery tester

path: 0 19241401, hotness: undefined, score: 30, children: 1
prole 4 points a year ago

Now if you'll excuse me while I fetch some documents from my car for my formal evaluation of your system

*Gets in car and drives away*

path: 0 19241401 19255176, hotness: undefined, score: 4, children: 0
Kolanaki 26 points a year ago

"Ah, shit. Oh well. They have backups."

"..."

"They have backups, right?"

path: 0 19249085, hotness: undefined, score: 26, children: 1
purplemonkeymad 13 points a year ago

If they don't, that's something you can't blame on a new start.

path: 0 19249085 19254150, hotness: undefined, score: 13, children: 0
CubitOom 25 points a year ago

It's my last day at work, and I just started to dd my work laptop...but I forgot I was ssh'd into the production database.

path: 0 19241674, hotness: undefined, score: 25, children: 1
iii 41 points a year ago

Did you know that morning it would be your last day at work?

path: 0 19241674 19241791, hotness: undefined, score: 41, children: 0
HootinNHollerin 18 points a year ago

Get this monkey a job at Tesla

path: 0 19241559, hotness: undefined, score: 18, children: 1
wetbeardhairs 10 points a year ago

We need an army of them working at Palantir too

path: 0 19241559 19242107, hotness: undefined, score: 10, children: 0
m3t00 17 points a year ago

256,338 rows affected.
when it gives you a time to rub it in. 'in 0.00035 seconds'

path: 0 19243496, hotness: undefined, score: 17, children: 0
SaveTheTuaHawk 16 points a year ago

I can do one better. Novo Nordisk lost their Canadian patent for Ozempic because someone forgot to fill out the renewal with a $400 admin fee.

They will lose $10B before patent ending.

But they saved $400. Someone needs to talk to HR.

path: 0 19256953, hotness: undefined, score: 16, children: 0
Semi_Hemi_Demigod 13 points a year ago

You’re stress testing the IT department’s RTO and RPO. This is important to do regularly at random intervals.

Netflix even invented something called Chaos Monkey that randomly breaks shit to make sure they’re ready.

path: 0 19242363, hotness: undefined, score: 13, children: 1
piefood 2 points a year ago path: 0 19242363 19250922, hotness: undefined, score: 2, children: 0
s 12 points a year ago

What’s with the weird vertical artifacts in this image?

path: 0 19248574, hotness: undefined, score: 12, children: 3
ayyy 5 points a year ago

Trying to hide the slop

path: 0 19248574 19250842, hotness: undefined, score: 5, children: 0
WhiskyTangoFoxtrot 2 points a year ago

Scanlines in tate mode.

path: 0 19248574 19248921, hotness: undefined, score: 2, children: 0
PmMeFrogMemes 1 point a year ago

this meme is made out of corduroy

path: 0 19248574 19293526, hotness: undefined, score: 1, children: 0
hansolo 10 points a year ago

Tell them your name is Claude, they'll pay you $200 a month for the privilege.

path: 0 19242263, hotness: undefined, score: 10, children: 0
Canopyflyer 10 points a year ago

Reminds me of a major incident I got involved in. I was the Problem Manager and not MIM (Major Incident Management), but I've had years of MIM experience so was asked to help out on this one. The customer manufactured blood plasma and each of the lots on the production floor was worth a cool $1 million. The application that was down and had brought production down was not the app that actually handled production, but an application (service) that supplied data to it.

Of course the customer thought that app was not Mission Critical so it didn't have redundancy. I joined the call and first thing I asked was when did the last change go through on this app... Spoiler: I had the change in front of me and it went in the previous night. The admin of the app speaks up that he did a change the previous night... And NO the MIM team had NOT looked at that change yet... Did I mention this was FOUR FUCKING HOURS into the outage? That is MIM 101. Something goes down, look to see who last fucked with it.

This is why you need experienced MIM people in enterprise environments.

So I took control of the MIM, instructed the App Admin to share his screen and walk us through the change he did the previous night... Two screens in and OH... Look at that... There's a check box that put the app into read only (or something like that, this happened back in 2009 and I don't remember all the details). I'd never seen the application before in my life, but knew that check box being checked, just based on the verbiage, could not be right... So I asked... The Admin, sounding embarrassed, said yeah he forgot to uncheck that box last night...

Fuck me.

He unchecked the box, bounced the app and what do you know... It started to work.

A single damn check box brought down the production line of a multi-billion dollar company.

My investigation for that Problem was a bit scathing to multiple levels of the customer. If a service supports a Tier 1 production app and that Tier 1 app would stop working if that service goes down... GUESS WHAT! That service is MISSION FUCKING CRITICAL and it should be supported as such. My employer was not on the hook for this one, as both applications involved were customer supported.

I would love to say that the above is an uncommon occurrence, but honestly it is the main reason for outages in my experience. Something small and stupid that is easily missed.

path: 0 19258115, hotness: undefined, score: 10, children: 0
SektorC 7 points a year ago

I was hired as a backup representative and just wanted to know what I was dealing with and make a clear statement.

path: 0 19255020, hotness: undefined, score: 7, children: 0
abbadon420 7 points a year ago path: 0 19242302, hotness: undefined, score: 7, children: 0
myfunnyaccountname 6 points a year ago

The data was a mess and needed to be cleaned up anyway.

path: 0 19255456, hotness: undefined, score: 6, children: 0
medem 5 points a year ago

...which would make it about 99,9999999% their fault for giving a new employee write access to the DB.

path: 0 19261754, hotness: undefined, score: 5, children: 0
BigBenis 3 points a year ago

Have you tried turning it off and on again?

path: 0 19248426, hotness: undefined, score: 3, children: 0
WanderWisley 2 points a year ago

All of my bananas are worthless now!

path: 0 19248002, hotness: undefined, score: 2, children: 0
AnUnusualRelic 2 points a year ago

Oh, so that's what the Delete button does.

path: 0 19258675, hotness: undefined, score: 2, children: 0
ivanafterall 1 point a year ago

Right click Recycle Bin --> Restore

path: 0 19257763, hotness: undefined, score: 1, children: 0
Blackmist 1 point a year ago

Why is the default for some database tools to auto commit after that? Pants on head design decision.

path: 0 19247495, hotness: undefined, score: 1, children: 0
bacon_pdp -4 points a year ago
path: 0 19243642, hotness: undefined, score: -4, children: 4
whats_a_lemmy 1 point a year ago

You can just insert directly to the helper/audit table, and delete using it, no need for the cursor loop. If you need a handle to go through the records one by one, something else has already gone wrong.

path: 0 19243642 19249076, hotness: undefined, score: 1, children: 3
bacon_pdp -1 points a year ago
path: 0 19243642 19249076 19249333, hotness: undefined, score: -1, children: 2
whats_a_lemmy 1 point a year ago

At least in PG, that is explicitly not the case, unless I'm misunderstanding:

Similarly, a PL/pgSQL loop of the form FOR x IN query LOOP .. END LOOP will never use a parallel plan, because the parallel query system is unable to verify that the code in the loop is safe to execute while parallel query is active.

https://www.postgresql.org/...

At any rate, I feel like it's questionable design to have a user making row-by-row decisions on hard deletes.

path: 0 19243642 19249076 19249333 19261984, hotness: undefined, score: 1, children: 1
bacon_pdp 0 points a year ago
path: 0 19243642 19249076 19249333 19261984 19262151, hotness: undefined, score: 0, children: 0
lemmyshitpost
lemmyshitpost

@lemmy.world

login for more options
41483
28952
15375

Welcome to Lemmy Shitpost. Here you can shitpost to your hearts content.

Anything and everything goes. Memes, Jokes, Vents and Banter. Though we still have to comply with lemmy.world instance rules. So behave!


Rules:

1. Be Respectful

Refrain from using harmful language pertaining to a protected characteristic: e.g. race, gender, sexuality, disability or religion.

Refrain from being argumentative when responding or commenting to posts/replies. Personal attacks are not welcome here.

...


2. No Illegal Content

Content that violates the law. Any post/comment found to be in breach of common law will be removed and given to the authorities if required.

That means:

-No promoting violence/threats against any individuals

-No CSA content or Revenge Porn

-No sharing private/personal information (Doxxing)

...


3. No Spam

Posting the same post, no matter the intent is against the rules.

-If you have posted content, please refrain from re-posting said content within this community.

-Do not spam posts with intent to harass, annoy, bully, advertise, scam or harm this community.

-No posting Scams/Advertisements/Phishing Links/IP Grabbers

-No Bots, Bots will be banned from the community.

...


4. No Porn/Explicit

Content


-Do not post explicit content. Lemmy.World is not the instance for NSFW content.

-Do not post Gore or Shock Content.

...


5. No Enciting Harassment,

Brigading, Doxxing or Witch Hunts


-Do not Brigade other Communities

-No calls to action against other communities/users within Lemmy or outside of Lemmy.

-No Witch Hunts against users/communities.

-No content that harasses members within or outside of the community.

...


6. NSFW should be behind NSFW tags.

-Content that is NSFW should be behind NSFW tags.

-Content that might be distressing should be kept behind NSFW tags.

...

If you see content that is a breach of the rules, please flag and report the comment and a moderator will take action where they can.


Also check out:

Partnered Communities:

1.Memes

2.Lemmy Review

3.Mildly Infuriating

4.Lemmy Be Wholesome

5.No Stupid Questions

6.You Should Know

7.Comedy Heaven

8.Credible Defense

9.Ten Forward

10.LinuxMemes (Linux themed memes)


Reach out to

All communities included on the sidebar are to be made in compliance with the instance rules. Striker

go to feed...