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

mnyk2070 · 11 Mayıs 2020

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)

Whistle · 11 Mayıs 2020

Veritabanı gitmiş. Mevcut yedekleri sql olarak alın ve veritabanını tekrardan kurunuz

mnyk2070 · 11 Mayıs 2020

hocam yedeğe gerek yok 0 dan da olur sildim mysql yükledim oyunu başlatırken bu hatayı alıyorum başlatamıyorum

Denizeri24 · 12 Mayıs 2020

SIGHUP, SIGINT, SIGTERM

db crash yiyor, bilinmedik filesleri kullanmayın lütfen.

mnyk2070 · 13 Mayıs 2020

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)

mnyk2070 · 13 Mayıs 2020

Denizeri24 demiş ki:
SIGHUP, SIGINT, SIGTERM

db crash yiyor, bilinmedik filesleri kullanmayın lütfen.

hocam bestianın filesini kullanıyorum bu hatayla karşılaştım işte

freebsd sürümünden de kaynaklı olabilirmi bu sorun ?

Denizeri24 · 13 Mayıs 2020

mnyk2070 demiş ki:
hocam bestianın filesini kullanıyorum bu hatayla karşılaştım işte

freebsd sürümünden de kaynaklı olabilirmi bu sorun ?

olacağını sanmıyorum ancak 9.2 kullanıyorsan sorun olabilir..

Whistle · 13 Mayıs 2020

mnyk2070 demiş ki:
reboot atınca giden itemlerin çözümünü buldum.Fakat bu hata kodunu nasıl düzeltebilirim tam olarak anlamadım. @Whistle

2002 hatası vermiş. Veritabanını baştan kurduktan sonra sadece metin2 ile alakalı şeyleri geri yükleyin.

mnyk2070 · 13 Mayıs 2020

Whistle demiş ki:
2002 hatası vermiş. Veritabanını baştan kurduktan sonra sadece metin2 ile alakalı şeyleri geri yükleyin.

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

.İşin ilginç yanı bu hatayı veriyor ama oyun çalışıyor yani db syserre düşüyor bazı kişilerde puttye düşmüş ch açarken.

Whistle · 13 Mayıs 2020

Eğer files vs şirket kurduysa onlara bu sorunu iletin

mnyk2070 · 13 Mayıs 2020

hayır kendi filesimi kurdum

Linkleri görebilmek için giriş yap veya kayıt ol.

bu hocam

alparslan · 14 Mayıs 2020

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.

mnyk2070 · 14 Mayıs 2020

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.

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ü

alparslan · 14 Mayıs 2020

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ü

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.

mnyk2070 · 14 Mayıs 2020

teşekkürler aklımda bulunsun

alparslan · 14 Mayıs 2020

rica ederim umarım çözüme ulaşır

Whistle · 10 Haziran 2020

alparslan demiş ki:
Link paylaşmak serbest mi bilemiyorum

Sorunun çözümüne yönelikse link paylaşmak serbest.
Metin2 PvP Soru-Cevap & Destek & Yardım Bölüm Kuralları madde 12/1

Ara

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

mnyk2070

MT Üye

alparslan

Whistle

Ruhsuz :/

mnyk2070

MT Üye

Denizeri24

Gentleman

mnyk2070

MT Üye

mnyk2070

MT Üye

Denizeri24

Gentleman

Whistle

Ruhsuz :/

mnyk2070

MT Üye

Whistle

Ruhsuz :/

mnyk2070

MT Üye

alparslan

Üye

mnyk2070

MT Üye

alparslan

Üye

mnyk2070

MT Üye

alparslan

Üye

Whistle

Ruhsuz :/

Benzer konular