Heya all guys
We got a problem, our database is doing tricks. A "bug" appened, people couldn't change the names of their toons or creat new ones. The server is running from almost 10mounths now, and that never appened before. Even like that, we tried the quiry that was around to "fix the name already in use problem", didn't work.
This is what appening
Logs;PS_DBAGENT__system.log
2011-10-20 14:45:20 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)
2011-10-20 14:45:20 ::CreateCharacter 42446 tatu retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'israel',12851,'tatu', 3,0,3,3,0,2,5,1, 1,0,0, 8,9,10,12,12,14, 290,295,160, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}
2011-10-20 14:45:20 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2011-10-20 14:45:21 VerifyReConnect : The Connection has been lost, SQLHDBC=dada68
2011-10-20 14:45:21 SDatabasePool::Reconnect:: success...
2011-10-20 14:45:27 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)
2011-10-20 14:45:27 ::CreateCharacter 39059 DEF_TANATOS_ retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'alessandro',12853,'DEF_TANATO S_', 1,3,3,2,2,4,1,0, 1,0,0, 12,9,14,10,10,10, 455,147,142, 2,0, 0,0, 1838.930054,129.330002,443.429993, 0,200,0,0,0)}
2011-10-20 14:45:27 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
Sorry for the big text but i tried to explain as much as i could. Apreciate for reading
Rayden
We got a problem, our database is doing tricks. A "bug" appened, people couldn't change the names of their toons or creat new ones. The server is running from almost 10mounths now, and that never appened before. Even like that, we tried the quiry that was around to "fix the name already in use problem", didn't work.
This is what appening
Logs;PS_DBAGENT__system.log
2011-10-20 14:45:20 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)
2011-10-20 14:45:20 ::CreateCharacter 42446 tatu retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'israel',12851,'tatu', 3,0,3,3,0,2,5,1, 1,0,0, 8,9,10,12,12,14, 290,295,160, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}
2011-10-20 14:45:20 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2011-10-20 14:45:21 VerifyReConnect : The Connection has been lost, SQLHDBC=dada68
2011-10-20 14:45:21 SDatabasePool::Reconnect:: success...
2011-10-20 14:45:27 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)
2011-10-20 14:45:27 ::CreateCharacter 39059 DEF_TANATOS_ retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'alessandro',12853,'DEF_TANATO S_', 1,3,3,2,2,4,1,0, 1,0,0, 12,9,14,10,10,10, 455,147,142, 2,0, 0,0, 1838.930054,129.330002,443.429993, 0,200,0,0,0)}
2011-10-20 14:45:27 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
Sorry for the big text but i tried to explain as much as i could. Apreciate for reading
Rayden