Active Member Exygo 1091 Posted December 18, 2014 Active Member Share Posted December 18, 2014 So my problem is that the table "item" is crashing while the server is running after 2-3 days (aprox) , sometimes the "log" table is crashing and causing the same thing. And the only solution is to force stop the server to repair the table and re-start the server and hte players are getting a roll-back of 5-10 minutes... what could i do to fix this problem? https://www.youtube.com/channel/UCQ8mAeda9TWq6SsTzB53emw/videos Link to comment Share on other sites More sharing options...
Reboot 772 Posted December 18, 2014 Share Posted December 18, 2014 Post syser man, who we are wizards to know what you have in the server error? Teacher to express correctly, you are brainy people. Link to comment Share on other sites More sharing options...
Active Member Exygo 1091 Posted December 18, 2014 Author Active Member Share Posted December 18, 2014 The only problems what i have are: the sync position, some harmless errors and this DB error: DirectQuery failed(SELECT login FROM block_exception) I fixed almost everything including TICS causing shutdown server ( just writes in syserr something now ) I deleted the logs becouse i know every error i have, and pure and simple the table crashed, next time when happen i will post the syslog, auto.log and also syserr The only reason why i posted here is becouse i'm out of ideas.. Any ideas what can cause table crash? https://www.youtube.com/channel/UCQ8mAeda9TWq6SsTzB53emw/videos Link to comment Share on other sites More sharing options...
Reboot 772 Posted December 18, 2014 Share Posted December 18, 2014 The only problems what i have are: the sync position, some harmless errors and this DB error: DirectQuery failed(SELECT login FROM block_exception) I fixed almost everything including TICS causing shutdown server ( just writes in syserr something now ) I deleted the logs becouse i know every error i have, and pure and simple the table crashed, next time when happen i will post the syslog, auto.log and also syserr The only reason why i posted here is becouse i'm out of ideas.. Any ideas what can cause table crash? Nobody can assume it is impossible not to defend a critical error syserr when you fall. Find me on skype, skype Id is on my profile page. Link to comment Share on other sites More sharing options...
Rumor 2607 Posted December 18, 2014 Share Posted December 18, 2014 The only problems what i have are: the sync position, some harmless errors and this DB error: DirectQuery failed(SELECT login FROM block_exception) I fixed almost everything including TICS causing shutdown server ( just writes in syserr something now ) I deleted the logs becouse i know every error i have, and pure and simple the table crashed, next time when happen i will post the syslog, auto.log and also syserr The only reason why i posted here is becouse i'm out of ideas.. Any ideas what can cause table crash? When you have a problem and a question, logs are expected. Don't expect people to do anything just because you say the logs are useless and you've deleted them. Link to comment Share on other sites More sharing options...
Reboot 772 Posted December 18, 2014 Share Posted December 18, 2014 The only problems what i have are: the sync position, some harmless errors and this DB error: DirectQuery failed(SELECT login FROM block_exception) I fixed almost everything including TICS causing shutdown server ( just writes in syserr something now ) I deleted the logs becouse i know every error i have, and pure and simple the table crashed, next time when happen i will post the syslog, auto.log and also syserr The only reason why i posted here is becouse i'm out of ideas.. Any ideas what can cause table crash? When you have a problem and a question, logs are expected. Don't expect people to do anything just because you say the logs are useless and you've deleted them. correctly. Link to comment Share on other sites More sharing options...
Active Member Exygo 1091 Posted December 20, 2014 Author Active Member Share Posted December 20, 2014 I checked everything, and i found that the TICS error is in syserr before server is going down, and only core1, i fixed the TICS error by removing abort() from the game source https://www.youtube.com/channel/UCQ8mAeda9TWq6SsTzB53emw/videos Link to comment Share on other sites More sharing options...
Premium Shogun 4588 Posted December 20, 2014 Premium Share Posted December 20, 2014 The "tics error" indicates something is wrong, removing the error message won't fix it. Link to comment Share on other sites More sharing options...
Reboot 772 Posted December 20, 2014 Share Posted December 20, 2014 Exygo :Send me a message on skype, I solved this problem many servers in romania. Link to comment Share on other sites More sharing options...
Active Member Exygo 1091 Posted December 20, 2014 Author Active Member Share Posted December 20, 2014 The server got crashed again at 22:17 time and this is the syserr: http://pastebin.com/WEXn1mRQ https://www.youtube.com/channel/UCQ8mAeda9TWq6SsTzB53emw/videos Link to comment Share on other sites More sharing options...
Premium Shogun 4588 Posted December 20, 2014 Premium Share Posted December 20, 2014 What's on syslog right before the crash? Link to comment Share on other sites More sharing options...
Active Member Exygo 1091 Posted December 20, 2014 Author Active Member Share Posted December 20, 2014 http://pastebin.com/swAstLjz down is the start of the pid i'm using autostart in case server crush... Syserr DB http://pastebin.com/mKCxMcu2 https://www.youtube.com/channel/UCQ8mAeda9TWq6SsTzB53emw/videos Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now