2019-05-31T14:22:29+00:00 DAEMON:dev grouper-api;grouper.log;grouper_dev;daemon;2019-05-31 10:22:29,641: [DefaultQuartzScheduler_Worker-9] WARN SqlExceptionHelper.logExceptions(127) - - SQL Error: 1451, SQLState: 23000 2019-05-31T14:22:29+00:00 DAEMON:dev grouper-api;grouper.log;grouper_dev;daemon;2019-05-31 10:22:29,641: [DefaultQuartzScheduler_Worker-9] WARN SqlExceptionHelper.logExceptions(127) - - SQL Error: 1451, SQLState: 23000 2019-05-31T14:22:29+00:00 DAEMON:dev grouper-api;grouper.log;grouper_dev;daemon;2019-05-31 10:22:29,641: [DefaultQuartzScheduler_Worker-9] ERROR SqlExceptionHelper.logExceptions(129) - - Cannot delete or update a parent row: a foreign key constraint fails (`grouper`.`grouper_group_set`, CONSTRAINT `fk_group_set_member_group_id` FOREIGN KEY (`member_group_id`) REFERENCES `grouper_groups` (`id`)) 2019-05-31T14:22:29+00:00 DAEMON:dev grouper-api;grouper.log;grouper_dev;daemon;2019-05-31 10:22:29,641: [DefaultQuartzScheduler_Worker-9] ERROR SqlExceptionHelper.logExceptions(129) - - Cannot delete or update a parent row: a foreign key constraint fails (`grouper`.`grouper_group_set`, CONSTRAINT `fk_group_set_member_group_id` FOREIGN KEY (`member_group_id`) REFERENCES `grouper_groups` (`id`)) 2019-05-31T14:22:29+00:00 DAEMON:dev grouper-api;grouper.log;grouper_dev;daemon;2019-05-31 10:22:29,641: [DefaultQuartzScheduler_Worker-9] ERROR BatchingBatch.performExecution(124) - - HHH000315: Exception executing batch [could not execute batch] 2019-05-31T14:22:29+00:00 DAEMON:dev grouper-api;grouper.log;grouper_dev;daemon;2019-05-31 10:22:29,641: [DefaultQuartzScheduler_Worker-9] ERROR BatchingBatch.performExecution(124) - - HHH000315: Exception executing batch [could not execute batch] 2019-05-31T14:22:29+00:00 DAEMON:dev grouper-api;grouper.log;grouper_dev;daemon;2019-05-31 10:22:29,729: [DefaultQuartzScheduler_Worker-9] WARN AbstractReadWriteEhcacheAccessStrategy.handleLockExpiry(173) - - HHH020008: Cache[edu.internet2.middleware.grouper.group.GroupSet] Key[edu.internet2.middleware.grouper.group.GroupSet#6ffa5d564cf94e31a28b604be1d27b7e] Lockable[(null)] 2019-05-31T14:22:29+00:00 DAEMON:dev A soft-locked cache entry was expired by the underlying Ehcache. If this happens regularly you should consider increasing the cache timeouts and/or capacity limits 2019-05-31T14:22:29+00:00 DAEMON:dev grouper-api;grouper.log;grouper_dev;daemon;2019-05-31 10:22:29,729: [DefaultQuartzScheduler_Worker-9] WARN AbstractReadWriteEhcacheAccessStrategy.handleLockExpiry(173) - - HHH020008: Cache[edu.internet2.middleware.grouper.group.GroupSet] Key[edu.internet2.middleware.grouper.group.GroupSet#6ffa5d564cf94e31a28b604be1d27b7e] Lockable[(null)] 2019-05-31T14:22:29+00:00 DAEMON:dev A soft-locked cache entry was expired by the underlying Ehcache. If this happens regularly you should consider increasing the cache timeouts and/or capacity limits 2019-05-31T14:22:29+00:00 DAEMON:dev grouper-api;grouper.log;grouper_dev;daemon;2019-05-31 10:22:29,729: [DefaultQuartzScheduler_Worker-9] WARN AbstractReadWriteEhcacheAccessStrategy.handleLockExpiry(173) - - HHH020008: Cache[edu.internet2.middleware.grouper.group.GroupSet] Key[edu.internet2.middleware.grouper.group.GroupSet#5263873d61ea4d6eb7803d86c7e98f53] Lockable[(null)] 2019-05-31T14:22:29+00:00 DAEMON:dev A soft-locked cache entry was expired by the underlying Ehcache. If this happens regularly you should consider increasing the cache timeouts and/or capacity limits 2019-05-31T14:22:29+00:00 DAEMON:dev grouper-api;grouper.log;grouper_dev;daemon;2019-05-31 10:22:29,729: [DefaultQuartzScheduler_Worker-9] WARN AbstractReadWriteEhcacheAccessStrategy.handleLockExpiry(173) - - HHH020008: Cache[edu.internet2.middleware.grouper.group.GroupSet] Key[edu.internet2.middleware.grouper.group.GroupSet#5263873d61ea4d6eb7803d86c7e98f53] Lockable[(null)] 2019-05-31T14:22:29+00:00 DAEMON:dev A soft-locked cache entry was expired by the underlying Ehcache. If this happens regularly you should consider increasing the cache timeouts and/or capacity limits 2019-05-31T14:22:29+00:00 DAEMON:dev grouper-api;grouper.log;grouper_dev;daemon;2019-05-31 10:22:29,730: [DefaultQuartzScheduler_Worker-9] ERROR GrouperLoaderType.syncGroupList(1689) - - Error on group: basis:byDept:ALL:PRESIDNT:AG_NATRS:60030000:60036000:Not Two-Factor 2019-05-31T14:22:29+00:00 DAEMON:dev java.lang.RuntimeException: Problem deleting groups for name: basis:byDept:ALL:PRESIDNT:AG_NATRS:60030000:60036000:Not Two-Factor, though did delete 0 groups 2019-05-31T14:22:29+00:00 DAEMON:dev at edu.internet2.middleware.grouper.hooks.examples.GroupTypeTupleIncludeExcludeHook.deleteGroupsIfNotUsed(GroupTypeTupleIncludeExcludeHook.java:1130) 2019-05-31T14:22:29+00:00 DAEMON:dev at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType.syncGroupList(GrouperLoaderType.java:1673) 2019-05-31T14:22:29+00:00 DAEMON:dev at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$4.runJob(GrouperLoaderType.java:540) 2019-05-31T14:22:29+00:00 DAEMON:dev at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(GrouperLoaderJob.java:465) 2019-05-31T14:22:29+00:00 DAEMON:dev at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.execute(GrouperLoaderJob.java:345) 2019-05-31T14:22:29+00:00 DAEMON:dev at org.quartz.core.JobRunShell.run(JobRunShell.java:202) 2019-05-31T14:22:29+00:00 DAEMON:dev at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) 2019-05-31T14:22:29+00:00 DAEMON:dev Caused by: edu.internet2.middleware.grouper.exception.GroupDeleteException: Problem in HibernateSession: HibernateSession (76c8277d): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (6b2c091e), stem name: basis:byDept:ALL:PRESIDNT:AG_NATRS:60030000:60036000:Not Two-Factor, group extension: Not Two-Factor, group dExtension: AG-ASSOC DEAN GRADUATE - Not Two-Factor, uuid: 09740d74e17646378755f0589955b1d9, , 2019-05-31T14:22:29+00:00 DAEMON:dev Problem in HibernateSession: HibernateSession (5bfb8ad7): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (6b2c091e) 2019-05-31T14:22:29+00:00 DAEMON:dev at edu.internet2.middleware.grouper.Group$6.callback(Group.java:1862) 2019-05-31T14:22:29+00:00 DAEMON:dev at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:701) 2019-05-31T14:22:29+00:00 DAEMON:dev at edu.internet2.middleware.grouper.Group.delete(Group.java:1761) 2019-05-31T14:22:29+00:00 DAEMON:dev at edu.internet2.middleware.grouper.hooks.examples.GroupTypeTupleIncludeExcludeHook.deleteGroupsIfNotUsed(GroupTypeTupleIncludeExcludeHook.java:1020) 2019-05-31T14:22:29+00:00 DAEMON:dev ... 6 more 2019-05-31T14:22:29+00:00 DAEMON:dev Caused by: edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem in HibernateSession: HibernateSession (76c8277d): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (6b2c091e) 2019-05-31T14:22:29+00:00 DAEMON:dev at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:589) 2019-05-31T14:22:29+00:00 DAEMON:dev at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:711) 2019-05-31T14:22:29+00:00 DAEMON:dev at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3GroupDAO.delete(Hib3GroupDAO.java:177) 2019-05-31T14:22:29+00:00 DAEMON:dev at edu.internet2.middleware.grouper.Group$6.callback(Group.java:1836) 2019-05-31T14:22:29+00:00 DAEMON:dev ... 9 more 2019-05-31T14:22:29+00:00 DAEMON:dev Caused by: org.hibernate.exception.ConstraintViolationException: could not execute batch 2019-05-31T14:22:29+00:00 DAEMON:dev at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112) 2019-05-31T14:22:29+00:00 DAEMON:dev at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) 2019-05-31T14:22:29+00:00 DAEMON:dev at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109) 2019-05-31T14:22:29+00:00 DAEMON:dev at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:119) 2019-05-31T14:22:29+00:00 DAEMON:dev at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:97) 2019-05-31T14:22:29+00:00 DAEMON:dev at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:147) 2019-05-31T14:22:29+00:00 DAEMON:dev at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:214) 2019-05-31T14:22:29+00:00 DAEMON:dev at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:611) 2019-05-31T14:22:29+00:00 DAEMON:dev at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:456) 2019-05-31T14:22:29+00:00 DAEMON:dev at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337) 2019-05-31T14:22:29+00:00 DAEMON:dev at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39) 2019-05-31T14:22:29+00:00 DAEMON:dev at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1282) 2019-05-31T14:22:29+00:00 DAEMON:dev at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionEnd(HibernateSession.java:509) 2019-05-31T14:22:29+00:00 DAEMON:dev at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:708) 2019-05-31T14:22:29+00:00 DAEMON:dev ... 11 more 2019-05-31T14:22:29+00:00 DAEMON:dev Caused by: java.sql.BatchUpdateException: Cannot delete or update a parent row: a foreign key constraint fails (`grouper`.`grouper_group_set`, CONSTRAINT `fk_group_set_member_group_id` FOREIGN KEY (`member_group_id`) REFERENCES `grouper_groups` (`id`)) 2019-05-31T14:22:29+00:00 DAEMON:dev at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2019-05-31T14:22:29+00:00 DAEMON:dev at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 2019-05-31T14:22:29+00:00 DAEMON:dev at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2019-05-31T14:22:29+00:00 DAEMON:dev at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 2019-05-31T14:22:29+00:00 DAEMON:dev at com.mysql.cj.util.Util.handleNewInstance(Util.java:192) 2019-05-31T14:22:29+00:00 DAEMON:dev at com.mysql.cj.util.Util.getInstance(Util.java:167) 2019-05-31T14:22:29+00:00 DAEMON:dev at com.mysql.cj.util.Util.getInstance(Util.java:174) 2019-05-31T14:22:29+00:00 DAEMON:dev at com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:224) 2019-05-31T14:22:29+00:00 DAEMON:dev at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:855) 2019-05-31T14:22:29+00:00 DAEMON:dev at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:437) 2019-05-31T14:22:29+00:00 DAEMON:dev at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:814) 2019-05-31T14:22:29+00:00 DAEMON:dev at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:2544) 2019-05-31T14:22:29+00:00 DAEMON:dev at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:110) 2019-05-31T14:22:29+00:00 DAEMON:dev ... 21 more 2019-05-31T14:22:29+00:00 DAEMON:dev Caused by: java.sql.SQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`grouper`.`grouper_group_set`, CONSTRAINT `fk_group_set_member_group_id` FOREIGN KEY (`member_group_id`) REFERENCES `grouper_groups` (`id`)) 2019-05-31T14:22:29+00:00 DAEMON:dev at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117) 2019-05-31T14:22:29+00:00 DAEMON:dev at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) 2019-05-31T14:22:29+00:00 DAEMON:dev at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) 2019-05-31T14:22:29+00:00 DAEMON:dev at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:955) 2019-05-31T14:22:29+00:00 DAEMON:dev at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1094) 2019-05-31T14:22:29+00:00 DAEMON:dev at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:834) 2019-05-31T14:22:29+00:00 DAEMON:dev ... 25 more