Jump to content

Shop offline crash my core

DeYaN.
 Share

Recommended Posts

DeYaN. Proficient

DeYaN. 27

Posted
Posted

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

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

Every time the core are stop with this

syserr:

Spoiler

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

 

syslog:

Spoiler

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

 

Link to comment
Share on other sites
  • Replies 8
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

terrorr
terrorr

Just this is the problem : Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)   Try reinstal mysql and all be fine.

DeYaN. Proficient

DeYaN. 27

Posted
  • Author
Posted
4 hours ago, terrorr said:

You has a Mysql problem.

you think that ? hmm

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

And what kind of problem i have there ? hmmm 

Link to comment
Share on other sites
metin2team Proficient

metin2team 741

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

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

 

also this 

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

your mysql server went down or something is wrong.

 

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

Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
 Share
Go to topic listing

Announcements



  • Similar Content

  • Activity

    1. 0

      We are looking for a C++ and Python programmer

      We are looking for a C++ and Python programmer for systems development and warfare for Metin2
      boloca in Paid Support / Searching / Recruiting
    2. 0

      [Quest Scheduler Request] Is there a way to make a quest run independet of player events? Lets say start quest automatically at server startup?

      The idea is, i want this quest to run regardless of player actions, at the moment it seems to start at player login ideally the quest would start at day Y(could have daily flag) hour X so basically a scheduler, so it won't be dependent on any player events quest test_npcmove begin state start begin when letter begin chat("Started") set_state("spawn_monster_in_map_boss_1") end end -- State to check for/spawn boss 1 state spawn_monster_in_map_boss_1 begin when letter begin chat("Spawning first boss") local mob_vnum = 102 -- Adjust VNUM for boss 1 local map_index = 352 local mobs = find_mobs_in_map(mob_vnum, map_index) local vid_boss1 = 0 local mobs_str = "BOSS 1 VIDs: {" .. table.concat(mobs, ", ") .. "}" chat(mobs_str) chat("Player X: " .. 339 .. " Y: " .. 363) if table.getn(mobs) > 0 then vid_boss1 = mobs[1] chat("Boss 1 found, using existing with VID: " .. tostring(vid_boss1)) else local vids = spawn_monster_in_map(mob_vnum, 1, false, map_index, 339, 363 + 10, true) vid_boss1 = vids[1] if vids[1] ~= nil then vid_boss1 = vids[1] chat("Boss 1 spawned with VID: " .. tostring(vid_boss1)) else vids = find_mobs_in_map(mob_vnum, map_index) vid_boss1 = vids[1] chat("Boss 2 fetched vid for spwaned mob: " .. tostring(vid_boss1)) end end pc.setqf("vid_boss1", vid_boss1) set_state("spawn_monster_in_map_boss_2") end end -- State to check for/spawn boss 2 state spawn_monster_in_map_boss_2 begin when letter begin local mob_vnum = 101 -- Adjust VNUM for boss 2 local map_index = 352 local mobs = find_mobs_in_map(mob_vnum, map_index) local vid_boss2 = 0 local mobs_str = "BOSS 2 VIDs: {" .. table.concat(mobs, ", ") .. "}" chat(mobs_str) if table.getn(mobs) > 0 then vid_boss2 = mobs[1] chat("Boss 2 found, using existing with VID: " .. tostring(vid_boss2)) else local vids = spawn_monster_in_map(mob_vnum, 1, false, map_index, 339, 363 - 10, true) vid_boss2 = vids[1] if vids[1] ~= nil then vid_boss2 = vids[1] chat("Boss 1 spawned with VID: " .. tostring(vid_boss2)) else vids = find_mobs_in_map(mob_vnum, map_index) vid_boss2 = vids[1] chat("Boss 2 fetched vid for spwaned mob: " .. tostring(vid_boss2)) end end pc.setqf("vid_boss2", vid_boss2) set_state("move_bosses") end end -- State to move both bosses state move_bosses begin when letter begin local vid_boss1 = pc.getqf("vid_boss1") local vid_boss2 = pc.getqf("vid_boss2") local target_x = 339 local target_y = 363 mob_move(vid_boss1, target_x, target_y) mob_move(vid_boss2, target_x, target_y) chat("Both bosses moved to player's position.") set_state("bosses_fight") end end -- State where bosses fight state bosses_fight begin when letter begin local vid_boss1 = pc.getqf("vid_boss1") local vid_boss2 = pc.getqf("vid_boss2") local map_index = 352 chat("Boss 1 VID: " .. tostring(vid_boss1)) chat("Boss 2 VID: " .. tostring(vid_boss2)) local success2, message2 = set_pc_can_attack_monster(vid_boss1, false, map_index) local success3, message3 = set_pc_can_attack_monster(vid_boss2, false, map_index) chat("Attempt to make boss 1 invinciple " .. tostring(success2) .. " - " .. message2) chat("Attempt to make boss 2 invinciple " .. tostring(success3) .. " - " .. message3) -- Attempt to make boss 1 attack boss 2 local success1, message1 = attack_mob(vid_boss1, vid_boss2, map_index) if success1 ~= nil and message1 ~= nil then chat("Attack attempt from Boss 1 to Boss 2: " .. tostring(success1) .. " - " .. message1) else chat("Attack attempt from Boss 1 to Boss 2: success or message is nil") end -- Attempt to make boss 2 attack boss 1 local success2, message2 = attack_mob(vid_boss2, vid_boss1, map_index) if success2 ~= nil and message2 ~= nil then chat("Attack attempt from Boss 2 to Boss 1: " .. tostring(success2) .. " - " .. message2) else chat("Attack attempt from Boss 2 to Boss 1: success or message is nil") end chat("Bosses are now set to fight each other.") chat("---------------------------------END------------------------------------") set_state("bosses_alive") end end state bosses_alive begin when letter begin chat("Checking if boss died") local vid_boss1 = pc.getqf("vid_boss1") local vid_boss2 = pc.getqf("vid_boss2") local map_index = 352 -- Check if Boss 1 is alive local is_boss1_alive, boss1_msg = is_mob_alive_in_map(vid_boss1, map_index) chat("Boss 1 alive check: " .. tostring(is_boss1_alive) .. " - " .. boss1_msg) -- Check if Boss 2 is alive local is_boss2_alive, boss2_msg = is_mob_alive_in_map(vid_boss2, map_index) chat("Boss 2 alive check: " .. tostring(is_boss2_alive) .. " - " .. boss2_msg) -- Determine the next state based on the bosses' statuses if not is_boss1_alive or not is_boss2_alive then if is_mob_alive_in_map(vid_boss1, map_index) then local success2, message2 = set_pc_can_attack_monster(vid_boss1, true, map_index) chat("Resetting invicibility for boss1 " .. tostring(success2) .. " - " .. message2) end if is_mob_alive_in_map(vid_boss2, map_index) then local success3, message3 = set_pc_can_attack_monster(vid_boss2, true, map_index) chat("Resetting invicibility for boss2 " .. tostring(success3) .. " - " .. message3) end chat("One of the bosses is dead. Resetting quest.") set_state("start") else chat("Both bosses are alive. Continuing the fight.") set_state("bosses_alive") end end end end And the last state, called bosses_alive seems to also reexecute only at player relog (login) Is there a way to make it so the states are independent of player events and just execute as soon as sv starts?
      astroNOT in Community Support - Questions & Answers
    3. 111

      Ulthar SF V2 (TMP4 Base)

      Can someone help me? .. rafinement still not working for me..
      robertbode in Binaries
    4. 0

      Quest function when 102.kill definition whereabouts help

      Hello, So I m trying to find where this vnum.kill function is defined on serverside, seems quite tricky, if anybody knows where it is defined and what name it has, please lmk Thanks, Gabi might be this guy void CQuestManager::Kill(unsigned int pc, unsigned int npc) { //m_CurrentNPCRace = npc; PC * pPC; sys_log(0, "CQuestManager::Kill QUEST_KILL_EVENT (pc=%d, npc=%d)", pc, npc); if ((pPC = GetPC(pc))) { if (!CheckQuestLoaded(pPC)) return; // kill call script if (npc >= MAIN_RACE_MAX_NUM) //@fixme109 m_mapNPC[npc].OnKill(*pPC); //@warme004 m_mapNPC[QUEST_NO_NPC].OnKill(*pPC); #ifdef ENABLE_PARTYKILL // party_kill call script LPCHARACTER ch = GetCurrentCharacterPtr(); LPPARTY pParty = ch->GetParty(); LPCHARACTER leader = pParty ? pParty->GetLeaderCharacter() : ch; if (leader) { m_pCurrentPartyMember = ch; if (npc >= MAIN_RACE_MAX_NUM) //@fixme109 m_mapNPC[npc].OnPartyKill(*GetPC(leader->GetPlayerID())); //@warme004 m_mapNPC[QUEST_NO_NPC].OnPartyKill(*GetPC(leader->GetPlayerID())); pPC = GetPC(pc); } #endif } else sys_err("QUEST: no such pc id : %d", pc); }
      astroNOT in Community Support - Questions & Answers
    5. 5

      [M2 FILTER] Customized Client Filter

      ENB Mode, a graphic enhancer for dx that people used on SA:MP to make it look better, i didn't see a metin2 server using this since 2017 . [Hidden Content]
      envy in Features & Metin2 Systems
    6. 19

      Chat / Whisper Emoji

      Simpson1 in Features & Metin2 Systems
    7. 0

      [INGAME] RGB Color on chat broken

      Hello all, It's my own created bug. I made many changes(implenting of systems) and I didn't noticed until now, so I'm not sure what invoke the below bug. If anyone could help me. The below there is a description of bug, feel free to ask parts of code etc... This text is CHAT_TYPE_SHOUT --> Call. But when add the Chatlogs Window above, the result of color is correct. The same happends with all kinds of chat.(Guild,party etc..) I'm not sure for reason but I can see the correct color in chat, when the screen/background/frontground is darker. (E.g. I tried to take a screenshot of bug with Lightshot the screen became darker and then the color of text was correct(green in this case).
      nora in Community Support - Questions & Answers
    8. 5

      [FREE] 1x1 pvp/event map by Davian

      @JimmermaniaThank you for your feedback. I will upload the link today, i am just waiting for Davian to search for the textures. [Hidden Content] Here is the full with the missing textures. I tried to upload the link, but I don't know how it works. I saw that the grass is grey too, but it has the textures in D:\ymir work\zone\dl2_gras\Foliage_SPR_S007_Diff.dds But if does not work for you please try to open it with a picture editor like photoshop click on "save as" and rewrite the old .dds
      vandaa95 in Maps
    9. 0

      Beginner / What is the most important?

      Hey, I want to know what is the most important thing to know, when you want to be a DEV in Metin2? What skills do you need, which software do you need (if you maybe want to host it online too) Thank you for your answers! :)
      chaosstyle in Community Support - Questions & Answers

  • Recently Browsing

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.