maxConnections is not working properly
Hi!
I'm trying to set up my Teamcity Server with maxConnections property but this not working properly for me.
database.properties content is
connectionProperties.user=tc
connectionProperties.password=tc
connectionUrl=jdbc\:postgresql\://db\:5432/tc
maxConnections=15
initialConnections=15
When I check my Postgres connections stats I'd like to see 15 active connections, but I see 17. This happens with different values of maxconnections parameter. Numbers of active connections is always 2 more over maxConnections property.
Also, I can see that TeamCity initialize two connections before other:
select backend_start from pg_stat_activity where datname='tc';
backend_start
-------------------------------
2018-10-24 15:24:44.861691+00
2018-10-24 15:24:44.961395+00
2018-10-24 15:24:45.013309+00
2018-10-24 15:24:45.063224+00
2018-10-24 15:24:45.103159+00
2018-10-24 15:24:45.145371+00
2018-10-24 15:24:45.183603+00
2018-10-24 15:24:45.22884+00
2018-10-24 15:24:45.279027+00
2018-10-24 15:24:45.323013+00
2018-10-24 15:24:45.362801+00
2018-10-24 15:24:45.400431+00
2018-10-24 15:24:45.450061+00
2018-10-24 15:24:45.503536+00
2018-10-24 15:24:45.554321+00
2018-10-24 15:24:45.598063+00
2018-10-24 15:24:45.698661+00
(17 rows)
Can you explain me, why I see this unexpected behavior?
Thanks!
Teamcity version is 2018.1 (build 58245)
JDBC Driver - postgresql-42.2.5
Please sign in to leave a comment.