Stiven. 0 Posted December 13, 2014 Share Posted December 13, 2014 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. Link to comment Share on other sites More sharing options...
Stiven. 0 Posted December 13, 2014 Author Share Posted December 13, 2014 up Link to comment Share on other sites More sharing options...
Reboot 772 Posted December 14, 2014 Share Posted December 14, 2014 Fdwatch 21, its the problem. 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