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: 17

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

Diablo 2 Online

Itens - Armory - Market - Clans - Builds - Chat

2

Re: Problem with "sqlist_check_timeout"

Haven't seen this before, Feofilaktt.


How often does it happen, any obvious patterns?

Owner of SlashDiablo - One of the oldest and most well known Diablo II servers
Admin of Resurgence - Vanilla++ mod
Co-Founder of Hellforged - Diablo 09 built on 1.13 engine (current work in progress)
Founder of Diablo2.org - Dedicated Discord server for PvPGN/D2GS questions

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?

Diablo 2 Online

Itens - Armory - Market - Clans - Builds - Chat

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

Diablo 2 Online

Itens - Armory - Market - Clans - Builds - Chat

5

Re: Problem with "sqlist_check_timeout"

bump hmm

Diablo 2 Online

Itens - Armory - Market - Clans - Builds - Chat

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.

Diablo 2 Online

Itens - Armory - Market - Clans - Builds - Chat

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: /

Diablo 2 Online

Itens - Armory - Market - Clans - Builds - Chat

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...

Diablo 2 Online

Itens - Armory - Market - Clans - Builds - Chat

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

Diablo 2 Online

Itens - Armory - Market - Clans - Builds - Chat

12

Re: Problem with "sqlist_check_timeout"

bump

Diablo 2 Online

Itens - Armory - Market - Clans - Builds - Chat

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

Diablo 2 Online

Itens - Armory - Market - Clans - Builds - Chat

15 (edited by Feofilaktt 06.02.2018 18:57)

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)

Help me @HarpyWar

The problem returned, in another S.O (Debian 8) and with the last version of PvPGN PRO.

Identical to the above problem, could you point me in a direction of what it might be?

Failed D2CS? Because? What would this "sqlist" be? What reasons for this queue to be full?

Some direction to search for @HarpyWar please.

Thank you

Added: 02.02.2018 15:41

When I tried to use the /rehash all command to reload the D2CS these errors occurred to me:

Feb 02 11:59:45 [error] net_listen: error bind listen socket
Feb 02 11:59:45 [error] server_listen: error listen socket
Feb 02 11:59:45 [error] d2cs_server_process: failed to setup listen socket
Feb 02 11:59:45 [error] main: failed to run server

Added: 05.02.2018 07:40

Update: I am now using the PvPGN PRO Windows version running with Wine on Debian 8 64-bit OS.

I am using the same configuration in PvPGN, both in the Linux/Windowns version.

Apparently, the problem was in PvPGN for Linux, maybe something in the build, or in my OS.

So far working well, keep you informed.

Added: 06.02.2018 12:19

dont work, same problem

Diablo 2 Online

Itens - Armory - Market - Clans - Builds - Chat

16

Re: Problem with "sqlist_check_timeout"

Solved, the problem was OS

Diablo 2 Online

Itens - Armory - Market - Clans - Builds - Chat

17

Re: Problem with "sqlist_check_timeout"

Hi, i have very simillar problem on windows 2016 server, any one know how to deal with that?
https://forums.pvpgn.pro/viewtopic.php?id=2005
Best Regards

Posts: 17

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"