DatabaseServer.exe crashes.

SchizophreniaRakii · 08/20/2011, 05:36

DatabaseServer.exe crashes every 7-15minutes.

CQuery-LogFile_20110819.txt_20110819.txt

Code:

2011/08/19	13:41:18
query:{call uspSavePocket( '01', '0022315', ?, ?, ?, ?, ?, ?, ?, ?, ?) }
SQLSTATE:40001 error:[Microsoft][SQL Native Client][SQL Server]Transaction (Process ID 135) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

error_20110819.txt

Code:

2011/ 8/19   21:42:00   CGuildHouseMng::DBLoadGuildHouse() : AddGuildHouse() Failed!!! [GuildId:000716]

2011/ 8/19   21:42:00   CGuildHouseMng::DBLoadGuildHouse() : AddGuildHouse() Failed!!! [GuildId:000461]

2011/ 8/19   22:54:52   TRANS : is not alive

2011/ 8/19   22:55:52   TRANS : is not alive

2011/ 8/19   22:56:52   TRANS : is not alive

2011/ 8/19   22:58:49   CGuildHouseMng::DBLoadGuildHouse() : AddGuildHouse() Failed!!! [GuildId:000716]

2011/ 8/19   22:58:49   CGuildHouseMng::DBLoadGuildHouse() : AddGuildHouse() Failed!!! [GuildId:000461]

2011/ 8/19   23:16:43   CDPSrvr::OnBuyItem : __PERIN_BUY_BUG -> [PlayerId:0013502(llTheBladerll)], [LastTick:5831192], [CurTick:5831192], [LastTryItem:26462], [Packet:0,11,99,26462]

2011/ 8/19   23:16:43   CDPSrvr::OnBuyItem : __PERIN_BUY_BUG -> [PlayerId:0013502(llTheBladerll)], [LastTick:5831192], [CurTick:5831208], [LastTryItem:26462], [Packet:0,11,99,26462]

2011/ 8/19   23:16:43   CDPSrvr::OnBuyItem : __PERIN_BUY_BUG -> [PlayerId:0013502(llTheBladerll)], [LastTick:5831192], [CurTick:5831208], [LastTryItem:26462], [Packet:0,11,99,26462]

error_20110819.log

Code:

2011/ 8/19 23:19:34
\Programming\Flyff\Official Source\Official Source\_Database\DbManagerLog.cpp, 1169:	uspLoggingTrade @pFlag=2, @pTradeID=1313821171, @pserverindex='01', @pidPlayer='0005278', @pItemIndex='22331', @pItemSerialNum=1026672713, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=95563911168
2011/ 8/19 23:19:34
\Programming\Flyff\Official Source\Official Source\_Database\DbManagerLog.cpp, 1169:	uspLoggingTrade @pFlag=2, @pTradeID=1313821171, @pserverindex='01', @pidPlayer='0005278', @pItemIndex='22330', @pItemSerialNum=493035011, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=61080165509599232
2011/ 8/19 23:19:39
SendItem::GetSendItem PlayerName = SolennHeussaff, Item_Count = 10 Qry = CHARACTER_STR 'S4',@im_idPlayer='0022098',@iserverindex='01',@iaccount='(null)',@im_szName='(null)',@iplayerslot=0,@idwWorldID=0,@im_dwIndex=0,@im_vPos_x=0.000000,@im_vPos_y=0.000000,@im_vPos_z=0.000000,@im_szCharacterKey='(null)',@im_dwSkinSet=0,@im_dwHairMesh=0,@im_dwHairColor=0,@im_dwHeadMesh=0,@im_dwSex=0,@im_vScale_x=0.000000,@im_dwMotion=0,@im_fAngle=0.000000,@im_nHitPoint=0,@im_nManaPoint=0,@im_nFatiguePoint=0,@im_dwRideItemIdx=0,@im_dwGold=0,@im_nJob=0,@im_pActMover='(null)',@im_nStr=0,@im_nSta=0,@im_nDex=0,@im_nInt=0,@im_nLevel=0,@im_nExp1=0,@im_nExp2=0,@im_aJobSkill='(null)',@im_aLicenseSkill='(null)',@im_aJobLv='(null)',@im_dwExpertLv=0,@im_idMarkingWorld=0,@im_vMarkingPos_x=0.000000,@im_vMarkingPos_y=0.000000,@im_vMarkingPos_z=0.000000,@im_nRemainGP=0,@im_nRemainLP=0,@im_nFlightLv=0,@im_nFxp=0,@im_nTxp=0,@im_lpQuestCntArray='(null)',@im_chAuthority='F',@im_dwMode=0,@im_idparty=0,@im_idMuerderer=0,@im_nFame=0,@im_nDeathExp=0,@im_nDeathLevel=0,@im_dwFlyTime=0,@im_nMessengerState=0,@iTotalPlayTime=0,@im_Card='(null)',@im_Index_Card='(null)',@im_ObjIndex_Card='(null)',@im_Cube='(null)',@im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)',@im_Inventory='(null)',@im_apIndex='(null)',@im_adwEquipment='(null)',@im_dwObjIndex='(null)',@im_aSlotApplet='(null)',@im_aSlotItem='(null)',@im_aSlotQueue='(null)',@im_SkillBar=0,@im_Bank='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex_Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tmAccFuel=0,@im_dwSMTime='(null)',@iSkillInfluence='(null)',@im_aCompleteQuest='(null)',@im_extInventory='(null)',@im_InventoryPiercing='(null)',@im_extBank='(null)',@im_BankPiercing ='(null)',@im_dwReturnWorldID=0,@im_vReturnPos_x=0.000000,@im_vReturnPos_y=0.000000,@im_vReturnPos_z=0.000000,@im_nPKValue=0,@im_dwPKPropensity=0,@im_dwPKExp=0,@im_nAngelExp=0,@im_nAngelLevel=0,@iszInventoryPet='(null)',@iszBankPet='(null)', @im_dwPetId=0,@im_nExpLog=0, @im_nAngelExpLog=0,@im_nCoupon=0,@im_nHonor=-1,@im_nLayer=0,@im_nCampusPoint=0,@im_idCampus=0,@im_aCheckedQuest='(null)'

~~Slepnix~~ · 08/20/2011, 10:10

ini is your database server in the script folder?

SchizophreniaRakii · 08/20/2011, 17:53

Script Folder Ini's Paths are correct. If that was wrong i think the databaseserver won't open. But it will open for a time then in 7-10 Minutes it will just close. If i'm running it as administrator. In 7-10 Minutes It will stopped working.

Hi EPVP!