DeYaN. 29 Posted December 17, 2016 Share Posted December 17, 2016 Hei everyone , about every 24 hours the mysql service is down and crash my channel 1 where is most of players online and i don`t have any ideea why ? I use the MariaDB101 and yes .. i try with an reinstall and same problem. I have this problems after i add the shop offline system by ken ( last version 13/2/2016 ) This is my database syserr: ( the db don`t crash only register this syserr) Here i see something "(query: UPDATE monarch set money=19085862 where empire=3 errno: 2002)" . He try to update tabble monarch but i dont have anything there. Spoiler AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, 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) VALUES(411570713, 289361, 1, 36, 1, 55701, 1, 40, 0, 1, 30, 1, 43, 1, 63, 1, 8636, 1, 8640, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, 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) VALUES(411570713, 289361, 1, 36, 1, 55701, 1, 40, 0, 1, 30, 1, 43, 1, 63, 1, 8636, 1, 8640, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, 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) VALUES(411570713, 289361, 1, 36, 1, 55701, 1, 40, 0, 1, 30, 1, 43, 1, 63, 1, 8636, 1, 8640, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, 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) VALUES(411570713, 289361, 1, 36, 1, 55701, 1, 40, 0, 1, 30, 1, 43, 1, 63, 1, 8636, 1, 8640, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, 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) VALUES(411570713, 289361, 1, 36, 1, 55701, 1, 40, 0, 1, 30, 1, 43, 1, 63, 1, 8636, 1, 8640, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, 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) VALUES(411570713, 289361, 1, 36, 1, 55701, 1, 40, 0, 1, 30, 1, 43, 1, 63, 1, 8636, 1, 8640, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, 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) VALUES(411570713, 289361, 1, 36, 1, 55701, 1, 40, 0, 1, 30, 1, 43, 1, 63, 1, 8636, 1, 8640, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, 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) VALUES(411570713, 289361, 1, 36, 1, 55701, 1, 40, 0, 1, 30, 1, 43, 1, 63, 1, 8636, 1, 8640, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, 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) VALUES(411570713, 289361, 1, 36, 1, 55701, 1, 40, 0, 1, 30, 1, 43, 1, 63, 1, 8636, 1, 8640, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, 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) VALUES(411570713, 289361, 1, 36, 1, 55701, 1, 40, 0, 1, 30, 1, 43, 1, 63, 1, 8636, 1, 8640, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, 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) VALUES(411570713, 289361, 1, 36, 1, 55701, 1, 40, 0, 1, 30, 1, 43, 1, 63, 1, 8636, 1, 8640, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) CH1 SYSERR ( where core is down ) Spoiler SYSERR: Dec 17 12:25:59 :: Select: wrong QUEST_SELECT request! : 284449 SYSERR: Dec 17 12:26:01 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) query: UPDATE offline_shop_npc SET time = 27540 WHERE owner_id = 282380 SYSERR: Dec 17 12:26:01 :: 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(), 2, 18, 0, 246361662, 'SET_SOCKET', '', '', 72701) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: 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(), 2, 18, 0, 246361662, 'SET_SOCKET', '', '', 72701) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying CH1 SYSLOG Spoiler Dec 17 12:26:01 :: CQuestManager::Kill QUEST_KILL_EVENT (pc=283966, npc=2312) Dec 17 12:26:01 :: GIVE_GOLD: Lordul 161845 Dec 17 12:26:01 :: GIVE_GOLD: Lordul 161845 SYSERR: Dec 17 12:26:01 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) query: UPDATE offline_shop_npc SET time = 27540 WHERE owner_id = 282380 SYSERR: Dec 17 12:26:01 :: 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(), 2, 18, 0, 246361662, 'SET_SOCKET', '', '', 72701) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: 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(), 2, 18, 0, 246361662, 'SET_SOCKET', '', '', 72701) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: 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(), 2, 18, 0, 246361662, 'SET_SOCKET', '', '', 72701) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: 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(), 2, 18, 0, 246361662, 'SET_SOCKET', '', '', 72701) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying Dec 17 12:26:01 :: AddAffect Königsskorpion type 210 apply 0 0 flag 6 duration 4 Dec 17 12:26:01 :: CQuestManager::Kill QUEST_KILL_EVENT (pc=290503, npc=2103) Dec 17 12:26:01 :: GIVE_GOLD: STEFANUT 132349 SYSERR: Dec 17 12:26:01 :: 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(), 2, 18, 0, 246361662, 'SET_SOCKET', '', '', 72701) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: 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(), 2, 18, 0, 246361662, 'SET_SOCKET', '', '', 72701) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: 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(), 2, 18, 0, 246361662, 'SET_SOCKET', '', '', 72701) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: 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(), 2, 18, 0, 246361662, 'SET_SOCKET', '', '', 72701) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying Dec 17 12:26:01 :: [H]B.AngeL: USE_ITEM Mantia Curajului (inven 1, cell: 12) Dec 17 12:26:01 :: [H]B.AngeL: USE_ITEM Mantia Curajului (inven 1, cell: 12) Dec 17 12:26:01 :: EuShop: USE_ITEM Vrãjeºte Obiectul (inven 1, cell: 12) Dec 17 12:26:01 :: GLOBAL_TIME: Dec 17 12:26:01 time_gap 0 SYSERR: Dec 17 12:26:01 :: 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(), 2, 18, 0, 246361662, 'SET_SOCKET', '', '', 72701) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: 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(), 2, 18, 0, 246361662, 'SET_SOCKET', '', '', 72701) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: 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(), 2, 18, 0, 246361662, 'SET_SOCKET', '', '', 72701) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: 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(), 2, 18, 0, 246361662, 'SET_SOCKET', '', '', 72701) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: 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(), 2, 18, 0, 246361662, 'SET_SOCKET', '', '', 72701) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: 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(), 2, 18, 0, 246361662, 'SET_SOCKET', '', '', 72701) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: 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(), 2, 18, 0, 246361662, 'SET_SOCKET', '', '', 72701) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: 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(), 2, 18, 0, 246361662, 'SET_SOCKET', '', '', 72701) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: 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(), 2, 18, 0, 246361662, 'SET_SOCKET', '', '', 72701) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: 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(), 2, 18, 0, 246361662, 'SET_SOCKET', '', '', 72701) errno: 2002) Dec 17 12:26:01 :: CQuestManager::Kill QUEST_KILL_EVENT (pc=288837, npc=3304) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: 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(), 2, 18, 0, 246361662, 'SET_SOCKET', '', '', 72701) errno: 2002) SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying SYSERR: Dec 17 12:26:01 :: 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(), 2, 18, 0, 246361662, 'SET_SOCKET', '', '', 72701) errno: 2002) Dec 17 12:26:01 :: GIVE_GOLD: TREX27 222874 SYSERR: Dec 17 12:26:01 :: ChildLoop: AsyncSQL: retrying Dec 17 12:26:01 :: GIVE_GOLD: TREX27 222874 mysql vds.err Spoiler 161217 12:26:01 mysqld_safe mysqld restarted 2016-12-17 12:26:03 34426872832 [Note] /usr/local/libexec/mysqld (mysqld 10.1.19-MariaDB) starting as process 25349 ... 2016-12-17 12:26:04 34426872832 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2016-12-17 12:26:04 34426872832 [Note] InnoDB: The InnoDB memory heap is disabled 2016-12-17 12:26:04 34426872832 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-12-17 12:26:04 34426872832 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2016-12-17 12:26:04 34426872832 [Note] InnoDB: Compressed tables use zlib 1.2.8 2016-12-17 12:26:04 34426872832 [Note] InnoDB: Using generic crc32 instructions 2016-12-17 12:26:04 34426872832 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2016-12-17 12:26:05 34426872832 [Note] InnoDB: Completed initialization of buffer pool 2016-12-17 12:26:05 34426872832 [Note] InnoDB: Highest supported file format is Barracuda. 2016-12-17 12:26:05 34426872832 [Note] InnoDB: The log sequence numbers 1623701 and 1623701 in ibdata files do not match the log sequence number 1623721 in the ib_logfiles! 2016-12-17 12:26:05 34426872832 [Note] InnoDB: Database was not shutdown normally! 2016-12-17 12:26:05 34426872832 [Note] InnoDB: Starting crash recovery. 2016-12-17 12:26:05 34426872832 [Note] InnoDB: Reading tablespace information from the .ibd files... 2016-12-17 12:26:05 34426872832 [Note] InnoDB: Restoring possible half-written data pages 2016-12-17 12:26:05 34426872832 [Note] InnoDB: from the doublewrite buffer... 2016-12-17 12:26:07 34426872832 [Note] InnoDB: 128 rollback segment(s) are active. 2016-12-17 12:26:07 34426872832 [Note] InnoDB: Waiting for purge to start 2016-12-17 12:26:07 34426872832 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.32-79.0 started; log sequence number 1623721 2016-12-17 12:26:07 34426899456 [Note] InnoDB: Dumping buffer pool(s) not yet started 2016-12-17 12:26:07 34426872832 [Note] Plugin 'FEEDBACK' is disabled. 2016-12-17 12:26:07 34426872832 [Note] Recovering after a crash using tc.log 2016-12-17 12:26:07 34426872832 [Note] Starting crash recovery... 2016-12-17 12:26:07 34426872832 [Note] Crash recovery finished. 2016-12-17 12:26:07 34426872832 [Note] Server socket created on IP: '::'. 2016-12-17 12:26:08 34426872832 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '10.1.19-MariaDB' socket: '/tmp/mysql.sock' port: 3306 FreeBSD Ports 2016-12-17 12:26:08 34870071296 [ERROR] mysqld: Table './player/monarch' is marked as crashed and should be repaired 2016-12-17 12:26:09 34870071296 [Warning] Checking table: './player/monarch' 2016-12-17 12:26:09 34870069248 [ERROR] mysqld: Table './player/item' is marked as crashed and should be repaired 2016-12-17 12:26:09 34870069248 [Warning] Checking table: './player/item' 2016-12-17 12:26:09 34947527680 [ERROR] mysqld: Table './log/acce' is marked as crashed and should be repaired 2016-12-17 12:26:09 34870072320 [ERROR] mysqld: Table './log/acce' is marked as crashed and should be repaired 2016-12-17 12:26:09 34870072320 [Warning] Checking table: './log/acce' 2016-12-17 12:26:39 34870074368 [ERROR] mysqld: Table './player/new_petsystem' is marked as crashed and should be repaired 2016-12-17 12:26:39 34870074368 [Warning] Checking table: './player/new_petsystem' 2016-12-17 12:26:48 34870077440 [ERROR] mysqld: Table './account/account' is marked as crashed and should be repaired 2016-12-17 12:26:48 34870077440 [Warning] Checking table: './account/account' 2016-12-17 12:27:04 34870080512 [ERROR] mysqld: Table './player/player' is marked as crashed and should be repaired 2016-12-17 12:27:04 34870080512 [Warning] Checking table: './player/player' 2016-12-17 12:28:33 34870071296 [ERROR] mysqld: Table './player/affect' is marked as crashed and should be repaired 2016-12-17 12:28:33 34870071296 [Warning] Checking table: './player/affect' 2016-12-17 12:28:33 34870069248 [ERROR] mysqld: Table './player/player_index' is marked as crashed and should be repaired 2016-12-17 12:28:33 34870069248 [Warning] Checking table: './player/player_index' 2016-12-17 12:28:34 34870069248 [ERROR] mysqld: Table './player/quest' is marked as crashed and should be repaired 2016-12-17 12:28:34 34870069248 [Warning] Checking table: './player/quest' 2016-12-17 12:28:44 34870068224 [ERROR] mysqld: Table './log/loginlog2' is marked as crashed and should be repaired 2016-12-17 12:28:44 34870068224 [Warning] Checking table: './log/loginlog2' 2016-12-17 12:28:44 34947527680 [ERROR] mysqld: Table './player/safebox' is marked as crashed and should be repaired 2016-12-17 12:28:44 34947527680 [Warning] Checking table: './player/safebox' 2016-12-17 12:28:44 34870080512 [ERROR] mysqld: Table './player/messenger_list' is marked as crashed and should be repaired 2016-12-17 12:28:44 34870081536 [ERROR] mysqld: Table './player/messenger_list' is marked as crashed and should be repaired 2016-12-17 12:28:44 34870082560 [ERROR] mysqld: Table './player/messenger_list' is marked as crashed and should be repaired 2016-12-17 12:28:44 34870080512 [Warning] Checking table: './player/messenger_list' 2016-12-17 12:29:00 34870072320 [ERROR] mysqld: Table './log/levellog' is marked as crashed and should be repaired 2016-12-17 12:29:00 34870072320 [Warning] Checking table: './log/levellog' 2016-12-17 12:29:09 34947538944 [ERROR] mysqld: Table './log/goldlog' is marked as crashed and should be repaired 2016-12-17 12:29:09 34870072320 [ERROR] mysqld: Table './log/goldlog' is marked as crashed and should be repaired 2016-12-17 12:29:09 34870072320 [Warning] Checking table: './log/goldlog' 2016-12-17 12:29:10 34870068224 [ERROR] mysqld: Table './log/quest_reward_log' is marked as crashed and should be repaired 2016-12-17 12:29:10 34870068224 [Warning] Checking table: './log/quest_reward_log' 2016-12-17 12:29:53 34870072320 [ERROR] mysqld: Table './log/speed_hack' is marked as crashed and should be repaired 2016-12-17 12:29:53 34870072320 [Warning] Checking table: './log/speed_hack' 2016-12-17 12:30:18 34870084608 [ERROR] mysqld: Table './player/guild_member' is marked as crashed and should be repaired 2016-12-17 12:30:18 34870084608 [Warning] Checking table: './player/guild_member' 2016-12-17 12:30:36 34947538944 [ERROR] mysqld: Table './player/guild_comment' is marked as crashed and should be repaired 2016-12-17 12:30:36 34947538944 [Warning] Checking table: './player/guild_comment' 2016-12-17 12:32:38 34870072320 [ERROR] mysqld: Table './log/shout_log' is marked as crashed and should be repaired 2016-12-17 12:32:38 34870072320 [Warning] Checking table: './log/shout_log' 2016-12-17 12:33:00 34947538944 [ERROR] mysqld: Table './player/offline_shop_npc' is marked as crashed and should be repaired 2016-12-17 12:33:00 34947538944 [Warning] Checking table: './player/offline_shop_npc' 2016-12-17 12:40:37 34426891264 [ERROR] mysqld: Table './player/guild' is marked as crashed and should be repaired 2016-12-17 12:40:37 34426891264 [Warning] Checking table: './player/guild' 2016-12-17 12:43:20 34870068224 [ERROR] mysqld: Table './log/refinelog' is marked as crashed and should be repaired 2016-12-17 12:43:20 34870068224 [Warning] Checking table: './log/refinelog' 2016-12-17 12:50:35 34870085632 [ERROR] mysqld: Table './player/guild_grade' is marked as crashed and should be repaired 2016-12-17 12:50:35 34870085632 [Warning] Checking table: './player/guild_grade' 2016-12-17 12:52:05 34870093824 [ERROR] mysqld: Table './player/offline_shop_item' is marked as crashed and should be repaired 2016-12-17 12:52:05 34870093824 [Warning] Checking table: './player/offline_shop_item' 2016-12-17 13:29:45 34870086656 [ERROR] mysqld: Table './log/money_log' is marked as crashed and should be repaired 2016-12-17 13:29:45 34870094848 [ERROR] mysqld: Table './log/money_log' is marked as crashed and should be repaired 2016-12-17 13:29:45 34870094848 [Warning] Checking table: './log/money_log' 2016-12-17 13:54:13 34870084608 [ERROR] mysqld: Table './player/marriage' is marked as crashed and should be repaired 2016-12-17 13:54:13 34870084608 [Warning] Checking table: './player/marriage' 2 Link to comment Share on other sites More sharing options...
metin2team 766 Posted December 17, 2016 Share Posted December 17, 2016 25 minutes ago, DeYaN. said: mysqld: Table './player/offline_shop_npc' is marked as crashed and should be repaired all the messages like this one mean that you should repair the table the message actually is self-explanatory. Link to comment Share on other sites More sharing options...
DeYaN. 29 Posted December 17, 2016 Author Share Posted December 17, 2016 43 minutes ago, metin2team said: all the messages like this one mean that you should repair the table the message actually is self-explanatory. Its repair and start the database automatic because the table are crash when game core are crash Link to comment Share on other sites More sharing options...
127.0.0.1 34 Posted December 17, 2016 Share Posted December 17, 2016 Why always you guys overwrite MySQL database? How hard can it be to install some mysql tables correct? Can't connect to local MySQL server through socket '/tmp/mysql.sock' This means that MySQL server is dead. I noticed that most people who work in Metin2 scene, just make a backup archive and unpack in /var/db/ This is fucking wrong guys. You guys do not know to install a MySQL database and you want to make servers. I suggest you to do so: Stop the metin server Repair all the tables to make sure they are functional. Create a .sql dump to all databases belonging to metin. Stop the MySQL server. ( service mysql-server stop) Delete the folder / var / db / mysql Now start again mysql server Now configure your mysql server again (The user " root " ) GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY 'password' WITH GRANT OPTION; FLUSH PRIVILEGES; Now install metin tables from .sql dump Regards, Ramy 1 Link to comment Share on other sites More sharing options...
DeYaN. 29 Posted December 17, 2016 Author Share Posted December 17, 2016 40 minutes ago, 127.0.0.1 said: Why always you guys overwrite MySQL database? How hard can it be to install some mysql tables correct? Can't connect to local MySQL server through socket '/tmp/mysql.sock' This means that MySQL server is dead. I noticed that most people who work in Metin2 scene, just make a backup archive and unpack in /var/db/ This is fucking wrong guys. You guys do not know to install a MySQL database and you want to make servers. I suggest you to do so: Stop the metin server Repair all the tables to make sure they are functional. Create a .sql dump to all databases belonging to metin. Stop the MySQL server. ( service mysql-server stop) Delete the folder / var / db / mysql Now start again mysql server Now configure your mysql server again (The user " root " ) GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY 'password' WITH GRANT OPTION; FLUSH PRIVILEGES; Now install metin tables from .sql dump Regards, Ramy Thx you Ramy , yes .. i didn`t use the mysql dump , all other steps i do. But i don`t think the backup archive is the problem , i did that for 4 years and no problem by now... But ok, i will try with mysql dump. What i see strange : In syserr database : " AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) " - i dont have anything in player.monnarch , what he want to update ? in sysser/syslog channel who are crash every time the FIRST error provide from the offlineshop " query: UPDATE offline_shop_npc SET time = 27540 WHERE owner_id = 282380 " Link to comment Share on other sites More sharing options...
127.0.0.1 34 Posted December 17, 2016 Share Posted December 17, 2016 11 minutes ago, DeYaN. said: Thx you Ramy , yes .. i didn`t use the mysql dump , all other steps i do. But i don`t think the backup archive is the problem , i did that for 4 years and no problem by now... But ok, i will try with mysql dump. What i see strange : In syserr database : " AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) (query: UPDATE monarch set money=19085862 where empire=3 errno: 2002) " - i dont have anything in player.monnarch , what he want to update ? in sysser/syslog channel who are crash every time the FIRST error provide from the offlineshop " query: UPDATE offline_shop_npc SET time = 27540 WHERE owner_id = 282380 " Let me explain, let's say that you did a database backup with MySQL 5.5 , and now you have installed MySQL 5.6 If you have the database on MySQL 5.5 and MySQL 5.6 installed, this means that you overwrite database .. This is not good. All versions are different, and once this thing could cost you your entire database. Each MySQL version has a different structure, more or less. Never overwrite folder var/db/mysql/mysql this folder should be never overwrite. No one can know what is in your server, follow the steps above .. and come back with an answer if this problem appears. I'm pretty sure the problem is only mysql server. And to make sure that the tables are optimized for MySQL version/MariaDB that you use to run this command too. After installing the database as I said above, run this command. // Mysql 5.6 mysql_upgrade // mysql 5.7 mysql_upgrade -u root -p After reboot you server. Then wait for a new crash. Link to comment Share on other sites More sharing options...
Night 367 Posted December 17, 2016 Share Posted December 17, 2016 well metin2 does not even run correctly under mysql > 5.5 so you should stick with the older version OR fix it so that it work properly with it. and going back to what @127.0.0.1 said , the mysql folder should never be overwritten , (which almost all those noob devs do). so to come up to what you did, you just uploaded a mysql.tar.gz and unpacked it with a smile . causing the mysql to fuck up at some point. what you should do? try running mysql on safe mode. what if my db does not work even with this mode? (if you have a running server) take a backup of it, then reinstall the same version to get a backup of data. the reinstall it with a lower version (eh there should be some other way). then install your db with this data. (if not) reinstall a lower version nvm your data mate. note : make sure that the mysql folder is not there. (in your backup) 1 Link to comment Share on other sites More sharing options...
Premium tierrilopes 453 Posted December 17, 2016 Premium Share Posted December 17, 2016 23 minutes ago, Night said: well metin2 does not even run correctly under mysql > 5.5 so you should stick with the older version OR fix it so that it work properly with it. and going back to what @127.0.0.1 said , the mysql folder should never be overwritten , (which almost all those noob devs do). so to come up to what you did, you just uploaded a mysql.tar.gz and unpacked it with a smile . causing the mysql to fuck up at some point. what you should do? try running mysql on safe mode. what if my db does not work even with this mode? (if you have a running server) take a backup of it, then reinstall the same version to get a backup of data. the reinstall it with a lower version (eh there should be some other way). then install your db with this data. (if not) reinstall a lower version nvm your data mate. note : make sure that the mysql folder is not there. (in your backup) Just to say that metin2 works fine on higher versions, even mariadb forks. People should leave old versions and their bugs behind. Link to comment Share on other sites More sharing options...
DeYaN. 29 Posted December 18, 2016 Author Share Posted December 18, 2016 (edited) Ok, i do : Stop the metin server Repair all the tables to make sure they are functional. Create a .sql dump to all databases belonging to metin. Stop the MySQL server. ( service mysql-server stop) Delete the folder / var / db / mysql Now start again mysql server Now configure your mysql server again (The user " root " ) GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY 'password' WITH GRANT OPTION; FLUSH PRIVILEGES; Now install metin tables from .sql dump Run command: // Mysql 5.6 mysql_upgrade // mysql 5.7 mysql_upgrade -u root -p Now i`m waiting ... But i`m still ussing the mariadb. ##### First time, i wanted to move on mysqlserver57 (the mysqlserver55 i see that is vunerable) but when i do the command "portsnap fetch extract" , after 20 seconds beggin of update , the putty and server don`t respond. I login to the VNC console to see what are happens and : Spoiler So .. f`ck myself what`s wrong with this vds ! Edited August 24, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Premium tierrilopes 453 Posted December 18, 2016 Premium Share Posted December 18, 2016 (edited) 23 minutes ago, DeYaN. said: Ok, i do : Stop the metin server Repair all the tables to make sure they are functional. Create a .sql dump to all databases belonging to metin. Stop the MySQL server. ( service mysql-server stop) Delete the folder / var / db / mysql Now start again mysql server Now configure your mysql server again (The user " root " ) GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY 'password' WITH GRANT OPTION; FLUSH PRIVILEGES; Now install metin tables from .sql dump Run command: // Mysql 5.6 mysql_upgrade // mysql 5.7 mysql_upgrade -u root -p Now i`m waiting ... But i`m still ussing the mariadb. ##### First time, i wanted to move on mysqlserver57 (the mysqlserver55 i see that is vunerable) but when i do the command "portsnap fetch extract" , after 20 seconds beggin of update , the putty and server don`t respond. I login to the VNC console to see what are happens and : Reveal hidden contents So .. f`ck myself what`s wrong with this vds ! Just do this: pkg install -y mysql57-server Edited August 24, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
DeYaN. 29 Posted December 18, 2016 Author Share Posted December 18, 2016 6 hours ago, tierrilopes said: Just do this: pkg install -y mysql57-server Yeah ,probably i can install the mysql without the port update but i wanted to do that update for myself , i was disappointed when i see that error and i abort the operation. However i`m waiting the response after i installing in mariadb with mysqldump. Link to comment Share on other sites More sharing options...
DeYaN. 29 Posted December 19, 2016 Author Share Posted December 19, 2016 The channel1 core was crash again .. this is the game.core . I remember that i don`t have any problem before i add the offline shop. So ,i don`t think is a problem with mysql. Spoiler Core was generated by `game'. Program terminated with signal SIGSEGV, Segmentation fault. #0 0x28820cf7 in mysql_num_rows () from /usr/lib32/libmysqlclient.so.18 [Current thread is 1 (LWP 100086)] (gdb) bt full #0 0x28820cf7 in mysql_num_rows () from /usr/lib32/libmysqlclient.so.18 No symbol table info available. #1 0x08092f0c in CHARACTER::OnClick (this=0x0, pkChrCauser=0x73324000) at char.cpp:5454 __FUNCTION__ = "OnClick" #2 0x0817edb0 in CInputMain::Analyze (this=0x4d5b549c, d=0x4d5b5400, bHeader=<optimized out>, c_pData=0x4df85022 "\032\275\345") at input_main.cpp:3450 ch = 0x356cf000 iExtraLen = <optimized out> __FUNCTION__ = "Analyze" #3 0x081661fb in CInputProcessor::Process (this=0x4d5b549c, lpDesc=0x4d5b5400, c_pvOrig=0x4df85000, iBytes=40, r_iBytesProceed=@0xffffa274: 34) at input.cpp:99 iExtraPacketSize = <optimized out> bHeader = 26 '\032' c_pszName = 0x342f364c "OnClick" c_pData = 0x4df85022 "\032\275\345" bLastHeader = <optimized out> iLastPacketLen = 17 iPacketLen = 6 __FUNCTION__ = "Process" #4 0x0812eb33 in DESC::ProcessInput (this=0x4d5b5400) at desc.cpp:303 ---Type <return> to continue, or q <return> to quit--- iBytesProceed = 34 bytes_read = 40 __FUNCTION__ = "ProcessInput" #5 0x082a2f74 in io_loop (fdw=0x29938f80) at main.cpp:994 iRet = 0 num_events = 16 event_idx = 5 __FUNCTION__ = "io_loop" #6 0x082a39a9 in idle () at main.cpp:877 now = {tv_sec = 1482123648, tv_usec = 614480} passed_pulses = <optimized out> t = 98450652 pta = {tv_sec = 1482123648, tv_usec = 15884} process_time_count = 15 #7 0x082a526c in main (argc=1, argv=<error reading variable: Cannot access memory at address 0x4>) at main.cpp:539 sectree_manager = {<singleton<SECTREE_MANAGER>> = { _vptr$singleton = 0x830a1f0 <vtable for SECTREE_MANAGER+8>, static ms_singleton = 0xffffa648}, static current_sectree_version = 768, m_map_pkSectree = {_M_t = { _M_impl = {<std::allocator<std::_Rb_tree_node<std::pair<unsigned int const, SECTREE_MAP*> > >> = {<__gnu_cxx::new_allocator<std::_Rb_tree_node<std---Type <return> to continue, or q <return> to quit--- ::pair<unsigned int const, SECTREE_MAP*> > >> = {<No data fields>}, <No data fields>}, _M_key_compare = {<std::binary_function<unsigned int, unsigned int, bool>> = {<No data fields>}, <No data fields>}, _M_header = {_M_color = std::_S_red, _M_parent = 0x3d9e2f20, _M_left = 0x31b84ac0, _M_right = 0x353ffa40}, _M_node_count = 33}}}, m_map_pkArea = {_M_t = { _M_impl = {<std::allocator<std::_Rb_tree_node<std::pair<int const, std::map<std::basic_string<char, std::char_traits<char>, std::allocator<char> >, TAreaInfo, std::less<std::basic_string<char, std::char_traits<char>, std::allocator<char> > >, std::allocator<std::pair<std::basic_string<char, std::char_traits<char>, std::allocator<char> > const, TAreaInfo> > > > > >> = {<__gnu_cxx::new_allocator<std::_Rb_tree_node<std::pair<int const, std::map<std::basic_string<char, std::char_traits<char>, std::allocator<char> >, TAreaInfo, std::less<std::basic_string<char, std::char_traits<char>, std::allocator<char> > >, std::allocator<std::pair<std::basic_string<char, std::char_traits<char>, std::allocator<char> > const, TAreaInfo> > > > > >> = {<No data fields>}, <No data fields>}, _M_key_compare = {<std::binary_function<int, int, bool>> = {<No data fields>}, <No data fields>}, _M_header = {_M_color = std::_S_red, _M_parent = 0x59bfe700, _M_left = 0x59bfe700, _M_right = 0x59bfe700}, _M_node_count = 1}}}, m_vec_mapRegion = {<std::_Vector_base<SMapRegion, std::allocator<SMapRegion> >> = { Link to comment Share on other sites More sharing options...
DeYaN. 29 Posted December 20, 2016 Author Share Posted December 20, 2016 crash again and again .. # Link to comment Share on other sites More sharing options...
DeYaN. 29 Posted December 21, 2016 Author Share Posted December 21, 2016 upp Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now