i observing my server and after 24hrs my server got crash
how to fix this :'( :handsdown:
Error logs:
how to fix this :'( :handsdown:
Error logs:
2014/08/07 16:56:11
query:uspLoggingTrade @pFlag=2, @pTradeID=1407401761, @pserverindex='01', @pidPlayer='0000118', @pItemIndex='22298', @pItemSerialNum=95805206, @pItemCnt=1, @pAbilityOpt=10, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=70733274624
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2014/08/07 16:56:11
query:uspLoggingTrade @pFlag=2, @pTradeID=1407401761, @pserverindex='01', @pidPlayer='0000118', @pItemIndex='22298', @pItemSerialNum=95805206, @pItemCnt=1, @pAbilityOpt=10, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=70733274624
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2014/08/07 16:56:11
query:LOG_ITEM_STR @im_szName='l420l',@iserverindex='01',@im_GetszNam e='HobbyxD',@idwWorldID=1,@im_dwGold=1979483647,@i m_nRemainGold=1979483647,@iItem_UniqueNo=211748400 0,@iItem_Name='22299',@iItem_durability=9000000,@i m_nAbilityOption=10,@Im_GetdwGold=1100483647,@iIte m_count=1,@iState='T',@im_nSlot0=100,@im_nSlot1=10 0,@im_bItemResist=0,@im_nResistAbilityOption=0,@im _bCharged=0,@im_dwKeepTime=0,@im_nRandomOptItemId= 137794688512,@inPiercedSize=4,@iadwItemId0=3218,@i adwItemId1=3218,@iadwItemId2=3218,@iadwItemId3=321 8,@iadwItemId4=0,@iMaxDurability=0,@inPetKind=0,@i nPetLevel=0,@idwPetExp=0,@iwPetEnergy=0,@iwPetLife =0,@inPetAL_D=0,@inPetAL_C=0,@inPetAL_B=0,@inPetAL _A=0,@inPetAL_S=0,@iadwItemId5=0,@iadwItemId6=0,@i adwItemId7=0,@iadwItemId8=0,@iadwItemId9=0,@inUMPi ercedSize=0,@iadwUMItemId0=0,@iadwUMItemId1=0,@iad wUMItemId2=0,@iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
2014/08/07 16:56:11
query:uspLoggingTrade @pFlag=2, @pTradeID=1407401761, @pserverindex='01', @pidPlayer='0000118', @pItemIndex='22299', @pItemSerialNum=2117484000, @pItemCnt=1, @pAbilityOpt=10, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=137794688512
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2014/08/07 16:56:11
query:uspLoggingTrade @pFlag=2, @pTradeID=1407401761, @pserverindex='01', @pidPlayer='0000118', @pItemIndex='22299', @pItemSerialNum=2117484000, @pItemCnt=1, @pAbilityOpt=10, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=137794688512
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2014/08/07 16:56:11
query:LOG_ITEM_STR @im_szName='l420l',@iserverindex='01',@im_GetszNam e='HobbyxD',@idwWorldID=1,@im_dwGold=1979483647,@i m_nRemainGold=1979483647,@iItem_UniqueNo=194350392 9,@iItem_Name='22301',@iItem_durability=4500000,@i m_nAbilityOption=10,@Im_GetdwGold=1100483647,@iIte m_count=1,@iState='T',@im_nSlot0=100,@im_nSlot1=10 0,@im_bItemResist=0,@im_nResistAbilityOption=0,@im _bCharged=0,@im_dwKeepTime=0,@im_nRandomOptItemId= 1387287156442273280,@inPiercedSize=0,@iadwItemId0= 0,@iadwItemId1=0,@iadwItemId2=0,@iadwItemId3=0,@ia dwItemId4=0,@iMaxDurability=0,@inPetKind=0,@inPetL evel=0,@idwPetExp=0,@iwPetEnergy=0,@iwPetLife=0,@i nPetAL_D=0,@inPetAL_C=0,@inPetAL_B=0,@inPetAL_A=0, @inPetAL_S=0,@iadwItemId5=0,@iadwItemId6=0,@iadwIt emId7=0,@iadwItemId8=0,@iadwItemId9=0,@inUMPierced Size=0,@iadwUMItemId0=0,@iadwUMItemId1=0,@iadwUMIt emId2=0,@iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
2014/08/07 16:56:11
query:uspLoggingTrade @pFlag=2, @pTradeID=1407401761, @pserverindex='01', @pidPlayer='0000118', @pItemIndex='22301', @pItemSerialNum=1943503929, @pItemCnt=1, @pAbilityOpt=10, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=13872871564422732 80
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2014/08/07 16:56:11
query:uspLoggingTrade @pFlag=2, @pTradeID=1407401761, @pserverindex='01', @pidPlayer='0000118', @pItemIndex='22301', @pItemSerialNum=1943503929, @pItemCnt=1, @pAbilityOpt=10, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=13872871564422732 80
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2014/08/07 16:56:11
query:LOG_ITEM_STR @im_szName='l420l',@iserverindex='01',@im_GetszNam e='HobbyxD',@idwWorldID=1,@im_dwGold=1979483647,@i m_nRemainGold=1979483647,@iItem_UniqueNo=121837687 4,@iItem_Name='22300',@iItem_durability=5850000,@i m_nAbilityOption=10,@Im_GetdwGold=1100483647,@iIte m_count=1,@iState='T',@im_nSlot0=100,@im_nSlot1=10 0,@im_bItemResist=0,@im_nResistAbilityOption=0,@im _bCharged=0,@im_dwKeepTime=0,@im_nRandomOptItemId= 162657970987230208,@inPiercedSize=0,@iadwItemId0=0 ,@iadwItemId1=0,@iadwItemId2=0,@iadwItemId3=0,@iad wItemId4=0,@iMaxDurability=0,@inPetKind=0,@inPetLe vel=0,@idwPetExp=0,@iwPetEnergy=0,@iwPetLife=0,@in PetAL_D=0,@inPetAL_C=0,@inPetAL_B=0,@inPetAL_A=0,@ inPetAL_S=0,@iadwItemId5=0,@iadwItemId6=0,@iadwIte mId7=0,@iadwItemId8=0,@iadwItemId9=0,@inUMPiercedS ize=0,@iadwUMItemId0=0,@iadwUMItemId1=0,@iadwUMIte mId2=0,@iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
2014/08/07 16:56:11
query:uspLoggingTrade @pFlag=2, @pTradeID=1407401761, @pserverindex='01', @pidPlayer='0000118', @pItemIndex='22300', @pItemSerialNum=1218376874, @pItemCnt=1, @pAbilityOpt=10, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=16265797098723020 8
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2014/08/07 16:56:11
query:uspLoggingTrade @pFlag=2, @pTradeID=1407401761, @pserverindex='01', @pidPlayer='0000118', @pItemIndex='22300', @pItemSerialNum=1218376874, @pItemCnt=1, @pAbilityOpt=10, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=16265797098723020 8
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2014/08/07 16:56:11
query:LOG_ITEM_STR @im_szName='GROUND',@iserverindex='01',@im_GetszNa me='Gray',@idwWorldID=1,@im_dwGold=2059997647,@im_ nRemainGold=2147483647,@iItem_UniqueNo=0,@iItem_Na me='12',@iItem_durability=0,@im_nAbilityOption=0,@ Im_GetdwGold=0,@iItem_count=87486000,@iState='R',@ im_nSlot0=100,@im_nSlot1=100,@im_bItemResist=0,@im _nResistAbilityOption=0,@im_bCharged=0,@im_dwKeepT ime=0,@im_nRandomOptItemId=0,@inPiercedSize=0,@iad wItemId0=0,@iadwItemId1=0,@iadwItemId2=0,@iadwItem Id3=0,@iadwItemId4=0,@iMaxDurability=0,@inPetKind= 0,@inPetLevel=0,@idwPetExp=0,@iwPetEnergy=0,@iwPet Life=0,@inPetAL_D=0,@inPetAL_C=0,@inPetAL_B=0,@inP etAL_A=0,@inPetAL_S=0,@iadwItemId5=0,@iadwItemId6= 0,@iadwItemId7=0,@iadwItemId8=0,@iadwItemId9=0,@in UMPiercedSize=0,@iadwUMItemId0=0,@iadwUMItemId1=0, @iadwUMItemId2=0,@iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
2014/08/07 20:19:28
query:{call uspSavePocket( '01', '0000022', ?, ?, ?, ?, ?, ?, ?, ?, ?) }
SQLSTATE:40001 error:[Microsoft][SQL Native Client][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.
query:uspLoggingTrade @pFlag=2, @pTradeID=1407401761, @pserverindex='01', @pidPlayer='0000118', @pItemIndex='22298', @pItemSerialNum=95805206, @pItemCnt=1, @pAbilityOpt=10, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=70733274624
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2014/08/07 16:56:11
query:uspLoggingTrade @pFlag=2, @pTradeID=1407401761, @pserverindex='01', @pidPlayer='0000118', @pItemIndex='22298', @pItemSerialNum=95805206, @pItemCnt=1, @pAbilityOpt=10, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=70733274624
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2014/08/07 16:56:11
query:LOG_ITEM_STR @im_szName='l420l',@iserverindex='01',@im_GetszNam e='HobbyxD',@idwWorldID=1,@im_dwGold=1979483647,@i m_nRemainGold=1979483647,@iItem_UniqueNo=211748400 0,@iItem_Name='22299',@iItem_durability=9000000,@i m_nAbilityOption=10,@Im_GetdwGold=1100483647,@iIte m_count=1,@iState='T',@im_nSlot0=100,@im_nSlot1=10 0,@im_bItemResist=0,@im_nResistAbilityOption=0,@im _bCharged=0,@im_dwKeepTime=0,@im_nRandomOptItemId= 137794688512,@inPiercedSize=4,@iadwItemId0=3218,@i adwItemId1=3218,@iadwItemId2=3218,@iadwItemId3=321 8,@iadwItemId4=0,@iMaxDurability=0,@inPetKind=0,@i nPetLevel=0,@idwPetExp=0,@iwPetEnergy=0,@iwPetLife =0,@inPetAL_D=0,@inPetAL_C=0,@inPetAL_B=0,@inPetAL _A=0,@inPetAL_S=0,@iadwItemId5=0,@iadwItemId6=0,@i adwItemId7=0,@iadwItemId8=0,@iadwItemId9=0,@inUMPi ercedSize=0,@iadwUMItemId0=0,@iadwUMItemId1=0,@iad wUMItemId2=0,@iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
2014/08/07 16:56:11
query:uspLoggingTrade @pFlag=2, @pTradeID=1407401761, @pserverindex='01', @pidPlayer='0000118', @pItemIndex='22299', @pItemSerialNum=2117484000, @pItemCnt=1, @pAbilityOpt=10, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=137794688512
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2014/08/07 16:56:11
query:uspLoggingTrade @pFlag=2, @pTradeID=1407401761, @pserverindex='01', @pidPlayer='0000118', @pItemIndex='22299', @pItemSerialNum=2117484000, @pItemCnt=1, @pAbilityOpt=10, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=137794688512
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2014/08/07 16:56:11
query:LOG_ITEM_STR @im_szName='l420l',@iserverindex='01',@im_GetszNam e='HobbyxD',@idwWorldID=1,@im_dwGold=1979483647,@i m_nRemainGold=1979483647,@iItem_UniqueNo=194350392 9,@iItem_Name='22301',@iItem_durability=4500000,@i m_nAbilityOption=10,@Im_GetdwGold=1100483647,@iIte m_count=1,@iState='T',@im_nSlot0=100,@im_nSlot1=10 0,@im_bItemResist=0,@im_nResistAbilityOption=0,@im _bCharged=0,@im_dwKeepTime=0,@im_nRandomOptItemId= 1387287156442273280,@inPiercedSize=0,@iadwItemId0= 0,@iadwItemId1=0,@iadwItemId2=0,@iadwItemId3=0,@ia dwItemId4=0,@iMaxDurability=0,@inPetKind=0,@inPetL evel=0,@idwPetExp=0,@iwPetEnergy=0,@iwPetLife=0,@i nPetAL_D=0,@inPetAL_C=0,@inPetAL_B=0,@inPetAL_A=0, @inPetAL_S=0,@iadwItemId5=0,@iadwItemId6=0,@iadwIt emId7=0,@iadwItemId8=0,@iadwItemId9=0,@inUMPierced Size=0,@iadwUMItemId0=0,@iadwUMItemId1=0,@iadwUMIt emId2=0,@iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
2014/08/07 16:56:11
query:uspLoggingTrade @pFlag=2, @pTradeID=1407401761, @pserverindex='01', @pidPlayer='0000118', @pItemIndex='22301', @pItemSerialNum=1943503929, @pItemCnt=1, @pAbilityOpt=10, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=13872871564422732 80
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2014/08/07 16:56:11
query:uspLoggingTrade @pFlag=2, @pTradeID=1407401761, @pserverindex='01', @pidPlayer='0000118', @pItemIndex='22301', @pItemSerialNum=1943503929, @pItemCnt=1, @pAbilityOpt=10, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=13872871564422732 80
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2014/08/07 16:56:11
query:LOG_ITEM_STR @im_szName='l420l',@iserverindex='01',@im_GetszNam e='HobbyxD',@idwWorldID=1,@im_dwGold=1979483647,@i m_nRemainGold=1979483647,@iItem_UniqueNo=121837687 4,@iItem_Name='22300',@iItem_durability=5850000,@i m_nAbilityOption=10,@Im_GetdwGold=1100483647,@iIte m_count=1,@iState='T',@im_nSlot0=100,@im_nSlot1=10 0,@im_bItemResist=0,@im_nResistAbilityOption=0,@im _bCharged=0,@im_dwKeepTime=0,@im_nRandomOptItemId= 162657970987230208,@inPiercedSize=0,@iadwItemId0=0 ,@iadwItemId1=0,@iadwItemId2=0,@iadwItemId3=0,@iad wItemId4=0,@iMaxDurability=0,@inPetKind=0,@inPetLe vel=0,@idwPetExp=0,@iwPetEnergy=0,@iwPetLife=0,@in PetAL_D=0,@inPetAL_C=0,@inPetAL_B=0,@inPetAL_A=0,@ inPetAL_S=0,@iadwItemId5=0,@iadwItemId6=0,@iadwIte mId7=0,@iadwItemId8=0,@iadwItemId9=0,@inUMPiercedS ize=0,@iadwUMItemId0=0,@iadwUMItemId1=0,@iadwUMIte mId2=0,@iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
2014/08/07 16:56:11
query:uspLoggingTrade @pFlag=2, @pTradeID=1407401761, @pserverindex='01', @pidPlayer='0000118', @pItemIndex='22300', @pItemSerialNum=1218376874, @pItemCnt=1, @pAbilityOpt=10, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=16265797098723020 8
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2014/08/07 16:56:11
query:uspLoggingTrade @pFlag=2, @pTradeID=1407401761, @pserverindex='01', @pidPlayer='0000118', @pItemIndex='22300', @pItemSerialNum=1218376874, @pItemCnt=1, @pAbilityOpt=10, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=16265797098723020 8
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2014/08/07 16:56:11
query:LOG_ITEM_STR @im_szName='GROUND',@iserverindex='01',@im_GetszNa me='Gray',@idwWorldID=1,@im_dwGold=2059997647,@im_ nRemainGold=2147483647,@iItem_UniqueNo=0,@iItem_Na me='12',@iItem_durability=0,@im_nAbilityOption=0,@ Im_GetdwGold=0,@iItem_count=87486000,@iState='R',@ im_nSlot0=100,@im_nSlot1=100,@im_bItemResist=0,@im _nResistAbilityOption=0,@im_bCharged=0,@im_dwKeepT ime=0,@im_nRandomOptItemId=0,@inPiercedSize=0,@iad wItemId0=0,@iadwItemId1=0,@iadwItemId2=0,@iadwItem Id3=0,@iadwItemId4=0,@iMaxDurability=0,@inPetKind= 0,@inPetLevel=0,@idwPetExp=0,@iwPetEnergy=0,@iwPet Life=0,@inPetAL_D=0,@inPetAL_C=0,@inPetAL_B=0,@inP etAL_A=0,@inPetAL_S=0,@iadwItemId5=0,@iadwItemId6= 0,@iadwItemId7=0,@iadwItemId8=0,@iadwItemId9=0,@in UMPiercedSize=0,@iadwUMItemId0=0,@iadwUMItemId1=0, @iadwUMItemId2=0,@iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
2014/08/07 20:19:28
query:{call uspSavePocket( '01', '0000022', ?, ?, ?, ?, ?, ?, ?, ?, ?) }
SQLSTATE:40001 error:[Microsoft][SQL Native Client][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.
2014/ 8/ 7 20:10:41
OnQueryDestroyPlayer - idPlayer:133 GetPlayer return NULL.
OnQueryDestroyPlayer - idPlayer:133 GetPlayer return NULL.
2014/ 8/ 7 20:17:01
OnAddPlayer(): pPlayer is NULL, 12
2014/ 8/ 7 20:17:01
OnAddPlayer(): pPlayer is NULL, 22
2014/ 8/ 7 21:10:41
^OnGetPlayerList(), macboy
2014/ 8/ 7 21:10:41
OnFail(): ERROR_FLYFF_ACCOUNT, macboy
2014/ 8/ 7 21:10:41
RemoveUser(): Illegal
OnAddPlayer(): pPlayer is NULL, 12
2014/ 8/ 7 20:17:01
OnAddPlayer(): pPlayer is NULL, 22
2014/ 8/ 7 21:10:41
^OnGetPlayerList(), macboy
2014/ 8/ 7 21:10:41
OnFail(): ERROR_FLYFF_ACCOUNT, macboy
2014/ 8/ 7 21:10:41
RemoveUser(): Illegal
