Age of Valor
login.php?sid=ca127c5adaf4c0014ad5ffc34edaa298 profile.php?mode=register&sid=ca127c5adaf4c0014ad5ffc34edaa298 faq.php?sid=ca127c5adaf4c0014ad5ffc34edaa298 memberlist.php?sid=ca127c5adaf4c0014ad5ffc34edaa298 search.php?sid=ca127c5adaf4c0014ad5ffc34edaa298 index.php?sid=ca127c5adaf4c0014ad5ffc34edaa298
Site Links: Home :: Donate :: Features :: Connection Guide




Age of Valor Forum Index » News » Shard revert due to database issue
Post new topic  Reply to topic View previous topic :: View next topic 
Shard revert due to database issue
PostPosted: Fri Feb 02, 2018 7:48 am Reply with quote
Red Squirrel
AoV Owner
Joined: 13 Dec 2006
Posts: 8192
Location: Ontario, Canada




Due to a database corruption issue we had to do a revert to Sun Dec 31 18:00:08 EST 2017. Given how dead the shard has been lately it only got noticed now so had to use a pretty old backup... but given the lack of activity not like much was lost anyway. Razz

Sorry for the inconvenience this may have caused. I will investigate the cause of the corruption.
_________________

my blog

Honk if you love Jesus, text if you want to meet Him!
View user's profile Send private message Visit poster's website MSN Messenger
PostPosted: Fri Feb 02, 2018 10:17 pm Reply with quote
ninja2007
Joined: 21 Aug 2007
Posts: 412
Location: 513, Ohio




should of left the characters wiped Razz i would of loved to start over from scratch with a bare server Razz
View user's profile Send private message Visit poster's website Yahoo Messenger
PostPosted: Tue Feb 13, 2018 10:29 pm Reply with quote
Red Squirrel
AoV Owner
Joined: 13 Dec 2006
Posts: 8192
Location: Ontario, Canada




This happened again this morning.

There's a weird issue with my network where if something is pegging disk I/O too much, stuff starts to lockup. I was trying to sync the ethereum blockchain, I think that is what was causing issues.

Had to restore a backup from this morning. (Tue Feb 13 06:00:26 EST 2018)

I stopped the blockchain sync for now to see if the problem goes away just to rule it out. If it is that, then I will simply put it on a dedicated machine instead of a VM.
_________________

my blog

Honk if you love Jesus, text if you want to meet Him!
View user's profile Send private message Visit poster's website MSN Messenger
PostPosted: Sat Feb 17, 2018 4:24 pm Reply with quote
Red Squirrel
AoV Owner
Joined: 13 Dec 2006
Posts: 8192
Location: Ontario, Canada




So this seems to keep happening. I really don't know what's going on but I won't really have much time to investigate for a while but I do need to look into this further. Nothing has actually changed for a long time so I really don't know why this keeps happening.
_________________

my blog

Honk if you love Jesus, text if you want to meet Him!
View user's profile Send private message Visit poster's website MSN Messenger
PostPosted: Sat Feb 17, 2018 4:37 pm Reply with quote
Red Squirrel
AoV Owner
Joined: 13 Dec 2006
Posts: 8192
Location: Ontario, Canada




It seems the network link to the DB server is randomly dropping. Going to keep shard down while I do a ping test. It seems to only happen when there is heavy load on the file server. Right now there is a backup job running and it's just killing everything. This issue has been a bane of my existence, it seems backup jobs put a ridiculous load on the server and then it causes stuff to crash and I just don't get why.

Edit: Decided to bring shard back up as I wanted to test backup anyway. I will monitor ping test while it's up.

Backup from Sat Feb 17 06:00:08 EST 2018 restored.
_________________

my blog

Honk if you love Jesus, text if you want to meet Him!
View user's profile Send private message Visit poster's website MSN Messenger
Shard revert due to database issue
Age of Valor Forum Index » News
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT  
Page 1 of 1  

  
  
 Post new topic  Reply to topic  
Shout Box


Powered by phpBB © 2001-2004 phpBB Group
Designed for Trushkin.net | Themes Database

This website and forum best viewed in a standards compliant browser such as Firefox or Opera.
Internet explorer is not recommended.