Buffer overflow and Runtime (WS)

[WinterWave]

Hello,

For about two weeks, I have a big problem, i have a buffer overflow (every 2/3 minuts) :

The RAM goes up to 11/12 go and then gradually decreases to the normally ram used by worldserver (4/5 go).

And every 3/4 hours, i have a runtime error (worldserver side), only when i have 150/200 player, in the night with 50 player i don't have this problem :

I have no special error, only some query error :

Error Full IdPlayer = 2383, PlayerName = XXX, ItemName : XXXX <= Useless

2013/ 1/28 22:39:13 Invalid Equipment Removed : XXXX <= Useless

RemoveUser(): dpid not found <= Useless

 Spoiler

Full of that (200ko/days):

query:uspLoggingTrade @pFlag=2, @pTradeID=1359300995, @pserverindex='01', @pidPlayer='0001647', @pItemIndex='40108', @pItemSerialNum=-1374214846, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=13874482293257054 72
SQLSTATE:01000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.

 Spoiler

Full of that (200ko/days):

query:LOG_ITEM_STR @im_szName='XXXX',@iserverindex='01',@im_GetszName ='XXXX',@idwWorldID=1,@im_dwGold=1347147860,@im_nR emainGold=1347147860,@iItem_UniqueNo=594112116,@iI tem_Name='70174',@iItem_durability=0,@im_nAbilityO ption=0,@Im_GetdwGold=27457276,@iItem_count=1,@iSt ate='T',@im_nSlot0=100,@im_nSlot1=100,@im_bItemRes ist=0,@im_nResistAbilityOption=0,@im_bCharged=1,@i m_dwKeepTime=0,@im_nRandomOptItemId=0,@inPiercedSi ze=0,@iadwItemId0=0,@iadwItemId1=0,@iadwItemId2=0, @iadwItemId3=0,@iadwItemId4=0,@iMaxDurability=0,@i nPetKind=0,@inPetLevel=0,@idwPetExp=0,@iwPetEnergy =0,@iwPetLife=0,@inPetAL_D=0,@inPetAL_C=0,@inPetAL _B=0,@inPetAL_A=0,@inPetAL_S=0,@iadwItemId5=0,@iad wItemId6=0,@iadwItemId7=0,@iadwItemId8=0,@iadwItem Id9=0,@inUMPiercedSize=0,@iadwUMItemId0=0,@iadwUMI temId1=0,@iadwUMItemId2=0,@iadwUMItemId3=0,@iadwUM ItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Server Native Client 10.0]Invalid cursor state

 Spoiler

And when i have uspLoggingtrade error above, i have that :

Program\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1359409546, @pserverindex='01', @pidPlayer='0002198', @pItemIndex='21040', @pItemSerialNum=418000518, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=2507455863808

I don't have made specially update except resource BASIC edit.

Help me please, this problem is so hardcore, i have see log etc but nothing is wrong.

Winter,
Cordially.

[ArakiLP]

DU hast zu wenig Arbeitsspeicher (RAM)

[Mognakor]

... Und ihr beide antwortet auf einen englischen Thread in Deutsch


Try checking the MSSQL-Server-Logs for further Data. They should be located in a path similiar to this one "Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log"

If you wanna make sure you got the right ones, check if the directory "...\MSSQL\Data\" contains files named ACCOUNT_DBF etc.

P.S: You can open the relevent files with Notepad++ or Editor. The newest one is allways named "ERRORLOG.1" (even if no errors occured ^^)

[WinterWave]

Hello,

Thanks for reply.

@Rolex My root have 24go, if I want i can have 500 players on it with no problem.

@Mognakor I have see the log and nothing special appears, and i have migrate my DB on a second SSD disk, and the mdf etc are here, and no problem with that.

[SourceShop]

maybe the source is bug

[WinterWave]

maybe the source is bug

What a council, seriously. xD

[xMootie]

These aren't exactly difficult problems... If you have 150+ players on s1, you should either have programming skills to fix it, or money to pay someone to fix it for you...

[WinterWave]

I don't want to pay someone to fix a problem, i have search in logging, source, res, and i find nothing.

I'm not Hells. ><

[xMootie]

Originally Posted by WinterWave

I don't want to pay someone to fix a problem, i have search in logging, source, res, and i find nothing.

I'm not Hells. ><

There's nothing wrong with a good administrator that hires developer(s) to work on the source. It's usually better to do this as it distributes the work load, giving the administrator more time to promote the server, manage staff, and check security.

It's always good for an administrator to have programming knowledge and experience, but it's not necessary if you have an experienced and trustworthy developer to work on the source code.

- slightly offtopic -

I don't like Hells because of the following reasons:

1. He's extremely immature, he even posts immature statements on his own server.

2. He doesn't contribute anything to his server. He's a very bad administrator and doesn't develop anything. If he was a good administrator, I wouldn't have any problem with him not developing anything.

3. He only runs a server to make money to buy things for himself(cars, hookers, etc). He would gladly **** off the players at InsanityFlyff if it meant he would make more money to spend on himself.

4. He scams the developers that work for him often. I've known three different developers that have told me that Hells scammed them by not paying for the work they gave him(when he promised he would).

[WinterWave]

My server is not here for money, all of money is reinvested ONLY in the server.

I think it's better for an administrator to do all thing (dev, web, and other thing he can do) on this server rather than buy service etc..