Jump to content

Shop offline crash my core


Recommended Posts

Hello friends , i have a problem since i add the shop offline. 

About at 24 hours , my channel 1 is crash  ( when most of people are online )

Every time the core are stop with this

syserr:

Spoiler

SYSERR: Dec 12 16:57:11 :: ChildLoop: AsyncSQL: query failed: Lost connection to MySQL server during query (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 236304, 1070604, 1577046, 380648, 'GET_GOLD', '', '89.43.110.234') errno: 2013)
SYSERR: Dec 12 16:57:11 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: SELECT pos, count, vnum, price, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6 ,applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7 FROM offline_shop_item WHERE owner_id = 286607
SYSERR: Dec 12 16:57:11 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: DELETE FROM player.offline_shop_npc WHERE owner_id = 286607
SYSERR: Dec 12 16:57:11 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 1, 2000, 351652017, 'SET_ATTR', '', '5.12.80.228', 15399) errno: 2002)
SYSERR: Dec 12 16:57:11 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 12 16:57:11 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 1, 2000, 351652017, 'SET_ATTR', '', '5.12.80.228', 15399) errno: 2002)
SYSERR: Dec 12 16:57:11 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 12 16:57:11 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 1, 2000, 351652017, 'SET_ATTR', '', '5.12.80.228', 15399) errno: 2002)
SYSERR: Dec 12 16:57:11 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 12 16:57:11 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 1, 2000, 351652017, 'SET_ATTR', '', '5.12.80.228', 15399) errno: 2002)
SYSERR: Dec 12 16:57:11 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 12 16:57:11 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 1, 2000, 351652017, 'SET_ATTR', '', '5.12.80.228', 15399) errno: 2002)
SYSERR: Dec 12 16:57:11 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 12 16:57:11 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 1, 2000, 351652017, 'SET_ATTR', '', '5.12.80.228', 15399) errno: 2002)
SYSERR: Dec 12 16:57:11 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 12 16:57:11 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 1, 2000, 351652017, 'SET_ATTR', '', '5.12.80.228', 15399) errno: 2002)
SYSERR: Dec 12 16:57:11 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 12 16:57:11 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 1, 2000, 351652017, 'SET_ATTR', '', '5.12.80.228', 15399) errno: 2002)
SYSERR: Dec 12 16:57:11 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 12 16:57:11 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 1, 2000, 351652017, 'SET_ATTR', '', '5.12.80.228', 15399) errno: 2002)
SYSERR: Dec 12 16:57:11 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 12 16:57:11 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 1, 2000, 351652017, 'SET_ATTR', '', '5.12.80.228', 15399) errno: 2002)
SYSERR: Dec 12 16:57:11 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 12 16:57:11 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 1, 2000, 351652017, 'SET_ATTR', '', '5.12.80.228', 15399) errno: 2002)
SYSERR: Dec 12 16:57:11 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 12 16:57:11 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 1, 2000, 351652017, 'SET_ATTR', '', '5.12.80.228', 15399) errno: 2002)
SYSERR: Dec 12 16:57:11 :: ChildLoop: AsyncSQL: retrying
 

 

syslog:

Spoiler

Dec 12 16:57:09 :: [QUERY : LONG INTERVAL(OverSec 182.193236)] : INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 289947, 723623, 482740, 373565, 'GET_GOLD', '', '82.77.117.222')
Dec 12 16:57:10 :: xHECTORx: USE_ITEM Licoare Rosie(G) (inven 1, cell: 2)
Dec 12 16:57:10 :: OnClick BestOne, magazin[vnum 30000 ServerUniqueID 397304, pid 0] by xBoyle
SYSERR: Dec 12 16:57:11 :: ChildLoop: AsyncSQL: query failed: Lost connection to MySQL server during query (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 236304, 1070604, 1577046, 380648, 'GET_GOLD', '', '89.43.110.234') errno: 2013)
Dec 12 16:57:11 :: [QUERY : LONG INTERVAL(OverSec 1.400380)] : INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 236304, 1070604, 1577046, 380648, 'GET_GOLD', '', '89.43.110.234')
SYSERR: Dec 12 16:57:11 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: SELECT pos, count, vnum, price, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6 ,applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7 FROM offline_shop_item WHERE owner_id = 286607
SYSERR: Dec 12 16:57:11 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: DELETE FROM player.offline_shop_npc WHERE owner_id = 286607
SYSERR: Dec 12 16:57:11 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 1, 2000, 351652017, 'SET_ATTR', '', '5.12.80.228', 15399) errno: 2002)
SYSERR: Dec 12 16:57:11 :: ChildLoop: AsyncSQL: retrying
 

 

Link to comment
Share on other sites

4 hours ago, terrorr said:

You has a Mysql problem.

you think that ? hmm

and why only the channel1 is down, i understand is more people than other  , but why the other is not down because the mysql are stopping right ?

And what kind of problem i have there ? hmmm 

Link to comment
Share on other sites

  • Bronze
 applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7 

Do you have a sash system? if yes please make sure that you have those fields in your "player.item" table.

 

also this

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)

your mysql server went down or something is wrong.

 

if there's a crash you should include the game.core lines, too.

Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

Announcements



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