Buffer overflow and Runtime (WS)

01/28/2013 22:48 WinterWave#1
Hello,

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

Quote:
[Only registered and activated users can see links. Click Here To Register...]
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 :

Quote:
[Only registered and activated users can see links. Click Here To Register...]
I have no special error, only some query error :

Quote:
Error Full IdPlayer = 2383, PlayerName = XXX, ItemName : XXXX <= Useless
Quote:
2013/ 1/28 22:39:13 Invalid Equipment Removed : XXXX <= Useless
Quote:
RemoveUser(): dpid not found <= Useless


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.
01/29/2013 09:29 ArakiLP#2
DU hast zu wenig Arbeitsspeicher (RAM)
01/29/2013 15:45 Mognakor#3
... Und ihr beide antwortet auf einen englischen Thread in Deutsch :D


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 ^^)
01/29/2013 18:56 WinterWave#4
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.

:)
01/29/2013 22:11 SourceShop#5
:o maybe the source is bug
01/29/2013 22:13 WinterWave#6
Quote:
maybe the source is bug
What a council, seriously. xD
01/31/2013 11:00 xMootie#7
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...
01/31/2013 11:20 WinterWave#8
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. ><
02/01/2013 02:53 xMootie#9
Quote:
Originally Posted by WinterWave View Post
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 piss 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).
02/01/2013 12:42 WinterWave#10
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..