in der Hoffnung hier Rat zu finden, wende ich mich nun an euch.
Bei uns kommen Errors im Sekundentakt, jedoch crasht der Server nicht o.ä.
Jedoch ziehen diese extrem an der Performance:
Hier die jeweiligen Errors:
Quote:
2011/ 4/29 16:22:06
SavePlayer(Cisco) - Exec RETURN FALSE, ThreadID : 58376
2011/ 4/29 16:22:11
SavePlayer(BlizZz4rd) - Exec RETURN FALSE, ThreadID : 57524
2011/ 4/29 16:22:14
SavePlayer(St4rSh0t) - Exec RETURN FALSE, ThreadID : 58808
2011/ 4/29 16:22:15
SavePlayer(ASAL) - Exec RETURN FALSE, ThreadID : 58376
2011/ 4/29 16:22:15
SavePlayer(Chillahx3) - Exec RETURN FALSE, ThreadID : 59004
2011/ 4/29 16:22:15
SavePlayer(iRyanZz) - Exec RETURN FALSE, ThreadID : 58756
2011/ 4/29 16:22:16
SavePlayer(Traceur) - Exec RETURN FALSE, ThreadID : 59024
2011/ 4/29 16:22:23
SavePlayer(Takuto) - Exec RETURN FALSE, ThreadID : 58376
2011/ 4/29 16:22:29
SavePlayer(Tiphret) - Exec RETURN FALSE, ThreadID : 58376
2011/ 4/29 16:22:30
SavePlayer(IrukaBlade) - Exec RETURN FALSE, ThreadID : 59004
2011/ 4/29 16:22:38
SavePlayer(ErikIstStark) - Exec RETURN FALSE, ThreadID : 58756
2011/ 4/29 16:22:39
SavePlayer(Senaty) - Exec RETURN FALSE, ThreadID : 59024
2011/ 4/29 16:24:16
SavePlayer(xExitingx) - Exec RETURN FALSE, ThreadID : 59268
2011/ 4/29 16:24:21
SavePlayer(xDestruction) - Exec RETURN FALSE, ThreadID : 59004
2011/ 4/29 16:24:23
SavePlayer(Gamatzu) - Exec RETURN FALSE, ThreadID : 58808
2011/ 4/29 16:24:24
SavePlayer(ChibiHaruka) - Exec RETURN FALSE, ThreadID : 59024
2011/ 4/29 16:24:25
SavePlayer(MoneyGril) - Exec RETURN FALSE, ThreadID : 58808
2011/ 4/29 16:24:25
SavePlayer(Burton) - Exec RETURN FALSE, ThreadID : 59024
2011/ 4/29 16:24:26
SavePlayer(Hermes) - Exec RETURN FALSE, ThreadID : 57524
2011/ 4/29 16:24:26
SavePlayer(AnION) - Exec RETURN FALSE, ThreadID : 58376
2011/ 4/29 16:24:26
SavePlayer(Ep1cFa1L) - Exec RETURN FALSE, ThreadID : 58880
2011/ 4/29 16:24:26
SavePlayer(Invader) - Exec RETURN FALSE, ThreadID : 58756
2011/ 4/29 16:24:27
SavePlayer(DerRanger) - Exec RETURN FALSE, ThreadID : 58376
2011/ 4/29 16:24:28
SavePlayer(Bunnny) - Exec RETURN FALSE, ThreadID : 58880
2011/ 4/29 16:24:28
SavePlayer(Suizid) - Exec RETURN FALSE, ThreadID : 59024
2011/ 4/29 16:24:28
SavePlayer(MezzoMix) - Exec RETURN FALSE, ThreadID : 59268
Quote:
2011/ 4/29 16:26:51
\Users\Kurosaki\Desktop\Datas\Source\_Database\DbM anagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1304087230, @pserverindex='01', @pidPlayer='0007927', @pItemIndex='20162', @pItemSerialNum=1265517732, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=4284104963072
2011/ 4/29 16:26:59
\Users\Kurosaki\Desktop\Datas\Source\_Database\DbM anagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1304087231, @pserverindex='01', @pidPlayer='0004209', @pItemIndex='22346', @pItemSerialNum=1097824799, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=72084747264
Quote:
2011/ 4/29 18:26:28
\Users\Kurosaki\Desktop\Datas\Source\_Database\DbM anagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1304094395, @pserverindex='01', @pidPlayer='0006518', @pItemIndex='22393', @pItemSerialNum=180222732, @pItemCnt=1, @pAbilityOpt=1, @pItemResist=2, @pResistAbilityOpt=3,@pRandomOpt=756586387712
2011/ 4/29 18:26:56
\Users\Kurosaki\Desktop\Datas\Source\_Database\DbM anager.cpp, 8071 RANKING.RANKING_DBF.dbo.usp_guildbank_log_view 'S3','000299','01'
Quote:
2011/04/29 16:22:06
query:{call CHARACTER_STR('U1','0007975','01','',?,?,?,?,?,?,? ,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ,?,?,?,?, 0, 0, 0,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
SQLSTATE:40001 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]Transaction (Process ID 132) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Quote:
2011/04/29 16:22:34
query:{call ADD_BANK_STR('U1','0005444','01', ?, ?, ?, ?, ?, ?, ?)}
Quote:
2011/04/29 16:26:51
query:uspLoggingTrade @pFlag=2, @pTradeID=1304087230, @pserverindex='01', @pidPlayer='0007927', @pItemIndex='20162', @pItemSerialNum=1265517732, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=4284104963072
SQLSTATE:22003 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]Arithmetic overflow error converting expression to data type int.
2011/04/29 16:26:51
query:uspLoggingTrade @pFlag=2, @pTradeID=1304087230, @pserverindex='01', @pidPlayer='0007927', @pItemIndex='20162', @pItemSerialNum=1265517732, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=4284104963072
SQLSTATE:01000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
2011/04/29 16:26:51
query:LOG_ITEM_STR @im_szName='Xunriise',@iserverindex='01',@im_Getsz Name='Knolli',@idwWorldID=1,@im_dwGold=428700824,@ im_nRemainGold=328700824,@iItem_UniqueNo=0,@iItem_ Name='12',@iItem_durability=0,@im_nAbilityOption=0 ,@Im_GetdwGold=273257710,@iItem_count=100000000,@i State='T',@im_nSlot0=100,@im_nSlot1=100,@im_bItemR esist=0,@im_nResistAbilityOption=0,@im_bCharged=0, @im_dwKeepTime=0,@im_nRandomOptItemId=0,@inPierced Size=0,@iadwItemId0=0,@iadwItemId1=0,@iadwItemId2= 0,@iadwItemId3=0,@iadwItemId4=0,@iMaxDurability=0, @inPetKind=0,@inPetLevel=0,@idwPetExp=0,@iwPetEner gy=0,@iwPetLife=0,@inPetAL_D=0,@inPetAL_C=0,@inPet AL_B=0,@inPetAL_A=0,@inPetAL_S=0,@iadwItemId5=0,@i adwItemId6=0,@iadwItemId7=0,@iadwItemId8=0,@iadwIt emId9=0,@inUMPiercedSize=0,@iadwUMItemId0=0,@iadwU MItemId1=0,@iadwUMItemId2=0,@iadwUMItemId3=0,@iadw UMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Server Native Client 10.0]Invalid cursor state
Von diesen ganzen Errors existieren haufenweise mehr, aber will die jetzt nicht alle hier posten.
Woran kann das alles hier liegen?
Db haben wir von Cross benutzt.
Neue DBs nehmen geht nicht, da zuviele User schon vorhanden sind.
Ich hoffe ihr könnt mir helfen,
thx im vorraus
mfg
Kurosaki