Çözüldü reboot atınca bütün itemler siliniyor

Bu konu çözüme ulaştırılmıştır. Çözüm için konuya yazılan tüm yorumları okumayı unutmayın. Eğer konudaki yorumlar sorununuzu çözmediyse yeni bir konu açabilirsiniz.
Durum
İçerik kilitlendiği için mesaj gönderimine kapatıldı.
mnyk2070

mnyk2070

MT Üye
MT Üye
Editör
iyi günler arkadaşlar daha önce bu problem olmuyordu fakat şimdi olmaya başladı.shutdown çekiyorum öyle reboot atıyorum yine bütün itemler siliniyor anlamıyorum 2 gündür bu sorunla uğraşıyorum mysql sildim tekrar yükledim yine aynı sorunu veriyor sebebi ne olabilir

db syserr kayıtları bu şekilde


Kod: 
SYSERR: May 11 14:51:06 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: May 11 14:51:08 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:08 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:13 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:13 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:13 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:13 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:18 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:18 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:18 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:18 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:18 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:18 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:23 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:23 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:23 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:23 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:28 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:28 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:28 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:28 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:28 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:28 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:28 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:28 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:28 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:28 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:33 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:33 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:33 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:33 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:33 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:33 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:33 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:33 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:33 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:33 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:33 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:33 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:38 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:38 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:38 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:38 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:38 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:38 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:38 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:38 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:38 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:38 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:38 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:38 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:38 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:38 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:52:37 :: pid_init:
Start of pid: 755

SYSERR: May 11 14:52:39 :: Load:  DirectQuery failed(SELECT login FROM block_exception)
 
Son düzenleme:
Çözüm
A
Sadece bir fikir yürütmek isterim. Ve öncelikle belirtmeliyim ki metin2 geliştiriciliğinde daha epeyce bir toyum. Lütfen eleştiri ya da yanlış olduğunu belirtecek bir yorum gelir ise bu duruma göre gelsin :) Hesaba item gelirken muhtemelen tablodaki bir veriyi yani itemin alınma zamanını eklemiyor. Ve reboot atarken de alınma zamanı mevcut olmayan itemleri siliyor. item_award tablosunun taken_item kısmı 00-00-0000 gözüküyor ise yeni bi item verip verilen yeni itemin item_taken değerini bir elle değiştirmeyi dene. Ondan sonra tekrar reboot at ve elle değiştirdiğin item gidecek mi bir kontrol et. Eğer gitmez ise oyunun itemlerin envantere geldiği kodları bi kontrol edilmeli.
Tarihe göre sırala Oy skoruna göre sırala
reboot atınca giden itemlerin çözümünü buldum.Fakat bu hata kodunu nasıl düzeltebilirim tam olarak anlamadım. @Whistle

Kod: 
SYSERR: May 11 14:51:06 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: May 11 14:51:08 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:08 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:13 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:13 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:13 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:13 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:18 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:18 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:18 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:18 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:18 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:18 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:23 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:23 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:23 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:23 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:28 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:28 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:28 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:28 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:28 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:28 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:28 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:28 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:28 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:28 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:33 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:33 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:33 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:33 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:33 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:33 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:33 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:33 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:33 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:33 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:33 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:33 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:38 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:38 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:38 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:38 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:38 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:38 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:38 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:38 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:38 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:38 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:38 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:38 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:51:38 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: May 11 14:51:38 :: ChildLoop: AsyncSQL: retrying
SYSERR: May 11 14:52:37 :: pid_init:
Start of pid: 755
SYSERR: May 11 14:52:39 :: Load:  DirectQuery failed(SELECT login FROM block_exception)
 
Upvote 0 Downvote
Whistle demiş ki:
2002 hatası vermiş. Veritabanını baştan kurduktan sonra sadece metin2 ile alakalı şeyleri geri yükleyin.
Hepsini görmek için tıklayın...
bu işlemleri yapabileceğim konu veya video falan var mı çünkü yanlışlıkla mysql sürümünü kaldırdım sunucu 0 dan kurup verdi bir dahaki sorunda ekstra ücret talep edecekler :D.İşin ilginç yanı bu hatayı veriyor ama oyun çalışıyor yani db syserre düşüyor bazı kişilerde puttye düşmüş ch açarken.
 
Upvote 0 Downvote
Sadece bir fikir yürütmek isterim. Ve öncelikle belirtmeliyim ki metin2 geliştiriciliğinde daha epeyce bir toyum. Lütfen eleştiri ya da yanlış olduğunu belirtecek bir yorum gelir ise bu duruma göre gelsin :) Hesaba item gelirken muhtemelen tablodaki bir veriyi yani itemin alınma zamanını eklemiyor. Ve reboot atarken de alınma zamanı mevcut olmayan itemleri siliyor. item_award tablosunun taken_item kısmı 00-00-0000 gözüküyor ise yeni bi item verip verilen yeni itemin item_taken değerini bir elle değiştirmeyi dene. Ondan sonra tekrar reboot at ve elle değiştirdiğin item gidecek mi bir kontrol et. Eğer gitmez ise oyunun itemlerin envantere geldiği kodları bi kontrol edilmeli.
 
Upvote 0 Downvote
Çözüm
alparslan demiş ki:
Sadece bir fikir yürütmek isterim. Ve öncelikle belirtmeliyim ki metin2 geliştiriciliğinde daha epeyce bir toyum. Lütfen eleştiri ya da yanlış olduğunu belirtecek bir yorum gelir ise bu duruma göre gelsin :) Hesaba item gelirken muhtemelen tablodaki bir veriyi yani itemin alınma zamanını eklemiyor. Ve reboot atarken de alınma zamanı mevcut olmayan itemleri siliyor. item_award tablosunun taken_item kısmı 00-00-0000 gözüküyor ise yeni bi item verip verilen yeni itemin item_taken değerini bir elle değiştirmeyi dene. Ondan sonra tekrar reboot at ve elle değiştirdiğin item gidecek mi bir kontrol et. Eğer gitmez ise oyunun itemlerin envantere geldiği kodları bi kontrol edilmeli.
Hepsini görmek için tıklayın...
reis item bölümü geç yenileniyor ordan durumu farkedip reboot atınca düzeldi ama şu syserr kodu canımı sıkmaya başladı düzeltemiyorum bir türlü
 
Upvote 0 Downvote
mnyk2070 demiş ki:
reis item bölümü geç yenileniyor ordan durumu farkedip reboot atınca düzeldi ama şu syserr kodu canımı sıkmaya başladı düzeltemiyorum bir türlü
Hepsini görmek için tıklayın...

Link paylaşmak serbest mi bilemiyorum fakat onun yerine şuan çözümü internette hiç arattın mı bilmiyorum onun için şöyle bir önerim olabilir. Google aramaya mysql errorno: 2002 yazdığında stackoverflow sitesi bu tarz çözümlerin en büyük sitesi gibi bişeydir buradaki yerleri okuyarak çözüme ulaşabilirsin. Cevapların solundaki hit sayıları ne kadar yüksekse büyük ihtimalle çözüm odur diyebilirsin. Orada paylaşılanları bir dene.
 
Upvote 0 Downvote
Durum
İçerik kilitlendiği için mesaj gönderimine kapatıldı.

Benzer konular

A
Yardım Toplu Pm Sistemi Build Hata
Yanıt
0
Gösterim
1
aozs
A
T
Yardım Oyuna giriş yaparken client atıyor
Yanıt
0
Gösterim
35
TEmreAta
T
T
  • Kilitli
  • Çözüldü
Çözüldü Binek Kostüm Sistemi
Yanıt
1
Gösterim
53
TEmreAta
T
A
Yardım Bugtan kurtulma sistemi
Yanıt
1
Gösterim
55
Kaiser
Kaiser
cacaa
  • Kilitli
  • Çözüldü
Çözüldü GetGlobalPosition hatası
Yanıt
1
Gösterim
43
cacaa
cacaa
Geri