Random
Source Code

backdating damnation

The fiery pit of hell one finds themselves in when attempting to repair massive amounts of poisoned historical database records using the very same dumpster of historical data.

J: Who in the hell backdated unit space logs into locked financial periods? I thought that was never supposed to happen?
L: Our period logging architecture was never meant to have the underlying tables updated directly by the application! The trigger keeps each window internally sequenced, so shifting a reporting post date into the middle of a locked post month will have devastating effects on all the downstream logs.
H: The backdating damnation quandary is clearly taking hold. Fellas you can't unring this bell! There is no undo for `rm -rf /*` and there is no `rollback` if you forgot your `begin`! Talk to the dbas, this is going to be a long night...

by badhorsey June 25, 2020