GlobalDBAgent.log ERROR!

[xxdestruxx]

[Sat Nov 21 2009 11:34:31.649727 3065809824]: Database Connect success!
[Sat Nov 21 2009 11:34:31.663039 3065809824]: [##ERROR##] OnIPCAuthAccount fail (usernum: 0)
[Sat Nov 21 2009 11:34:31.663121 3065809824]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Could not find the index entry for RID '16721c0000010000' in index page (1:723), index ID 0, database 'ACCOUNT'.
[Sat Nov 21 2009 11:34:31.663190 3065809824]: [##ERROR##] DB ERROR(CODE) : 644
[Sat Nov 21 2009 11:34:31.663232 3065809824]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sat Nov 21 2009 11:34:31.663261 3065809824]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Sat Nov 21 2009 11:34:31.663289 3065809824]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_auth( ? , ? , ? , ? )}
[Sat Nov 21 2009 11:34:31.675222 3065809824]: Database Connect success!
[Sat Nov 21 2009 11:34:31.675299 3065809824]: [##ERROR##] 'OnIPCAuthAccount' fail (Database/Auth.cpp:283)
[Sat Nov 21 2009 11:34:31.676292 3065809824]: [##ERROR##] UsrMap Fail : MainCmd(30) Ret(11B:0:283) Addr(127.0.0.1)
[Sat Nov 21 2009 11:35:41.319728 3034340256]: Database Connect success!
[Sat Nov 21 2009 11:35:41.336408 3034340256]: [##ERROR##] OnIPCAuthAccount fail (usernum: 0)
[Sat Nov 21 2009 11:35:41.336490 3034340256]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Could not find the index entry for RID '16721c0000010000' in index page (1:723), index ID 0, database 'ACCOUNT'.
[Sat Nov 21 2009 11:35:41.336522 3034340256]: [##ERROR##] DB ERROR(CODE) : 644
[Sat Nov 21 2009 11:35:41.336550 3034340256]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sat Nov 21 2009 11:35:41.336578 3034340256]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Sat Nov 21 2009 11:35:41.336606 3034340256]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_auth( ? , ? , ? , ? )}
[Sat Nov 21 2009 11:35:41.350867 3034340256]: Database Connect success!
[Sat Nov 21 2009 11:35:41.350956 3034340256]: [##ERROR##] 'OnIPCAuthAccount' fail (Database/Auth.cpp:283)
[Sat Nov 21 2009 11:35:41.351030 3034340256]: [##ERROR##] UsrMap Fail : MainCmd(30) Ret(11B:0:283) Addr(127.0.0.1)

[MentaL]

[chumpywumpy]

This looks like index corruption in the database. I would suggest a "dbcc checkdb" and if that doesn't fix it run "dbcc dbreindex".

Make sure you have all of the latest services packs and make ure you have a scheduled maintenance job to a) take a daily backup and b) do health checks. Google "maintenance tasks" for your version of sql as this is essential!

[xxdestruxx]

SQL 2000 does not recognize the command DBCC DBREINDEX
===============


edit

Thanks

Used Command: DBCC DBREINDEX (cabal_auth_tale)




in ACCOUNT :)