Errors :(

[macboyem07]

i observing my server and after 24hrs my server got crash

how to fix this :'(
Error logs:

 Spoiler

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.

 Spoiler

2014/ 8/ 7 20:10:41
OnQueryDestroyPlayer - idPlayer:133 GetPlayer return NULL.

 Spoiler

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

[xTwiLightx]

None of those errors indicate the reason for your crashes.

Try to debug your server (I guess WorldServer?) with Visual Studio while it is running, this will give best results.

Btw, you should create indexes in your database to prevent deadlocks.
You should find scripts here in the Release section.

[macboyem07]

thanks for info sir.. but i dont know how to debug xD .. but i try to click the debug to my VS this is the result sir

 Spoiler

'7-WorldServer.exe': Loaded 'C:\Users\acer\Desktop\FlyffTestFiles\GrandFlyffv1 9~\Grand source\Output\7-WorldServer.exe', Symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\ntdll.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\mscoree.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\kernel32.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\KernelBase.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\winmm.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\msvcrt.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\user32.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\gdi32.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\lpk.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\usp10.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\ws2_32.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\rpcrt4.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\nsi.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\advapi32.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\sechost.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\oleaut32.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\ole32.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\winsxs\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.7601.18201_none_ec8 0f00e8593ece5\comctl32.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\oleacc.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\winspool.drv', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\version.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\apphelp.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\AppPatch\AcLayers.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\sspicli.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\shell32.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\shlwapi.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\userenv.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\profapi.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\mpr.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\imm32.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\msctf.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\Microsoft.NET\Framework\v4.0.30319\msc oreei.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\Microsoft.NET\Framework\v1.1.4322\fusi on.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\Microsoft.NET\Framework\v1.1.4322\msvc r71.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\Microsoft.NET\Framework\v1.1.4322\msco rwks.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\Microsoft.NET\Framework\v1.1.4322\msco rlib.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\assembly\NativeImages1_v1.1.4322\mscor lib\1.0.5000.0__b77a5c561934e089_4c5ce61c\mscorlib .dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\Microsoft.NET\Framework\v1.1.4322\dias ymreader.dll', No symbols loaded.
'DefaultDomain': Loaded 'c:\windows\microsoft.net\framework\v1.1.4322\msco rlib.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\Microsoft.NET\Framework\v1.1.4322\msco rsn.dll', No symbols loaded.
'7-WorldServer': Loaded 'c:\Users\acer\Desktop\FlyffTestFiles\GrandFlyffv1 9~\Grand source\Output\7-WorldServer.exe', Symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\Microsoft.NET\Framework\v1.1.4322\msco rjit.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\cryptbase.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\clbcatq.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Program Files\Internet Download Manager\idmmkb.dll', No symbols loaded.
The thread 'Win32 Thread' (0x1588) has exited with code 0 (0x0).
The program '[6560] 7-WorldServer.exe' has exited with code 0 (0x0).
The program '[6560] 7-WorldServer.exe: Native' has exited with code 0 (0x0).

how to fix this sir? thanks in advance

[Drabur]

Originally Posted by macboyem07

thanks for info sir.. but i dont know how to debug xD .. but i try to click the debug to my VS this is the result sir

 Spoiler

'7-WorldServer.exe': Loaded 'C:\Users\acer\Desktop\FlyffTestFiles\GrandFlyffv1 9~\Grand source\Output\7-WorldServer.exe', Symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\ntdll.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\mscoree.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\kernel32.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\KernelBase.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\winmm.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\msvcrt.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\user32.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\gdi32.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\lpk.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\usp10.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\ws2_32.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\rpcrt4.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\nsi.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\advapi32.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\sechost.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\oleaut32.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\ole32.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\winsxs\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.7601.18201_none_ec8 0f00e8593ece5\comctl32.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\oleacc.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\winspool.drv', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\version.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\apphelp.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\AppPatch\AcLayers.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\sspicli.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\shell32.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\shlwapi.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\userenv.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\profapi.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\mpr.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\imm32.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\msctf.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\Microsoft.NET\Framework\v4.0.30319\msc oreei.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\Microsoft.NET\Framework\v1.1.4322\fusi on.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\Microsoft.NET\Framework\v1.1.4322\msvc r71.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\Microsoft.NET\Framework\v1.1.4322\msco rwks.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\Microsoft.NET\Framework\v1.1.4322\msco rlib.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\assembly\NativeImages1_v1.1.4322\mscor lib\1.0.5000.0__b77a5c561934e089_4c5ce61c\mscorlib .dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\Microsoft.NET\Framework\v1.1.4322\dias ymreader.dll', No symbols loaded.
'DefaultDomain': Loaded 'c:\windows\microsoft.net\framework\v1.1.4322\msco rlib.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\Microsoft.NET\Framework\v1.1.4322\msco rsn.dll', No symbols loaded.
'7-WorldServer': Loaded 'c:\Users\acer\Desktop\FlyffTestFiles\GrandFlyffv1 9~\Grand source\Output\7-WorldServer.exe', Symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\Microsoft.NET\Framework\v1.1.4322\msco rjit.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\cryptbase.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Windows\System32\clbcatq.dll', No symbols loaded.
'7-WorldServer.exe': Loaded 'C:\Program Files\Internet Download Manager\idmmkb.dll', No symbols loaded.
The thread 'Win32 Thread' (0x1588) has exited with code 0 (0x0).
The program '[6560] 7-WorldServer.exe' has exited with code 0 (0x0).
The program '[6560] 7-WorldServer.exe: Native' has exited with code 0 (0x0).

how to fix this sir? thanks in advance

this are just a few information about included library and a exit code in the end. Look for the TuT how debug flyff.

[macboyem07]

Originally Posted by Drabur

this are just a few information about included library and a exit code in the end. Look for the TuT how debug flyff.

i cant see TuT to how debug flyff. hoho ..can you give me links boss?