java.lang.IllegalStateException: Cannot deactivate

[jsturnbull]

Hello,

 

I am receiving the following exception on JasperServer:

 

java.lang.IllegalStateException: Cannot deactivate transaction synchronization - not active

at org.springframework.transaction.support.TransactionSynchronizationManager.clearSynchronization(TransactionSynchronizationManager.java:270)

 

The exception is raised consistently after a period of inactivity such as when JasperServer is accessed first thing in the morning having not been used in the previous evening.

 

We are running JasperServer 2.1.0 on Windows Server 2003 R2 with JRE 1.6.06.

 

Any help much appreciated

james

[lucianc]

Could you post a full stacktrace for this?

 

Regards,

Lucian

[jsturnbull]

Hello Lucian,

 

Here you go...

 

08:45:10,150 ERROR JSErrorPage_jsp,http-9080-Processor23:322 -

java.lang.IllegalStateException: Cannot deactivate transaction synchronization - not active

at org.springframework.transaction.support.TransactionSynchronizationManager.clearSynchronization(TransactionSynchronizationManager.java:270)

at org.springframework.transaction.support.AbstractPlatformTransactionManager.cleanupAfterCompletion(AbstractPlatformTransactionManager.java:902)

at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:777)

at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:722)

at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:325)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:111)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)

at $Proxy1.loadResourcesList(Unknown Source)

at com.jaspersoft.jasperserver.war.action.RepoAdminAction.initAction(RepoAdminAction.java:149)

at sun.reflect.GeneratedMethodAccessor396.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.webflow.util.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:103)

at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:136)

at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:203)

at org.springframework.webflow.engine.AnnotatedAction.execute(AnnotatedAction.java:142)

at org.springframework.webflow.engine.ActionExecutor.execute(ActionExecutor.java:61)

at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:180)

at org.springframework.webflow.engine.State.enter(State.java:200)

at org.springframework.webflow.engine.Flow.start(Flow.java:557)

at org.springframework.webflow.engine.impl.RequestControlContextImpl.start(RequestControlContextImpl.java:195)

at org.springframework.webflow.engine.impl.FlowExecutionImpl.start(FlowExecutionImpl.java:189)

at org.springframework.webflow.executor.FlowExecutorImpl.launch(FlowExecutorImpl.java:206)

at sun.reflect.GeneratedMethodAccessor360.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)

at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)

at $Proxy13.launch(Unknown Source)

at org.springframework.webflow.executor.support.FlowRequestHandler.handleFlowRequest(FlowRequestHandler.java:131)

at org.springframework.webflow.executor.mvc.FlowController.handleRequestInternal(FlowController.java:170)

at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)

at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:820)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396)

at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)

at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)

at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:136)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:131)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:131)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)

at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)

at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)

at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)

at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)

at java.lang.Thread.run(Unknown Source)

[lucianc]

Spring transaction code appears to have problems rolling back a transaction that resulted in an exception; this might be a Spring bug.

 

Anyway, what we're actually interested in is the original exception that occurred in the transaction (that got swallowed by the Spring rollback exception). One way to find out what the original exception was is to enable debugging logging for org.springframework.transaction classes, i.e. add the following line to WEB-INF/log4j.properties:

Code:

log4j.logger.org.springframework.transaction=DEBUG

 

If you do this, the WEB-INF/logs/jasperserver.log file should contain a line that looks like "Completing transaction for [..] after exception: .." before the Spring rollback exception occurs.

 

Based on the case you're describing, a possible cause might be that the DB server closes connections after an idle timeout, so the JS connection pool could contain invalid/dead connections after a long inactivity. If this is the case, you could try to avoid this case by setting a validationQuery (e.g. "select count(*) from JIRole" for the "jasperserver" data source defined in META-INF/context.xml and $TOMCAT/conf/Catalina/$HOST/jasperserver.xml, or, if you use MySQL, by appending "&autoReconnect=true" or "&autoReconnectForPools=true" to the JDBC url of the same data source.

 

Regards,

Lucian

[Gaby38]

Lucian,

I also get very often the same error since I am using jasperserver. But as it is not blocking and occurs only the 1st time I connect after a long inactivity, I din't take care of that and didn't post anything about that.

Remember that you helped me when I was getting troubles with a DB connection which I killed the shadow process of. As you said, I put in place a validation query and all ran OK except that famous "cannot deactivate transaction" that persists. But this validation query is for my work Database and not Jasperserver database. So I will also try to do what you are saying for the Mysql Database supporting my jasperserver metadata.

I'll keep you aware of the results.

[Gaby38]

Just to say that I did the modification suggested by Lucian : add "&autoReconnectForPools=true" to the URL in the MySql JDBC Datasource.

Since this update, I didn't get any more the "Cannot deactivate transaction synchronization" error message. Before I used to get it at each morning login after a long inactivity.

So thanks again Lucian for your advices.

[jsturnbull]

Hello again,

Unfortunately having made the original post I was taken off JasperServer to do other work for my employers. However I back Japering now. I have upgraded to JS3 but we still experience the same problem. I have tried chaning the jdbc connection string to no avail.

The url I use is:

url="jdbc:mysql://localhost:3306/jasperserver?autoReconnect=true&autoReconnectForPools=true&useUnicode=true&characterEncoding=UTF8"

Here is the full log with the change to log4j that you suggested. Any further suggestions gratefully received.

 

08:23:18,572 DEBUG TransactionSynchronizationManager,http-9080-1:166 - Bound value [org.springframework.jdbc.datasource.ConnectionHolder@13e5d15] for key [org.apache.tomcat.dbcp.dbcp.BasicDataSource@12b4986] to thread [http-9080-1]
08:23:18,572 DEBUG TransactionSynchronizationManager,http-9080-1:166 - Bound value [org.springframework.orm.hibernate3.SessionHolder@1e3e4c5] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] to thread [http-9080-1]
08:23:18,572 DEBUG TransactionSynchronizationManager,http-9080-1:219 - Initializing transaction synchronization
08:23:18,572 DEBUG TransactionInterceptor,http-9080-1:275 - Getting transaction for [org.acegisecurity.userdetails.UserDetailsService.loadUserByUsername]
08:23:18,634 DEBUG TransactionSynchronizationManager,http-9080-1:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@1e3e4c5] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-1]
08:23:18,634 DEBUG TransactionSynchronizationManager,http-9080-1:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@1e3e4c5] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-1]
08:23:18,634 DEBUG TransactionSynchronizationManager,http-9080-1:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@1e3e4c5] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-1]
08:23:18,728 DEBUG TransactionSynchronizationManager,http-9080-1:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@1e3e4c5] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-1]
08:23:18,728 DEBUG TransactionSynchronizationManager,http-9080-1:139 - Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@13e5d15] for key [org.apache.tomcat.dbcp.dbcp.BasicDataSource@12b4986] bound to thread [http-9080-1]
08:23:18,728 DEBUG TransactionInterceptor,http-9080-1:275 - Getting transaction for [com.jaspersoft.jasperserver.api.metadata.user.service.ProfileAttributeService.getProfileAttributesForPrincipal]
08:23:18,728 DEBUG TransactionSynchronizationManager,http-9080-1:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@1e3e4c5] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-1]
08:23:18,728 DEBUG TransactionSynchronizationManager,http-9080-1:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@1e3e4c5] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-1]
08:23:18,759 ERROR ErrorLogger,JasperServerScheduler_QuartzSchedulerThread:2015 - An error occured while scanning for the next trigger to fire.
org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.JasperServerScheduler': com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Software caused connection abort: recv failed

STACKTRACE:

java.net.SocketException: Software caused connection abort: recv failed
    at java.net.SocketInputStream.socketRead0(Native Method)
    at java.net.SocketInputStream.read(Unknown Source)
    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1902)
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
    at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4913)
    at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:331)
    at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:317)
    at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:1389)
    at org.quartz.impl.jdbcjobstore.JobStoreCMT.acquireNextTrigger(JobStoreCMT.java:1132)
    at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:233)


** END NESTED EXCEPTION **



Last packet sent to the server was 0 ms ago. [see nested exception: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Software caused connection abort: recv failed

STACKTRACE:

java.net.SocketException: Software caused connection abort: recv failed
    at java.net.SocketInputStream.socketRead0(Native Method)
    at java.net.SocketInputStream.read(Unknown Source)
    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1902)
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
    at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4913)
    at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:331)
    at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:317)
    at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:1389)
    at org.quartz.impl.jdbcjobstore.JobStoreCMT.acquireNextTrigger(JobStoreCMT.java:1132)
    at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:233)


** END NESTED EXCEPTION **



Last packet sent to the server was 0 ms ago.]
    at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:1396)
    at org.quartz.impl.jdbcjobstore.JobStoreCMT.acquireNextTrigger(JobStoreCMT.java:1132)
    at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:233)
* Nested Exception (Underlying Cause) ---------------
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Software caused connection abort: recv failed

STACKTRACE:

java.net.SocketException: Software caused connection abort: recv failed
    at java.net.SocketInputStream.socketRead0(Native Method)
    at java.net.SocketInputStream.read(Unknown Source)
    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1902)
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
    at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4913)
    at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:331)
    at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:317)
    at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:1389)
    at org.quartz.impl.jdbcjobstore.JobStoreCMT.acquireNextTrigger(JobStoreCMT.java:1132)
    at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:233)


** END NESTED EXCEPTION **



Last packet sent to the server was 0 ms ago.
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2563)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
    at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4913)
    at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:331)
    at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:317)
    at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:1389)
    at org.quartz.impl.jdbcjobstore.JobStoreCMT.acquireNextTrigger(JobStoreCMT.java:1132)
    at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:233)
08:23:18,791 DEBUG TransactionSynchronizationManager,http-9080-1:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@1e3e4c5] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-1]
08:23:18,806 DEBUG TransactionInterceptor,http-9080-1:305 - Completing transaction for [com.jaspersoft.jasperserver.api.metadata.user.service.ProfileAttributeService.getProfileAttributesForPrincipal]
08:23:18,806 DEBUG TransactionInterceptor,http-9080-1:305 - Completing transaction for [org.acegisecurity.userdetails.UserDetailsService.loadUserByUsername]
08:23:18,806 DEBUG TransactionSynchronizationManager,http-9080-1:272 - Clearing transaction synchronization
08:23:18,806 DEBUG TransactionSynchronizationManager,http-9080-1:190 - Removed value [org.springframework.orm.hibernate3.SessionHolder@1e3e4c5] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] from thread [http-9080-1]
08:23:18,806 DEBUG TransactionSynchronizationManager,http-9080-1:190 - Removed value [org.springframework.jdbc.datasource.ConnectionHolder@13e5d15] for key [org.apache.tomcat.dbcp.dbcp.BasicDataSource@12b4986] from thread [http-9080-1]
08:23:18,806  WARN LoggerListener,http-9080-1:55 - Authentication event AuthenticationSuccessEvent: [removed]; details: org.acegisecurity.ui.WebAuthenticationDetails@0: RemoteIpAddress: [removed]; SessionId: 542A7FD4EF7A5FE6BEDC18E089AEC850
08:23:18,806  WARN LoggerListener,http-9080-1:55 - Authentication event InteractiveAuthenticationSuccessEvent: [removed]; details: org.acegisecurity.ui.WebAuthenticationDetails@0: RemoteIpAddress: [removed]; SessionId: 542A7FD4EF7A5FE6BEDC18E089AEC850
08:23:20,197 DEBUG TransactionSynchronizationManager,http-9080-2:166 - Bound value [org.springframework.jdbc.datasource.ConnectionHolder@12f717c] for key [org.apache.tomcat.dbcp.dbcp.BasicDataSource@12b4986] to thread [http-9080-2]
08:23:20,197 DEBUG TransactionSynchronizationManager,http-9080-2:166 - Bound value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] to thread [http-9080-2]
08:23:20,197 DEBUG TransactionSynchronizationManager,http-9080-2:219 - Initializing transaction synchronization
08:23:20,197 DEBUG TransactionInterceptor,http-9080-2:275 - Getting transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryService.getFolder]
08:23:20,197 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,197 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@12f717c] for key [org.apache.tomcat.dbcp.dbcp.BasicDataSource@12b4986] bound to thread [http-9080-2]
08:23:20,197 DEBUG TransactionInterceptor,http-9080-2:275 - Getting transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryService.getFolder]
08:23:20,197 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,197 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@12f717c] for key [org.apache.tomcat.dbcp.dbcp.BasicDataSource@12b4986] bound to thread [http-9080-2]
08:23:20,197 DEBUG TransactionInterceptor,http-9080-2:275 - Getting transaction for [org.acegisecurity.acl.AclProvider.supports]
08:23:20,197 DEBUG TransactionInterceptor,http-9080-2:305 - Completing transaction for [org.acegisecurity.acl.AclProvider.supports]
08:23:20,197 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,197 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@12f717c] for key [org.apache.tomcat.dbcp.dbcp.BasicDataSource@12b4986] bound to thread [http-9080-2]
08:23:20,197 DEBUG TransactionInterceptor,http-9080-2:275 - Getting transaction for [org.acegisecurity.acl.AclProvider.getAcls]
08:23:20,197 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,197 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@12f717c] for key [org.apache.tomcat.dbcp.dbcp.BasicDataSource@12b4986] bound to thread [http-9080-2]
08:23:20,197 DEBUG TransactionInterceptor,http-9080-2:275 - Getting transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryUnsecure.getResourceUnsecure]
08:23:20,197 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,212 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@12f717c] for key [org.apache.tomcat.dbcp.dbcp.BasicDataSource@12b4986] bound to thread [http-9080-2]
08:23:20,212 DEBUG TransactionInterceptor,http-9080-2:275 - Getting transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryUnsecure.getResourceUnsecure]
08:23:20,212 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,212 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,212 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,244 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,244 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,244 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,275 DEBUG TransactionInterceptor,http-9080-2:305 - Completing transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryUnsecure.getResourceUnsecure]
08:23:20,275 DEBUG TransactionInterceptor,http-9080-2:305 - Completing transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryUnsecure.getResourceUnsecure]
08:23:20,275 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,275 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@12f717c] for key [org.apache.tomcat.dbcp.dbcp.BasicDataSource@12b4986] bound to thread [http-9080-2]
08:23:20,275 DEBUG TransactionInterceptor,http-9080-2:275 - Getting transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryUnsecure.getFolderUnsecure]
08:23:20,275 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,275 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@12f717c] for key [org.apache.tomcat.dbcp.dbcp.BasicDataSource@12b4986] bound to thread [http-9080-2]
08:23:20,275 DEBUG TransactionInterceptor,http-9080-2:275 - Getting transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryUnsecure.getFolderUnsecure]
08:23:20,275 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,291 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,291 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,291 DEBUG TransactionInterceptor,http-9080-2:305 - Completing transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryUnsecure.getFolderUnsecure]
08:23:20,291 DEBUG TransactionInterceptor,http-9080-2:305 - Completing transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryUnsecure.getFolderUnsecure]
08:23:20,291 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,291 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@12f717c] for key [org.apache.tomcat.dbcp.dbcp.BasicDataSource@12b4986] bound to thread [http-9080-2]
08:23:20,291 DEBUG TransactionInterceptor,http-9080-2:275 - Getting transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryUnsecure.getResourceUnsecure]
08:23:20,291 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,291 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@12f717c] for key [org.apache.tomcat.dbcp.dbcp.BasicDataSource@12b4986] bound to thread [http-9080-2]
08:23:20,291 DEBUG TransactionInterceptor,http-9080-2:275 - Getting transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryUnsecure.getResourceUnsecure]
08:23:20,291 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,291 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,306 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,306 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,306 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,306 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,306 DEBUG TransactionInterceptor,http-9080-2:305 - Completing transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryUnsecure.getResourceUnsecure]
08:23:20,306 DEBUG TransactionInterceptor,http-9080-2:305 - Completing transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryUnsecure.getResourceUnsecure]
08:23:20,306 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,306 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@12f717c] for key [org.apache.tomcat.dbcp.dbcp.BasicDataSource@12b4986] bound to thread [http-9080-2]
08:23:20,306 DEBUG TransactionInterceptor,http-9080-2:275 - Getting transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryUnsecure.getFolderUnsecure]
08:23:20,306 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,306 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@12f717c] for key [org.apache.tomcat.dbcp.dbcp.BasicDataSource@12b4986] bound to thread [http-9080-2]
08:23:20,322 DEBUG TransactionInterceptor,http-9080-2:275 - Getting transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryUnsecure.getFolderUnsecure]
08:23:20,322 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,322 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,322 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,322 DEBUG TransactionInterceptor,http-9080-2:305 - Completing transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryUnsecure.getFolderUnsecure]
08:23:20,322 DEBUG TransactionInterceptor,http-9080-2:305 - Completing transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryUnsecure.getFolderUnsecure]
08:23:20,322 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,322 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,322 ERROR JDBCTransaction,http-9080-1:67 - JDBC begin failed
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.io.EOFException

STACKTRACE:

java.io.EOFException
    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1905)
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
    at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4913)
    at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:331)
    at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:317)
    at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:63)
    at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
    at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:497)
    at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:349)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:255)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:102)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
    at $Proxy1.getResource(Unknown Source)
    at com.jaspersoft.jasperserver.war.model.impl.RepositoryExplorerTreeDataProviderImpl.getNode(RepositoryExplorerTreeDataProviderImpl.java:79)
    at com.jaspersoft.jasperserver.war.model.TreeHelper.getSubtree(TreeHelper.java:66)
    at com.jaspersoft.jasperserver.war.action.tree.TreeAction.getNode(TreeAction.java:115)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.springframework.webflow.util.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:103)
    at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:136)
    at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:203)
    at org.springframework.webflow.engine.AnnotatedAction.execute(AnnotatedAction.java:142)
    at org.springframework.webflow.engine.ActionExecutor.execute(ActionExecutor.java:61)
    at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:180)
    at org.springframework.webflow.engine.State.enter(State.java:200)
    at org.springframework.webflow.engine.Transition.execute(Transition.java:229)
    at org.springframework.webflow.engine.DecisionState.doEnter(DecisionState.java:58)
    at org.springframework.webflow.engine.State.enter(State.java:200)
    at org.springframework.webflow.engine.Flow.start(Flow.java:557)
    at org.springframework.webflow.engine.impl.RequestControlContextImpl.start(RequestControlContextImpl.java:195)
    at org.springframework.webflow.engine.impl.FlowExecutionImpl.start(FlowExecutionImpl.java:189)
    at org.springframework.webflow.executor.FlowExecutorImpl.launch(FlowExecutorImpl.java:206)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
    at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
    at $Proxy13.launch(Unknown Source)
    at org.springframework.webflow.executor.support.FlowRequestHandler.handleFlowRequest(FlowRequestHandler.java:131)
    at org.springframework.webflow.executor.mvc.FlowController.handleRequestInternal(FlowController.java:170)
    at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
    at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45)
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:820)
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396)
    at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
    at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
    at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:141)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
    at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    at java.lang.Thread.run(Unknown Source)


** END NESTED EXCEPTION **



Last packet sent to the server was 0 ms ago.
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2563)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
    at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4913)
    at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:331)
    at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:317)
    at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:63)
    at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
    at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:497)
    at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:349)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:255)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:102)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
    at $Proxy1.getResource(Unknown Source)
    at com.jaspersoft.jasperserver.war.model.impl.RepositoryExplorerTreeDataProviderImpl.getNode(RepositoryExplorerTreeDataProviderImpl.java:79)
    at com.jaspersoft.jasperserver.war.model.TreeHelper.getSubtree(TreeHelper.java:66)
    at com.jaspersoft.jasperserver.war.action.tree.TreeAction.getNode(TreeAction.java:115)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.springframework.webflow.util.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:103)
    at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:136)
    at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:203)
    at org.springframework.webflow.engine.AnnotatedAction.execute(AnnotatedAction.java:142)
    at org.springframework.webflow.engine.ActionExecutor.execute(ActionExecutor.java:61)
    at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:180)
    at org.springframework.webflow.engine.State.enter(State.java:200)
    at org.springframework.webflow.engine.Transition.execute(Transition.java:229)
    at org.springframework.webflow.engine.DecisionState.doEnter(DecisionState.java:58)
    at org.springframework.webflow.engine.State.enter(State.java:200)
    at org.springframework.webflow.engine.Flow.start(Flow.java:557)
    at org.springframework.webflow.engine.impl.RequestControlContextImpl.start(RequestControlContextImpl.java:195)
    at org.springframework.webflow.engine.impl.FlowExecutionImpl.start(FlowExecutionImpl.java:189)
    at org.springframework.webflow.executor.FlowExecutorImpl.launch(FlowExecutorImpl.java:206)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
    at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
    at $Proxy13.launch(Unknown Source)
    at org.springframework.webflow.executor.support.FlowRequestHandler.handleFlowRequest(FlowRequestHandler.java:131)
    at org.springframework.webflow.executor.mvc.FlowController.handleRequestInternal(FlowController.java:170)
    at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
    at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45)
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:820)
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396)
    at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
    at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
    at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:141)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
    at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    at java.lang.Thread.run(Unknown Source)
08:23:20,337 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,400 DEBUG TransactionInterceptor,http-9080-2:305 - Completing transaction for [org.acegisecurity.acl.AclProvider.getAcls]
08:23:20,416 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,416 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@12f717c] for key [org.apache.tomcat.dbcp.dbcp.BasicDataSource@12b4986] bound to thread [http-9080-2]
08:23:20,416 DEBUG TransactionInterceptor,http-9080-2:275 - Getting transaction for [org.acegisecurity.acl.AclProvider.supports]
08:23:20,416 DEBUG TransactionInterceptor,http-9080-2:305 - Completing transaction for [org.acegisecurity.acl.AclProvider.supports]
08:23:20,416 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,416 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@12f717c] for key [org.apache.tomcat.dbcp.dbcp.BasicDataSource@12b4986] bound to thread [http-9080-2]
08:23:20,416 DEBUG TransactionInterceptor,http-9080-2:275 - Getting transaction for [org.acegisecurity.acl.AclProvider.getAcls]
08:23:20,416 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,416 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@12f717c] for key [org.apache.tomcat.dbcp.dbcp.BasicDataSource@12b4986] bound to thread [http-9080-2]
08:23:20,416 DEBUG TransactionInterceptor,http-9080-2:275 - Getting transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryUnsecure.getResourceUnsecure]
08:23:20,416 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,416 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@12f717c] for key [org.apache.tomcat.dbcp.dbcp.BasicDataSource@12b4986] bound to thread [http-9080-2]
08:23:20,416 DEBUG TransactionInterceptor,http-9080-2:275 - Getting transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryUnsecure.getResourceUnsecure]
08:23:20,416 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,416 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,416 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,431 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,431 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,431 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,431 DEBUG TransactionInterceptor,http-9080-2:305 - Completing transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryUnsecure.getResourceUnsecure]
08:23:20,431 DEBUG TransactionInterceptor,http-9080-2:305 - Completing transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryUnsecure.getResourceUnsecure]
08:23:20,431 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,431 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@12f717c] for key [org.apache.tomcat.dbcp.dbcp.BasicDataSource@12b4986] bound to thread [http-9080-2]
08:23:20,431 DEBUG TransactionInterceptor,http-9080-2:275 - Getting transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryUnsecure.getFolderUnsecure]
08:23:20,447 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,447 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@12f717c] for key [org.apache.tomcat.dbcp.dbcp.BasicDataSource@12b4986] bound to thread [http-9080-2]
08:23:20,447 DEBUG TransactionInterceptor,http-9080-2:275 - Getting transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryUnsecure.getFolderUnsecure]
08:23:20,447 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,447 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,447 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,447 DEBUG TransactionInterceptor,http-9080-2:305 - Completing transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryUnsecure.getFolderUnsecure]
08:23:20,447 DEBUG TransactionInterceptor,http-9080-2:305 - Completing transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryUnsecure.getFolderUnsecure]
08:23:20,447 DEBUG TransactionInterceptor,http-9080-2:305 - Completing transaction for [org.acegisecurity.acl.AclProvider.getAcls]
08:23:20,447 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,462 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,462 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,462 DEBUG TransactionInterceptor,http-9080-2:305 - Completing transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryService.getFolder]
08:23:20,462 DEBUG TransactionInterceptor,http-9080-2:305 - Completing transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryService.getFolder]
08:23:20,462 DEBUG TransactionSynchronizationManager,http-9080-2:272 - Clearing transaction synchronization
08:23:20,462 DEBUG TransactionSynchronizationManager,http-9080-2:190 - Removed value [org.springframework.orm.hibernate3.SessionHolder@183cee3] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] from thread [http-9080-2]
08:23:20,462 DEBUG TransactionSynchronizationManager,http-9080-2:190 - Removed value [org.springframework.jdbc.datasource.ConnectionHolder@12f717c] for key [org.apache.tomcat.dbcp.dbcp.BasicDataSource@12b4986] from thread [http-9080-2]
08:23:20,462 DEBUG TransactionSynchronizationManager,http-9080-2:166 - Bound value [org.springframework.jdbc.datasource.ConnectionHolder@1f85b60] for key [org.apache.tomcat.dbcp.dbcp.BasicDataSource@12b4986] to thread [http-9080-2]
08:23:20,462 DEBUG TransactionSynchronizationManager,http-9080-2:166 - Bound value [org.springframework.orm.hibernate3.SessionHolder@1976572] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] to thread [http-9080-2]
08:23:20,462 DEBUG TransactionSynchronizationManager,http-9080-2:219 - Initializing transaction synchronization
08:23:20,462 DEBUG TransactionInterceptor,http-9080-2:275 - Getting transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryService.getFolder]
08:23:20,462 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@1976572] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,462 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1f85b60] for key [org.apache.tomcat.dbcp.dbcp.BasicDataSource@12b4986] bound to thread [http-9080-2]
08:23:20,462 DEBUG TransactionInterceptor,http-9080-2:275 - Getting transaction for [com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryService.getFolder]
08:23:20,478 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@1976572] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,478 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1f85b60] for key [org.apache.tomcat.dbcp.dbcp.BasicDataSource@12b4986] bound to thread [http-9080-2]
08:23:20,478 DEBUG TransactionInterceptor,http-9080-2:275 - Getting transaction for [org.acegisecurity.acl.AclProvider.supports]
08:23:20,478 DEBUG TransactionInterceptor,http-9080-2:305 - Completing transaction for [org.acegisecurity.acl.AclProvider.supports]
08:23:20,478 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@1976572] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,478 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1f85b60] for key [org.apache.tomcat.dbcp.dbcp.BasicDataSource@12b4986] bound to thread [http-9080-2]
08:23:20,478 DEBUG TransactionInterceptor,http-9080-2:275 - Getting transaction for [org.acegisecurity.acl.AclProvider.getAcls]
08:23:20,478 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.orm.hibernate3.SessionHolder@1976572] for key [org.hibernate.impl.SessionFactoryImpl@d39c9f] bound to thread [http-9080-2]
08:23:20,478 DEBUG TransactionSynchronizationManager,http-9080-2:139 - Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1f85b60] for key [org.apache.tomcat.dbcp.dbcp.BasicDataSource@12b4986] bound to thread [http-908

[jsturnbull]

The answer looks like it might possibly found here

 

http://forums.mysql.com/read.php?39,139821,160175#msg-160175

[jsturnbull]

Ha! I'm an idiot. I revisited Lucian's answer and added in validationQuery="select * from jirole;" to the context.xml file which for some reason I failed to do initially and lo and behold that solved the problem. Thanks Lucian!

[developerdude]

So. I am running into this problem too. It seems to be a common problem with connection pooling - especially with MySQL and its 8 hour timeout (I had this problem with MySQL and C3PO in a completely different system).

 

I tried putting the autoReconnect=true and autoReconnectForPools=true settings in the URL and restarting Tomcat but it still had problems over the weekend. I guess I will also try the validation query and some other settings (testonborrow) in the pool next to see if that fixes it. From what I understand the two (autoreconnect and testonborrow) are essentially the same thing.

[developerdude]

Well, I added the following to the jdbc-connection-pool-params element in the jasperserverDS-jdbc.xml

<property name="validationQuery" value="select 1">
<property name="testOnBorrow" value="true">
<property name="testOnReturn" value="false">

I tried to add validationQuery="select * from jirole;" to the context.xml file, but it blew chunks on that - said there was no jirole table (although it worked fine on my local machine - just not on the server). So I changed it to 'select 1' and that worked. It ran overnight and so far no more exceptions.

[metricmine]

Code:

Hi, I'm getting this error against Vertica (per screenshot).  I am using Vertica as the source (JDBC).  I do not see this in context.xml or jasperserver.xml therefore the earlier suggested fixes do not help me.  Also tried to append "&autoReconnect=true" on a lark - just in case this mysql-specific syntax worked for vertica but it didn't.



Any advice would be appreciated.  Details in screenshots attached.