Chris, BTW you may put this *important* (and seemingly reccurring) autoreconnect MySQL 5.0+ tip in the SandBox for the moment : http://docs.ofbiz.org/display/OFBIZ/Sandbox
And thanks for all your great and accurate help for users (and even devs ;o) ! Jacques ----- Original Message ----- From: "Chris Howe" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, January 12, 2007 10:19 PM Subject: Re: Sluggish server / Minerva exception > Two issues there... > SVN: You likely checked out using > svn.ofbiz.org/svn/ofbiz/trunk which is the old > repository. The new svn repository is at > http://svn.apache.org/viewvc/ofbiz/ > > (OFBiz SVN has been off Minerva for nearly a year now) > > The second issue, if you're using MySQL 5.0+, the auto > reconnect attribute was deprecated as a security > feature and so MySql will close the connection after 8 > hours of inactivity. For a work around please see > this recent discussion. > > http://www.nabble.com/forum/ViewPost.jtp?post=8213433&framed=y > > > --- John Martin <[EMAIL PROTECTED]> wrote: > > > 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 > >
