Jump to content

Stiven.

Inactive Member
  • Posts

    2
  • Joined

  • Last visited

  • Feedback

    0%

Posts posted by Stiven.

  1. 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  :D
     
     
     
    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.

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