• 0
Sign in to follow this  
Followers 0
DeYaN.

Mysql service down problem.

Question

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'
 

 

Share this post


Link to post
Share on other sites

13 answers to this question

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

 

Share this post


Link to post
Share on other sites
  • 0
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

Share this post


Link to post
Share on other sites
  • 0

Why always you guys overwrite MySQL database?   :facepalm: 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/  :lol: 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 person likes this

Share this post


Link to post
Share on other sites
  • 0
40 minutes ago, 127.0.0.1 said:

Why always you guys overwrite MySQL database?   :facepalm: 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/  :lol: 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 "

 

Share this post


Link to post
Share on other sites
  • 0
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.

Share this post


Link to post
Share on other sites
  • 0

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 person likes this

Share this post


Link to post
Share on other sites
  • 0
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.

Share this post


Link to post
Share on other sites
  • 0

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

i194_cimgpsh_orig.png

So .. f`ck myself what`s wrong with this vds !

Share this post


Link to post
Share on other sites
  • 0
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

i194_cimgpsh_orig.png

So .. f`ck myself what`s wrong with this vds !

Just do this:

pkg install -y mysql57-server

Share this post


Link to post
Share on other sites
  • 0
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.

Share this post


Link to post
Share on other sites
  • 0

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> >> = {
 

 

Share this post


Link to post
Share on other sites

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
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.