News for hackers. Stuff that matters.

A comment on Atlassian: We estimate the rebuilding effort to last for up to 2 more weeks. Parent comment

Re:Atlassian: We estimate the rebuilding effort to last for ... by bmurphy1976 on Monday April 11, 2022 @02:54PM (#30993066)
Bonus tip: don't even type COMMIT until after you've run a few select queries to verify the data has in fact changed how you expected it to change.
[ Parent | on HN ]
Re:Atlassian: We estimate the rebuilding effort to last for ... by beart on Monday April 11, 2022 @03:14PM (#30993342)
super duper bonus tip: Don't execute SQL in a production environment that you just typed out on the fly.
[ Parent | on HN ]
Re:Atlassian: We estimate the rebuilding effort to last for ... by sergiotapia on Monday April 11, 2022 @07:51PM (#30996762)
I fucked up once and lost 2 hours of customer data. I was so lucky we were a small startup and had daily backups AND the backup was only 2 hours old. I would have been royally fucked. Never making that mistake again.

Always use a copy of prod on a staging server and run your queries there for testing.

[ Parent | on HN ]
Re:Atlassian: We estimate the rebuilding effort to last for ... by mdoms on Monday April 11, 2022 @05:49PM (#30995560)
It's incredibly depressing how common this is in the real world, but I can tell you from experience that this NEVER happens in Atlassian production systems.
[ Parent | on HN ]