Çö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 · 5 Mayıs 2020

item_proto.txt dosyasında ki verileri veritabanına yazarken hata veriyor
vrunner'de sürekli olarak serveri açmaya çalıştığı için bu tekrar edip duruyor.

okcoder1134 · 5 Mayıs 2020

Whistle demiş ki:
item_proto.txt dosyasında ki verileri veritabanına yazarken hata veriyor
vrunner'de sürekli olarak serveri açmaya çalıştığı için bu tekrar edip duruyor.

data too long diye birşey vardı syslog da "name" sütununu gösteriyordu.
item proto tablosundaki "name " sutünunu designe girip lenght değerini 24 den 100e çektim.
O hata gitti.
sorunları tam olarak okuyabilsem halledeceğim sanırım

Whistle · 5 Mayıs 2020

Aynen

Zaten bu tarz konularsa o yüzden hata kayıtlarını istiyorum. Genellikle sorunu tespit etmek için faydalı oluyorlar

okcoder1134 · 5 Mayıs 2020

Whistle demiş ki:
Aynen
Zaten bu tarz konularsa o yüzden hata kayıtlarını istiyorum. Genellikle sorunu tespit etmek için faydalı oluyorlar

Ben şu tekrarlanan hataları iyice Bi kontrol edeyim. Buraya yazayım çözelim şu işi lütfen. Fileste diğer arkadaşlarımın çok fazla emeği var şu sorunu halletmemiz lazım o emeklerin çöp olmaması için

okcoder1134 · 6 Mayıs 2020

Whistle demiş ki:
Aynen
Zaten bu tarz konularsa o yüzden hata kayıtlarını istiyorum. Genellikle sorunu tespit etmek için faydalı oluyorlar

Evet yanılmıyorsam şu aşağıdaki 3 satırı komple tüm item ve moblarda sırasıyla veriyor.
Var mı bir fikriniz Yaklaşık 500.000 adet satır oluşmuş syserr içerisinde

Kod:

SYSERR: May  5 23:28:23 :: ChildLoop: AsyncSQL: query failed: Field 'resist_claw' doesn't have a default value (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 (101, "??", "Yabani Köpek", 0, 0, 0, 1,

SYSERR: May  5 23:49:58 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'locale_name' at row 1 (query: 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 (18578, 2, 6, "????L+8", "Kyanit Turmalin Küpeler +8", 500000, 0, 0, 1, 0, 64, 256, 0, 18579, 9188, 10, 0, 0, 4, 3, 1, 110, 0, 0, 4, 19, 1, 2050, 72, 10, 0, 0, 0, 0, 0, 0 ) errno: 1406)


SYSERR: May  5 23:49:58 :: ChildLoop: AsyncSQL::ChildLoop : mysql_query error: Data too long for column 'locale_name' at row 1:
query: 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 (40459, 28, 3, "new_sword_skin", "Büyülü Kızıl Antika Kılıcı", 0, 0, 0, 2, 0, 0, 294944, 0, 0, 0, 0, 0, 0, 9, 0, 7, 604800, 0, 0, 21, 30, 53, 70, 72, 5, 0, 0, 0, 0, 0, 0 )

MEKA · 6 Mayıs 2020

locale_name için veri çok uzun diyor type varbinary length 64 olarak ayarlayın bu şekilde ayarlı ise bir itemin ismi çok uzun olabilir onu kısaltmayı deneyin

Whistle · 6 Mayıs 2020

@okcoder1134 aslında o kayıtları her serveri açtığınız bir kere veriyor ama vrunner sağ olsun üst üste açmaya çalıştığı için böyle oluyor. @Trashy 'nin dediğini uygularsanız çözülecektir. :s18:

okcoder1134 · 6 Mayıs 2020

Trashy demiş ki:
locale_name için veri çok uzun diyor type varbinary length 64 olarak ayarlayın bu şekilde ayarlı ise bir itemin ismi çok uzun olabilir onu kısaltmayı deneyin

Whistle demiş ki:
@okcoder1134 aslında o kayıtları her serveri açtığınız bir kere veriyor ama vrunner sağ olsun üst üste açmaya çalıştığı için böyle oluyor. @Trashy 'nin dediğini uygularsanız çözülecektir.

Çözdüm beyler çözdüm

(1) resist_claw için : mob proto'daki resist_claw sütununu diğer resistler ile karşılaştırdım. design table bölümünde "default" ayarı 0 iken resist_claw da boş idi. zaten syserri türkçeye çevirdiğimizde default atanmamış gibi birşey diyordu. oraya 0 yazdım.

(2) data too long için : item proto'daki "locale_name" sütununun lenghts ayarını 24'den 100'e çektim kafa rahat olsun diye.

(3) bu da aynı sütunu yani locale_name sütununu gösteriyordu.

Bu 3 işlemi yaptıktan sonra. oyunu rebootlayıp başlat komutunu verdim. Şuan DB içerisindeki syserr ve syslog 3 ve 5 mb boyutuna geldi ve yarım saattir 1 bayt bile artmadı. içerisinde türlü sorunlar da hala var aynı mantıkla çözmeyi deneyeceğim sorunum olursa bu konu açık kalsın geri dönüş yapacağım.

Şu değerler sizce normal mi? 8 Çekirdek CPU ve 10 GB ram mevcut. 250 gb SSD var

Whistle · 6 Mayıs 2020

Syserr kayıtları hayat kurtarır.

okcoder1134 · 6 Mayıs 2020

Whistle demiş ki:
Syserr kayıtları hayat kurtarır.

Valla doğru

okcoder1134 · 6 Mayıs 2020

Whistle demiş ki:
Syserr kayıtları hayat kurtarır.

Merhaba yeni konu açmak istemedim. Gerekirse açayım ama şu syserri bir türlü çözemedim. Oyun yaklaşık 5-6 saat boyunca DB şişmesi yapmadı. Tamam dedim oldu dedim fakat bu sefer de şöyle bir syserr ile log boyutları 1 GB'ı geçmiş :

Kod:

SYSERR: May  6 15:00:03 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'size' 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 (10501, ". 345 361", ". 345 361", 9, 5, 0, 1,

MEKA · 6 Mayıs 2020

10501 kodlu şeyi bi kontrol edin ondada problem olabilir

okcoder1134 · 6 Mayıs 2020

Trashy demiş ki:
2614 eklentisini görüntüle

10501 kodlu şeyi bi kontrol edin ondada problem olabilir

Tek syserr değil bu. Tüm mob proto içindeki itemleri aşağıya doğru listelemiş aynı syserr.

MEKA · 6 Mayıs 2020

sizde boş olan yerleri söyliyim oralarıda doldurun belki hata kalkar

size enum 0 0 tik işaretli
ai_flag set 0 0 tik işaretli degil
setraceflag set 0 0 tik işaretli
setimmunelfag set 0 0 tik işaretli

ek olarak level bigint 3 0 tik işaretli bende istersen sende öyle yap

Whistle · 6 Mayıs 2020

okcoder1134 demiş ki:

Merhaba yeni konu açmak istemedim. Gerekirse açayım ama şu syserri bir türlü çözemedim. Oyun yaklaşık 5-6 saat boyunca DB şişmesi yapmadı. Tamam dedim oldu dedim fakat bu sefer de şöyle bir syserr ile log boyutları 1 GB'ı geçmiş :

Kod:

SYSERR: May  6 15:00:03 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'size' 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 (10501, ". 345 361", ". 345 361", 9, 5, 0, 1,

Geçenlerde mask_type ile uğraşırken protoları tekrardan okutmam gerekiyordu ve bende bu hatayı almıştım. Sürekli olarak syserr hatalarını kayıtta tuttuğum bir konu var.
Buradaki 5. hata kısmını okuyabilirsiniz.
Syserr Hataları ve Çözümleri

okcoder1134 · 6 Mayıs 2020

Trashy demiş ki:
sizde boş olan yerleri söyliyim oralarıda doldurun belki hata kalkar

size enum 0 0 tik işaretli
ai_flag set 0 0 tik işaretli degil
setraceflag set 0 0 tik işaretli
setimmunelfag set 0 0 tik işaretli

ek olarak level bigint 3 0 tik işaretli bende istersen sende öyle yap

Teşekkür ederim deneyeceğim.

Whistle demiş ki:
Geçenlerde mask_type ile uğraşırken protoları tekrardan okutmam gerekiyordu ve bende bu hatayı almıştım. Sürekli olarak syserr hatalarını kayıtta tuttuğum bir konu var.
Buradaki 5. hata kısmını okuyabilirsiniz.
Syserr Hataları ve Çözümleri

Uzun yol mu daha sağlıklı olur yoksa kısa yol mu

Whistle · 6 Mayıs 2020

okcoder1134 demiş ki:
Uzun yol mu daha sağlıklı olur yoksa kısa yol mu

Kısa yol tabii ki de

Ben sadece olası çözüm yöntemlerini yazdım. Seç beğen al

Kısa yolu yaparsanız not null seçeneği işaretli ise kaldırmayı unutmayın.

okcoder1134 · 6 Mayıs 2020

Pekala

Hemen deneyeyim test edeyim ve dönüş yapayım

okcoder1134 · 6 Mayıs 2020

Whistle demiş ki:
Kısa yol tabii ki de
Ben sadece olası çözüm yöntemlerini yazdım. Seç beğen al
Kısa yolu yaparsanız not null seçeneği işaretli ise kaldırmayı unutmayın.

Büyük ihtimalle syserr dosyaları 1 gb falan olduğu için görmedim ya da yeni bir sorun bu.
Şuan dbnin kullandığı cpu aşırı artmaya başladı eskisi gibi.
verdiği syserr kayıtları şu ikisinin benzeri :

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,
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 (49751,
SYSERR: May  6 18:07:37 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xC3\xB6\xC0\xCE\xBD\xC5...' 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 (2729,

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
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 (5145, "??? ??? ????", "Zeki Taş Maymun
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 (5146, "??? ??? ?????", "Zeki Maymun Li
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 (5151, "??? ??? ??", "Kötü Güçlü Maymun
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 (5152, "??? ??? ????", "Kötü Güçlü Maym

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

MT Üye

Ruhsuz :/

MT Üye

Ruhsuz :/

MT Üye

MT Üye

Discord: mekaprojects

Ruhsuz :/

MT Üye

Ruhsuz :/

MT Üye

MT Üye

Discord: mekaprojects

MT Üye

Discord: mekaprojects

Ruhsuz :/

MT Üye

Ruhsuz :/

MT Üye

MT Üye

Benzer konular