Details
-
Bug
-
Resolution: Fixed
-
High
-
5.3.4, 5.5
-
None
-
MySQL 5.6.12
Description
Steps to reproduce
- Setup a Confluence instance to point to a MySQL Database
- Set the hibernate.c3p0.min_size property in confluence.cfg.xml to a non-zero value.
- Monitor the number of connections created to the MySQL database over the next couple minutes with:
select user, count(*) from information_schema.processlist group by user;
Expected Results
The database connections should stay between the bounds of min_size and max_size.
Actual Results
The database connections surpass the bound set in max_size, and end up being up to 7 times the number set in min_size.
Workaround
Setting the min_size value to 0 will lead to the max_size being obeyed.
Alternatively, if strict control of the number of connections is required, divide your intended connection pool size by 7 and set your min_size to this value.