Yardım DB SYS Query execution was interrupted

  • Konuyu açan Konuyu açan Tengrist
  • Açılış Tarihi Açılış Tarihi
  • Yanıt Yanıt 9
  • Gösterim Gösterim 193
Konu sahibi bu konuda soru soruyor. Sorusu ile ilgili bilgisi olanların yanıtlamasını bekliyor.
Tengrist

Tengrist

MT Üye
MT Üye
Mesaj
556
Çözümler
19
Beğeni
401
Puan
809
Ticaret Puanı
0
C++:
Genişlet Daralt Kopyala 
SYSERR: May 11 14:55:00 :: ChildLoop: AsyncSQL: query failed: Query execution was interrupted (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1317)
SYSERR: May 11 14:55:05 :: ChildLoop: AsyncSQL: query failed: Can't connect to MySQL server on '127.0.0.1' (61) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2003)
SYSERR: May 11 14:55:05 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:55:10 :: ChildLoop: AsyncSQL: query failed: Can't connect to MySQL server on '127.0.0.1' (61) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2003)
SYSERR: May 11 14:55:10 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:55:10 :: ChildLoop: AsyncSQL: query failed: Can't connect to MySQL server on '127.0.0.1' (61) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2003)
SYSERR: May 11 14:55:10 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 13 02:08:29 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Field 'title' doesn't have a default value
query: INSERT INTO player (id, account_id, name, level, st, ht, dx, iq, job, voice, dir, x, y, z, hp, mp, random_hp, random_sp, stat_point, stamina, part_base, part_main, part_hair,part_acce,  gold, playtime, skill_level, quickslot) VALUES(0, 257, 'Player1', 1, 3, 4, 3, 6, 3, 0, 0, 361293, 876985, 0, 860, 320, 0, 0, 0, 800, 0, 0, 0, 0, 0, 0, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
SYSERR: May 13 02:08:29 :: __QUERY_PLAYER_CREATE: QUERY_ERROR: UPDATE player_index SET pid2=0 WHERE id=257
SYSERR: May 13 02:08:32 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Field 'title' doesn't have a default value
query: INSERT INTO player (id, account_id, name, level, st, ht, dx, iq, job, voice, dir, x, y, z, hp, mp, random_hp, random_sp, stat_point, stamina, part_base, part_main, part_hair,part_acce,  gold, playtime, skill_level, quickslot) VALUES(0, 257, 'Player1', 1, 3, 4, 3, 6, 3, 0, 0, 361388, 876454, 0, 860, 320, 0, 0, 0, 800, 0, 0, 0, 0, 0, 0, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
SYSERR: May 13 02:08:32 :: __QUERY_PLAYER_CREATE: QUERY_ERROR: UPDATE player_index SET pid2=0 WHERE id=257
SYSERR: May 13 17:59:17 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Field 'title' doesn't have a default value
query: INSERT INTO player (id, account_id, name, level, st, ht, dx, iq, job, voice, dir, x, y, z, hp, mp, random_hp, random_sp, stat_point, stamina, part_base, part_main, part_hair,part_acce,  gold, playtime, skill_level, quickslot) VALUES(0, 257, 'Player1', 1, 3, 4, 3, 6, 3, 0, 0, 361769, 876951, 0, 860, 320, 0, 0, 0, 800, 0, 0, 0, 0, 0, 0, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
SYSERR: May 13 17:59:17 :: __QUERY_PLAYER_CREATE: QUERY_ERROR: UPDATE player_index SET pid2=0 WHERE id=257
SYSERR: May 18 20:32:32 :: ChildLoop: AsyncSQL: query failed: Query execution was interrupted (query: REPLACE INTO item (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2, socket3) VALUES(10004575, 189, 1, 1, 1, 86012, 1716069948, 0, 0, 0) errno: 1317)
SYSERR: May 18 20:32:32 :: ChildLoop: AsyncSQL: query failed: Can't connect to MySQL server on '127.0.0.1' (61) (query: REPLACE INTO item (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2, socket3, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(10004573, 189, 1, 51, 1, 23029, 1716725055, 0, 0, 0, 1, 1000, 53, 30, 23, 5, 28, 5, 24, 5, 0, 0, 0, 0) errno: 2003)
SYSERR: May 18 20:32:32 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 18 20:32:32 :: ChildLoop: AsyncSQL: query failed: Can't connect to MySQL server on '127.0.0.1' (61) (query: REPLACE INTO item (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2, socket3, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(10004573, 189, 1, 51, 1, 23029, 1716725055, 0, 0, 0, 1, 1000, 53, 30, 23, 5, 28, 5, 24, 5, 0, 0, 0, 0) errno: 2003)
SYSERR: May 18 20:32:32 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 18 20:32:32 :: ChildLoop: AsyncSQL: query failed: Can't connect to MySQL server on '127.0.0.1' (61) (query: REPLACE INTO item (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2, socket3, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(10004573, 189, 1, 51, 1, 23029, 1716725055, 0, 0, 0, 1, 1000, 53, 30, 23, 5, 28, 5, 24, 5, 0, 0, 0, 0) errno: 2003)
SYSERR: May 18 20:32:32 :: ChildLoop: AsyncSQL: retrying
 
Tarihe göre sırala Oy skoruna göre sırala
player tablosunda title için default value verilmemiş. sağ tık design table yap. titleye gelip defaulta 0 yaz. kaydet dene
 
Upvote 0 Downvote

Benzer konular

U
Yardım Connection refused hatasi , item proto ve mob proto duzenleme yapinca
2
Yanıt
21
Gösterim
4K
Whistle
Whistle
orhanha4rd
  • Kilitli
  • Çözüldü
Çözüldü ch1 core1 syser
Yanıt
4
Gösterim
542
orhanha4rd
orhanha4rd
melihalbayrak
Yardım Warning Çözüm?
2
Yanıt
25
Gösterim
2K
melihalbayrak
melihalbayrak
Legandalith
  • Kilitli
  • Çözüldü
Çözüldü asynchsql socket3 sorunum
Yanıt
2
Gösterim
671
Legandalith
Legandalith
M
Yardım Db Aldığım Syserr
Yanıt
8
Gösterim
970
MsCharles
M
Üst