Kremzeek attacks Seibertron.com's database server; Autobot Mainframe later restores it!
Posted by Seibertron
Oct 15, 2015 at 1:39pm CDT
24,558 views
View Discussion
Sign in
or
Join
to reply
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!
More Bots. More News. More Awesome.
Re: Kremzeek attacks Seibertron.com's database server; Autobot Mainframe later restores it!
(view post)
Comment by DedicatedGhostArt
Oct 15, 2015
So can yesterday’s news be restored?
Re: Kremzeek attacks Seibertron.com's database server; Autobot Mainframe later restores it!
(view post)
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.
Comment by Seibertron
Oct 15, 2015
SillySpringer wrote: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.
Re: Kremzeek attacks Seibertron.com's database server; Autobot Mainframe later restores it!
(view post)
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.
Comment by Kyleor
Oct 15, 2015
Seibertron wrote:SillySpringer wrote: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.
Re: Kremzeek attacks Seibertron.com's database server; Autobot Mainframe later restores it!
(view post)
Also just saw Google may have a cache of all the articles:
http://webcache.googleusercontent.com/s ... clnk&gl=us
Comment by Kyleor
Oct 15, 2015
Kyleor wrote:Seibertron wrote:SillySpringer wrote: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
Re: Kremzeek attacks Seibertron.com's database server; Autobot Mainframe later restores it!
(view post)
Comment by Emerje
Oct 15, 2015
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
Emerje
Re: Kremzeek attacks Seibertron.com's database server; Autobot Mainframe later restores it!
(view post)
Comment by steve2275
Oct 15, 2015
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 /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
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 /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
Re: Kremzeek attacks Seibertron.com's database server; Autobot Mainframe later restores it!
(view post)
Nice to know I'm not alone in the lost weapons/upgrades thing.
Comment by Riot Riverman
Oct 15, 2015
steve2275 wrote: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 /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.
Re: Kremzeek attacks Seibertron.com's database server; Autobot Mainframe later restores it!
(view post)
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?
Comment by Seibertron
Oct 15, 2015
Riot Riverman wrote:steve2275 wrote: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 /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?
Re: Kremzeek attacks Seibertron.com's database server; Autobot Mainframe later restores it!
(view post)
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.
Comment by Riot Riverman
Oct 15, 2015
Seibertron wrote:Riot Riverman wrote:steve2275 wrote: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 /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.
Re: Kremzeek attacks Seibertron.com's database server; Autobot Mainframe later restores it!
(view post)
Comment by Seibertron
Oct 15, 2015
Can you post a URL to where you can see that data so that I can backtrace which tables were not restored properly? Thanks.
Re: Kremzeek attacks Seibertron.com's database server; Autobot Mainframe later restores it!
(view post)
Are the tactics restored properly now?
Comment by Seibertron
Oct 15, 2015
Riot Riverman wrote: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?
Re: Kremzeek attacks Seibertron.com's database server; Autobot Mainframe later restores it!
(view post)
Ok never mind my training stats are back.
Comment by Riot Riverman
Oct 15, 2015
Riot Riverman wrote:Seibertron wrote:Riot Riverman wrote:steve2275 wrote: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 /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.
Re: Kremzeek attacks Seibertron.com's database server; Autobot Mainframe later restores it!
(view post)
Yes, thank you.
Comment by Riot Riverman
Oct 15, 2015
Seibertron wrote:Riot Riverman wrote: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.
Re: Kremzeek attacks Seibertron.com's database server; Autobot Mainframe later restores it!
(view post)
Comment by fenrir72
Oct 15, 2015
Question of the ignorant, this was due to hardware failure of the server?
Re: Kremzeek attacks Seibertron.com's database server; Autobot Mainframe later restores it!
(view post)
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!
Comment by Seibertron
Oct 15, 2015
fenrir72 wrote: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!
Re: Kremzeek attacks Seibertron.com's database server; Autobot Mainframe later restores it!
(view post)
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.
Comment by Seibertron
Oct 15, 2015
Kyleor wrote: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.
Re: Kremzeek attacks Seibertron.com's database server; Autobot Mainframe later restores it!
(view post)
Comment by D-Maximal_Primal
Oct 15, 2015
What about the legends listings? Included Shockwave and the cassettes... (and Pink Taserpeak) 
Re: Kremzeek attacks Seibertron.com's database server; Autobot Mainframe later restores it!
(view post)
http://www.seibertron.com/heavymetalwar ... r_id=84224
but he's a 9 that should be an 11
go cubbies
Comment by steve2275
Oct 16, 2015
Riot Riverman wrote:Seibertron wrote:Riot Riverman wrote: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
Re: Kremzeek attacks Seibertron.com's database server; Autobot Mainframe later restores it!
(view post)
How's that?
Comment by Burn
Oct 16, 2015
steve2275 wrote:but he's a 9 that should be an 11
How's that?
Re: Kremzeek attacks Seibertron.com's database server; Autobot Mainframe later restores it!
(view post)
Comment by D-Maximal_Primal
Oct 16, 2015
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
