Skip to Content.
Sympa Menu

grouper-users - [grouper-users] exhausting hibernate JDBC connection pool

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] exhausting hibernate JDBC connection pool

Chronological Thread 
  • From: Scott Koranda <>
  • To: grouper-users <>
  • Subject: [grouper-users] exhausting hibernate JDBC connection pool
  • Date: Tue, 1 Nov 2016 16:33:22 -0500
  • Ironport-phdr: 9a23:Lc2OfxEEbsqRE4c2wBHce51GYnF86YWxBRYc798ds5kLTJ75osuwAkXT6L1XgUPTWs2DsrQf2rCQ4/mrADBcqb+681k6OKRWUBEEjchE1ycBO+WiTXPBEfjxciYhF95DXlI2t1uyMExSBdqsLwaK+i760zceF13FOBZvIaytQ8iJ3p7xh7n5osGPKyxzxxOFKYtoKxu3qQiD/uI3uqBFbpgL9x3Sv3FTcP5Xz247bXianhL7+9vitMU7q3cY6Lod8JtPS6LnZ6kiCKFDAS49ezQ6/sr2rRTZCBaU62EHemQQjhdSBQXZtlf3Uoqn4QXgse8o4yKdIdG+brcuUDKu5u8/Uxzvki4BOzcR/2Tei8g2h6Ve9kHy7ydjypLZNdnGfMF1ebnQKIsX


I am helping manage a large Grouper deployment that manages a
number of groups for a campus, including groups that represent
course offerings ("course groups").

November 1 marks a "transition" from one set of course groups
to another. The result is a large amount of work for 3 loader
jobs that manage the course groups.

In the past earlier versions of Grouper, all running on the
same VM (no changes in the available resources have happened),
have ridden out this transition without issue.

Today, however, using Grouper version 2.3 was different. We
saw that the loader consumed all of the available JDBC
connections. The default was set in

hibernate.c3p0.max_size = 16

This caused a number of loader jobs, including maintenance
jobs like CHANGE_LOG_changeLogTempToChangeLog, to be starved.

Stopping the loader and changing to

hibernate.c3p0.max_size = 32

made the issue go away.

My question is what might be different in Grouper version 2.3
that caused all of the JDBC connections to be consumed where
previously they were not?

I am wondering if code has changed that causes the Grouper
loader to be more "aggressive" in how it processes "a lot of

I also note that we did not see this issue on the dev system.
That VM, however, has less CPU cores and memory available to
it, so I am wondering if that constrained the loader in some
way and prevented it from scaling up and exhausting the JDBC

I appreciate any input the Grouper team has.


Scott K

Archive powered by MHonArc 2.6.19.

Top of Page