View previous topic :: View next topic |
Author |
Message |
scarface
Joined: 12 Jun 2005 Posts: 94 Location: Sweden
|
Posted: Mon Aug 17, 2009 12:40 Post subject: Problem with new host |
|
|
I've changed over to a completely new host, the last host was running Desktop based Linux and it ran almost perfectly, but the new host is running a server based linux (Bash console only no desktop), everything is setup the same, all plugins load and as far as the logs are concerned everything is fine, it all works great... then randomly the cpu will jump to 100 and the server will lag and crash (well it hangs actually because the restart script doesn't even detect that it's down so the server doesn't restart), the host doesn't know what the problem is and I have absolutely no idea and I'm at my wits end, it can happen after 1 minute of the server going online, or it can happen 24 hours after :/
Does anyone have any idea whatsoever as to what could possibly be the issue here? |
|
Back to top |
|
|
scarface
Joined: 12 Jun 2005 Posts: 94 Location: Sweden
|
Posted: Wed Aug 19, 2009 12:10 Post subject: |
|
|
Ok I've found the root of the problem, my bank chests that store items randomly crash the server and I have no idea why, our bank MySQL database banking table consists of the following columns:
gold int(11)
exp int(11)
items blob
I'm fairly sure this is how we had it setup before without problems, can anyone offer advice or assistance?
Cheers. |
|
Back to top |
|
|
axs
Joined: 11 Feb 2005 Posts: 76
|
Posted: Wed Aug 19, 2009 13:59 Post subject: |
|
|
Change blob to mediumblob, maybe some items do not fit into blob.
If so...they are damaged and you have to delete them from table. |
|
Back to top |
|
|
scarface
Joined: 12 Jun 2005 Posts: 94 Location: Sweden
|
Posted: Thu Aug 20, 2009 13:02 Post subject: |
|
|
Hey axs good call man, been running for well over 24 hours now without a single crash and players frequently using the database, cheers |
|
Back to top |
|
|
|