ich habe aber nicht mysql 5.7 sondern mysql 5.6 und welche "tables" hast du bitte repariert. ?
Beiträge von Greeley
-
-
das Problem besteht weiterhin.
-
meine Frage ist immer noch ob mir jemand erklären kann wie ich die game.core debugge oder zumindest was ich eingeben muss weil bis jetzt habe ich nur das
(gdb) core game.core
Core was generated by `game'.
Program terminated with signal 11, Segmentation fault.
#0 0x080b805c in ?? ()da ich leider nicht wirklich Ahnung von dem Spaß habe wie ich was Debugge oder ob ich das so richtig gemacht habe. kp ich hoffe das hilft.
-
Bitte einfach ein mal die game.core mit gdb debuggen wie Remix schon sagt dann können wir uns das eventuell erklären weil wir diese Probleme nicht haben
Kann mir jemand sagen wie ich das mache ? -
Bei mir sieht der syserr der DB so aus.
SYSERR: Dec 26 20:57:20.324157 :: pid_init:
Start of pid: 833SYSERR: Dec 26 20:58:25.295284 :: 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: Dec 26 20:58:25.295867 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 26 20:58:30.285426 :: 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: Dec 26 20:58:30.285481 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 26 20:58:30.285537 :: 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: Dec 26 20:58:30.285561 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 26 20:58:35.287101 :: 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: Dec 26 20:58:35.287179 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 26 20:58:35.287222 :: 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: Dec 26 20:58:35.287238 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 26 20:58:35.287264 :: 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: Dec 26 20:58:35.287278 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 26 20:58:40.287108 :: 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: Dec 26 20:58:40.287160 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 26 20:58:40.287194 :: 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: Dec 26 20:58:40.287209 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 26 20:58:40.287235 :: 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: Dec 26 20:58:40.287248 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 26 20:58:40.287273 :: 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: Dec 26 20:58:40.287286 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 26 20:58:43.916713 :: 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: Dec 26 20:58:43.916786 :: 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: Dec 26 20:58:43.983201 :: Process: FDWATCH: peer null in event: ident 22
SYSERR: Dec 26 20:58:45.290591 :: 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: Dec 26 20:58:45.290703 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 26 20:58:45.290744 :: 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: Dec 26 20:58:45.290795 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 26 20:58:45.290863 :: 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: Dec 26 20:58:45.290879 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 26 20:58:45.290906 :: 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: Dec 26 20:58:45.290919 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 26 20:58:45.290946 :: 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: Dec 26 20:58:45.290960 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 26 20:58:50.301858 :: ChildLoop: MySQL connection was reconnected. querying locale set
SYSERR: Dec 26 21:02:42.201323 :: DirectQuery: MySQL connection was reconnected. querying locale set
SYSERR: Dec 26 21:02:42.286893 :: Process: FDWATCH: peer null in event: ident 21und im Syslog der DB das
Dec 26 21:02:42.189365 :: SetPlay off 1359093779 greeley
Dec 26 21:02:42.189489 :: SetPlay off 1732701792 test
Dec 26 21:02:42.189539 :: Connection closed. (host: 127.0.0.1)
Dec 26 21:02:42.189552 :: ItemIDRange: returned. 10000001 ~ 20000000
SYSERR: Dec 26 21:02:42.201323 :: DirectQuery: MySQL connection was reconnected. querying locale set
Dec 26 21:02:42.201499 :: --mysql_set_character_set(latin1)
Dec 26 21:02:42.202672 :: ItemIDRange: Build: 10000001 ~ 20000000 start:10000338
SYSERR: Dec 26 21:02:42.286893 :: Process: FDWATCH: peer null in event: ident 21und von der core1 das
Start of pid: 839
SYSERR: Dec 26 20:58:26.390919 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
query: SELECT * FROM offline_shop_npc
SYSERR: Dec 26 20:58:26.466500 :: heart_idle: losing 60 seconds. (lag occured)
SYSERR: Dec 26 20:58:46.841580 :: socket_connect: HOST 188.165.145.130:14120, could not connect.
SYSERR: Dec 26 20:59:41.457722 :: ChildLoop: MySQL connection was reconnected. querying locale set
SYSERR: Dec 26 21:00:14.649421 :: DirectQuery: MySQL connection was reconnected. querying locale set
SYSERR: Dec 26 21:00:14.654282 :: locale_find: LOCALE_ERROR: "You were banned! Reason:";Syslog der core1
Dec 26 21:00:14.647060 :: COMMAND: [SA]Greeley: ban
Dec 26 21:00:14.647169 :: BAN Test1
SYSERR: Dec 26 21:00:14.649421 :: DirectQuery: MySQL connection was reconnected. querying locale set
Dec 26 21:00:14.649554 :: --mysql_set_character_set(latin1)
SYSERR: Dec 26 21:00:14.654282 :: locale_find: LOCALE_ERROR: "You were banned! Reason:"; -
Würde ich ja jetzt gerne machen Remix aber ich weiß leider nicht ganz wo ich den " stacktrace" von der .core finde
-
und der wäre?
hab nichts verändert an dem client oder files hab nur
die ip-adresse in der serverinfo.py eingetragen und in der start.shfiles liegen auf /usr/home und mysql natürlich in var/db
also wüsste nicht was da flasch sein sollte
Da Stimme ich dir zu bei mir ist das leider genau so der Fall ich habe nichts verändert.
mich würde es freuen wenn man den Fehler beheben könnte.
Oder mal einer eine Erklärung zum fixen des ganzen bekommen würde. -
Ich benutze die Bitte melden Sie sich an, um diesen Link zu sehen. aber vor ab auch beim /unbann gibt es einen CRASH das habe ich vergessen zu erwähnen.
-
Hallo,
ich habe das Proplem das mir ingame alles zerschossen wird sobald ich /ban eingebe [Z,B] /Bann Test1 Hack
und ich weiß leider nicht woran es liegen kann, wäre echt klasse wenn mir da einer helfen könnte.
MFG: Greeley