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 post

0 answers to this question

Recommended Posts

There have been no answers to this question yet

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



Shoutbox

Shoutbox

Chatroom Rules

 

Join our Discord

A request for help = Shoutbox Ban

Be respectful & Respect the rules

 

×
×
  • 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.