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.