DB Crash...

Da' Real Pαιη · 01/12/2014, 00:33

Liebe E*PvP-Community,

ich bin nun auf die 34k umgestiegen und musste feststellen, dass beim Uppen eines Gegenstandes der Server crashed.
Ich haben ebenso nach allen möglichen Fehlern gesucht und den Syserr Inhalt eins nach dem anderen abarbeitet.
Dennoch bekomme ich diesen Fehler.

Code:

SYSERR: Jan 11 23:14:11 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jan 11 23:14:13 :: Load:  DirectQuery failed(SELECT login FROM block_exception)
SYSERR: Jan 11 23:14:19 :: Process: FDWATCH: peer null in event: ident 24
SYSERR: Jan 11 23:15:52 :: Process: FDWATCH: peer null in event: ident 26

Langsam verzweifel ich wirklich.
Und falls jemand sagt, ich soll auf die r_40k umsteigen, könnt ihr euch diesen Kommentar sparen.

Danke im voraus.

king regards
DaRealPain

Structurix · 01/12/2014, 00:37

Das sollten keine Fehler sein die deine Core zum abstürzen bringen,in den anderen sys steht nix drinne?Bei mir steht das gleiche drinne und nix stürtzt ab.

MFG

Da' Real Pαιη · 01/12/2014, 00:43

db syserr:

Code:

SYSERR: Jan 11 23:13:04 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jan 11 23:13:04 :: pid_deinit: 
End of pid

SYSERR: Jan 11 23:14:11 :: pid_init: 
Start of pid: 814

SYSERR: Jan 11 23:14:11 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jan 11 23:14:13 :: Initialize: conf.txt: Cannot find PLAYER_DELETE_LEVEL_LIMIT, use default level 121
SYSERR: Jan 11 23:14:13 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table './player/marriage' is marked as crashed and last (automatic?) repair failed
query: DELETE FROM marriage WHERE is_married = 0
SYSERR: Jan 11 23:14:13 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table './player/marriage' is marked as crashed and last (automatic?) repair failed
query: SELECT pid1, pid2, love_point, time, is_married, p1.name, p2.name FROM marriage, player as p1, player as p2 WHERE p1.id = pid1 AND p2.id = pid2
SYSERR: Jan 11 23:14:13 :: Load:  DirectQuery failed(SELECT login FROM block_exception)
SYSERR: Jan 11 23:14:19 :: Process: FDWATCH: peer null in event: ident 24
SYSERR: Jan 11 23:15:52 :: Process: FDWATCH: peer null in event: ident 26

channel1:

Code:

SYSERR: Jan 11 23:32:45 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:32:49 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:32:52 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:32:55 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:32:58 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:33:01 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:33:04 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:33:07 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:33:10 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:33:13 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:33:15 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jan 11 23:33:15 :: pid_deinit: 
End of pid

SYSERR: Jan 11 23:35:09 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jan 11 23:35:10 :: pid_deinit: 
End of pid

SYSERR: Jan 11 23:38:42 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:38:45 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:38:48 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:38:51 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:38:54 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:38:57 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:39:00 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:39:03 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:39:06 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:39:09 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:39:10 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jan 11 23:39:10 :: pid_deinit: 
End of pid

SYSERR: Jan 11 23:40:43 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:40:46 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:40:49 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:40:52 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:40:55 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:40:58 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:41:01 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:41:04 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:41:07 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:41:10 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:41:13 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:41:16 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:41:19 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:41:22 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan 11 23:41:23 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jan 11 23:41:23 :: pid_deinit: 
End of pid

SYSERR: Jan 11 23:44:38 :: dungeon_get_flag: no dungeon !!!
SYSERR: Jan 11 23:44:55 :: DoRefineWithScroll: REFINE : Unknown refine scroll item. Value0: 1

Structurix · 01/12/2014, 00:47

schau mal hier nach

SYSERR: Jan 11 23:44:55 :: DoRefineWithScroll: REFINE : Unknown refine scroll item. Value0: 1
geh noch mal alles durch was du geändert hast,

und schau mal hier

SYSERR: Jan 11 23:14:13 :: DirectQuery: AsyncSQL:

irectQuery : mysql_query error: Table './player/marriage' is marked as crashed and last (automatic?) repair failed

dein db tabelle ist gecrasht,aber an dem oberen fehler liegt es

MFG

Da' Real Pαιη · 01/12/2014, 01:22

hat jemand eine Lösung wie ich das fixxen kann ?
Bedanke mich im voraus.

Akzyra · 01/12/2014, 02:07

Rechtsklick in Navicat auf Tabelle -> Mantain -> Repair

Sollte gehen, kann grade nicht schauen

Da' Real Pαιη · 01/12/2014, 02:39

@Akzyra
Habe alle tabellen repair.
Aber der Fehler besteht weiter hin...
Ich verzweifle langsam :/

.Inya · 01/12/2014, 02:50

Womit versuchst du was zu uppen und welche refine_vnum hat es?

Welche Value0 hat das Upitem?

Da' Real Pαιη · 01/12/2014, 03:13

Ist nur Yang und egal ob beim schmied oder mit Metall.

ebert.tonna · 01/12/2014, 11:59

Ihr könnt ihm so nicht helfen, da muss jemand mit TV ran, es sind einfach zuviele Sachen die er falsch haben könnte. Und Verzweiflungstaten helfen hier nicht.

Da' Real Pαιη · 01/12/2014, 14:22

Danke dir Ebert.tonna.
Habe das Problem nach stunden endlich gefunden.
Das Problem enstand nach dem ich die Diff "vCardlog ausnoppen: (Thanks to .Avenue™)"
rauf gepatcht habe...
Jetzt geht alles danke nochmals für eure Hilfe.
Man kann nie genung lernen^^

Nectix · 01/12/2014, 14:46

#closed