Open Discussions about the VoyeurWeb
User avatar
By Administrator
#56460
Hello Voyeurwebbers!

Hope you are all doing well. I wanted to chime in and explain the cause behind the downtime here today.

While running system maintenance, one of our admins accidentally deleted a database user that had all the data from the forums, the support helpdesk, and the wiki. This process deleted all the tables associated with these sections so we had to restore everything from the latest backups that were on our backup servers. We have recovered everything up until about 4/7/2015 5:19 am. We are still tightening things up so you might see intermittent downtime here and there for the next 2 -3 more hours. This error had no effect on anything besides the sections mentioned and nothing was compromised by outside parties. This was an internal staff fuck-up which has been fixed.

Human errors are inevitable and this is just one example of that. Please excuse the inconvenience and thank you for your patience and understanding.
User avatar
By Thinker
#56479
That is freaky. There must be DB cascading deletes on everything. Having the tables deleted seems to be very poor DB design. I do hope you get things straightened out.
User avatar
By Administrator
#56483
The sections that were affected are not reading data off of our primary database cluster.

The database schema set up for these sections are reading and writing off one database server. This servers 'mysql' user was deleted hence the end result with /var/lib/mysql/* getting wiped out.
User avatar
By rockclimber
#56486
Thanks Diego!
long long title how many chars? lets see 123 ok more? yes 60

We have created lots of YouTube videos just so you can achieve [...]

Another post test yes yes yes or no, maybe ni? :-/

The best flat phpBB theme around. Period. Fine craftmanship and [...]

Do you need a super MOD? Well here it is. chew on this

All you need is right here. Content tag, SEO, listing, Pizza and spaghetti [...]

Lasagna on me this time ok? I got plenty of cash

this should be fantastic. but what about links,images, bbcodes etc etc? [...]