About Channel down.

04/06/2016 21:42 multimetin#1
Hi. I'm from turkey. I have one problem.

I open one channel and no problem.

But when I open 4 ch. my server is down.

I'm using 50k files. I have source.

This is my Channel 1 syserr.

Code:
SYSERR: Apr  6 18:48:11 :: pid_init: 
Start of pid: 802

SYSERR: Apr  6 18:49:51 :: heart_idle: losing 98 seconds. (lag occured)
SYSERR: Apr  6 18:49:54 :: socket_connect: HOST 37.123.97.104:17000, could not connect.
Game99 syser

Code:
SYSERR: Apr  6 18:48:31 :: pid_init: 
Start of pid: 814

SYSERR: Apr  6 18:50:09 :: heart_idle: losing 95 seconds. (lag occured)
SYSERR: Apr  6 18:50:11 :: socket_accept: accept: Software caused connection abort (fd 13)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 1, 632, 202472) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 1, 633, 206483) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 1, 634, 107285) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 1, 635, 315865) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 1, 636, 832871) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 1, 637, 214595) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 1, 657, 216472) errno: 1136)


Al codes.
Code:
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 1, 657, 216472) errno: 1136)

game99 full syser
Code:
SYSERR: Apr  6 18:48:31 :: pid_init: 
Start of pid: 814

SYSERR: Apr  6 18:50:09 :: heart_idle: losing 95 seconds. (lag occured)
SYSERR: Apr  6 18:50:11 :: socket_accept: accept: Software caused connection abort (fd 13)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 1, 632, 202472) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 1, 633, 206483) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 1, 634, 107285) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 1, 635, 315865) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 1, 636, 832871) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 1, 637, 214595) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 1, 657, 216472) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 1, 2102, 539265) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 1, 2103, 1258116) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 1, 2104, 435056) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 1, 2105, 138104) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 1, 2106, 1280421) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 1, 8009, 778) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 2110, 1) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 3100, 1) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 5110, 1) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 14160, 1) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 27002, 2) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 27003, 1) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 27004, 3) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 27105, 1) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 28043, 1) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 50056, 1) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 50300, 6) errno: 1136)
SYSERR: Apr  6 19:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 70048, 1) errno: 1136)
SYSERR: Apr  6 20:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 603, 1) errno: 1136)
SYSERR: Apr  6 20:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 632, 4) errno: 1136)
SYSERR: Apr  6 20:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 633, 3) errno: 1136)
SYSERR: Apr  6 20:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 634, 7) errno: 1136)
SYSERR: Apr  6 20:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 635, 5) errno: 1136)
SYSERR: Apr  6 20:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 636, 15) errno: 1136)
SYSERR: Apr  6 20:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 637, 7) errno: 1136)
SYSERR: Apr  6 20:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 656, 3) errno: 1136)
SYSERR: Apr  6 20:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 657, 6) errno: 1136)
SYSERR: Apr  6 20:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 901, 1) errno: 1136)
SYSERR: Apr  6 20:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 937, 1) errno: 1136)
SYSERR: Apr  6 20:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 1001, 31) errno: 1136)
SYSERR: Apr  6 20:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 1002, 50) errno: 1136)
SYSERR: Apr  6 20:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 1003, 38) errno: 1136)
SYSERR: Apr  6 20:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 1004, 11) errno: 1136)
SYSERR: Apr  6 20:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 1031, 26) errno: 1136)
SYSERR: Apr  6 20:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 1032, 9) errno: 1136)
SYSERR: Apr  6 20:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 1061, 25) errno: 1136)
SYSERR: Apr  6 20:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 1062, 8) errno: 1136)
SYSERR: Apr  6 20:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 2102, 10) errno: 1136)
SYSERR: Apr  6 20:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 2103, 22) errno: 1136)
SYSERR: Apr  6 20:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 2104, 15) errno: 1136)
SYSERR: Apr  6 20:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 2105, 2) errno: 1136)
SYSERR: Apr  6 20:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 2106, 22) errno: 1136)
SYSERR: Apr  6 20:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 2107, 1) errno: 1136)
SYSERR: Apr  6 20:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 2108, 1) errno: 1136)
SYSERR: Apr  6 20:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 8009, 1) errno: 1136)
SYSERR: Apr  6 20:48:01 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log VALUES (NOW(), 7, 8015, 1) errno: 1136)
New syserr

Code:
SYSERR: Apr  6 22:59:08 :: pid_init: 
Start of pid: 878

SYSERR: Apr  6 22:59:08 :: socket_bind: bind: Address already in use
SYSERR: Apr  6 22:59:58 :: Process: SEQUENCE 64e2e900 mismatch 0xaf != 0x64 header 254
SYSERR: Apr  6 22:59:58 :: Process: SEQUENCE_LOG [UNKNOWN]-------------
	[254 : 0xaf]
04/07/2016 09:06 Cyber36#2
As I can see, there is no error that would cause a core-crash e.g "channel-down".
Could you tell us, if in the corefolder, that crashes, is a "game.core"?

EDIT: "I open one channel and no problem.

But when I open 4 ch. my server is down."

Does your server has enough RAM for that much cores running? How much is it?
04/07/2016 14:32 theo1990#3

take a look hat your money_log table. your server try to insert a new row of data but the value count != colum count. That means your server try to insert more values than columes exist or more colums exists but less values.


The server try to connect to IP:PORT but he cant. The Port can may be wrong.... At this error iam not sure.