Jump to content
Phishing - Beware of identity theft... ×
  • 0

[help] the server is constantly falling


Stiven.

Question

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.

Link to comment
Share on other sites

  • Answers 2
  • Created
  • Last Reply

Top Posters For This Question

Top Posters For This Question

2 answers to this question

Recommended Posts

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


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