Çözüldü DB Şişmesi nasıl giderilir?

okcoder1134 · 5 Mayıs 2020

DB syserr ve syslog boyutları her dakika başı 2-3 MB artıyor.
saatte 2-3 GB'ya kadar ulaşabiliyor.
Tekrarladığı hatalar ise şu şekilde :

Kod:

May  5 17:55:45 :: QUERY_FLUSH: replace into item_proto  (vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, masktype, masksubtype, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 ) values (51502, 23, 0, "à «È¥à ¸Ü®", "Cor Draconis (işlenmemiş)", 0, 0, 0, 1, 4, 0, 106880, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
May  5 17:55:45 :: QUERY_FLUSH: replace into item_proto  (vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, masktype, masksubtype, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 ) values (51503, 23, 0, "ÈØÈ‘à «È¥à ¸Ü®", "Cor Draconis (normal)", 0, 0, 0, 1, 4, 0, 106880, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
May  5 17:55:45 :: QUERY_FLUSH: replace into item_proto  (vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, masktype, masksubtype, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 ) values (51504, 23, 0, "ÑÒÈ‘à «È¥à ¸Ü®", "Cor Draconis (soylu)", 0, 0, 0, 1, 4, 0, 106880, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
May  5 17:55:45 :: QUERY_FLUSH: replace into item_proto  (vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, masktype, masksubtype, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 ) values (51505, 23, 0, "ÑÕ«Gà «È¥à ¸Ü®", "Cor Draconis (değerli)", 0, 0, 0, 1, 4, 0, 106880, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
May  5 17:55:45 :: QUERY_FLUSH: replace into item_proto  (vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, masktype, masksubtype, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 ) values (51506, 23, 0, "|Ü³Gà «È¥à ¸Ü®", "Cor Draconis (destansı)", 0, 0, 0, 1, 4, 0, 106880, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
May  5 17:55:45 :: QUERY_FLUSH: replace into item_proto  (vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, masktype, masksubtype, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 ) values (51507, 23, 0, "ÈØÈ‘à «È¥à ¸Ü®", "Cor Draconis (yontulmuş)", 0, 0, 0, 1, 4, 0, 106880, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
May  5 17:55:45 :: QUERY_FLUSH: replace into item_proto  (vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, masktype, masksubtype, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 ) values (51508, 23, 0, "ÑÒÈ‘à «È¥à ¸Ü®", "Cor Draconis (ender)", 0, 0, 0, 1, 4, 0, 106880, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
May  5 17:55:45 :: QUERY_FLUSH: replace into item_proto  (vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, masktype, masksubtype, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 ) values (51509, 23, 0, "ÑÕ«Gà «È¥à ¸Ü®", "Cor Draconis (antika)", 0, 0, 0, 1, 4, 0, 106880, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
May  5 17:55:45 :: QUERY_FLUSH: replace into item_proto  (vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, masktype, masksubtype, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 ) values (51510, 23, 0, "|Ü³Gà «È¥à ¸Ü®", "Cor Draconis (efsanevi)", 0, 0, 0, 1, 4, 0, 65664, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
May  5 17:55:45 :: QUERY_FLUSH: replace into item_proto  (vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, masktype, masksubtype, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 ) values (51511, 23, 0, "Ú©Ø¦à «È¥à ¸Ü®", "Cor Diamas", 0, 0, 0, 1, 4, 0, 106880, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
May  5 17:55:45 :: QUERY_FLUSH: replace into item_proto  (vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, masktype, masksubtype, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 ) values (51512, 23, 0, "ÈØ¦à «È¥à ¸Ü®", "Cor Rubinum", 0, 0, 0, 1, 4, 0, 106880, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
May  5 17:55:45 :: QUERY_FLUSH: replace into item_proto  (vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, masktype, masksubtype, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 ) values (51513, 23, 0, "Ç³Ø¦à «È¥à ¸Ü®", "Cor Jadeit", 0, 0, 0, 1, 4, 0, 106880, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
May  5 17:55:45 :: QUERY_FLUSH: replace into item_proto  (vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, masktype, masksubtype, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 ) values (51514, 23, 0, "Ã¶Ø¦à «È¥à ¸Ü®", "Cor Saphirum", 0, 0, 0, 1, 4, 0, 106880, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
May  5 17:55:45 :: QUERY_FLUSH: replace into item_proto  (vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, masktype, masksubtype, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 ) values (51515, 23, 0, "ÔºØ¦à «È¥à ¸Ü®", "Cor Granatum", 0, 0, 0, 1, 4, 0, 106880, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
May  5 17:55:45 :: QUERY_FLUSH: replace into item_proto  (vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, masktype, masksubtype, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 ) values (51516, 23, 0, "É¦Ø¦à «È¥à ¸Ü®", "Cor Atrum", 0, 0, 0, 1, 4, 0, 106880, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
May  5 17:55:45 :: QUERY_FLUSH: replace into item_proto  (vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, masktype, masksubtype, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 ) values (51517, 23, 0, "Ú©Ø¦à «È¥à ¸Ü®(ÈØÒ®Â¶)", "Cor Diamas (normal)", 0, 0, 0, 1, 4, 0, 106880, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )

Kod:

May  5 17:55:26 :: MOB #14017 Sunak                    level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14018 Sunak                    level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14019 Sunak                    level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14020 Karargah                 level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14021 Karargah                 level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14022 Karargah                 level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14023 Karargah                 level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14024 Karargah                 level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14025 Karargah                 level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14026 Karargah                 level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14027 Karargah                 level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14028 Karargah                 level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14029 Karargah                 level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14030 Eğitim Kampı             level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14031 Eğitim Kampı             level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14032 Eğitim Kampı             level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14033 Eğitim Kampı             level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14034 Eğitim Kampı             level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14035 Eğitim Kampı             level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14036 Eğitim Kampı             level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14037 Eğitim Kampı             level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14038 Eğitim Kampı             level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14039 Eğitim Kampı             level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14040 Ocak                     level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14041 Ocak                     level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14042 Ocak                     level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14043 Ocak                     level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14044 Ocak                     level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14045 Ocak                     level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14046 Ocak                     level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14047 Ocak                     level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14048 Ocak                     level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #14049 Ocak                     level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #20001 Simyacı                  level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20002 Aranyo                   level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20003 Ah-Yu                    level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20004 Dilenci                  level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20005 Yonah                    level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20006 Mirine                   level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20007 Depocu                   level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20008 Octavio                  level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20009 Yaşlı Adam               level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20010 Seyyar satıcı            level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20011 Uriel                    level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20012 Yu-Rang                  level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20013 Hidra Bekçisi            level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20014 Taurean                  level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20015 Deokbae                  level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20016 Demirci                  level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20017 Yu-Hwan                  level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20018 Baek-Go                  level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20019 Yang-Shin                level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20020 Hain Balso               level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20021 Ariyoung                 level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20022 Basit Şebnemci           level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20023 Soon                     level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20024 Harang                   level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20025 .                        level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20026 Ji-Ryu                   level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20027 Gillian                  level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20028 Mirinenin Erkek Kardeşi  level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20029 Midilli                  level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20030 At                       level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20031 Noel Baba                level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20032 Noel Ağacı               level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20033 Noel Ağacı               level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20034 Noel Ağacı               level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20035 Bayrak                   level: 1   rank: 5 empire: 1
May  5 17:55:26 :: MOB #20036 Bayrak                   level: 1   rank: 5 empire: 2
May  5 17:55:26 :: MOB #20037 Bayrak                   level: 1   rank: 5 empire: 3
May  5 17:55:26 :: MOB #20038 ..                       level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20039 .                        level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20040 Emlakçı                  level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20041 Sarhoş                   level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20042 Seyyar satıcı            level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20043 .                        level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20044 Silahçı, Stanley         level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20045 Zırhçı, Stanton          level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20046 Kuyumcu, Starbuck        level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20047 Elmas Damarı             level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20048 Kehribar Damarı          level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20049 Fosil Tahta Damarı       level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20050 Bakır Damarı             level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20051 Gümüş Damarı             level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20052 Altın Damarı             level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20053 Yeşim Damarı             level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20054 Abanoz Damarı            level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20055 Midye Yığını             level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20056 Beyaz Altın Damarı       level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20057 Kristal Damarı           level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20058 Kuvars Damarı            level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20059 Cennetin Gözyaşı Damarı  level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20060 Elmas İşleyici           level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20061 Kehribar İşleyici        level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20062 Fosil Odun İşleyici      level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20063 Bakır İşleyici           level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20064 Gümüş İşleyici           level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20065 Altın İşleyici           level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20066 Yeşim İşleyici           level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20067 Abanoz İşleyici          level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20068 İnci İşleyici            level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20069 Beyaz Altın İşleyici     level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20070 Kristal İşleyici         level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20071 Ametist İşleyici         level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20072 Cennet Gözyaşı İşleyici  level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20073 Eski Mühür               level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20074 ŞeytanKulesi SilahUstası level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20075 ŞeytanKulesi Zırh Ustası level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20076 Şeytan Kulesi Kuyumcusu  level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20077 Sunak muhafızı           level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #20078 Sunak muhafızı           level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #20079 Sunak muhafızı           level: 70  rank: 5 empire: 0
May  5 17:55:26 :: MOB #20080 Eğitim Rehberi           level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20081 Çalıntı Geçit Mühürü     level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20082 Usta                     level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20083 Jegal-Tunseok            level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20084 Biyolog Chaegirab        level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20085 Jimjunja                 level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20086 Handu-Up                 level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20087 Wonda-Rim                level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20088 Shuk-Sal                 level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20089 Pung-Ho                  level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20090 Heuk-Yong                level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20091 Seon-Pyeong              level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20092 Servisci                 level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20093 Koe-Pung                 level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20094 Hong-Hae                 level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20095 Seon-Hae                 level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20096 ??? ???                  level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20097 Kale Girişi              level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20098 Kale Girişi              level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20099 Kale Girişi              level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20101 Beyaz At                 level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20102 Kahverengi At            level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20103 Siyah At                 level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20104 Beyaz At                 level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20105 Kahverengi At            level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20106 Siyah At                 level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20107 Beyaz At                 level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20108 Kahverengi At            level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20109 Siyah At                 level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20110 Yaban Domuzu             level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20111 Kurt                     level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20112 Kaplan                   level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20113 Aslan                    level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20114 white lion               level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20115 Savaş Yaban Domuzu       level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20116 Kızgın Kurt              level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20117 Vahşi Kaplan             level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20118 Yırtıcı Aslan            level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20119 Asil Kara Yağız Atı      level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20120 ?????                    level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20121 ?????                    level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20122 ?????                    level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20123 ?????                    level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20124 ?????                    level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20125 ?????                    level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20126 Noel Baba                level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20201 ??????                   level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20202 ??????                   level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20203 ?????                    level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20204 ???????                  level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20205 ?????? ??????            level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20206 ?????? ??????            level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20207 ?????? ?????             level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20208 ?????? ???????           level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20209 ?????? ??????            level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20210 ?????? ??????            level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20211 ?????? ?????             level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20212 ?????? ???????           level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20213 ?????????                level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20214 ?????? ?????????         level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20215 ?????? ?????????         level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20216 ????????                 level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20217 ?????? ????????          level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20218 ?????? ????????          level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20219 blackpony                level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20220 Å©¸®½º¸¶½º ¼ø·Ï          level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20221 Àü°©¹é¿õ                 level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20222 Àü°©ÆÒ´õ                 level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20223 Àü°©¼®·æÀÚ               level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20224 ³ÆøÇÑ Àü°©¼®·æÀÚ        level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20225 ¿ë¸ÍÇÑ Àü°©¼®·æÀÚ        level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20226 ÈæÀ¯´ÏÄÜ                 level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20227 ¹éÀ¯´ÏÄÜ                 level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20228 Àü°©¸ÍÁ¶                 level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20229 ³ÆøÇÑ Àü°©¸ÍÁ¶          level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20230 ¿ë¸ÍÇÑ Àü°©¸ÍÁ¶          level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20231 Àü°©Èæ¹ü                 level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20232 Àü°©Ç¥¹ü                 level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20233 Muffin (kahve aksesuar)  level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20234 Nugget (kahve aksesuar)  level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20235 Muffin (mavi aksesuar)   level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20236 Nugget (mavi aksesuar)   level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20237 Muffin (yeşil aksesuar)  level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20238 Nugget (yeşil aksesuar)  level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20239 Şimşek                   level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20240 Gümbürtü                 level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20241 Nugget (Azul Marinho)    level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20242 Muffin (Rosa)            level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20243 NoNAme                   level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20244 Dragão de Nirvana        level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20245 Dragão de Samsara        level: 1   rank: 5 empire: 0
May  5 17:55:26 :: MOB #20246 Manny                    level: 1   rank: 5 empire: 0

Bundan önce Normal Log'lar da aynı şekilde katlanıyordu.
Kullandığım fileste köylerdeki slotlar kaldırılmıştı.
Regen.txt dosyasını başka bir dosyayla değiştirdiğimde o sorun çözülmüştü.
Peki bu sorun neden kaynaklanmakta?

Whistle · 6 Mayıs 2020

Size hatası çözüldü mü?

Whistle · 6 Mayıs 2020

Kod:

SYSERR: May  6 18:07:54 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xD1\xAD\xDB\xAD\xD8\xB0...' for column 'name' at row 1 (query: replace into mob_proto  (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (49741,

Bunu çözmek için name sütununun karakter kodlamasını değiştirmeniz gerekiyor.
Default: 'Noname'
Character Set: latin1
Collection: latin1_swedish_ci

okcoder1134 demiş ki:
SYSERR: May 6 18:07:46 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'setRaceFlag' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (5144, "??? ??? ???", "Zeki Maymun Gene

Bunu çözmek için ise;
setRaceFlag veri türünü set'e çevirin ve not null seçeneğini işaretleyin.
length ve decimals kısmına da 0, 0 yazınız.

okcoder1134 · 6 Mayıs 2020

Whistle demiş ki:

Kod:

SYSERR: May  6 18:07:54 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xD1\xAD\xDB\xAD\xD8\xB0...' for column 'name' at row 1 (query: replace into mob_proto  (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (49741,

Bunu çözmek için name sütununun karakter kodlamasını değiştirmeniz gerekiyor.
Default: 'Noname'
Character Set: latin1
Collection: latin1_swedish_ci

Bunu çözmek için ise;
setRaceFlag veri türünü set'e çevirin ve not null seçeneğini işaretleyin.
length ve decimals kısmına da 0, 0 yazınız.

size hatası evet çözüldü.
setraceflag dolu hala ya.
name de çözüldü fakat SetraceFlag hala aynı hatayı vermeye devam ediyor.

Kod:

SYSERR: May  6 22:44:32 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'setRaceFlag' at row 1 (query: replace into mob_proto  (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (3552, "A©ª¨¬OA¨¬¥ì¥ìAu¢¥U¡ío¡¾?", "Zal

MEKA · 6 Mayıs 2020

txt nin gözünü seveyim ya

hiç böyle problemleri yok

Whistle · 6 Mayıs 2020

okcoder1134 demiş ki:
name de çözüldü fakat SetraceFlag hala aynı hatayı vermeye devam ediyor

not null kısmındaki işareti kaldırıp tekrar deneyebilir misiniz?

Trashy demiş ki:
txt nin gözünü seveyim ya hiç böyle problemleri yok

no_txt olmayınca normalde direk txt dosyalarından okuyup hafızaya alıyor. Çoğu fileste txt dosyalarından okuduğu veriyi veritabanına yazdırmasını sağlayabiliyoruz. Bu yüzden yine aynı hataları vermeye devam edecek.

Sanırsam bu syserr kayıtlarının sebebi de bu

okcoder1134 · 6 Mayıs 2020

Whistle demiş ki:
not null kısmındaki işareti kaldırıp tekrar deneyebilir misiniz?

no_txt olmayınca normalde direk txt dosyalarından okuyup hafızaya alıyor. Çoğu fileste txt dosyalarından okuduğu veriyi veritabanına yazdırmasını sağlayabiliyoruz. Bu yüzden yine aynı hataları vermeye devam edecek. Sanırsam bu syserr kayıtlarının sebebi de bu

Not nullu kaldırdığımda sorun çözüldü sağolasın

Yalnız şu değerler normal mi sizce benim için çok önemli bu files başladım bayadır bırakıp başka filese geçmek istemiyorum

sonuna kadar sorunlarını çözmem gerekiyor

Makina özellikleri :
10 GB DDR4 RAM
250 GB SSD
8 çekirdek işlemci 2.60 gHz 2000 mHz

Whistle · 6 Mayıs 2020

Vrunner kullandığınız için sürekli sistem bu işlemleri devam ettirecek. Eğer daha az kaynak tüketmesini istiyorsanız devredışı bırakın

okcoder1134 · 6 Mayıs 2020

Whistle demiş ki:
Vrunner kullandığınız için sürekli sistem bu işlemleri devam ettirecek. Eğer daha az kaynak tüketmesini istiyorsanız devredışı bırakın

Vrunnerin tam olarak işlevi nedir?
ben ch çökünce otomatik olarak tekrar başlatan birşey diye biliyorum. böylelikle oyuncular çökmeyi DC gibi hissediyor.
Kapatırsam ne olacak ya da yanlış mı biliyorum ?

Whistle · 7 Mayıs 2020

Vrunner'in ne olduğunu doğru biliyorsunuz

Fakat verimli çalışmıyor. Sadece ch düştüğü zaman açmaya çalışsa tamam ama sürekli açmaya çalıştığı için oyunun her açılışınca yapılan işlemler sürekli tekrarlanıyor. Bu işlemlerde çok fazla sistem kaynağı tüketiyor.
Kendi bilgisayarımdan örnek veriyim. Sanal makinayı açtım. Oyunu başlat dediğim zaman windows dahil olmak üzere açılana kadar takılıyor.

Zaten filesinizde kanal düşüren hataların hepsini düzeltirseniz buna gerek olacağını sanmam. Otomatik açtırma işlevi için ise farklı yöntemler uygulanabilir. Freebsd timerlarından vs yararlanılabilir

okcoder1134 · 7 Mayıs 2020

Whistle demiş ki:
Vrunner'in ne olduğunu doğru biliyorsunuz
Fakat verimli çalışmıyor. Sadece ch düştüğü zaman açmaya çalışsa tamam ama sürekli açmaya çalıştığı için oyunun her açılışınca yapılan işlemler sürekli tekrarlanıyor. Bu işlemlerde çok fazla sistem kaynağı tüketiyor.
Kendi bilgisayarımdan örnek veriyim. Sanal makinayı açtım. Oyunu başlat dediğim zaman windows dahil olmak üzere açılana kadar takılıyor.

Zaten filesinizde kanal düşüren hataların hepsini düzeltirseniz buna gerek olacağını sanmam. Otomatik açtırma işlevi için ise farklı yöntemler uygulanabilir. Freebsd timerlarından vs yararlanılabilir

şuan channellar, game99, auth, db ve log dosyalarındaki syserrlerin boyutları 5-10 MB yi geçmiyor.
Oyuna sadece ben ve 2 arkadaşım giriyor. yakın zamanda açılış yapacağız ve ch düşmesi gibi bir sorun yaşamak istemiyorum. Bu syserr hatalarını(5-10 MB'lık) ciddiye almalı mıyım?

MEKA · 7 Mayıs 2020

2 kişi ile bu syserrleri veriyorsa oyuncular girince artabilir syserrleri çözmeyi deneyin

okcoder1134 · 7 Mayıs 2020

Trashy demiş ki:
2 kişi ile bu syserrleri veriyorsa oyuncular girince artabilir syserrleri çözmeyi deneyin

Yakın zamanda yaklaşık 10 15 kişilik bi grubumuz var onları davet edeceğiz oyuna ve test yapacağız. O zaman oluşan syserrleri çözmeye başlayayım o zaman :/

Whistle · 7 Mayıs 2020

Bu konuda belirttiğiniz tüm sorunlar çözüldüyse konuyu kilitliyorum

okcoder1134 · 7 Mayıs 2020

Whistle demiş ki:
Bu konuda belirttiğiniz tüm sorunlar çözüldüyse konuyu kilitliyorum

Kilitleyebilirsiniz

teşekkür ederim yardımlarınız için

Ara

Çözüldü DB Şişmesi nasıl giderilir?

Diğer Seçenekler

okcoder1134

MT Üye

Whistle

Whistle

Luntar

Whistle

Luntar

okcoder1134

MT Üye

MEKA

Discord: mekaprojects

Whistle

Luntar

okcoder1134

MT Üye

Whistle

Luntar

okcoder1134

MT Üye

Whistle

Luntar

okcoder1134

MT Üye

MEKA

Discord: mekaprojects

okcoder1134

MT Üye

Whistle

Luntar

okcoder1134

MT Üye

Benzer konular