I'm having trouble creating a new character .. When I enter the character name "This name is in use" error.
Logs;PS_DBAGENT__system.log
And Sql Screen !Quote:
2011-02-01 15:13:54 PS_DBAGENT__system log start (DBAgent01)
2011-02-01 15:14:14 connect game, Name=
2011-02-01 15:14:14 1 1 SAgent:isconnect: (4, 64)
2011-02-01 15:14:14 1 1 T=000:00:00:000, RC=2,RCS=0, RB=41,RBS=0, SC=2,SCS=0, SB=2060,SBS=0
2011-02-01 15:14:14 disconnect game, Name=Game254
2011-02-01 15:14:15 connect game, Name=
2011-02-01 15:14:15 connect game, Name=
2011-02-01 15:15:30 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)
2011-02-01 15:15:30 ::CreateCharacter 0 sdkjalkdja retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'vodkasexual',1,'sdkjalkdja', 2,0,3,0,0,2,5,0, 1,0,0, 8,9,10,12,12,14, 3261,4501,452, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}
2011-02-01 15:15:30 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2011-02-01 15:15:32 VerifyReConnect : The Connection has been lost, SQLHDBC=6b2db0
2011-02-01 15:15:32 SDatabasePool::Reconnect:: success...
2011-02-01 15:15:33 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)
2011-02-01 15:15:33 ::CreateCharacter 0 sdkjalkdja retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'vodkasexual',1,'sdkjalkdja', 2,0,3,0,0,2,5,0, 1,0,0, 8,9,10,12,12,14, 3261,4501,452, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}
2011-02-01 15:15:33 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2011-02-01 15:15:35 VerifyReConnect : The Connection has been lost, SQLHDBC=6c4208
2011-02-01 15:15:37 SDatabasePool::Reconnect:: success...
2011-02-01 15:15:37 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)
2011-02-01 15:15:37 ::CreateCharacter 0 sdkjalkdja retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'vodkasexual',1,'sdkjalkdja', 2,0,3,0,0,2,5,0, 1,0,0, 8,9,10,12,12,14, 3261,4501,452, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}
2011-02-01 15:15:37 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2011-02-01 15:15:42 VerifyReConnect : The Connection has been lost, SQLHDBC=6c4208
2011-02-01 15:15:42 SDatabasePool::Reconnect:: success...
2011-02-01 15:15:42 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)
2011-02-01 15:15:42 ::CreateCharacter 0 sdkjalkdja retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'vodkasexual',1,'sdkjalkdja', 2,0,3,0,0,2,5,0, 1,0,0, 8,9,10,12,12,14, 3261,4501,452, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}
2011-02-01 15:15:42 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2011-02-01 15:15:45 VerifyReConnect : The Connection has been lost, SQLHDBC=6b3590
2011-02-01 15:15:45 SDatabasePool::Reconnect:: success...
2011-02-01 15:15:45 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)
2011-02-01 15:15:45 ::CreateCharacter 0 sdkjalkdja retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'vodkasexual',1,'sdkjalkdja', 2,0,3,0,0,2,5,0, 1,0,0, 8,9,10,12,12,14, 3261,4501,452, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}
2011-02-01 15:15:45 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2011-02-01 15:15:47 VerifyReConnect : The Connection has been lost, SQLHDBC=6b3590
2011-02-01 15:15:47 SDatabasePool::Reconnect:: success...
2011-02-01 15:15:47 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)
2011-02-01 15:15:47 ::CreateCharacter 0 sdkjalkdja retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'vodkasexual',1,'sdkjalkdja', 2,0,3,0,0,2,5,0, 1,0,0, 8,9,10,12,12,14, 3261,4501,452, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}
2011-02-01 15:15:47 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2011-02-01 15:15:55 VerifyReConnect : The Connection has been lost, SQLHDBC=6b3590
2011-02-01 15:15:55 SDatabasePool::Reconnect:: success...
2011-02-01 15:16:15 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)
2011-02-01 15:16:15 ::CreateCharacter 0 ceemcmeedsa retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'vodkasexual',1,'ceemcmeedsa', 2,0,3,0,0,2,5,0, 1,0,0, 8,9,10,12,12,14, 3261,4501,452, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}
2011-02-01 15:16:15 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2011-02-01 15:16:18 VerifyReConnect : The Connection has been lost, SQLHDBC=6b3590
2011-02-01 15:16:18 SDatabasePool::Reconnect:: success...
2011-02-01 15:16:31 3 1 SERVICE_CONTROL_STOP
2011-02-01 15:16:42 1 1 SAgent:isconnect: (4, 64)
2011-02-01 15:16:42 1 1 T=000:02:00:000, RC=47,RCS=0, RB=2720,RBS=18, SC=81,SCS=0, SB=28479,SBS=193
2011-02-01 15:16:42 disconnect game, Name=Game01
2011-02-01 15:16:42 1 1 SAgent:isconnect: (4, 64)
2011-02-01 15:16:42 1 1 T=000:02:00:000, RC=1,RCS=0, RB=37,RBS=0, SC=29,SCS=0, SB=47363,SBS=322
2011-02-01 15:16:42 disconnect game, Name=Game01
2011-02-01 15:16:42 save market... wait plz...
2011-02-01 15:16:42 save all... wait plz... enter /uc
2011-02-01 15:16:43 PS_DBAGENT__system log end (DBAgent01)
2011-02-01 15:16:43 3 1 SService::ServiceCtrlDispatcher(): service shutdown
How do I resolve this problem. Waiting for your help.
Thanks