Support Forum

[stampy]

we get a "DBCP pool" exception now at the login page to trackstudio; there is no login form, just the exception. Any ideas? This is from our dev version of TS so its not critical

before this, i was playing with manually inserting new rows in the gr_attachment table, and then i uploaded an attachment the "normal" way via the UI. Otherwise, no one else uses this TS. Here is the start of the stack trace

Stack Trace:
org.hibernate.HibernateException: Could not create a DBCP pool
at org.hibernate.connection.DBCPConnectionProvider.configure(DBCPConnectionProvider.java:186)
at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)
at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56)
at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:366)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:60)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1881)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1174)
at com.trackstudio.startup.Config.getSessionFactory(Config.java:424)
at com.trackstudio.startup.HibernateSession.currentSession(HibernateSession.java:21)
at com.trackstudio.startup.DatabaseValidator.validate(DatabaseValidator.java:522)
at com.trackstudio.startup.TSLoader.init(TSLoader.java:48)
at org.apache.struts.action.ActionServlet.initModulePlugIns(ActionServlet.java:869)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:336)

[admin]

Yes, this is a known problem which occurs sometimes, no good solution yet - just restart TrackStudio if this occurs.

[stampy]

hm, we already restarted it and it still happens. Any other ideas? Again, this is our development server so we can rebuild it. I only ask if you have any more ideas on trying to get rid of this exception just in case it happens on our main server. thanks

[admin]

please open trackstudio.hibernate.properties and

1) Comment
hibernate.connection.provider_class org.hibernate.connection.DBCPConnectionProvider

2) Add/Uncomment
hibernate.connection.provider_class org.hibernate.connection.C3P0ConnectionProvider

3) Add the following
hibernate.c3p0.max_size 100
hibernate.c3p0.min_size 10
hibernate.c3p0.timeout 5000
hibernate.c3p0.max_statements 100
hibernate.c3p0.idle_test_period 3000
hibernate.c3p0.acquire_increment 2
hibernate.c3p0.validate false
hibernate.c3p0.debugUnreturnedConnectionStackTraces true
hibernate.c3p0.unreturnedConnectionTimeout 1800

4) Download
http://www.trackstudio.com/tse-35/c3p0-0.9.1.jar
and put it to webapps/TrackStudio/WEB-INF/lib

5) Restart TrackStudio

If you can replicate the problem - please send me error log. Please also try to decrease max_size and min_size:
hibernate.c3p0.max_size 100
hibernate.c3p0.min_size 10

possible, this will lead to early crash.

The problem is occurs because TrackStudio have connection leak somewhere. We have yet another customer with this problem, but never seen it on our server. Probably, connection leaked when some specific TrackStudio functionality is used.

C3P0 can kill leaked connections and should print to log file (in theory) where they has been opened.

[stampy]

hm, i was going to start doing this but the guys already wiped the server and restored a working TS. Sorry.

[hammj]

This issue popped up for me, but I can't get to the .jar file in the resolution.

[admin]

Which TS version do you use now?

[hammj]

I am on version 3.5.12, but I think I figured it out. I think the database got corrupted. I was able to do a backup and restore as a new DB and pointed TS at the new one and that works.