Skip to main content

The worst part of testing the new "Delete everything associated with this account" script for the first time with prod data is that if it fucks up, there goes the prod data.

I tested it a whole bunch in staging and a dev environment though?

silverwizard reshared this.

Welp - I took out prod at 2330 hours

Good thing I got it back within 5 minutes
No backup restore needed! Just a reboot! I just gave the DB infinite load
Test in staging they said!
It's the same as prod they said!

turns out if you run a select on dozens of GBs of data it's a lot more than less than 1 GB
@silverwizard There was no dry run mode to evaluate the amount of data to be deleted?
Dry runs didn't crash, no idea why