Jump to content
×
×
  • Create New...
  • 0

Shop offline crash my core


DeYaN.

Question

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

8 answers to this question

Recommended Posts

  • 0
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
  • 0
 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

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


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.