The Energon Pub

[Stuartmaximus]

There's a bug floating around, Ryan has been looking into it when he's had a chance (been tied up with NYCC news as well)

Ok, thanks

[Sabrblade]

Was there a board-wide mass eradication of posts conducted last night? I'm looking through my posting history and seeing that virtually every single post I made yesterday has disappeared from the forum. Same with posts I recall others making yesterday; they're all gone too.

[Cobotron]

Ya. October 14th, 2015 never happened.!

[Seibertron]

Seibertron.com's database experienced a major crash late last night / early this morning. After almost 9 hours of trying to resolve the problem over night and into this morning, the site was finally restored from a late Tuesday night back. Unfortunately, all data from the past 36 hours was unable to be restored due to the crash. So basically it's like yesterday never happened here on Seibertron.com. I apologize for the inconvenience and we are looking into further redundancy to help prevent this problem in the future.

If you encounter any further errors, please let us know in the Seibertron.com Problem Reporting Thread in our Energon Pub Forums. Thanks!

See you at TFcon in Charlotte this weekend!

[DedicatedGhostArt]

So can yesterday’s news be restored?

[Seibertron]

So can yesterday’s news be restored?

Unfortunately, no. It happened late at night around 2:30am Central. Our database backups happen at 4:00am so this morning's database backup was incomplete due to the crash (and what was there was junk/unusable). My alternative to backing up to the Tuesday backup was using a backup I have from about a month ago on an offsite server. That was my last resort that I thought I was going to have to use but fortunately I was able to get the Tuesday backup to work finally after some initial problems.

[Kyleor]

So can yesterday’s news be restored?

Unfortunately, no. It happened late at night around 2:30am Central. Our database backups happen at 4:00am so this morning's database backup was incomplete due to the crash (and what was there was junk/unusable). My alternative to backing up to the Tuesday backup was using a backup I have from about a month ago on an offsite server. That was my last resort that I thought I was going to have to use but fortunately I was able to get the Tuesday backup to work finally after some initial problems.

If it might help towards any restoration I have a News RSS feed in my email, so I have the main article picture and initial article paragraph/blurbs.

[Kyleor]

So can yesterday’s news be restored?

Unfortunately, no. It happened late at night around 2:30am Central. Our database backups happen at 4:00am so this morning's database backup was incomplete due to the crash (and what was there was junk/unusable). My alternative to backing up to the Tuesday backup was using a backup I have from about a month ago on an offsite server. That was my last resort that I thought I was going to have to use but fortunately I was able to get the Tuesday backup to work finally after some initial problems.

If it might help towards any restoration I have a News RSS feed in my email, so I have the main article picture and initial article paragraph/blurbs.

Also just saw Google may have a cache of all the articles:

http://webcache.googleusercontent.com/s ... clnk&gl=us

[Emerje]

I guess it doesn't come as a huge surprise since a lot of us have been getting that error that's mentioned earlier in the thread and the servers have been pretty sluggish for a while now.

Emerje

[steve2275]

i lost all of my weapons


still got my armor and energon (but not enough to replace 8 fusion cannons)

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/www/vhosts/seibertron.com/httpdocs/heavymetalwar/character-upgrade.php on line 380

i did get the upgrade tho
http://www.seibertron.com/heavymetalwar ... r_id=84224
lost all 10 repair and 10 strafe

if this is gonna happen just reset the game again already
and on my grandma's 1 year passing none the less

maybe i should just blame the cubbies

[Riot Riverman]

i lost all of my weapons


still got my armor and energon (but not enough to replace 8 fusion cannons)

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/www/vhosts/seibertron.com/httpdocs/heavymetalwar/character-upgrade.php on line 380

i did get the upgrade tho
http://www.seibertron.com/heavymetalwar ... r_id=84224
lost all 10 repair and 10 strafe

if this is gonna happen just reset the game again already
and on my grandma's 1 year passing none the less

maybe i should just blame the cubbies

Nice to know I'm not alone in the lost weapons/upgrades thing.

[Seibertron]

i lost all of my weapons


still got my armor and energon (but not enough to replace 8 fusion cannons)

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/www/vhosts/seibertron.com/httpdocs/heavymetalwar/character-upgrade.php on line 380

i did get the upgrade tho
http://www.seibertron.com/heavymetalwar ... r_id=84224
lost all 10 repair and 10 strafe

if this is gonna happen just reset the game again already
and on my grandma's 1 year passing none the less

maybe i should just blame the cubbies

Nice to know I'm not alone in the lost weapons/upgrades thing.

Some of these tables I'm flyin' blind on whether or not they're repaired with the correct data restored. Check out the weapons table now ... is it back to how it was a couple of days ago now?

Are you still receiving the error that you posted on the character-upgrade page?

[Riot Riverman]

i lost all of my weapons


still got my armor and energon (but not enough to replace 8 fusion cannons)

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/www/vhosts/seibertron.com/httpdocs/heavymetalwar/character-upgrade.php on line 380

i did get the upgrade tho
http://www.seibertron.com/heavymetalwar ... r_id=84224
lost all 10 repair and 10 strafe

if this is gonna happen just reset the game again already
and on my grandma's 1 year passing none the less

maybe i should just blame the cubbies

Nice to know I'm not alone in the lost weapons/upgrades thing.

Some of these tables I'm flyin' blind on whether or not they're repaired with the correct data restored. Check out the weapons table now ... is it back to how it was a couple of days ago now?

Are you still receiving the error that you posted on the character-upgrade page?

Well I got my weapons back, the character profile and upgrade pages are back to normal, but anything in training (ram, repair,etc.) is still zero on my end.

[Seibertron]

Can you post a URL to where you can see that data so that I can backtrace which tables were not restored properly? Thanks.

[Seibertron]

Well I got my weapons back, the character profile and upgrade pages are back to normal, but anything in training (ram, repair,etc.) is still zero on my end.

Are the tactics restored properly now?

[Riot Riverman]

i lost all of my weapons


still got my armor and energon (but not enough to replace 8 fusion cannons)

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/www/vhosts/seibertron.com/httpdocs/heavymetalwar/character-upgrade.php on line 380

i did get the upgrade tho
http://www.seibertron.com/heavymetalwar ... r_id=84224
lost all 10 repair and 10 strafe

if this is gonna happen just reset the game again already
and on my grandma's 1 year passing none the less

maybe i should just blame the cubbies

Nice to know I'm not alone in the lost weapons/upgrades thing.

Some of these tables I'm flyin' blind on whether or not they're repaired with the correct data restored. Check out the weapons table now ... is it back to how it was a couple of days ago now?

Are you still receiving the error that you posted on the character-upgrade page?

Well I got my weapons back, the character profile and upgrade pages are back to normal, but anything in training (ram, repair,etc.) is still zero on my end.

Ok never mind my training stats are back.

[Riot Riverman]

Well I got my weapons back, the character profile and upgrade pages are back to normal, but anything in training (ram, repair,etc.) is still zero on my end.

Are the tactics restored properly now?

Yes, thank you.

[fenrir72]

Question of the ignorant, this was due to hardware failure of the server?

[Seibertron]

Question of the ignorant, this was due to hardware failure of the server?

I don't think so. The server seibertron.com is on is pretty good. This is the longest we've ever been on 1 server before, which I think is due to it being a raid server.

I'm pretty sure this is ultimately just related to the database. To be honest though, I think I'm at the end of my abilities as an amateur server administrator. I know enough to be dangerous, enough to fix problems and enough to run Seibertron.com on a dedicated server for the past 13 years, but I'm not a database administrator. There's no silver bullet to fix the MySQL settings but I'm out of ideas. The database is still has an extreme amount of CPU usage but I'm out of ideas because it seems like nothing I'm changing is solving the problem. If anyone out there is a DBA, I'd love to talk about some suggestions and/or solutions!

[Seibertron]

Also just saw Google may have a cache of all the articles:

http://webcache.googleusercontent.com/s ... clnk&gl=us

Gotta love Google. Thanks to your suggestion, Kyleor, and to Google's cache of Seibertron.com, all of the news stories from yesterday were restored.

http://www.seibertron.com/transformers/news/

If you see that I missed something, please let me know. Sucks we lost yesterday's forums posts, but I think we'll live.

[D-Maximal_Primal]

What about the legends listings? Included Shockwave and the cassettes... (and Pink Taserpeak)

[steve2275]

Well I got my weapons back, the character profile and upgrade pages are back to normal, but anything in training (ram, repair,etc.) is still zero on my end.

Are the tactics restored properly now?

Yes, thank you.

http://www.seibertron.com/heavymetalwar ... r_id=84224
but he's a 9 that should be an 11
go cubbies

[Burn]

but he's a 9 that should be an 11

How's that?

[D-Maximal_Primal]

I think the system is still glitching. I could not get on last night for a few hours and this is the first time I've able to get on since about midnight my time

[Kyleor]

Also just saw Google may have a cache of all the articles:

http://webcache.googleusercontent.com/s ... clnk&gl=us

Gotta love Google. Thanks to your suggestion, Kyleor, and to Google's cache of Seibertron.com, all of the news stories from yesterday were restored.

http://www.seibertron.com/transformers/news/

If you see that I missed something, please let me know. Sucks we lost yesterday's forums posts, but I think we'll live.

All the news articles that showed up in my RSS feed are back up.

I wonder if after posting an article you could also have the Internet Archive save a copy of the page using their 'Save Page Now' function: http://archive.org/web/

Free, immediate, article backups.