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

    Could not delete collection rows problem

    Andrew Cheung Newbie

      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