DB Crash...

01/12/2014 00:33 Da' Real Pαιη#1
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
01/12/2014 00:37 Structurix#2
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
01/12/2014 00:43 Da' Real Pαιη#3
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
01/12/2014 00:47 Structurix#4
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::DirectQuery : 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
01/12/2014 01:22 Da' Real Pαιη#5
hat jemand eine Lösung wie ich das fixxen kann ?
Bedanke mich im voraus.
01/12/2014 02:07 Akzyra#6
Rechtsklick in Navicat auf Tabelle -> Mantain -> Repair

Sollte gehen, kann grade nicht schauen
01/12/2014 02:39 Da' Real Pαιη#7
@Akzyra
Habe alle tabellen repair.
Aber der Fehler besteht weiter hin...
Ich verzweifle langsam :/
01/12/2014 02:50 .Inya#8
Womit versuchst du was zu uppen und welche refine_vnum hat es?

Welche Value0 hat das Upitem?
01/12/2014 03:13 Da' Real Pαιη#9
Ist nur Yang und egal ob beim schmied oder mit Metall.
01/12/2014 11:59 ebert.tonna#10
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.
01/12/2014 14:22 Da' Real Pαιη#11
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^^
01/12/2014 14:46 Nectix#12
#closed