-
help!!!
[Wed Oct 21 2009 19:26:55.580267 3054570400]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Wed Oct 21 2009 19:26:55.583008 3054570400]: [##ERROR##] DB ERROR(CODE) : 20009
[Wed Oct 21 2009 19:26:55.583079 3054570400]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Oct 21 2009 19:26:55.583154 3054570400]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Wed Oct 21 2009 19:26:55.583214 3054570400]: [##ERROR##] DB ERROR(STM_TEXT) :
[Wed Oct 21 2009 19:26:55.583279 3054570400]: [##ERROR##] Database Connect Fail (uid=xx;pwd=xxxxxx;dsn=CabalGame01;APP=DBAgent_01)
[Wed Oct 21 2009 19:26:55.583776 3054570400]: [##ERROR##] check 'pDB' fail
[Wed Oct 21 2009 19:26:55.583844 3054570400]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Wed Oct 21 2009 19:26:55.583910 3054570400]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Wed Oct 21 2009 19:30:04.573038 3086039968]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Wed Oct 21 2009 19:30:04.573245 3086039968]: [##ERROR##] DB ERROR(CODE) : 20009
[Wed Oct 21 2009 19:30:04.573310 3086039968]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Oct 21 2009 19:30:04.573386 3086039968]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Wed Oct 21 2009 19:30:04.573448 3086039968]: [##ERROR##] DB ERROR(STM_TEXT) :
[Wed Oct 21 2009 19:30:04.573513 3086039968]: [##ERROR##] Database Connect Fail (uid=xx;pwd=xxxxxxxx;dsn=CabalGame01;APP=DBAgent_01)
[Wed Oct 21 2009 19:30:04.573659 3086039968]: [##ERROR##] check 'pDB' fail
[Wed Oct 21 2009 19:30:04.573721 3086039968]: [##ERROR##] 'OnIPCItemSerial0' fail (Database/ItemSerial.cpp:24)
[Wed Oct 21 2009 19:30:04.573819 3086039968]: [##ERROR##] UsrMap Fail : MainCmd(50) Ret(18:0:24) Addr(127.0.0.1)
I got that from time to time, i think it's from TG!Anyone help?:)
-
Re: help!!!
All that means is some database connections failed because the sql server could not be contacted. If it manages most of the time and only fails occasionally it could be a blip in the vmware networking (if you use vmware) or something like that. The trick is to look at what the other processes are doing at the samt ime as the dbagent is mostly just running queries and doing background stuff, it's things like the worldsvrs, login server and chatnode that do most of the work.
-
Re: help!!!
[Wed Oct 21 2009 21:13:43.624298 3023510432]: [##ERROR##] OnIPCQueryCashItem fail
[Wed Oct 21 2009 21:13:43.624495 3023510432]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Read from SQL server failed.
[Wed Oct 21 2009 21:13:43.624544 3023510432]: [##ERROR##] DB ERROR(CODE) : 20004
[Wed Oct 21 2009 21:13:43.624590 3023510432]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Oct 21 2009 21:13:43.624634 3023510432]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Wed Oct 21 2009 21:13:43.624679 3023510432]: [##ERROR##] DB ERROR(STM_TEXT) : {call up_QueryMyCashItem( ? , ? )}
[Wed Oct 21 2009 21:16:52.616875 3023510432]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Wed Oct 21 2009 21:16:52.617036 3023510432]: [##ERROR##] DB ERROR(CODE) : 20009
[Wed Oct 21 2009 21:16:52.617083 3023510432]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Oct 21 2009 21:16:52.617220 3023510432]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Wed Oct 21 2009 21:16:52.617265 3023510432]: [##ERROR##] DB ERROR(STM_TEXT) :
[Wed Oct 21 2009 21:16:52.617313 3023510432]: [##ERROR##] Database Connect Fail (uid=xx;pwd=xxxxxxx;dsn=CabalCash;APP=CashDBAgent)
[Wed Oct 21 2009 21:16:52.617412 3023510432]: [##ERROR##] 'OnIPCQueryCashItem' fail (Database/CashItem.cpp:72)
[Wed Oct 21 2009 21:16:52.617507 3023510432]: [##ERROR##] UsrMap Fail : MainCmd(70) Ret(48:0:72) Addr(127.0.0.1)
[Wed Oct 21 2009 21:32:33.444784 3013020576]: [##ERROR##] OnIPCQueryCashItem fail
[Wed Oct 21 2009 21:32:33.444927 3013020576]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Read from SQL server failed.
[Wed Oct 21 2009 21:32:33.444977 3013020576]: [##ERROR##] DB ERROR(CODE) : 20004
[Wed Oct 21 2009 21:32:33.445024 3013020576]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Oct 21 2009 21:32:33.445069 3013020576]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Wed Oct 21 2009 21:32:33.445116 3013020576]: [##ERROR##] DB ERROR(STM_TEXT) : {call up_QueryMyCashItem( ? , ? )}
now i get that error......OMG......forgot to mention sv is dedicated maybe that matters:thumbup:
also i mention i get that error since 3 days....
thanks for helping
-
Re: help!!!
It doesn't matter if it is dedicated or not. You need to check the other logs as all that tells us is that the server cannot be found it doesn't give any clues as to why. It sounds like the connection between windows and centos is getting reset, but that is just a guess. I would look at the connectivity between the two and try things like ping tests when the errors appear to see if there is still a connection.
Unfortunately using vmware does introduce an extra place where networking can be unreliable. This is why i don't use vmware myself for anything other than test servers.
-
Re: help!!!
then can you recommends something else?i checked other logs but same error!:thumbup: thanx again for help
-
Re: help!!!
I can't recommend anything as all i can tell is the connection is dropping out. I have no information to tell me what could be causing it and my only guess is that it is vmware networking closing connections. I only use vmware for test servers not "production" servers as vmware adds another area where things can go wrong.
You need to examine the connectivity between the two and see what is happening at the time it drops. Only investigation into what is actually happening will solve this one.
-
Re: help!!!
oke found out the problem!From mistake at sql ip i put a vpn ip.....which is closing from time to time and from there is the bug!Now i put the real sql ip and works perfect:)!
Thanks for help!:)
Greetz
