-
Posts
2 -
Joined
-
Last visited
-
Feedback
0%
Content Type
Forums
Store
Third Party - Providers Directory
Feature Plan
Release Notes
Docs
Events
Posts posted by Stiven.
-
-
Hi,
few days ago I have problems with the server and I could not identify all problems to solveappreciate if you help me to identifySYSERR DB:SYSERR: Dec 10 12:18:16 :: Start: TABLE_POSTFIX not configured use defaultSYSERR: 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: retryingSYSERR: 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: retryingSYSERR: 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: retryingSYSERR: Dec 11 03:02:16 :: ChildLoop: MySQL connection was reconnected. querying locale setSYSERR: 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: retryingSYSERR: 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 <= 120000000SYSERR: 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 <= 120000000SYSERR: Dec 11 21:08:53 :: pid_deinit:End of pidSYSERR: Dec 12 13:29:50 :: Start: TABLE_POSTFIX not configured use defaultSYSERR: Dec 12 13:29:53 :: pid_init:Start of pid: 1830SYSERR: Dec 12 13:29:53 :: Start: TABLE_POSTFIX not configured use defaultSYSERR: Dec 12 22:21:11 :: DirectQuery: MySQL connection was reconnected. querying locale setSYSERR: Dec 12 22:21:11 :: Process: FDWATCH: peer null in event: ident 21SYSERR CH1:
SYSERR: Dec 12 13:29:41 :: socket_bind: bind: Address already in useSYSERR: 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: 1781SYSERR: Dec 12 13:29:44 :: socket_bind: bind: Address already in useSYSERR: 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: 1794SYSERR: Dec 12 13:29:47 :: socket_bind: bind: Address already in useSYSERR: 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: 1810SYSERR: Dec 12 13:29:50 :: socket_bind: bind: Address already in useSYSERR: 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: 1826SYSERR: Dec 12 13:29:53 :: socket_bind: bind: Address already in useSYSERR: 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 setSYSERR: 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 setSYSERR: 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 clickSYSERR: 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 clickSYSERR: Dec 11 20:31:03 :: socket_bind: bind: Address already in useSYSERR: Dec 11 20:31:03 :: socket_bind: bind: Address already in useSYSERR: Dec 11 20:31:03 :: socket_bind: bind: Address already in useSYSERR 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: 50087SYSERR: Dec 12 22:37:42 :: socket_bind: bind: Address already in useSYSERR: 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: 50127SYSERR: Dec 12 22:38:12 :: socket_bind: bind: Address already in useSYSERR: 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: 50171SYSERR: Dec 12 22:38:42 :: socket_bind: bind: Address already in useSYSERR: 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: 50217SYSERR: Dec 12 22:39:12 :: socket_bind: bind: Address already in useSYSERR: 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.
[help] the server is constantly falling
in Community Support - Questions & Answers
Posted
up