Skript-db creating too many SQL connections #19

New Issue

Govindas · 2022-06-26T18:39:09Z

Govindas commented

2022-06-26 18:39:09 +00:00

One user reported that skript-db created 150 connections in 5 minutes that stay without closing. There may be a leak?

In addition to that, we should add configuration option for max connections at any given time.

One user reported that skript-db created 150 connections in 5 minutes that stay without closing. There may be a leak? In addition to that, we should add configuration option for max connections at any given time.

cidon commented

2022-08-25 19:43:07 +00:00

yea same for me.
i got a lot of connections, so that my website doesn't work anymore..

maybe it's because i open multiple databases at a time

yea same for me. i got a lot of connections, so that my website doesn't work anymore.. maybe it's because i open multiple databases at a time

Govindas commented

2022-08-26 06:44:16 +00:00

yea same for me.
i got a lot of connections, so that my website doesn't work anymore..

maybe it's because i open multiple databases at a time

Could you share more details on your setup? I cannot reproduce this issue on my own network, so I need your sql server configuration, your queries and how often they are done.

Usually increasing max connections limit in your sql server configuration should help.

Also make sure you have not saved sql connections into persistent variables (those would end up starting on server startup)

> yea same for me. > i got a lot of connections, so that my website doesn't work anymore.. > > maybe it's because i open multiple databases at a time Could you share more details on your setup? I cannot reproduce this issue on my own network, so I need your sql server configuration, your queries and how often they are done. Usually increasing max connections limit in your sql server configuration should help. Also make sure you have not saved sql connections into persistent variables (those would end up starting on server startup)

cidon commented

2022-08-26 18:20:08 +00:00

which variables should I use then? How should they look?
{_sql} wouldn't work in other skripts right?

which variables should I use then? How should they look? {_sql} wouldn't work in other skripts right?

Govindas commented

2022-08-26 19:09:34 +00:00

{-variables}

you can enable them with (?!-).* variable pattern in config.SK database settings

{-variables} you can enable them with (?!-).* variable pattern in config.SK database settings

cidon commented

2022-08-27 10:33:57 +00:00

doesn't change anything..

there are just a lot of sleep connections. If you kill them, the plugin sends warnings that is has to recreate them

doesn't change anything.. there are just a lot of sleep connections. If you kill them, the plugin sends warnings that is has to recreate them

Govindas commented

2022-08-27 17:52:52 +00:00

how much is a lot?

cidon commented

2022-09-01 20:17:41 +00:00

always the max connections limit
i think the connections get saved somewhere else and then always reconnected or they just don't get right closed.

always the max connections limit i think the connections get saved somewhere else and then always reconnected or they just don't get right closed.

Govindas commented

2022-09-02 11:11:16 +00:00

variables.CSV file would be the only somewhere else place it may save to

Govindas commented

2022-12-08 19:30:52 +00:00

I finally took time to debug this issue and found the cause to be that I removed thread-pool-size config option many updates ago, I have now re-added it in skript-db 1.3.9 and it should be fixed. (Release soon)

Govindas closed this issue

2022-12-08 19:30:52 +00:00

Govindas referenced this issue from a commit

2022-12-08 19:33:17 +00:00

Re-add thread-pool-size config option, fixes #19

Sign in to join this conversation.