-
Centos
omg now i got some prob in sql:Tue Nov 17 2009 04:55:21.729600 3044768656]: [##ERROR##] UsrMap Fail : MainCmd(28) Ret(25:0:37) Addr(127.0.0.1)
[Tue Nov 17 2009 04:55:21.729994 3023788944]: [##ERROR##] OnIPCSetLoginStt fail (UserNum: 552)
[Tue Nov 17 2009 04:55:21.730036 3023788944]: [##ERROR##] DB ERROR(MSG) :
[Tue Nov 17 2009 04:55:21.730070 3023788944]: [##ERROR##] DB ERROR(CODE) : 0
[Tue Nov 17 2009 04:55:21.730104 3023788944]: [##ERROR##] DB ERROR(VAR_INFO) :
[Tue Nov 17 2009 04:55:21.730137 3023788944]: [##ERROR##] DB ERROR(SQLSTATE) : 00000
[Tue Nov 17 2009 04:55:21.730171 3023788944]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_setloginstt( ? , ? , ? )}
[Tue Nov 17 2009 04:55:21.790997 3023788944]: Database Connect success!
[Tue Nov 17 2009 04:55:21.791072 3023788944]: [##ERROR##] 'OnIPCSetLoginStt' fail (Database/SetLoginStat.cpp:37)
[Tue Nov 17 2009 04:55:21.791118 3023788944]: [##ERROR##] UsrMap Fail : MainCmd(28) Ret(25:0:37) Addr(127.0.0.1)
[Tue Nov 17 2009 04:55:21.791454 2992319376]: [##ERROR##] OnIPCSetLoginStt fail (UserNum: 1)
[Tue Nov 17 2009 04:55:21.791496 2992319376]: [##ERROR##] DB ERROR(MSG) :
[Tue Nov 17 2009 04:55:21.791532 2992319376]: [##ERROR##] DB ERROR(CODE) : 0
[Tue Nov 17 2009 04:55:21.791568 2992319376]: [##ERROR##] DB ERROR(VAR_INFO) :
[Tue Nov 17 2009 04:55:21.791699 2992319376]: [##ERROR##] DB ERROR(SQLSTATE) : 00000
[Tue Nov 17 2009 04:55:21.791736 2992319376]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_setloginstt( ? , ? , ? )}
[Tue Nov 17 2009 04:55:21.817640 2992319376]: Database Connect success!
Global db agent
[Mon Nov 16 2009 18:41:06.062586 3065736080]: [##ERROR##] DB ERROR(MSG) :
[Mon Nov 16 2009 18:41:06.062714 3065736080]: [##ERROR##] DB ERROR(CODE) : 0
[Mon Nov 16 2009 18:41:06.062780 3065736080]: [##ERROR##] DB ERROR(VAR_INFO) :
[Mon Nov 16 2009 18:41:06.062830 3065736080]: [##ERROR##] DB ERROR(SQLSTATE) : 00000
[Mon Nov 16 2009 18:41:06.062878 3065736080]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults}
[Mon Nov 16 2009 18:41:06.107003 3065736080]: Database Connect success!
[Mon Nov 16 2009 18:41:06.107119 3065736080]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187)
[Mon Nov 16 2009 18:41:06.107207 3065736080]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1)
[Mon Nov 16 2009 18:41:06.238747 3076225936]: [##ERROR##] UpdateCharData fail (CharacterIdx: 8)
[Mon Nov 16 2009 18:41:06.238826 3076225936]: [##ERROR##] DB ERROR(MSG) :
[Mon Nov 16 2009 18:41:06.238878 3076225936]: [##ERROR##] DB ERROR(CODE) : 0
[Mon Nov 16 2009 18:41:06.238928 3076225936]: [##ERROR##] DB ERROR(VAR_INFO) :
[Mon Nov 16 2009 18:41:06.238976 3076225936]: [##ERROR##] DB ERROR(SQLSTATE) : 00000
[Mon Nov 16 2009 18:41:06.239026 3076225936]: [##ERROR##] DB ERROR(STM_TEXT) : {call set_cabal_character_ex( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )}
[Mon Nov 16 2009 18:41:06.255690 3076225936]: Database Connect success!
[Mon Nov 16 2009 18:41:06.255850 3076225936]: [##ERROR##] 'UpdateCharData' fail (Database/UpdateChDat.cpp:279)
[Mon Nov 16 2009 18:41:06.255896 3076225936]: [##ERROR##] 'OnIPCUnInitialze' fail (Database/UpdateChDat.cpp:415)
[Mon Nov 16 2009 18:41:06.255943 3076225936]: [##ERROR##] UsrMap Fail : MainCmd(42) Ret(19F:0:415) Addr(127.0.0.1)
[Mon Nov 16 2009 18:41:06.256456 3042966416]: [##ERROR##] DB ERROR(MSG) :
[Mon Nov 16 2009 18:41:06.256499 3042966416]: [##ERROR##] DB ERROR(CODE) : 0
[Mon Nov 16 2009 18:41:06.256536 3042966416]: [##ERROR##] DB ERROR(VAR_INFO) :
[Mon Nov 16 2009 18:41:06.256572 3042966416]: [##ERROR##] DB ERROR(SQLSTATE) : 00000
[Mon Nov 16 2009 18:41:06.256607 3042966416]: [##ERROR##] DB ERROR(STM_TEXT) : UPDATE CABAL_ITEMSERIAL_TABLE SET SERIALBGN = ? , SERIALEND = ? WHERE GROUPIDX = ? AND KINDIDX = ?
[Mon Nov 16 2009 18:41:06.273204 3042966416]: Database Connect success!
Db Agent
[Mon Nov 16 2009 18:42:46.029512 3065805712]: [##ERROR##] DB ERROR(MSG) :
[Mon Nov 16 2009 18:42:46.029565 3065805712]: [##ERROR##] DB ERROR(CODE) : 0
[Mon Nov 16 2009 18:42:46.029614 3065805712]: [##ERROR##] DB ERROR(VAR_INFO) :
[Mon Nov 16 2009 18:42:46.029662 3065805712]: [##ERROR##] DB ERROR(SQLSTATE) : 00000
[Mon Nov 16 2009 18:42:46.029721 3065805712]: [##ERROR##] DB ERROR(STM_TEXT) : {call up_QueryMyCashItem( ? , ? )}
[Mon Nov 16 2009 18:42:46.051262 3065805712]: Database Connect success!
[Mon Nov 16 2009 18:42:46.051381 3065805712]: [##ERROR##] 'OnIPCQueryCashItem' fail (Database/CashItem.cpp:72)
[Mon Nov 16 2009 18:42:46.051443 3065805712]: [##ERROR##] UsrMap Fail : MainCmd(70) Ret(48:0:72) Addr(127.0.0.1)
[Mon Nov 16 2009 18:44:21.745695 3086785424]: [##ERROR##] OnIPCQueryCashItem fail
[Mon Nov 16 2009 18:44:21.745871 3086785424]: [##ERROR##] DB ERROR(MSG) :
[Mon Nov 16 2009 18:44:21.745926 3086785424]: [##ERROR##] DB ERROR(CODE) : 0
[Mon Nov 16 2009 18:44:21.745976 3086785424]: [##ERROR##] DB ERROR(VAR_INFO) :
[Mon Nov 16 2009 18:44:21.746024 3086785424]: [##ERROR##] DB ERROR(SQLSTATE) : 00000
[Mon Nov 16 2009 18:44:21.746072 3086785424]: [##ERROR##] DB ERROR(STM_TEXT) : {call up_QueryMyCashItem( ? , ? )}
[Mon Nov 16 2009 18:44:21.782677 3086785424]: Database Connect success!
Cash db agent
i got sick with those prob
They make laag to the server
-
Re: Centos
Things don't randomly stop working in the database so what did you change last? There are no error message or codes from the sql server saying why the queries failed, and there are lots of different types of queries so either something has changed or been fiddled with.
The queries are all about cash items and updating player states. Is anyone trying hacks?