rlm_sql Closing Connections

[Ammad Ali]

After changing I am still having connections spawning and connections 
are getting closed. Need your advise.

Mon Dec  7 17:01:09 2020 : Info: Loaded virtual server inner-tunnel
Mon Dec  7 17:01:09 2020 : Info: Loaded virtual server status
Mon Dec  7 17:01:09 2020 : Info: Ready to process requests
Mon Dec  7 17:06:35 2020 : Warning: rlm_sql (sql): 50 of 50 connections 
in use.  You probably need to increase "spare"
Mon Dec  7 17:06:35 2020 : Info: rlm_sql (sql): Opening additional 
connection (50)
Mon Dec  7 17:06:35 2020 : Warning: rlm_sql (sql): 50 of 50 connections 
in use.  You probably need to increase "spare"
Mon Dec  7 17:06:35 2020 : Error: rlm_sql (sql): Cannot open new 
connection, connection spawning already in progress
Mon Dec  7 17:06:35 2020 : Warning: rlm_sql (sql): 50 of 50 connections 
in use.  You probably need to increase "spare"
Mon Dec  7 17:06:35 2020 : Error: rlm_sql (sql): Cannot open new 
connection, connection spawning already in progress
Mon Dec  7 17:06:35 2020 : Warning: rlm_sql (sql): 51 of 51 connections 
in use.  You probably need to increase "spare"
Mon Dec  7 17:06:35 2020 : Info: rlm_sql (sql): Opening additional 
connection (51)
Mon Dec  7 17:06:35 2020 : Warning: rlm_sql (sql): 51 of 51 connections 
in use.  You probably need to increase "spare"
Mon Dec  7 17:06:35 2020 : Error: rlm_sql (sql): Cannot open new 
connection, connection spawning already in progress
Mon Dec  7 17:06:35 2020 : Warning: rlm_sql (sql): 52 of 52 connections 
in use.  You probably need to increase "spare"
Mon Dec  7 17:06:35 2020 : Info: rlm_sql (sql): Opening additional 
connection (52)
Mon Dec  7 17:06:35 2020 : Warning: rlm_sql (sql): 52 of 52 connections 
in use.  You probably need to increase "spare"
Mon Dec  7 17:06:35 2020 : Error: rlm_sql (sql): Cannot open new 
connection, connection spawning already in progress
Mon Dec  7 17:06:35 2020 : Warning: rlm_sql (sql): 53 of 53 connections 
in use.  You probably need to increase "spare"
Mon Dec  7 17:06:35 2020 : Info: rlm_sql (sql): Opening additional 
connection (53)
Mon Dec  7 17:06:35 2020 : Warning: rlm_sql (sql): 53 of 53 connections 
in use.  You probably need to increase "spare"
Mon Dec  7 17:06:35 2020 : Error: rlm_sql (sql): Cannot open new 
connection, connection spawning already in progress
Mon Dec  7 17:06:35 2020 : Warning: rlm_sql (sql): 53 of 53 connections 
in use.  You probably need to increase "spare"
Mon Dec  7 17:06:35 2020 : Error: rlm_sql (sql): Cannot open new 
connection, connection spawning already in progress
Mon Dec  7 17:06:35 2020 : Warning: rlm_sql (sql): 54 of 54 connections 
in use.  You probably need to increase "spare"
Mon Dec  7 17:06:35 2020 : Info: rlm_sql (sql): Opening additional 
connection (54)
Mon Dec  7 17:06:35 2020 : Warning: rlm_sql (sql): 54 of 54 connections 
in use.  You probably need to increase "spare"
Mon Dec  7 17:06:35 2020 : Error: rlm_sql (sql): Cannot open new 
connection, connection spawning already in progress
Mon Dec  7 17:06:53 2020 : Info: rlm_sql (sql): 6 of 55 connections in 
use.  Need more spares
Mon Dec  7 17:06:53 2020 : Info: rlm_sql (sql): Opening additional 
connection (55)
Mon Dec  7 17:06:53 2020 : Info: rlm_sql (sql): 6 of 55 connections in 
use.  Need more spares
Mon Dec  7 17:06:53 2020 : Error: rlm_sql (sql): Cannot open new 
connection, connection spawning already in progress
Mon Dec  7 17:07:23 2020 : Info: rlm_sql (sql): Closing connection (29), 
from 6 unused connections
Mon Dec  7 17:07:38 2020 : Info: rlm_sql (sql): Closing connection (5), 
from 4 unused connections
Mon Dec  7 17:07:45 2020 : Info: rlm_sql (sql): Closing connection (27), 
from 4 unused connections
Mon Dec  7 17:07:48 2020 : Info: rlm_sql (sql): Closing connection (36), 
from 3 unused connections
Mon Dec  7 17:07:49 2020 : Info: rlm_sql (sql): Closing connection (19), 
from 2 unused connections
Mon Dec  7 17:07:51 2020 : Info: rlm_sql (sql): Closing connection (11), 
from 1 unused connections


On 12/7/2020 5:03 PM, Ammad Ali wrote:
> Hi Alan,
>
> I am using FR 3.0.4. I have changed the idle_timeout to zero. Let me 
> monitor things and will share you the feedback.
>
> Ammad
> On 12/7/2020 1:47 PM, Alan Buxey wrote:
>> what version are you using?
>>
>> If you are able to keeplong-lived sessions to yourDB (and there isnt a
>> firewall playing games between your server and the DB) then why are
>> you idling out the connections
>> at all? set idle_timeout to 0 and the connections will be kept and you
>> wont have this close/reconnect issue anyway) . do you need 20 spare
>> connections? looks like they arent being used....you're
>> currently spinning up more than you need.