by Outcast_Searcher » Wed 14 Aug 2019, 14:33:38
$this->bbcode_second_pass_quote('asg70', 'I') was told that PStarr wasn't banned but that his user data was damaged in a system crash. Why his and no other active poster is beyond me. Karma? Anyway, if that's the case he could have started a new account. It could be that he decided that enough was enough or he would have been too crushed to have a new user with a reset post-counter. Anyway you slice it, this place is better off without him and his broken-record of "corn liquor", "eau de bakken", "demand-dearth", "peak oil caused the credit crisis" kool-aid, suburbanite haterade, and mild climate change denialism.
Thanks for the insight.
Well, I was a mainframe DB2 system programmer at IBM for 17 years (who built and maintained and fixed/recovered the database systems, helped DBA's with problems, etc), so I have some clue about SQL driven databases, which this site uses.
(We had to rebuild 1 test system over that time (of hundreds my team was responsible for), because a DBA we entrusted to back up the core system databases in a system we inherited from an internal IBM shop, did his job improperly (and we promptly took over that responsibility after that). However, we lost little or no customer data, because we just rebuilt the system, and had the DBA's reload all the data, and checked things out. It was inconvenient and a few minor short term test files might have been lost, but nothing existing for over a few days or so. Aside from that fiasco, we never lost a single bit of customer data, even with all the DASD crashes that occurred before RAID systems became standard.)
1). Assuming the posting data from pstarr were being backed up periodically like via unloads, image copies, etc, it's hard for me to understand how ALL of his data was lost due to a crash unless there were some VERY iffy things going on with data backups (perhaps caused by funding issues and lack of staff, etc -- NOT assigning blame, just making an observation. I saw a local IBM credit union lose ALL its computer data to the hard drive crashing in the 80's because they weren't backing up their only hard drive -- where the data WAS their entire business and had legal repercussions, etc. It took WEEKS for them to recover from that one, using manual backup records).
2). It's also surprising to me that his old user id would be completely nonviable for use, even if they had to wipe it, re-establish it, and load his old posts. Now, maybe they couldn't or wouldn't manually reset his post counter to a big number, and that was the issue, as you say.
3). And, not knowing the specifics of the database system driving the SQL for this site, maybe things are COMPLETELY different than mainframe DB2. (I remember thinking poorly of various aspects of Oracle, and of aspects of small system relational database systems over the years).
...
I just find it surprising that such a data catastrophe would happen to only ONE user's data, unless their only backup scheme is separate files for each user or something, and why would a data administrator do that?
But yeah, such a thing would certainly explain why a long term active member might be peeved and leave.
Given the track record of the perma-doomer blogs, I wouldn't bet a fast crash doomer's money on their predictions.