DeYaN.

January 12, 2017

Hei dev , i put the system and in my test is working.

After i add to my server for players :

syser:

Spoiler

SYSERR: Jan 12 14:40:23 :: Click: CQuestManager::Click(pid=272457, target_npc_name=Ship ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:40:25 :: Click: CQuestManager::Click(pid=272457, target_npc_name=Ship ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:40:28 :: Click: CQuestManager::Click(pid=272457, target_npc_name=Ship ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:40:30 :: Click: CQuestManager::Click(pid=272457, target_npc_name=Ship ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:40:30 :: Click: CQuestManager::Click(pid=272457, target_npc_name=Ship ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:40:30 :: Click: CQuestManager::Click(pid=272457, target_npc_name=Ship ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:40:31 :: ItemLoad: cannot create item by vnum 53025 (name [GA]Frunza id 690014491)
SYSERR: Jan 12 14:40:31 :: Click: CQuestManager::Click(pid=272457, target_npc_name=Anubis ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:40:37 :: Click: CQuestManager::Click(pid=272457, target_npc_name=ARR000NNNNNN ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:40:49 :: Click: CQuestManager::Click(pid=272457, target_npc_name=farmCocos ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:40:50 :: Click: CQuestManager::Click(pid=272457, target_npc_name=farmCocos ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:40:50 :: Click: CQuestManager::Click(pid=272457, target_npc_name=farmCocos ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:40:50 :: Click: CQuestManager::Click(pid=272457, target_npc_name=farmCocos ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:40:51 :: Click: CQuestManager::Click(pid=272457, target_npc_name=[H]ViperOn3 ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:40:51 :: Click: CQuestManager::Click(pid=272457, target_npc_name=[H]ViperOn3 ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:40:52 :: Click: CQuestManager::Click(pid=272457, target_npc_name=[H]ViperOn3 ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:40:52 :: Click: CQuestManager::Click(pid=272457, target_npc_name=[H]ViperOn3 ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:40:59 :: Click: CQuestManager::Click(pid=57710, target_npc_name=eXtreme112 ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:40:59 :: Click: CQuestManager::Click(pid=57710, target_npc_name=eXtreme112 ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:40:59 :: Click: CQuestManager::Click(pid=57710, target_npc_name=eXtreme112 ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:01 :: Click: CQuestManager::Click(pid=57710, target_npc_name=Rengar ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:01 :: Click: CQuestManager::Click(pid=57710, target_npc_name=Rengar ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:01 :: Click: CQuestManager::Click(pid=57710, target_npc_name=Rengar ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:02 :: Click: CQuestManager::Click(pid=57710, target_npc_name=Rengar ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:02 :: Resume: wrong QUEST_WAIT request! : 201152
SYSERR: Jan 12 14:41:02 :: Click: CQuestManager::Click(pid=57710, target_npc_name=Rengar ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:02 :: Click: CQuestManager::Click(pid=57710, target_npc_name=Rengar ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:02 :: Click: CQuestManager::Click(pid=57710, target_npc_name=Rengar ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:03 :: Click: CQuestManager::Click(pid=57710, target_npc_name=Rengar ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:04 :: Click: CQuestManager::Click(pid=272457, target_npc_name=Mercury21 ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:06 :: Click: CQuestManager::Click(pid=244264, target_npc_name=Iugoslav ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:08 :: Click: CQuestManager::Click(pid=244264, target_npc_name=qAndrei ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:08 :: Click: CQuestManager::Click(pid=244264, target_npc_name=qAndrei ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:08 :: Click: CQuestManager::Click(pid=272457, target_npc_name=Iugoslav ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:09 :: Click: CQuestManager::Click(pid=244264, target_npc_name=[H]ViperOn3 ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:09 :: Click: CQuestManager::Click(pid=272457, target_npc_name=Iugoslav ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:09 :: Click: CQuestManager::Click(pid=272457, target_npc_name=Iugoslav ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:09 :: Click: CQuestManager::Click(pid=272457, target_npc_name=Iugoslav ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:09 :: Click: CQuestManager::Click(pid=244264, target_npc_name=[H]ViperOn3 ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:10 :: Click: CQuestManager::Click(pid=244264, target_npc_name=Hunter ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:10 :: Click: CQuestManager::Click(pid=244264, target_npc_name=Hunter ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:10 :: Click: CQuestManager::Click(pid=244264, target_npc_name=Hunter ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:13 :: Click: CQuestManager::Click(pid=57710, target_npc_name=Rengar ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:13 :: Click: CQuestManager::Click(pid=57710, target_npc_name=Rengar ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:13 :: Click: CQuestManager::Click(pid=57710, target_npc_name=Rengar ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:14 :: Click: CQuestManager::Click(pid=57710, target_npc_name=Rengar ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:15 :: Click: CQuestManager::Click(pid=57710, target_npc_name=Rengar ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:15 :: Click: CQuestManager::Click(pid=244264, target_npc_name=KyngStar ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:15 :: Click: CQuestManager::Click(pid=57710, target_npc_name=Rengar ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:15 :: Click: CQuestManager::Click(pid=244264, target_npc_name=KyngStar ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:15 :: Click: CQuestManager::Click(pid=57710, target_npc_name=Rengar ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:16 :: Click: CQuestManager::Click(pid=244264, target_npc_name=Carr3four ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:16 :: Click: CQuestManager::Click(pid=244264, target_npc_name=Carr3four ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:16 :: Click: CQuestManager::Click(pid=244264, target_npc_name=Carr3four ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:17 :: Click: CQuestManager::Click(pid=244264, target_npc_name=Carr3four ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:17 :: Click: CQuestManager::Click(pid=244264, target_npc_name=Carr3four ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:18 :: Click: CQuestManager::Click(pid=57710, target_npc_name=eXtreme112 ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:18 :: Click: CQuestManager::Click(pid=57710, target_npc_name=eXtreme112 ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:19 :: Click: CQuestManager::Click(pid=2484709, target_npc_name=xSavitar ,magazin) - NOT EXIST NPC RACE VNUM[30000]
SYSERR: Jan 12 14:41:20 :: Click: CQuestManager::Click(pid=57710, target_npc_name=xRebelAx ,magazin) - NOT EXIST NPC RACE VNUM[30000]

So when i try to open the shop offline by ken is not working , the normal shop is working.

And 2 minutes lateer the core are crash , this is the gdb:

Spoiler

#0 CEntity::UpdateSectree (this=0x3f439000) at sectree.h:191
it = {<std::tr1::__detail::_Hashtable_iterator_base<std::pair<CEntity* const, int>,false>> = {
_M_cur_node = 0x3f439000, _M_cur_bucket = 0x3fb881e0}, <No data fields>}
this_it = {<std::tr1::__detail::_Hashtable_iterator_base<std::pair<CEntity* const, int>,false>> = {
_M_cur_node = 0x0, _M_cur_bucket = 0x0}, <No data fields>}
__FUNCTION__ = "UpdateSectree"
#1 0x0806f487 in CHARACTER::Show (this=0x3f439000, lMapIndex=71, x=706003, y=512168, z=0,
bShowSpawnMotion=false) at char.cpp:1596
sectree = 0x59b45280
bChangeTree = true
#2 0x080b7911 in CHARACTER_MANAGER::SpawnMob (this=0xffffc398, dwVnum=2065, lMapIndex=71, x=706003,
y=512168, z=0, bSpawnMotion=false, iRot=88, bShow=true, isOfflineShopNPC=false, real_owner=0)
at char_manager.cpp:450
tree = <value optimized out>
dwAttr = <value optimized out>
is_set = <value optimized out>
pkMob = (const CMob *) 0x297eec80
sectree = <value optimized out>
ch = 0x3f439000
__FUNCTION__ = "SpawnMob"
s_isLog = false

The problem are in the source. I recheck the files but is perfect...

Solved # My problem was from OBJDIR , i delete all and recompile

January 12, 2017

Hello dev i have a problem :))

For 3 years i use a old mob_proto with his decryptor ( 2089M version) . Now i install the "target information mob system" and i see that the system use the hp,attack,etc from mob_proto and my mob_proto because is old ( 2089m version) don`t have the new columns.

So .. i search on the google and i find a mob_proto 2016 in my language with that new columns , but the type is " mob_proto_dump.xml so .. now the new problem : Who i can compile in mob_proto ( to put in the client ) ? :))

I search on the google but without succes.

This is the mob_proto_dump.xml wich i want to compile :

This is the hidden content, please

# solve

December 21, 2016

upp

December 20, 2016

crash again and again .. #

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

December 18, 2016

channel - config of shop offline set the yang for create a shop 0 . The shop offline by ken have to many bugs.

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.

December 18, 2016

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 !

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 "

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

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'

December 13, 2016

2 minutes ago, VZLand said:

its rev not bad but necesary any fixed!

I don`t know why the mysql process is down ..

December 13, 2016

3 minutes ago, VZLand said:

u not have last rev from ken?

https://metin2.download/picture/dwNvZ4DNmv73VczCIKCfmcEG4resDN7s/.png

¿

MHM,i think i have the same version

Spoiler

December 13, 2016

4 hours ago, terrorr said:

You has a Mysql problem.

you think that ? hmm

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

And what kind of problem i have there ? hmmm

December 12, 2016

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

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

Every time the core are stop with this

syserr:

Spoiler

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

syslog:

Spoiler

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

December 12, 2016

item_proto client - type/antiflag/flag (i dont remember exactly)

December 8, 2016

Nicusor probably the models .

Member Representations · December 7, 2016

37 minutes ago, Taz21 said:

Ai coaiele cat rama?

cat china man :)))

December 6, 2016

53 minutes ago, wezt said:

@DeYaN. you need to create 'locale' folder in your game client directory.

Reveal hidden contents

Then, move all dds/png/tga files from your locale pack in this folder. File paths should be the same as in your locale pack (e.g. you have 'locale\en\ui\loading\gauge_empty.dds' file, move it in 'GAME_CLIENT_FOLDER\locale\en\ui\loading\' directory).

Reveal hidden contents

Regards.

Thx you again , i try and that is not my problem

If i make the crash with login at channel and after that logout and login to another channel , my sysser allways have this error:

Spoiler

1206 01:56:53861 :: File "game.py", line 1353, in OnKeyUp

1206 01:56:53861 :: TypeError
1206 01:56:53861 :: :
1206 01:56:53861 :: 'NoneType' object has no attribute '__getitem__'

December 5, 2016

upp ##

December 5, 2016

you find something ?

December 5, 2016

5 hours ago, wezt said:

@DeYaN., check out your item_list.txt (lines specified in syserr.txt) also try to move all images from locale pack to locale folder (described above).

Thx you for reply , i fix the item_list.txt but this is not the problem , syser not register a error wich is crash the client. Always was a different error.

And i don`t understand what images i need to move ? ( my locale.eix/epk have the default files nothing in + and in folder pack is only files with .epk and .eix )

Example: I login in channel 2 and after that i logout and login again in channel 1 and tadaam.. ??????? (client crash)

December 4, 2016

On 3/10/2016 at 4:16 PM, wezt said:

Hey, thanks for advice with locale files (I've had it in old-old client but forgot to add this thing in new one when moved to 40k).

Now this problem also fixed for me (200 teleports in row - no any crashes).

As far i remember the problem is in loading background images for loading screen.

@mafianekcek I'd advice you move all py/txt files back to locale pack and leave in locale folder only images

Regards

Wezt , i find this topic , sorry for quote , but i have a problem like this ...

When i try to change many times the character , the client crash with this:

Spoiler

This is my errorlog :

Spoiler

Module Name: C:\Users\Manafu\Desktop\Metin2Icarus v1.1\Metin2Icarus.exe
Time Stamp: 0x58445413 - (null)

Exception Type: 0xc0000005

eax: 0x2d3aedb8   ebx: 0x004c1960
ecx: 0x3ffdf37d   edx: 0x00000003
esi: 0x0316f000   edi: 0x2e3c8248
ebp: 0x00b0df48   esp: 0x00b0df2c

0x0039dc8e   C:\Users\Manafu\Desktop\Metin2Icarus v1.1\Metin2Icarus.exe
0x0031db4f   C:\Users\Manafu\Desktop\Metin2Icarus v1.1\Metin2Icarus.exe
0x0031de05   C:\Users\Manafu\Desktop\Metin2Icarus v1.1\Metin2Icarus.exe
0x003083ab   C:\Users\Manafu\Desktop\Metin2Icarus v1.1\Metin2Icarus.exe
0x00307f61   C:\Users\Manafu\Desktop\Metin2Icarus v1.1\Metin2Icarus.exe
0x0030677e   C:\Users\Manafu\Desktop\Metin2Icarus v1.1\Metin2Icarus.exe
0x0035af06   C:\Users\Manafu\Desktop\Metin2Icarus v1.1\Metin2Icarus.exe
0x00342a95   C:\Users\Manafu\Desktop\Metin2Icarus v1.1\Metin2Icarus.exe
0x00342df2   C:\Users\Manafu\Desktop\Metin2Icarus v1.1\Metin2Icarus.exe
0x0026d39f   C:\Users\Manafu\Desktop\Metin2Icarus v1.1\Metin2Icarus.exe
0x1e0a87b7   C:\Users\Manafu\Desktop\Metin2Icarus v1.1\python27.dll

This is the syserr:

Spoiler

1204 13:43:32839 :: Traceback (most recent call last):

1204 13:43:32839 :: File "game.py", line 1353, in OnKeyUp

1204 13:43:32839 :: TypeError
1204 13:43:32839 :: :
1204 13:43:32840 :: 'NoneType' object has no attribute '__getitem__'
1204 13:43:32840 ::

1204 13:43:33898 :: Unknown Server Command super_quest 151 | super_quest
1204 13:43:38653 :: Unknown Server Command super_quest 151 | super_quest
1204 13:43:43387 :: Unknown Server Command super_quest 151 | super_quest
1204 13:43:48420 :: Unknown Server Command super_quest 151 | super_quest
1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9021

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9022

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9023

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9024

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9025

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9026

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9027

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9028

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9029

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9030

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9031

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9032

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9033

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9034

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9035

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9036

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9037

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9038

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9039

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9040

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9041

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9042

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9043

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9044

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9045

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9046

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9047

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9048

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9049

1204 13:43:55388 :: CItemManager::LoadItemList(locale/ro/item_list.txt) - StrangeLine in 9050

December 3, 2016

23 hours ago, Braxy said:

You dont have to download files to search in them , u could take every each file from site and find directly from the mega then u can donwload the specified folder as .rar

Thx you , solve # first problem , now .. the second

December 2, 2016

On 12/1/2016 at 6:16 AM, Braxy said:

Here u can find the updates that are on Official servers , these updates include couple of HairStyle Models for Lycan

This is the hidden content, please

Sign In

or

Sign Up

Braxy , you have any ideea in wich folder is the hairstyle ? i try to download all files and after that ,to search , but it`s download with 43kb/s

Sign In

Forums

Store

Third Party - Providers Directory

Feature Plan

Release Notes

Docs

Events

Posts posted by DeYaN.

Important Information