Jump to content
  • 0

Crash DB core problem


Undertaker

Question

Hi,
I have problems with the fact that sometimes the core of the database crashes. I don't know where the problem may be, I tried everything here, the source doesn't report any errors to me during compilation. The core of the database usually crashes with a many warps. However, there is only 1 person on the server at that moment. The VPS has 4GB of RAM, so the problem of insufficient memory is ruled out here. Here I attach the syserr database and channel1.


DB syserr:

Spoiler

SYSERR: Feb  1 20:32:29 :: pid_init: 
Start of pid: 14640

SYSERR: Feb  1 20:51:12 :: ChildLoop: AsyncSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 (query: REPLACE INTO affect  (dwPID, bType, bApplyOn, lApplyValue, dwFlag, lDuration, lSPCost) VALUES(1, 515, 12, -99000, 0, 402482, 0) errno: 1064)
 

 

Channel1 syserr:
 

Spoiler

SYSERR: Feb  1 20:32:33 :: pid_init: 
Start of pid: 14643

SYSERR: Feb  1 20:58:03 :: socket_connect: HOST localhost:17700, could not connect.
SYSERR: Feb  1 20:58:06 :: socket_connect: HOST localhost:17700, could not connect.
SYSERR: Feb  1 20:58:09 :: socket_connect: HOST localhost:17700, could not connect.
SYSERR: Feb  1 20:58:12 :: socket_connect: HOST localhost:17700, could not connect.
SYSERR: Feb  1 20:58:15 :: socket_connect: HOST localhost:17700, could not connect.
SYSERR: Feb  1 20:58:18 :: socket_connect: HOST localhost:17700, could not connect.
SYSERR: Feb  1 20:58:21 :: socket_connect: HOST localhost:17700, could not connect.
SYSERR: Feb  1 20:58:24 :: socket_connect: HOST localhost:17700, could not connect.
SYSERR: Feb  1 20:58:27 :: socket_connect: HOST localhost:17700, could not connect.
SYSERR: Feb  1 20:58:30 :: socket_connect: HOST localhost:17700, could not connect.
SYSERR: Feb  1 20:58:33 :: socket_connect: HOST localhost:17700, could not connect.
SYSERR: Feb  1 20:58:36 :: socket_connect: HOST localhost:17700, could not connect.
SYSERR: Feb  1 20:58:39 :: socket_connect: HOST localhost:17700, could not connect.
 


Thank you very much for the advice and solution to this problem. 

Edited by Undertaker
Link to comment
Share on other sites

  • Answers 0
  • Created
  • Last Reply

Top Posters For This Question

Popular Days

Top Posters For This Question

Popular Days

0 answers to this question

Recommended Posts

There have been no answers to this question yet

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.