0 Replies Latest reply on Apr 1, 2014 4:54 PM by ndrw_cheung

    Could not delete collection rows problem

    ndrw_cheung

      Hi. 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