Skip to forum content

You are not logged in. Please login or register.


forums.pvpgn.pro → [EN] Tech Support → Problem with "sqlist_check_timeout"

Pages 1

You must login or register to post a reply

RSS topic feed

Posts: 14

1 (edited by Feofilaktt 07.10.2017 02:57)

Topic: Problem with "sqlist_check_timeout"

It seems to be a flood of connections or something.

Has anyone ever had this problem?

https://forums.pvpgn.pro/uploads/images/2017/10/02/image.png

2

Re: Problem with "sqlist_check_timeout"

Haven't seen this before, Feofilaktt.


How often does it happen, any obvious patterns?

Owner of Slash Diablo & Diablo2.org (coming soon).

Also check out Slash's Character Armory!

3 (edited by Feofilaktt 07.10.2017 00:44)

Re: Problem with "sqlist_check_timeout"

It does not have a pattern.

The symptom of this "anomaly" is the blocking of port 6112 in the selection of chars..


https://forums.pvpgn.pro/uploads/images/2017/10/04/6113.jpg


for now I have solved the problem by reducing the time of empty sockets checking on the server

# How often the server will check queues for expired data
sq_checkinterval =

# How long will it take for a server to expire?
sq_timeout =

but I've seen this on other forums, it seems to be an attack with "ghost connections" (empty connections). They serve only to occupy all sockets available for connection on the server.

I think that's it..

Added: 04.10.2017 16:04

Our friend Harpywar could help us develop something in D2CS to avoid these "ghost connections."

Added: 04.10.2017 17:14

for now I have solved the problem by reducing the time of empty sockets checking on the server

don't work...

I will try to create a rule in iptables to limit the connections on the ports due.. return if it succees!

Added: 06.10.2017 09:48

for now I have solved the problem by reducing the time of empty sockets checking on the server

don't work...

I will try to create a rule in iptables to limit the connections on the ports due.. return if it succees!

dont work! sad

Added: 07.10.2017 10:54

I'm thinking it might be something with OS.

Some kernel errors appeared ... Immediately put here.

Could you help me HarpyWar?

4 (edited by Feofilaktt 14.11.2017 05:43)

Re: Problem with "sqlist_check_timeout"

Hello!

I bring a problem in my D2CS.

Apparently it's a flaw in D2CS in Ubuntu 14.04.5

There is apparently no pattern, the error that is thrown in the game is this:

https://forums.pvpgn.pro/uploads/images/2017/10/07/error_game.jpg

Players who are online on the server continue to play normally, only the players who want to connect have problems when selecting the character.

PS: I can only normalize by restarting the D2CS process


See Logs:

D2CS.LOG

sqlist_check_timeout: destroying expired server queue

https://forums.pvpgn.pro/uploads/images/2017/10/07/d2cs.png


BNETD.LOG

realm_deactive: realm XXXX is not activated

https://forums.pvpgn.pro/uploads/images/2017/10/07/bnetd.png


Kernel Panic

D2CS blocked for more than 120 seconds

https://forums.pvpgn.pro/uploads/images/2017/10/07/kernel_panic.jpg

5

Re: Problem with "sqlist_check_timeout"

bump hmm

6

Re: Problem with "sqlist_check_timeout"

have you tried to switch the distribution with something newer?
what is your pvpgn version?

7

Re: Problem with "sqlist_check_timeout"

hehpe wrote:

have you tried to switch the distribution with something newer?
what is your pvpgn version?

not yet...

latest version of Pvpgn

It seems that if you have a time limit or use.. every 2 days connected this fault occurs.

I'm going to start renaming D2CS every 24 hours to see if the problem goes away, if at all, let's know that it is related to some kind of failure/limit in OS.

8 (edited by hehpe 12.10.2017 18:28)

Re: Problem with "sqlist_check_timeout"

Feofilaktt wrote:
hehpe wrote:

have you tried to switch the distribution with something newer?
what is your pvpgn version?

not yet...

latest version of Pvpgn

It seems that if you have a time limit or use.. every 2 days connected this fault occurs.

I'm going to start renaming D2CS every 24 hours to see if the problem goes away, if at all, let's know that it is related to some kind of failure/limit in OS.

Try to compile older version of pvpgn (1.8.5,1.99-svn-577)
Are you sure it's not ports/firewall related?

9

Re: Problem with "sqlist_check_timeout"

hehpe wrote:

Try to compile older version of pvpgn (1.8.5,1.99-svn-577)
Are you sure it's not ports/firewall related?

If it were the rules of the firewall, why would it work to a certain extent?

I have a few IPtables rules and the problem started before adding the rules hmm

When I have a while I will try to use another version of PVPgn or another version of OS.

But I would like more options, to make the changes, I did not want to have to keep stopping the server to perform these maintenance: /

10

Re: Problem with "sqlist_check_timeout"

I have not yet had time to work on another version of PvPGN or install it on another OS.

but I did a shell script to restart the D2CS every 2 days.. It worked, the problem did not appear any more

when I have time, I'll change the version of PvPGN or OS to see what the real problem is..

Added: 20.10.2017 08:33

I'll soon be sharing the script done to restart D2CS automatically every other day...

11 (edited by Feofilaktt 14.11.2017 05:39)

Re: Problem with "sqlist_check_timeout"

What would be the most stable version to use on the Linux system?

The latest version "PvPGN 1.99.7.1-PRO"?

or

The "PvPGN v1.99-SVN" version?


I ask this question because I use the latest version of PvPGN in my OS Linux and I'm having problems with "sqlist".

This problem -> https://forums.pvpgn.pro/viewtopic.php?id=1842


It looks like it does not clean or refresh this data and when it reaches the 32,000 mark it hangs from D2CS.

I have to be rebooting the D2CS every 2 days due to the volume of players

If one day increase the volume of players, I will have to decrease the restart time to 1 days or less.


Tnks

12

Re: Problem with "sqlist_check_timeout"

bump

13

Re: Problem with "sqlist_check_timeout"

Attach full logs bnetd, d2cs, d2dbs, d2gs with maximum loglevel.

(I recommend use the latest pvpgn from Github)

Do not ask for support in PM.

14

Re: Problem with "sqlist_check_timeout"

HarpyWar wrote:

Attach full logs bnetd, d2cs, d2dbs, d2gs with maximum loglevel.

(I recommend use the latest pvpgn from Github)

It's all right! I'll try and return the result here.

Tks HarpyWar

Posts: 14

Pages 1

You must login or register to post a reply

Who now at forum

Currently view post: 0 guests, 0 registered users

forums.pvpgn.pro → [EN] Tech Support → Problem with "sqlist_check_timeout"



Generated in 0.118 seconds (90% PHP - 10% DB) with 22 queries