Skocz do zawartości

  • 👋 Witaj na MPCForum!

    Przeglądasz forum jako gość, co oznacza, że wiele świetnych funkcji jest jeszcze przed Tobą! 😎

    • ✅ Pełny dostęp do działów i ukrytych treści
    • ✅ Możliwość pisania i odpowiadania w tematach
    • ✅ System prywatnych wiadomości
    • ✅ Zbieranie reputacji i rozwijanie swojego profilu
    • ✅ Członkostwo w jednej z największych społeczności graczy

    👉 Dołączenie zajmie Ci mniej niż minutę – a zyskasz znacznie więcej!

    Zarejestruj się teraz

Problem z mysql sock (2) taken_time

dawiiiiiid879

Rekomendowane odpowiedzi

dawiiiiiid879 Uczeń

dawiiiiiid879

Opublikowano
Uczeń

dawiiiiiid879

Opublikowano

Witam, postawiłem serwer na source game, walczę z uporczywym rozłączaniem bazy danych, które następuje po kilkunastu godzinach pracy serwera.

Nie wiem co może być przyczyną. Założyłem wcześniej podobny temat, niestety został z jakiegoś powodu usunięty, było tam rozwiązanie kilku innych problemów.

 

Przedstawię wam syserr.txt

 

db

 

 

 

SYSERR: Aug 29 11:47:11 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 29 11:47:11 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 29 11:47:15 :: ChildLoop: MySQL connection was reconnected. querying locale set
SYSERR: Aug 29 11:48:15 :: ChildLoop: MySQL connection was reconnected. querying locale set
SYSERR: Aug 29 12:44:55 :: DirectQuery: MySQL connection was reconnected. querying locale set
SYSERR: Aug 29 12:44:55 :: Process: FDWATCH: peer null in event: ident 23
SYSERR: Aug 29 22:06:28 :: ChildLoop: MySQL connection was reconnected. querying locale set

 
auth - czyste
 
ch11 i ch12
 

SYSERR: Aug 29 11:43:06 :: socket_connect: HOST localhost:15002, could not connect.
SYSERR: Aug 29 11:43:09 :: socket_connect: HOST localhost:15002, could not connect.
SYSERR: Aug 29 11:43:50 :: heart_idle: losing 38 seconds. (lag occured)
SYSERR: Aug 29 11:48:17 :: ChildLoop: MySQL connection was reconnected. querying locale set
SYSERR: Aug 29 12:03:14 :: ChildLoop: MySQL connection was reconnected. querying locale set
SYSERR: Aug 29 22:06:15 :: ChildLoop: MySQL connection was reconnected. querying locale set
SYSERR: Aug 29 22:06:15 :: ChildLoop: MySQL connection was reconnected. querying locale set

 
ch99
 

SYSERR: Aug 29 11:43:08 :: socket_connect: HOST localhost:15002, could not connect.
SYSERR: Aug 29 11:43:11 :: socket_connect: HOST localhost:15002, could not connect.
SYSERR: Aug 29 11:43:18 :: regen_load: No mob data by vnum 20400
SYSERR: Aug 29 11:43:18 :: SpawnMob: SpawnMob: no mob data for vnum 20400
SYSERR: Aug 29 11:43:50 :: heart_idle: losing 34 seconds. (lag occured)
SYSERR: Aug 29 11:44:53 :: SpawnMob: SpawnMob: no mob data for vnum 20400
SYSERR: Aug 29 11:46:23 :: SpawnMob: SpawnMob: no mob data for vnum 20400
SYSERR: Aug 29 11:47:20 :: Process: SEQUENCE 2994b000 mismatch 0xaf != 0x64 header 254
SYSERR: Aug 29 11:47:20 :: Process: SEQUENCE_LOG [uNKNOWN]-------------
[254 : 0xaf]
 
SYSERR: Aug 29 11:47:52 :: SpawnMob: SpawnMob: no mob data for vnum 20400
SYSERR: Aug 29 11:49:22 :: SpawnMob: SpawnMob: no mob data for vnum 20400

 
Widziałem wiele tematów na temat tych błędów, lecz w żadnym z nich nie znalazłem rozwiązania. Próbowałem przeanalizować tabelki w MYSQL ustalając inne kodowanie, np latin1. Nadawałem ustalałem chmod, chown oraz chgrp na var/db/mysql/
 
 
 
 
 
 
 
Gość Lajk™

Gość Lajk™

Opublikowano

Gość Lajk™

Opublikowano

Jak dobrze mi się wydaje błąd 2 spowodowany jest brakiem połączenia z MySQL bo jest ono wyłączone.

Wpisz mysql-server status i napisz mi jaka jest odpowiedź od systemu.

dawiiiiiid879 Uczeń

dawiiiiiid879

Opublikowano
Uczeń

dawiiiiiid879

  • Autor
Opublikowano

"could not connect" nie jest raczej dla mnie duzym problemem, poprostu czasem tak mam. Natomiast wpisy ktore generują się w db syserr.txt prawdopodobnie powodują "Mysql reconnect"

 

 

SYSERR: Aug 30 03:09:19 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:19 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09:19 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:19 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09:19 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:19 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09:19 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:19 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09:19 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:19 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09:19 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:19 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09:19 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:19 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09:19 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:19 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09:19 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:19 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09:19 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:19 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09:19 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:19 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09:22 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
query: SELECT MAX(id) FROM item  WHERE id >= 2100000001 and id <= 2110000000
SYSERR: Aug 30 03:09:22 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
query: SELECT COUNT(*) FROM item  WHERE id >= 2100000001 AND id <= 2110000000
SYSERR: Aug 30 03:09:22 :: Process: FDWATCH: peer null in event: ident 20
 
 
 
SYSERR: Aug 30 03:09:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09: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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09: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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09: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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09: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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09: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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09: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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09: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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09: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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09: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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09: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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09: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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09:30 :: ChildLoop: MySQL connection was reconnected. querying locale set
SYSERR: Aug 30 03:20:27 :: ChildLoop: MySQL connection was reconnected. querying locale set

 
Serwer generuje błędy, rozłącza bazę danych, po czym działa dalej i można się logować i grać. Po wpisaniu mysql-server status: "MYSQL is running as PID 3024
"
 
kamil2321 Bywalec

kamil2321

Opublikowano
Bywalec

kamil2321

Opublikowano

Jak dobrze mi się wydaje błąd 2 spowodowany jest brakiem połączenia z MySQL bo jest ono wyłączone.

Wpisz mysql-server status i napisz mi jaka jest odpowiedź od systemu.

A Ty wpisz sobie "apt-get update && upt-get upgrade" bo coś słabo mu pomagasz ;-)

 

 

"could not connect" nie jest raczej dla mnie duzym problemem, poprostu czasem tak mam. Natomiast wpisy ktore generują się w db syserr.txt prawdopodobnie powodują "Mysql reconnect"

 

 

SYSERR: Aug 30 03:09:19 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:19 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09:19 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:19 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09:19 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:19 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09:19 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:19 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09:19 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:19 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09:19 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:19 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09:19 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:19 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09:19 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:19 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09:19 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:19 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09:19 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:19 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09:19 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:19 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09:22 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
query: SELECT MAX(id) FROM item  WHERE id >= 2100000001 and id <= 2110000000
SYSERR: Aug 30 03:09:22 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
query: SELECT COUNT(*) FROM item  WHERE id >= 2100000001 AND id <= 2110000000
SYSERR: Aug 30 03:09:22 :: Process: FDWATCH: peer null in event: ident 20
 
 
 
SYSERR: Aug 30 03:09:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09: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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09: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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09: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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09: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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09: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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09: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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09: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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09: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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09: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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09: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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09: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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 30 03:09:23 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 30 03:09:30 :: ChildLoop: MySQL connection was reconnected. querying locale set
SYSERR: Aug 30 03:20:27 :: ChildLoop: MySQL connection was reconnected. querying locale set

 
Serwer generuje błędy, rozłącza bazę danych, po czym działa dalej i można się logować i grać. Po wpisaniu mysql-server status: "MYSQL is running as PID 3024

"

 

 

Spx, przecież widać że problem tkwi w tabelkach oraz częściowo w game, a czemu tak myślę? 

 

Mały ale nie dość wyraźny wpis:

 

SYSERR: Aug 29 11:43:50 :: heart_idle: losing 34 seconds. (lag occured)

A drugi:

SYSERR: Aug 29 11:47:20 :: Process: SEQUENCE 2994b000 mismatch 0xaf != 0x64 header 254
SYSERR: Aug 29 11:47:20 :: Process: SEQUENCE_LOG [UNKNOWN]-------------
[254 : 0xaf]

I tylko te wpisy są najważniejsze.

Spoko podałeś prawie wszystkie logi, ale często każdy zapomina by upomnieć się o logi mysql, które masz w pliku .err w bazie w /var/db/mysql/

Tam jest więcej informacji jak i o crashu tabelek bądź cokolwiek innego podczas uruchamiania.

Ponadto powiem Ci tak, zawsze daje się uprawnienia chown i chgrp a zwykle każdy idiota daje 777 bo tak było napisane na MPC masakra totalna jakaś, większość serwerów ma na 777 i to porażka życiowa :D wystarczy źle wyłączyć mysql i tabele dostają crasha bez powrotu naprawy, a jeśli ktoś już chce naprawić to naprawa długo potrwa i takie usługi nie są darmowe ;-)

 

Czekam na plik .err ;-)

 

Pozdrawiam

Pomogłem ? klik up to Like ;D ( Lubię to ! ) xD

300 postów-> 10.10.2013 godz. 9:00
400 postów-> 19.10.2013 godz. 9:00

 

dawiiiiiid879 Uczeń

dawiiiiiid879

Opublikowano
Uczeń

dawiiiiiid879

  • Autor
Opublikowano

kamil2321 napisał:

 

Spoko podałeś prawie wszystkie logi, ale często każdy zapomina by upomnieć się o logi mysql, które masz w pliku .err w bazie w /var/db/mysql/

Tam jest więcej informacji jak i o crashu tabelek bądź cokolwiek innego podczas uruchamiania.

Ponadto powiem Ci tak, zawsze daje się uprawnienia chown i chgrp a zwykle każdy idiota daje 777 bo tak było napisane na MPC masakra totalna jakaś, większość serwerów ma na 777 i to porażka życiowa  :D wystarczy źle wyłączyć mysql i tabele dostają crasha bez powrotu naprawy, a jeśli ktoś już chce naprawić to naprawa długo potrwa i takie usługi nie są darmowe ;-)

 

Czekam na plik .err ;-)

 

Pozdrawiam

 

Witam uprzejmie, oto plik .err z /var/db/mysql/ z godziny 17.38:

 

 

2016-09-07 17:13:32 1003 [Warning] IP address '121.40.137.98' could not be resolved: hostname nor servname provided, or not known
160907 17:37:54 mysqld_safe mysqld restarted
2016-09-07 17:38:40 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-09-07 17:38:40 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.30) starting as process 2476 ...
2016-09-07 17:38:40 2476 [Note] Plugin 'FEDERATED' is disabled.
2016-09-07 17:38:40 2476 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-09-07 17:38:40 2476 [Note] InnoDB: The InnoDB memory heap is disabled
2016-09-07 17:38:40 2476 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-09-07 17:38:40 2476 [Note] InnoDB: Memory barrier is not used
2016-09-07 17:38:40 2476 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-09-07 17:38:40 2476 [Note] InnoDB: Not using CPU crc32 instructions
2016-09-07 17:38:40 2476 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-09-07 17:38:40 2476 [Note] InnoDB: Completed initialization of buffer pool
2016-09-07 17:38:42 2476 [Note] InnoDB: Highest supported file format is Barracuda.
2016-09-07 17:38:43 2476 [Note] InnoDB: The log sequence numbers 11025669 and 11025669 in ibdata files do not match the log sequence number 11025679 in the ib_logfiles!
2016-09-07 17:38:43 2476 [Note] InnoDB: Database was not shutdown normally!
2016-09-07 17:38:43 2476 [Note] InnoDB: Starting crash recovery.
2016-09-07 17:38:43 2476 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-09-07 17:38:48 2476 [Note] InnoDB: Restoring possible half-written data pages 
2016-09-07 17:38:48 2476 [Note] InnoDB: from the doublewrite buffer...
2016-09-07 17:38:48 2476 [Note] InnoDB: 128 rollback segment(s) are active.
2016-09-07 17:38:48 2476 [Note] InnoDB: Waiting for purge to start
2016-09-07 17:38:48 2476 [Note] InnoDB: 5.6.30 started; log sequence number 11025679
2016-09-07 17:38:48 2476 [Note] Server hostname (bind-address): '*'; port: 3306
2016-09-07 17:38:48 2476 [Note] IPv6 is available.
2016-09-07 17:38:48 2476 [Note]   - '::' resolves to '::';
2016-09-07 17:38:48 2476 [Note] Server socket created on IP: '::'.
2016-09-07 17:38:48 2476 [Note] Event Scheduler: Loaded 0 events
2016-09-07 17:38:48 2476 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.30'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

 
Co ciekawe, godzina 17.38 plik syserr.txt z db:

SYSERR: Sep  7 14:32:50 :: pid_init: 
Start of pid: 1389
 
SYSERR: Sep  7 17:37:54 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:37:54 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:37:59 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:37:59 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:37:59 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:37:59 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:04 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:04 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:04 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:04 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:04 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:04 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:09 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:09 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:09 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:09 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:09 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:09 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:09 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:09 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:14 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:14 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:14 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:14 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:14 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:14 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:14 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:14 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:14 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:14 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:19 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:19 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:19 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:19 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:19 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:19 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:19 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:19 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:19 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:19 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:19 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:19 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:24 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:24 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:24 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:24 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:24 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:24 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:24 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:24 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:24 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:24 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:24 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:24 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:24 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:24 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:29 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:29 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:29 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:29 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:29 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:29 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:29 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:29 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:29 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:29 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:29 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:29 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:29 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:29 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:29 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:29 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:34 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:34 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:34 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:34 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:34 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:34 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:34 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:34 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:34 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:34 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:34 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:34 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:34 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:34 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:34 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:34 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:34 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:34 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:39 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:39 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:39 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:39 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:39 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:39 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:39 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:39 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:39 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:39 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:39 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:39 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:39 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:39 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:39 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:39 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:39 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:39 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:39 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:39 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:44 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:44 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:44 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:44 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:44 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:44 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:44 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:44 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:44 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:44 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:44 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:44 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:44 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:44 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:44 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:44 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:44 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:44 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:44 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:44 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:44 :: 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,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Sep  7 17:38:44 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep  7 17:38:48 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
query: SELECT MAX(id) FROM item  WHERE id >= 30000001 and id <= 40000000
SYSERR: Sep  7 17:38:48 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
query: SELECT COUNT(*) FROM item  WHERE id >= 30000001 AND id <= 40000000
SYSERR: Sep  7 17:38:48 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Sep  7 17:38:49 :: ChildLoop: MySQL connection was reconnected. querying locale set
SYSERR: Sep  7 17:44:42 :: ChildLoop: MySQL connection was reconnected. querying locale set
SYSERR: Sep  7 17:45:07 :: DirectQuery: MySQL connection was reconnected. querying locale set

 
Co ciekawe, serwer nadal działa, niestety niektóre mapy wywaliło i nie można się na nie zalogować. Channel mam rozdzielony na ch1_1 oraz ch1_2. Komenda ps wskazuje, że ch1_2 właśnie nie jest włączone (a było).

 

Zarchiwizowany

Ten temat przebywa obecnie w archiwum. Dodawanie nowych odpowiedzi zostało zablokowane.

Tematy
×
×
  • Dodaj nową pozycję...