WTF!? Anyone Have This Errors!?

[LocaSimon]

i Got This ERROR! OMG! Every 5min i get it !!! Why !?

[Thu Jul 21 2011 13:30:29.149389 3065228176]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1)
[Thu Jul 21 2011 13:30:29.154026 3086207888]: [##ERROR##] UpdateCharData fail (CharacterIdx: 328)
[Thu Jul 21 2011 13:30:29.154157 3086207888]: [##ERROR##] DB ERROR(MSG)      : [FreeTDS][SQL Server]Read from SQL server failed.
[Thu Jul 21 2011 13:30:29.154184 3086207888]: [##ERROR##] DB ERROR(CODE)     : 20004
[Thu Jul 21 2011 13:30:29.154203 3086207888]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Thu Jul 21 2011 13:30:29.154222 3086207888]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Thu Jul 21 2011 13:30:29.154240 3086207888]: [##ERROR##] DB ERROR(STM_TEXT) : {call set_cabal_character_ex(  ?                ,  ?                 ,  ?            ,  ?               ,  ?           ,  ?           ,  ?           ,  ?           ,  ?            ,  ?              ,  ?             ,  ?             ,  ?          ,  ?          ,  ?          ,  ?              ,  ?              ,  ?               ,  ?                  ,  ?          ,  ?                  ,  ?                  ,  ?                  ,  ?                 ,  ?                ,  ?                       ,  ?                           ,  ?                          ,  ?                           ,  ?                       ,  ?                       ,  ?                           ,  ?                      ,  ?                    ,  ?                   ,  ?                   ,  ?                   ,  ?                   ,  ?                   ,  ?                 ,  ?                 ,  ?                 ,  ?                 ,  ?                 ,  ?                       ,  ?                           ,  ?               ,  ?                      ,  ?                    ,  ?                     )}
[Thu Jul 21 2011 13:30:29.173491 3086207888]: Database Connect success!
[Thu Jul 21 2011 13:30:29.173557 3086207888]: [##ERROR##] 'UpdateCharData' fail (Database/UpdateChDat.cpp:279)
[Thu Jul 21 2011 13:30:29.173581 3086207888]: [##ERROR##] 'OnIPCUpdateChDat' fail (Database/UpdateChDat.cpp:388)
[Thu Jul 21 2011 13:30:29.173603 3086207888]: [##ERROR##] UsrMap Fail : MainCmd(46) Ret(184:0:388) Addr(127.0.0.1)
[Thu Jul 21 2011 13:30:29.173622 3044248464]: [##ERROR##] UpdateCharData fail (CharacterIdx: 361)
[Thu Jul 21 2011 13:30:29.173686 3044248464]: [##ERROR##] DB ERROR(MSG)      : [FreeTDS][SQL Server]Read from SQL server failed.
[Thu Jul 21 2011 13:30:29.173739 3044248464]: [##ERROR##] DB ERROR(CODE)     : 20004
[Thu Jul 21 2011 13:30:29.173759 3044248464]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Thu Jul 21 2011 13:30:29.173777 3044248464]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Thu Jul 21 2011 13:30:29.173796 3044248464]: [##ERROR##] DB ERROR(STM_TEXT) : {call set_cabal_character_ex(  ?                ,  ?                 ,  ?            ,  ?               ,  ?           ,  ?           ,  ?           ,  ?           ,  ?            ,  ?              ,  ?             ,  ?             ,  ?          ,  ?          ,  ?          ,  ?              ,  ?              ,  ?               ,  ?                  ,  ?          ,  ?                  ,  ?                  ,  ?                  ,  ?                 ,  ?                ,  ?                       ,  ?                           ,  ?                          ,  ?                           ,  ?                       ,  ?                       ,  ?                           ,  ?                      ,  ?                    ,  ?                   ,  ?                   ,  ?                   ,  ?                   ,  ?                   ,  ?                 ,  ?                 ,  ?                 ,  ?                 ,  ?                 ,  ?                       ,  ?                           ,  ?               ,  ?                      ,  ?                    ,  ?                     )}
[Thu Jul 21 2011 13:30:29.181094 3044248464]: Database Connect success!
[Thu Jul 21 2011 13:30:29.181158 3044248464]: [##ERROR##] 'UpdateCharData' fail (Database/UpdateChDat.cpp:279)
[Thu Jul 21 2011 13:30:29.181184 3044248464]: [##ERROR##] 'OnIPCUpdateChDat' fail (Database/UpdateChDat.cpp:388)
[Thu Jul 21 2011 13:30:29.181207 3044248464]: [##ERROR##] UsrMap Fail : MainCmd(46) Ret(184:0:388) Addr(127.0.0.1)
[Thu Jul 21 2011 13:33:55.975193 3044248464]: [##ERROR##] DB ERROR(MSG)      : 
[Thu Jul 21 2011 13:33:55.975238 3044248464]: [##ERROR##] DB ERROR(CODE)     : 0
[Thu Jul 21 2011 13:33:55.975259 3044248464]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Thu Jul 21 2011 13:33:55.975278 3044248464]: [##ERROR##] DB ERROR(SQLSTATE) : 00000
[Thu Jul 21 2011 13:33:55.975296 3044248464]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults}
[Thu Jul 21 2011 13:33:55.988707 3044248464]: Database Connect success!
[Thu Jul 21 2011 13:33:55.988764 3044248464]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187)
[Thu Jul 21 2011 13:33:55.988879 3044248464]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1)
[Thu Jul 21 2011 13:33:55.997423 3075718032]: [##ERROR##] UpdateCharData fail (CharacterIdx: 160)
[Thu Jul 21 2011 13:33:55.997471 3075718032]: [##ERROR##] DB ERROR(MSG)      : 
[Thu Jul 21 2011 13:33:55.997491 3075718032]: [##ERROR##] DB ERROR(CODE)     : 0
[Thu Jul 21 2011 13:33:55.997510 3075718032]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Thu Jul 21 2011 13:33:55.997529 3075718032]: [##ERROR##] DB ERROR(SQLSTATE) : 00000
[Thu Jul 21 2011 13:33:55.997547 3075718032]: [##ERROR##] DB ERROR(STM_TEXT) : {call set_cabal_character_ex(  ?                ,  ?                 ,  ?            ,  ?               ,  ?           ,  ?           ,  ?           ,  ?           ,  ?            ,  ?              ,  ?             ,  ?             ,  ?          ,  ?          ,  ?          ,  ?              ,  ?              ,  ?               ,  ?                  ,  ?          ,  ?                  ,  ?                  ,  ?                  ,  ?                 ,  ?                ,  ?                       ,  ?                           ,  ?                          ,  ?                           ,  ?                       ,  ?                       ,  ?                           ,  ?                      ,  ?                    ,  ?                   ,  ?                   ,  ?                   ,  ?                   ,  ?                   ,  ?                 ,  ?                 ,  ?                 ,  ?                 ,  ?                 ,  ?                       ,  ?                           ,  ?               ,  ?                      ,  ?                    ,  ?                     )}
[Thu Jul 21 2011 13:33:56.011279 3075718032]: Database Connect success!
[Thu Jul 21 2011 13:33:56.011355 3075718032]: [##ERROR##] 'UpdateCharData' fail (Database/UpdateChDat.cpp:279)
[Thu Jul 21 2011 13:33:56.011395 3075718032]: [##ERROR##] 'OnIPCUnInitialze' fail (Database/UpdateChDat.cpp:415)
[Thu Jul 21 2011 13:33:56.011421 3075718032]: [##ERROR##] UsrMap Fail : MainCmd(42) Ret(19F:0:415) Addr(127.0.0.1)
[Thu Jul 21 2011 13:34:28.080929 3086207888]: [##ERROR##] DB ERROR(MSG)      : 
[Thu Jul 21 2011 13:34:28.081163 3086207888]: [##ERROR##] DB ERROR(CODE)     : 0
[Thu Jul 21 2011 13:34:28.081192 3086207888]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Thu Jul 21 2011 13:34:28.081214 3086207888]: [##ERROR##] DB ERROR(SQLSTATE) : 00000
[Thu Jul 21 2011 13:34:28.081234 3086207888]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults}
[Thu Jul 21 2011 13:34:28.087466 3086207888]: Database Connect success!
[Thu Jul 21 2011 13:34:28.087536 3086207888]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187)
[Thu Jul 21 2011 13:34:28.087568 3086207888]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1)

[MentaL]

[Yamachi]

Obviously something is interrupting the connection between your DB and server... You might want to think about moving your DB to a separate dedi or getting a beefier dedi and more bandwidth, and/or reducing the amount of players.

[chumpywumpy]

That isn't it Mr Squirrel, sorry :P

[Thu Jul 21 2011 13:30:29.149389 3065228176]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1)
[Thu Jul 21 2011 13:30:29.154026 3086207888]: [##ERROR##] UpdateCharData fail (CharacterIdx: 328)
[Thu Jul 21 2011 13:30:29.154157 3086207888]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Read from SQL server failed.
[Thu Jul 21 2011 13:30:29.154184 3086207888]: [##ERROR##] DB ERROR(CODE) : 20004
[Thu Jul 21 2011 13:30:29.154203 3086207888]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Jul 21 2011 13:30:29.154222 3086207888]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Thu Jul 21 2011 13:30:29.154240 3086207888]: [##ERROR##] DB ERROR(STM_TEXT) : {call set_cabal_character_ex( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )}
[Thu Jul 21 2011 13:30:29.173491 3086207888]: Database Connect success!
[Thu Jul 21 2011 13:30:29.173557 3086207888]: [##ERROR##] 'UpdateCharData' fail (Database/UpdateChDat.cpp:279)
[Thu Jul 21 2011 13:30:29.173581 3086207888]: [##ERROR##] 'OnIPCUpdateChDat' fail (Database/UpdateChDat.cpp:388)
[Thu Jul 21 2011 13:30:29.173603 3086207888]: [##ERROR##] UsrMap Fail : MainCmd(46) Ret(184:0:388) Addr(127.0.0.1)
[Thu Jul 21 2011 13:30:29.173622 3044248464]: [##ERROR##] UpdateCharData fail (CharacterIdx: 361)
[Thu Jul 21 2011 13:30:29.173686 3044248464]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Read from SQL server failed.
[Thu Jul 21 2011 13:30:29.173739 3044248464]: [##ERROR##] DB ERROR(CODE) : 20004
[Thu Jul 21 2011 13:30:29.173759 3044248464]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Jul 21 2011 13:30:29.173777 3044248464]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Thu Jul 21 2011 13:30:29.173796 3044248464]: [##ERROR##] DB ERROR(STM_TEXT) : {call set_cabal_character_ex( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )}
[Thu Jul 21 2011 13:30:29.181094 3044248464]: Database Connect success!

These are are very unusual and a database read query is failing. I'm guessing there is some bad char data in the db for characteridx 328 and 361. These errors have never come up before so I think something has been modded badly somewhere (new items maybe?). You would need to start by checking exactly what these chars have in terms on equips and skill data but you probably won't find the reason without using the SQL profiler to see exactly what data is going through the set_cabal_character_ex stored procedure.

[Thu Jul 21 2011 13:33:55.988764 3044248464]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187)
[Thu Jul 21 2011 13:33:55.988879 3044248464]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1)
[Thu Jul 21 2011 13:33:55.997423 3075718032]: [##ERROR##] UpdateCharData fail (CharacterIdx: 160)
[Thu Jul 21 2011 13:33:55.997471 3075718032]: [##ERROR##] DB ERROR(MSG) :
[Thu Jul 21 2011 13:33:55.997491 3075718032]: [##ERROR##] DB ERROR(CODE) : 0
[Thu Jul 21 2011 13:33:55.997510 3075718032]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Jul 21 2011 13:33:55.997529 3075718032]: [##ERROR##] DB ERROR(SQLSTATE) : 00000
[Thu Jul 21 2011 13:33:55.997547 3075718032]: [##ERROR##] DB ERROR(STM_TEXT) : {call set_cabal_character_ex( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )}
[Thu Jul 21 2011 13:33:56.011279 3075718032]: Database Connect success!

This error is well known. It means there are no nation war results to read. You can ignore this one until you have run a TG channel at least once.

[LocaSimon]

yes but when i get this TG error i cant log in to the server !

[allocen]

Then reinstall the whole server, and see if it its still the same and don`t forget to make a backup of your curently files.

[LocaSimon]

i Still Get This Error .. i reinstalled SQL and i use Chanel type 9 ... (Siruis).... what to do ?