2.1.6 fails intermittently seems to be MYSQL related

[Migrated From Jforum.net]

Further investigation by our lead devloper seems to lead to wards this being a clash between ourt Application connection pool manager ( bitmechanic) and the one shipped with jForum.

We are looking to see if we cna migreate ot he newer one for the applcaiton ... will post update if this resolves the issue.
[originally posted on jforum.net by robpretty]

[Migrated From Jforum.net]

Hi we have been having a few issues with the follwoing installtion fo jforum over the alst 24 hours.


Running tomcat 5.5.17 mysql 5 running on debian with j2esdk 1.5 and jforum 2.1.6.

Basically the forumn wokrs fie for aourn 12 hours or so and then an attmept to access the forum gives the follwoing STDout error. we are investigating if there are any odd processes runinng on the server that may cause thisbut has anyone else had this type of intermitttent issue?

As simple restart of tomcat seems not to always fix the issue...a full server bounce does we are puzzled as the MYSQL DB seems to be fine.... Looks liek a connection issue to mYSQL as when it fails even local dev PCs cannot connet to the remote DB but we can access via a MYSQL cleint? Perhaps some deadlocks?

net.jforum.exceptions.DatabaseException: Error while trying to start the database: net.jforum.exceptions.DatabaseException: java.sql.SQLException: Connections could not be acquired from the underlying database!
com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:104)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:264)
com.mchange.v2


[originally posted on jforum.net by robpretty]

[Migrated From Jforum.net]

As thought it was aclash with the connection pooling .... now we ar ealigne don the same connection poler for both Jfroum adn applcaition and every things is fine :@)
[originally posted on jforum.net by robpretty]