SQL error when running CRUX for a day

[jmozah]

Struts Problem Report

Struts has detected an unhandled exception:

Messages:
Connection.close() has already been called. Invalid operation in this state.
JDBC rollback failed
File: com/mysql/jdbc/SQLError.java
Line number: 888
Stacktraces

org.hibernate.TransactionException: JDBC rollback failed
org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:204)
com.googlecode.s2hibernate.struts2.plugin.interceptors.SessionTransactionInjectorInterceptor.intercept(SessionTransactionInjectorInterceptor.java:165)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:468)
org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:76)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:185)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:151)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:269)
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515)
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
java.lang.Thread.run(Thread.java:636)

com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Connection.close() has already been called. Invalid operation in this state.
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:888)
com.mysql.jdbc.Connection.getMutex(Connection.java:3728)
com.mysql.jdbc.Connection.rollback(Connection.java:5204)
org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:217)
org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:196)
com.googlecode.s2hibernate.struts2.plugin.interceptors.SessionTransactionInjectorInterceptor.intercept(SessionTransactionInjectorInterceptor.java:165)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:468)
org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:76)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:185)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:151)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:269)
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515)
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
java.lang.Thread.run(Thread.java:636)

You are seeing this page because development mode is enabled. Development mode, or devMode, enables extra debugging behaviors and reports to assist developers. To disable this mode, set:

struts.devMode=false
in your WEB-INF/classes/struts.properties file.

[sonalgoyal]

Can you tell me when this happens? If you leave it up for a day, are all pages showing this error, or some particular page or action?

[jmozah]

After i leave it for a day.. i start the page again next dat by issuing http:/machine:8080/crux ... then i get this error
Now i cannot see anything...

[sonalgoyal]

Seems MySQL is terminating the connections after idle waiting, lets use c3p0 connection pooling with hibernate.

[jmozah]

How do i do that?

[sonalgoyal]

I am working on the patch. In the meantime, can you bounce tomcat and start the browser? Let me know if you see any issues.

[jmozah]

Working if i bounce tomcat

[sonalgoyal]

Cool. The Hibernate layer is right now not configured to pool and keep alive the mysql connections. So after a couple of hours, the connection drops and crux becomes unresponsive. We will push the patch for hibernate with connection pooling enabled, and that will keep the pooled connections afresh. Thanks for pointing this out.

[jmozah]

Let me know when it is pushed. I will pull and check.
I forgot one more thing.. The velocity jar's are not included with the default bundle. I downloaded it manually

./Zahoor@iPad

On 14-Sep-2011, at 4:48 PM, Sonalreply@reply.github.com wrote:

Cool. The Hibernate layer is right now not configured to pool and keep alive the mysql connections. So after a couple of hours, the connection drops and crux becomes unresponsive. We will push the patch for hibernate with connection pooling enabled, and that will keep the pooled connections afresh. Thanks for pointing this out.

Reply to this email directly or view it on GitHub:
#11 (comment)

[sonalgoyal]

Where do you need velocity? The war should be self sufficient.

http://in.linkedin.com/in/sonalgoyal

On Wed, Sep 14, 2011 at 7:19 PM, J Mohamed Zahoor <
reply@reply.github.com>wrote:

Let me know when it is pushed. I will pull and check.
I forgot one more thing.. The velocity jar's are not included with the
default bundle. I downloaded it manually

./Zahoor@iPad

On 14-Sep-2011, at 4:48 PM, Sonalreply@reply.github.com wrote:

Cool. The Hibernate layer is right now not configured to pool and keep
alive the mysql connections. So after a couple of hours, the connection
drops and crux becomes unresponsive. We will push the patch for hibernate
with connection pooling enabled, and that will keep the pooled connections
afresh. Thanks for pointing this out.

Reply to this email directly or view it on GitHub:
#11 (comment)

Reply to this email directly or view it on GitHub:
#11 (comment)

[sonalgoyal]

This was fixed long time ago. Please let me know if this persists.