We have an ofBiz application server that is running in a staging/demo environment that gets little usage. In December I updated the source code via subversion from the trunk so the code is fairly up to date. The application starts out around 100MB but just sitting there grows to approx 300MB of memory over time under very lite loads. It is accessing a mySQL database. I noticed today that when I went to login to the application it was extremely slow. After restarting the ofBiz application the performance issue went away.
I looked into the ofbiz.log file and noticed an exception / error "There was an error getting a Minerva datasource". I don't know if this is the cause of the performance issues or not but started going down this path since the error was specific to the login: ========================= 2007-01-12 14:56:19,025 (RMI TCP Connection(34512)-192.168.1.3) [ ConnectionFactory.java:82 :ERROR] ---- runtime exception report -------------------------------------------------- There was an error getting a Minerva datasource. Exception: java.lang.RuntimeException Message: No ManagedConnections Available! ---- stack trace --------------------------------------------------------------- java.lang.RuntimeException: No ManagedConnections Available! org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:655) org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection( XAPoolDataSource.java:355) org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection( MinervaConnectionFactory.java:43) org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources( ConnectionFactory.java:79) org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection( GeronimoTransactionFactory.java:97) ..... ConnectionFactory.java:71 :ERROR] ******* ERROR: No database connection found for helperName "localmysql" 2007-01-12 14:56:19,025 (RMI TCP Connection(34512)-192.168.1.3) [ GenericDelegator.java:574:ERROR] ---- exception report ---------------------------------------------------------- Failure in create operation for entity [UserLoginHistory]: org.ofbiz.entity.GenericEntityException: Exception while inserting the following entity: [GenericEntity:UserLoginHistory][createdStamp,2007-01-12 14:55:59.025(java.sql.Timestamp)][createdTxStamp,2007-01-12 ========================= In doing some research, I found that Minerva was replaced with Geronimo back in Jun 06 so I was surprised and confused seeing this exception. I don't know if there is some configuration in my environment that is messed up and therefore still using Minerva erroneously? Any thoughts? Thanks - John
