Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-2936

delete large group can cause errors

    XMLWordPrintable

Details

    • New Feature
    • Resolution: Unresolved
    • Minor
    • None
    • None
    • None
    • None

    Description

       2020-08-17 15:18:26,234: [Thread-38] INFO  EventLog.info(156) -  - [bf382128e19c43d7b508fd25cafda6e5,'IDM800047602','person'] delete group: 'OSU:WebLoginService:d91d059d92c7ccfc3185420a5f8aceff0ed8d99c:ref:kmdcust:kmdata-1588-reporting-health-sciences-library' (1697ms)
      2020-08-17 15:27:22,313: [Thread-39] ERROR UiV2Stem$4.run(2247) -  - Error obliterating folder: 'OSU:WebLoginService:d91d059d92c7ccfc3185420a5f8aceff0ed8d99c:ref:kmdcust'
      edu.internet2.middleware.grouper.exception.GroupDeleteException: Problem in HibernateSession: HibernateSession (43c01472): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (1b980f66),
      Exception in list: (class edu.internet2.middleware.grouper.Composite), ByHqlStatic, query: 'select c from Composite as c, GroupSet as gs, Field as f where gs.memberGroupId = :group and ( c.leftFactorUuid = gs.ownerGroupId or c.rightFactorUuid = gs.ownerGroupId ) and gs.fieldId = f.uuid and gs.fieldId = :field', cacheable: false, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3CompositeDAO.findAsFactorOrHasMemberOfFactor, tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 'group'->'ed42feeffc7e46b6ae70ebc846ba2592'Bind var[1]: 'Param (class java.lang.String): 'field'->'6142a7efff744cfd8a9dae4058c5d64b', ,
      Exception in delete: edu.internet2.middleware.grouper.Membership, edu.internet2.middleware.grouper.hibernate.ByObject@7270790a,
      Problem in HibernateSession: HibernateSession (7c1bdf16): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (1b980f66),
      Exception in delete: edu.internet2.middleware.grouper.Membership, ByObjectStatic, query: ', cacheable: null, cacheRegion: null, entityName: ImmediateMembershipEntry, tx type: null,
      Problem in HibernateSession: HibernateSession (4657063e): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (1b980f66),
      Problem in HibernateSession: HibernateSession (4cf9cafe): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (1b980f66), stem name: OSU:WebLoginService:d91d059d92c7ccfc3185420a5f8aceff0ed8d99c:ref:kmdcust:kmdata-1430-system-reporting-–-all-osu, group extension: kmdata-1430-system-reporting-–-all-osu, group dExtension: Reporting – All OSU, uuid: ed42feeffc7e46b6ae70ebc846ba2592, ,
      Problem in HibernateSession: HibernateSession (63abdaa8): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (1b980f66)
              at edu.internet2.middleware.grouper.Group$6.callback(Group.java:2076)
              at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:703)
              at edu.internet2.middleware.grouper.Group.delete(Group.java:1975)
              at edu.internet2.middleware.grouper.Stem.deleteGroups(Stem.java:5522)
              at edu.internet2.middleware.grouper.grouperUi.serviceLogic.UiV2Stem.stemDeleteSubmitHelper(UiV2Stem.java:2327)
              at edu.internet2.middleware.grouper.grouperUi.serviceLogic.UiV2Stem$4.run(UiV2Stem.java:2242)
              at java.lang.Thread.run(Thread.java:748)
      Caused by: edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem in HibernateSession: HibernateSession (43c01472): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (1b980f66),
      Exception in list: (class edu.internet2.middleware.grouper.Composite), ByHqlStatic, query: 'select c from Composite as c, GroupSet as gs, Field as f where gs.memberGroupId = :group and ( c.leftFactorUuid = gs.ownerGroupId or c.rightFactorUuid = gs.ownerGroupId ) and gs.fieldId = f.uuid and gs.fieldId = :field', cacheable: false, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3CompositeDAO.findAsFactorOrHasMemberOfFactor, tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 'group'->'ed42feeffc7e46b6ae70ebc846ba2592'Bind var[1]: 'Param (class java.lang.String): 'field'->'6142a7efff744cfd8a9dae4058c5d64b', ,
      Exception in delete: edu.internet2.middleware.grouper.Membership, edu.internet2.middleware.grouper.hibernate.ByObject@7270790a,
      Problem in HibernateSession: HibernateSession (7c1bdf16): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (1b980f66),
      Exception in delete: edu.internet2.middleware.grouper.Membership, ByObjectStatic, query: ', cacheable: null, cacheRegion: null, entityName: ImmediateMembershipEntry, tx type: null,
      Problem in HibernateSession: HibernateSession (4657063e): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (1b980f66),
      Problem in HibernateSession: HibernateSession (4cf9cafe): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (1b980f66)
              at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:591)
              at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:713)
              at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.list(ByHqlStatic.java:407)
              at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.listSet(ByHqlStatic.java:458)
              at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3CompositeDAO.findAsFactorOrHasMemberOfFactor(Hib3CompositeDAO.java:78)
              at edu.internet2.middleware.grouper.Membership.processPostMembershipDelete(Membership.java:2116)
              at edu.internet2.middleware.grouper.Membership.onPostDelete(Membership.java:2006)
              at edu.internet2.middleware.grouper.hibernate.ByObject.delete(ByObject.java:126)
              at edu.internet2.middleware.grouper.hibernate.ByObjectStatic$10.callback(ByObjectStatic.java:675)
              at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:703)
              at edu.internet2.middleware.grouper.hibernate.ByObjectStatic.delete(ByObjectStatic.java:662)
              at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO.delete(Hib3MembershipDAO.java:2247)
              at edu.internet2.middleware.grouper.Membership$2$1.callback(Membership.java:580)
              at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:976)
              at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1024)
              at edu.internet2.middleware.grouper.Membership$2.callback(Membership.java:570)
              at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:703)
              at edu.internet2.middleware.grouper.Membership.delete(Membership.java:564)
              at edu.internet2.middleware.grouper.Membership$3.callback(Membership.java:1458)
              at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:703)
              at edu.internet2.middleware.grouper.Membership.internal_deleteAllField(Membership.java:1437)
              at edu.internet2.middleware.grouper.Membership.internal_deleteAllFieldType(Membership.java:1544)
              at edu.internet2.middleware.grouper.Group$6$1.callback(Group.java:2015)
              at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:976)
              at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1024)
              at edu.internet2.middleware.grouper.Group$6.callback(Group.java:2011)
              ... 6 more
      Caused by: org.hibernate.exception.LockAcquisitionException: could not execute batch
              at org.hibernate.dialect.MySQLDialect$3.convert(MySQLDialect.java:524)
              at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
              at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
              at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:119)
              at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:97)
              at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:147)
              at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:214)
              at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:611)
              at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:456)
              at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)
              at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
              at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1282)
              at edu.internet2.middleware.grouper.hibernate.HibUtils.evict(HibUtils.java:536)
              at edu.internet2.middleware.grouper.hibernate.HibUtils.evict(HibUtils.java:471)
              at edu.internet2.middleware.grouper.hibernate.HibUtils.evict(HibUtils.java:450)
              at edu.internet2.middleware.grouper.hibernate.ByHql.list(ByHql.java:382)
              at edu.internet2.middleware.grouper.hibernate.ByHqlStatic$2.callback(ByHqlStatic.java:417)
              at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:703)
              ... 30 more
      Caused by: java.sql.BatchUpdateException: Lock wait timeout exceeded; try restarting transaction
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
              at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
              at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
              at com.mysql.jdbc.Util.getInstance(Util.java:408)
              at com.mysql.jdbc.SQLError.createBatchUpdateException(SQLError.java:1163)
              at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1778)
              at com.mysql.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1262)
              at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:970)
              at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:2544)
              at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:110)
              ... 44 more
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
              at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
              at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
              at com.mysql.jdbc.Util.getInstance(Util.java:408)
              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:952)
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
              at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
              at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
              at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
              at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
              at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079)
              at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1756)
              ... 48 more 

      Attachments

        Activity

          People

            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: