Could not delete collection rows problem
ndrw_cheung Apr 1, 2014 4:54 PMHi. Not sure if this is the right place to post this question,but since the error message has to do with picketlink, I thought I might be able to get some help from this forum.
I'm using JBOSS EPP5.2.1 and our authentication mechanism is done against Novell eDirectory. I noticed the following error in the log when the application server hangs. What causes the problem and how can I fix the problem?
Any help is appreciated.
-Andrew
server.log :
2014-03-28 17:03:50,927 ERROR [STDERR] (http-10.10.10.89-8380-3) org.hibernate.exception.GenericJDBCException: could not delete collection rows: [org.picketlink.idm.impl.model.hibernate.HibernateIdentityObjectAttribute.textValues#716]
2014-03-28 17:03:50,927 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
2014-03-28 17:03:50,927 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
2014-03-28 17:03:50,927 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
2014-03-28 17:03:50,927 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.hibernate.persister.collection.AbstractCollectionPersister.deleteRows(AbstractCollectionPersister.java:1314)
2014-03-28 17:03:50,927 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.hibernate.action.CollectionUpdateAction.execute(CollectionUpdateAction.java:84)
2014-03-28 17:03:50,927 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:278)
2014-03-28 17:03:50,927 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:262)
2014-03-28 17:03:50,927 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:169)
2014-03-28 17:03:50,927 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
2014-03-28 17:03:50,927 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
2014-03-28 17:03:50,927 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1030)
2014-03-28 17:03:50,927 ERROR [STDERR] (http-10.10.10.89-8380-3) at sun.reflect.GeneratedMethodAccessor420.invoke(Unknown Source)
2014-03-28 17:03:50,927 ERROR [STDERR] (http-10.10.10.89-8380-3) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2014-03-28 17:03:50,927 ERROR [STDERR] (http-10.10.10.89-8380-3) at java.lang.reflect.Method.invoke(Method.java:597)
2014-03-28 17:03:50,927 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:343)
2014-03-28 17:03:50,927 ERROR [STDERR] (http-10.10.10.89-8380-3) at $Proxy297.flush(Unknown Source)
2014-03-28 17:03:50,928 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.picketlink.idm.impl.store.hibernate.HibernateIdentityStoreSessionImpl.save(HibernateIdentityStoreSessionImpl.java:57)
2014-03-28 17:03:50,928 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.picketlink.idm.impl.repository.RepositoryIdentityStoreSessionImpl.save(RepositoryIdentityStoreSessionImpl.java:75)
2014-03-28 17:03:50,928 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.picketlink.idm.impl.api.session.IdentitySessionImpl.save(IdentitySessionImpl.java:206)
2014-03-28 17:03:50,928 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.exoplatform.services.organization.idm.PicketLinkIDMOrganizationServiceImpl.flush(PicketLinkIDMOrganizationServiceImpl.java:200)
2014-03-28 17:03:50,928 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.exoplatform.services.organization.idm.UserDAOImpl.getPopulatedUser(UserDAOImpl.java:802)
2014-03-28 17:03:50,928 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.exoplatform.services.organization.idm.UserDAOImpl.findUserByName(UserDAOImpl.java:311)
2014-03-28 17:03:50,928 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.exoplatform.services.organization.idm.UserDAOImpl.authenticate(UserDAOImpl.java:378)
2014-03-28 17:03:50,928 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.exoplatform.services.organization.auth.OrganizationAuthenticatorImpl.validateUser(OrganizationAuthenticatorImpl.java:150)
2014-03-28 17:03:50,928 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.exoplatform.services.security.jaas.SharedStateLoginModule.login(SharedStateLoginModule.java:70)
2014-03-28 17:03:50,928 ERROR [STDERR] (http-10.10.10.89-8380-3) at sun.reflect.GeneratedMethodAccessor51880.invoke(Unknown Source)
2014-03-28 17:03:50,928 ERROR [STDERR] (http-10.10.10.89-8380-3) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at java.lang.reflect.Method.invoke(Method.java:597)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at javax.security.auth.login.LoginContext.invoke(LoginContext.java:769)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at javax.security.auth.login.LoginContext.access$000(LoginContext.java:186)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at javax.security.auth.login.LoginContext$4.run(LoginContext.java:683)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at java.security.AccessController.doPrivileged(Native Method)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at javax.security.auth.login.LoginContext.invokePriv(LoginContext.java:680)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at javax.security.auth.login.LoginContext.login(LoginContext.java:579)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.jboss.security.plugins.auth.JaasSecurityManagerBase.defaultLogin(JaasSecurityManagerBase.java:553)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.jboss.security.plugins.auth.JaasSecurityManagerBase.authenticate(JaasSecurityManagerBase.java:487)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.jboss.security.plugins.auth.JaasSecurityManagerBase.isValid(JaasSecurityManagerBase.java:365)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.jboss.security.plugins.JaasSecurityManager.isValid(JaasSecurityManager.java:160)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.jboss.web.tomcat.security.JBossWebRealm.authenticate(JBossWebRealm.java:399)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAuthenticator.java:258)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:426)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:95)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.jboss.web.tomcat.service.request.ActiveRequestResponseCacheValve.internalProcess(ActiveRequestResponseCacheValve.java:74)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.jboss.web.tomcat.service.request.ActiveRequestResponseCacheValve.invoke(ActiveRequestResponseCacheValve.java:47)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:599)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:451)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at java.lang.Thread.run(Thread.java:662)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) Caused by: java.sql.SQLException: Connection is not associated with a managed connection.org.jboss.resource.adapter.jdbc.jdk6.WrappedConnectionJDK6@8876a2
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.jboss.resource.adapter.jdbc.WrappedConnection.lock(WrappedConnection.java:97)
2014-03-28 17:03:50,929 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:254)
2014-03-28 17:03:50,930 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
2014-03-28 17:03:50,930 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:116)
2014-03-28 17:03:50,930 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
2014-03-28 17:03:50,930 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)
2014-03-28 17:03:50,930 ERROR [STDERR] (http-10.10.10.89-8380-3) at org.hibernate.persister.collection.AbstractCollectionPersister.deleteRows(AbstractCollectionPersister.java:1252)
2014-03-28 17:03:50,930 ERROR [STDERR] (http-10.10.10.89-8380-3) ... 51 more