[help] the server is constantly falling

[Stiven. 0]

Hi,

 

few days ago I have problems with the server and I could not identify all problems to solve

 

appreciate if you help me to identify 

 

 

 

SYSERR DB:

 

SYSERR: Dec 10 12:18:16 :: Start: TABLE_POSTFIX not configured use default

SYSERR: Dec 11 03:02:08 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)

SYSERR: Dec 11 03:02:08 :: ChildLoop: AsyncSQL: retrying

SYSERR: Dec 11 03:02:12 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)

SYSERR: Dec 11 03:02:12 :: ChildLoop: AsyncSQL: retrying

SYSERR: Dec 11 03:02:12 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)

SYSERR: Dec 11 03:02:12 :: ChildLoop: AsyncSQL: retrying

SYSERR: Dec 11 03:02:16 :: ChildLoop: MySQL connection was reconnected. querying locale set

SYSERR: Dec 11 21:08:50 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)

SYSERR: Dec 11 21:08:50 :: ChildLoop: AsyncSQL: retrying

SYSERR: Dec 11 21:08:52 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.

SYSERR: Dec 11 21:08:52 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

query: SELECT MAX(id) FROM item WHERE id >= 110000001 and id <= 120000000

SYSERR: Dec 11 21:08:52 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

query: SELECT COUNT(*) FROM item WHERE id >= 110000001 AND id <= 120000000

SYSERR: Dec 11 21:08:53 :: pid_deinit: 

End of pid

SYSERR: Dec 12 13:29:50 :: Start: TABLE_POSTFIX not configured use default

SYSERR: Dec 12 13:29:53 :: pid_init: 

Start of pid: 1830

 

SYSERR: Dec 12 13:29:53 :: Start: TABLE_POSTFIX not configured use default

SYSERR: Dec 12 22:21:11 :: DirectQuery: MySQL connection was reconnected. querying locale set

SYSERR: Dec 12 22:21:11 :: Process: FDWATCH: peer null in event: ident 21

 

SYSERR CH1:

 

 

SYSERR: Dec 12 13:29:41 :: socket_bind: bind: Address already in use

SYSERR: Dec 12 13:29:41 :: ChildLoop: AsyncSQL::ChildLoop : mysql_query error: Out of range value for column 'time' at row 1:

query: INSERT INTO bootlog (time, hostname, channel) VALUES(NOW(), 'channel1_1', 1)

SYSERR: Dec 12 13:29:44 :: pid_init: 

Start of pid: 1781

 

SYSERR: Dec 12 13:29:44 :: socket_bind: bind: Address already in use

SYSERR: Dec 12 13:29:44 :: ChildLoop: AsyncSQL::ChildLoop : mysql_query error: Out of range value for column 'time' at row 1:

query: INSERT INTO bootlog (time, hostname, channel) VALUES(NOW(), 'channel1_1', 1)

SYSERR: Dec 12 13:29:47 :: pid_init: 

Start of pid: 1794

 

SYSERR: Dec 12 13:29:47 :: socket_bind: bind: Address already in use

SYSERR: Dec 12 13:29:47 :: ChildLoop: AsyncSQL::ChildLoop : mysql_query error: Out of range value for column 'time' at row 1:

query: INSERT INTO bootlog (time, hostname, channel) VALUES(NOW(), 'channel1_1', 1)

SYSERR: Dec 12 13:29:50 :: pid_init: 

Start of pid: 1810

 

SYSERR: Dec 12 13:29:50 :: socket_bind: bind: Address already in use

SYSERR: Dec 12 13:29:50 :: ChildLoop: AsyncSQL::ChildLoop : mysql_query error: Out of range value for column 'time' at row 1:

query: INSERT INTO bootlog (time, hostname, channel) VALUES(NOW(), 'channel1_1', 1)

SYSERR: Dec 12 13:29:53 :: pid_init: 

Start of pid: 1826

 

SYSERR: Dec 12 13:29:53 :: socket_bind: bind: Address already in use

SYSERR: Dec 12 13:29:53 :: ChildLoop: AsyncSQL::ChildLoop : mysql_query error: Out of range value for column 'time' at row 1:

query: INSERT INTO bootlog (time, hostname, channel) VALUES(NOW(), 'channel1_1', 1)

SYSERR: Dec 12 22:20:22 :: ChildLoop: MySQL connection was reconnected. querying locale set

SYSERR: Dec 12 22:20:22 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 1, 65232, 165020, 0, 'LOGIN', '177.228.103.25 1112177755 1 21 145254', '177.228.103.25') errno: 1406)

SYSERR: Dec 12 22:20:23 :: ChildLoop: AsyncSQL: query failed: Incorrect integer value: 'Y' for column 'is_gm' at row 1 (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'Y', NOW(), 1, 1, 1, inet_aton('177.228.103.25'), '') errno: 1366)

SYSERR: Dec 12 22:20:37 :: ChildLoop: MySQL connection was reconnected. querying locale set

SYSERR: Dec 12 22:20:37 :: RunState: LUA_ERROR: [string "flame_dungeon"]:2: attempt to call field `setting' (a nil value)

SYSERR: Dec 12 22:20:37 :: WriteRunningStateToSyserr: LUA_ERROR: quest flame_dungeon.start click

SYSERR: Dec 12 22:20:37 :: RunState: LUA_ERROR: [string "oso"]:1: attempt to call field `Oso' (a nil value)

SYSERR: Dec 12 22:20:37 :: WriteRunningStateToSyserr: LUA_ERROR: quest oso.start click

SYSERR: Dec 11 20:31:03 :: socket_bind: bind: Address already in use

SYSERR: Dec 11 20:31:03 :: socket_bind: bind: Address already in use

SYSERR: Dec 11 20:31:03 :: socket_bind: bind: Address already in use

 

 

 

SYSERR AUTH:

 

SYSERR: Dec 12 22:37:12 :: socket_bind: bind: Address already in use

SYSERR: Dec 12 22:37:12 :: ChildLoop: AsyncSQL: query failed: Table 'account.string' doesn't exist (query: SELECT name, text FROM string errno: 1146)

SYSERR: Dec 12 22:37:12 :: ChildLoop: AsyncSQL::ChildLoop : mysql_query error: Out of range value for column 'time' at row 1:

query: INSERT INTO bootlog (time, hostname, channel) VALUES(NOW(), 'auth', 1)

SYSERR: Dec 12 22:37:42 :: pid_init: 

Start of pid: 50087

 

SYSERR: Dec 12 22:37:42 :: socket_bind: bind: Address already in use

SYSERR: Dec 12 22:37:42 :: ChildLoop: AsyncSQL: query failed: Table 'account.string' doesn't exist (query: SELECT name, text FROM string errno: 1146)

SYSERR: Dec 12 22:37:42 :: ChildLoop: AsyncSQL::ChildLoop : mysql_query error: Out of range value for column 'time' at row 1:

query: INSERT INTO bootlog (time, hostname, channel) VALUES(NOW(), 'auth', 1)

SYSERR: Dec 12 22:38:12 :: pid_init: 

Start of pid: 50127

 

SYSERR: Dec 12 22:38:12 :: socket_bind: bind: Address already in use

SYSERR: Dec 12 22:38:12 :: ChildLoop: AsyncSQL: query failed: Table 'account.string' doesn't exist (query: SELECT name, text FROM string errno: 1146)

SYSERR: Dec 12 22:38:12 :: ChildLoop: AsyncSQL::ChildLoop : mysql_query error: Out of range value for column 'time' at row 1:

query: INSERT INTO bootlog (time, hostname, channel) VALUES(NOW(), 'auth', 1)

SYSERR: Dec 12 22:38:42 :: pid_init: 

Start of pid: 50171

 

SYSERR: Dec 12 22:38:42 :: socket_bind: bind: Address already in use

SYSERR: Dec 12 22:38:42 :: ChildLoop: AsyncSQL: query failed: Table 'account.string' doesn't exist (query: SELECT name, text FROM string errno: 1146)

SYSERR: Dec 12 22:38:42 :: ChildLoop: AsyncSQL::ChildLoop : mysql_query error: Out of range value for column 'time' at row 1:

query: INSERT INTO bootlog (time, hostname, channel) VALUES(NOW(), 'auth', 1)

SYSERR: Dec 12 22:39:12 :: pid_init: 

Start of pid: 50217

 

SYSERR: Dec 12 22:39:12 :: socket_bind: bind: Address already in use

SYSERR: Dec 12 22:39:12 :: ChildLoop: AsyncSQL: query failed: Table 'account.string' doesn't exist (query: SELECT name, text FROM string errno: 1146)

SYSERR: Dec 12 22:39:12 :: ChildLoop: AsyncSQL::ChildLoop : mysql_query error: Out of range value for column 'time' at row 1:

query: INSERT INTO bootlog (time, hostname, channel) VALUES(NOW(), 'auth', 1)

 

 

Thank you and goodbye.

[Stiven. 0]

up

[Reboot 764]

Fdwatch 21, its the problem.