Mantis - Quercus
Viewing Issue Advanced Details
1241 minor always 07-10-06 16:40 07-18-06 09:44
closed 3.0.19  
none 3.0.20  
0001241: Lots of InstanceAlreadyExists exceptions when using MySQL from Quercus
It looks like something in the current (Subversion) Quercus MySQL code isn't playing nice with JMX. I get tons of these exceptions, though the app appears to work fine. Seems to spit out one every time our code connects to MySQL, which of course happens a lot.

[16:36:40.552] resin:type=ConnectionPool,Host=default,WebApp=/,name=dbpool-0
[16:36:40.552] at com.caucho.jmx.AbstractMBeanServer.registerMBean(
[16:36:40.552] at com.caucho.jmx.Jmx.register(
[16:36:40.552] at
[16:36:40.552] at com.caucho.jca.ConnectionPool.init(
[16:36:40.552] at com.caucho.sql.DBPool.init(
[16:36:40.552] at com.caucho.sql.DatabaseManager.findDatabaseImpl(
[16:36:40.552] at com.caucho.sql.DatabaseManager.findDatabase(
[16:36:40.552] at com.caucho.quercus.env.Env.getConnection(
[16:36:40.552] at com.caucho.quercus.lib.db.Mysqli.connectInternal(
[16:36:40.552] at com.caucho.quercus.lib.db.Mysqli.<init>(
[16:36:40.552] at com.caucho.quercus.lib.db.MysqlModule.mysql_connect(

07-13-06 22:23   
A slight clarification: this seems to happen every time our code connects to a particular MySQL instance for the first time (which I assume implies the creation of a connection pool for that instance). Once the site has been up for a while and we've contacted all our databases, I stop seeing the error message.