org.opentest4j.AssertionFailedError: 
expected: 0L
 but was: 1L
	at app//de.tum.cit.aet.artemis.communication.MessageIntegrationTest.lambda$testDecreaseUnreadMessageCountWhenDeletingMessage$28(MessageIntegrationTest.java:725)
	at app//org.awaitility.core.AssertionCondition.lambda$new$0(AssertionCondition.java:53)
	at app//org.awaitility.core.ConditionAwaiter$ConditionPoller.call(ConditionAwaiter.java:248)
	at app//org.awaitility.core.ConditionAwaiter$ConditionPoller.call(ConditionAwaiter.java:235)
	at [email protected]/java.util.concurrent.FutureTask.run(FutureTask.java:317)
	at [email protected]/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
	at [email protected]/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
	at [email protected]/java.lang.Thread.run(Thread.java:1583)

org.springframework.dao.DataIntegrityViolationException: could not execute batch [Referential integrity constraint violation: "FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]] [delete from conversation where id=?]; SQL [delete from conversation where id=?]; constraint ["FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]]
	at app//org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:290)
	at app//org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:241)
	at app//org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:566)
	at app//org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:795)
	at app//org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:758)
	at app//org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:663)
	at app//org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:413)
	at app//org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:138)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:165)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:223)
	at app/jdk.proxy3/jdk.proxy3.$Proxy388.deleteAll(Unknown Source)
	at app//de.tum.cit.aet.artemis.communication.OneToOneChatIntegrationTest.tearDown(OneToOneChatIntegrationTest.java:42)
	at [email protected]/java.lang.reflect.Method.invoke(Method.java:580)
	at [email protected]/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387)
	at [email protected]/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1312)
	at [email protected]/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1843)
	at [email protected]/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1808)
	at [email protected]/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:188)
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute batch [Referential integrity constraint violation: "FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]] [delete from conversation where id=?]
	at app//org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:97)
	at app//org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:58)
	at app//org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:108)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.lambda$performExecution$2(BatchImpl.java:294)
	at app//org.hibernate.engine.jdbc.mutation.internal.PreparedStatementGroupSingleTable.forEachStatement(PreparedStatementGroupSingleTable.java:59)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.performExecution(BatchImpl.java:264)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.execute(BatchImpl.java:242)
	at app//org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.getBatch(JdbcCoordinatorImpl.java:173)
	at app//org.hibernate.engine.jdbc.mutation.internal.MutationExecutorSingleBatched.resolveBatch(MutationExecutorSingleBatched.java:47)
	at app//org.hibernate.engine.jdbc.mutation.internal.MutationExecutorSingleBatched.getStatementGroup(MutationExecutorSingleBatched.java:40)
	at app//org.hibernate.engine.jdbc.mutation.internal.AbstractSingleMutationExecutor.getPreparedStatementDetails(AbstractSingleMutationExecutor.java:45)
	at app//org.hibernate.persister.entity.mutation.AbstractDeleteCoordinator.doStaticDelete(AbstractDeleteCoordinator.java:265)
	at app//org.hibernate.persister.entity.mutation.AbstractDeleteCoordinator.coordinateDelete(AbstractDeleteCoordinator.java:87)
	at app//org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2973)
	at app//org.hibernate.action.internal.EntityDeleteAction.execute(EntityDeleteAction.java:131)
	at app//org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:632)
	at app//org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:499)
	at app//org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:377)
	at app//org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:41)
	at app//org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:127)
	at app//org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1407)
	at app//org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:488)
	at app//org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:2329)
	at app//org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:1986)
	at app//org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:439)
	at app//org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:169)
	at app//org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:267)
	at app//org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101)
	at app//org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:562)
	... 21 more
Caused by: org.h2.jdbc.JdbcBatchUpdateException: Referential integrity constraint violation: "FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]
	at app//org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1282)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.lambda$performExecution$2(BatchImpl.java:279)
	... 46 more

org.springframework.dao.DataIntegrityViolationException: could not execute batch [Referential integrity constraint violation: "FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]] [delete from conversation where id=?]; SQL [delete from conversation where id=?]; constraint ["FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]]
	at app//org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:290)
	at app//org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:241)
	at app//org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:566)
	at app//org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:795)
	at app//org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:758)
	at app//org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:663)
	at app//org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:413)
	at app//org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:138)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:165)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:223)
	at app/jdk.proxy3/jdk.proxy3.$Proxy388.deleteAll(Unknown Source)
	at app//de.tum.cit.aet.artemis.communication.OneToOneChatIntegrationTest.tearDown(OneToOneChatIntegrationTest.java:42)
	at [email protected]/java.lang.reflect.Method.invoke(Method.java:580)
	at [email protected]/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387)
	at [email protected]/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1312)
	at [email protected]/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1843)
	at [email protected]/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1808)
	at [email protected]/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:188)
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute batch [Referential integrity constraint violation: "FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]] [delete from conversation where id=?]
	at app//org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:97)
	at app//org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:58)
	at app//org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:108)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.lambda$performExecution$2(BatchImpl.java:294)
	at app//org.hibernate.engine.jdbc.mutation.internal.PreparedStatementGroupSingleTable.forEachStatement(PreparedStatementGroupSingleTable.java:59)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.performExecution(BatchImpl.java:264)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.execute(BatchImpl.java:242)
	at app//org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.getBatch(JdbcCoordinatorImpl.java:173)
	at app//org.hibernate.engine.jdbc.mutation.internal.MutationExecutorSingleBatched.resolveBatch(MutationExecutorSingleBatched.java:47)
	at app//org.hibernate.engine.jdbc.mutation.internal.MutationExecutorSingleBatched.getStatementGroup(MutationExecutorSingleBatched.java:40)
	at app//org.hibernate.engine.jdbc.mutation.internal.AbstractSingleMutationExecutor.getPreparedStatementDetails(AbstractSingleMutationExecutor.java:45)
	at app//org.hibernate.persister.entity.mutation.AbstractDeleteCoordinator.doStaticDelete(AbstractDeleteCoordinator.java:265)
	at app//org.hibernate.persister.entity.mutation.AbstractDeleteCoordinator.coordinateDelete(AbstractDeleteCoordinator.java:87)
	at app//org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2973)
	at app//org.hibernate.action.internal.EntityDeleteAction.execute(EntityDeleteAction.java:131)
	at app//org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:632)
	at app//org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:499)
	at app//org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:377)
	at app//org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:41)
	at app//org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:127)
	at app//org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1407)
	at app//org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:488)
	at app//org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:2329)
	at app//org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:1986)
	at app//org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:439)
	at app//org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:169)
	at app//org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:267)
	at app//org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101)
	at app//org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:562)
	... 21 more
Caused by: org.h2.jdbc.JdbcBatchUpdateException: Referential integrity constraint violation: "FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]
	at app//org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1282)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.lambda$performExecution$2(BatchImpl.java:279)
	... 46 more

org.springframework.dao.DataIntegrityViolationException: could not execute batch [Referential integrity constraint violation: "FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]] [delete from conversation where id=?]; SQL [delete from conversation where id=?]; constraint ["FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]]
	at app//org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:290)
	at app//org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:241)
	at app//org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:566)
	at app//org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:795)
	at app//org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:758)
	at app//org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:663)
	at app//org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:413)
	at app//org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:138)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:165)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:223)
	at app/jdk.proxy3/jdk.proxy3.$Proxy388.deleteAll(Unknown Source)
	at app//de.tum.cit.aet.artemis.communication.OneToOneChatIntegrationTest.tearDown(OneToOneChatIntegrationTest.java:42)
	at [email protected]/java.lang.reflect.Method.invoke(Method.java:580)
	at [email protected]/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387)
	at [email protected]/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1312)
	at [email protected]/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1843)
	at [email protected]/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1808)
	at [email protected]/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:188)
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute batch [Referential integrity constraint violation: "FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]] [delete from conversation where id=?]
	at app//org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:97)
	at app//org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:58)
	at app//org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:108)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.lambda$performExecution$2(BatchImpl.java:294)
	at app//org.hibernate.engine.jdbc.mutation.internal.PreparedStatementGroupSingleTable.forEachStatement(PreparedStatementGroupSingleTable.java:59)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.performExecution(BatchImpl.java:264)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.execute(BatchImpl.java:242)
	at app//org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.getBatch(JdbcCoordinatorImpl.java:173)
	at app//org.hibernate.engine.jdbc.mutation.internal.MutationExecutorSingleBatched.resolveBatch(MutationExecutorSingleBatched.java:47)
	at app//org.hibernate.engine.jdbc.mutation.internal.MutationExecutorSingleBatched.getStatementGroup(MutationExecutorSingleBatched.java:40)
	at app//org.hibernate.engine.jdbc.mutation.internal.AbstractSingleMutationExecutor.getPreparedStatementDetails(AbstractSingleMutationExecutor.java:45)
	at app//org.hibernate.persister.entity.mutation.AbstractDeleteCoordinator.doStaticDelete(AbstractDeleteCoordinator.java:265)
	at app//org.hibernate.persister.entity.mutation.AbstractDeleteCoordinator.coordinateDelete(AbstractDeleteCoordinator.java:87)
	at app//org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2973)
	at app//org.hibernate.action.internal.EntityDeleteAction.execute(EntityDeleteAction.java:131)
	at app//org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:632)
	at app//org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:499)
	at app//org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:377)
	at app//org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:41)
	at app//org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:127)
	at app//org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1407)
	at app//org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:488)
	at app//org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:2329)
	at app//org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:1986)
	at app//org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:439)
	at app//org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:169)
	at app//org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:267)
	at app//org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101)
	at app//org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:562)
	... 21 more
Caused by: org.h2.jdbc.JdbcBatchUpdateException: Referential integrity constraint violation: "FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]
	at app//org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1282)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.lambda$performExecution$2(BatchImpl.java:279)
	... 46 more

org.springframework.dao.DataIntegrityViolationException: could not execute batch [Referential integrity constraint violation: "FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]] [delete from conversation where id=?]; SQL [delete from conversation where id=?]; constraint ["FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]]
	at app//org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:290)
	at app//org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:241)
	at app//org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:566)
	at app//org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:795)
	at app//org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:758)
	at app//org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:663)
	at app//org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:413)
	at app//org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:138)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:165)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:223)
	at app/jdk.proxy3/jdk.proxy3.$Proxy388.deleteAll(Unknown Source)
	at app//de.tum.cit.aet.artemis.communication.OneToOneChatIntegrationTest.tearDown(OneToOneChatIntegrationTest.java:42)
	at [email protected]/java.lang.reflect.Method.invoke(Method.java:580)
	at [email protected]/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387)
	at [email protected]/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1312)
	at [email protected]/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1843)
	at [email protected]/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1808)
	at [email protected]/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:188)
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute batch [Referential integrity constraint violation: "FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]] [delete from conversation where id=?]
	at app//org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:97)
	at app//org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:58)
	at app//org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:108)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.lambda$performExecution$2(BatchImpl.java:294)
	at app//org.hibernate.engine.jdbc.mutation.internal.PreparedStatementGroupSingleTable.forEachStatement(PreparedStatementGroupSingleTable.java:59)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.performExecution(BatchImpl.java:264)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.execute(BatchImpl.java:242)
	at app//org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.getBatch(JdbcCoordinatorImpl.java:173)
	at app//org.hibernate.engine.jdbc.mutation.internal.MutationExecutorSingleBatched.resolveBatch(MutationExecutorSingleBatched.java:47)
	at app//org.hibernate.engine.jdbc.mutation.internal.MutationExecutorSingleBatched.getStatementGroup(MutationExecutorSingleBatched.java:40)
	at app//org.hibernate.engine.jdbc.mutation.internal.AbstractSingleMutationExecutor.getPreparedStatementDetails(AbstractSingleMutationExecutor.java:45)
	at app//org.hibernate.persister.entity.mutation.AbstractDeleteCoordinator.doStaticDelete(AbstractDeleteCoordinator.java:265)
	at app//org.hibernate.persister.entity.mutation.AbstractDeleteCoordinator.coordinateDelete(AbstractDeleteCoordinator.java:87)
	at app//org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2973)
	at app//org.hibernate.action.internal.EntityDeleteAction.execute(EntityDeleteAction.java:131)
	at app//org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:632)
	at app//org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:499)
	at app//org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:377)
	at app//org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:41)
	at app//org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:127)
	at app//org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1407)
	at app//org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:488)
	at app//org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:2329)
	at app//org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:1986)
	at app//org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:439)
	at app//org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:169)
	at app//org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:267)
	at app//org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101)
	at app//org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:562)
	... 21 more
Caused by: org.h2.jdbc.JdbcBatchUpdateException: Referential integrity constraint violation: "FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]
	at app//org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1282)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.lambda$performExecution$2(BatchImpl.java:279)
	... 46 more

org.springframework.dao.DataIntegrityViolationException: could not execute batch [Referential integrity constraint violation: "FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]] [delete from conversation where id=?]; SQL [delete from conversation where id=?]; constraint ["FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]]
	at app//org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:290)
	at app//org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:241)
	at app//org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:566)
	at app//org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:795)
	at app//org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:758)
	at app//org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:663)
	at app//org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:413)
	at app//org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:138)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:165)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:223)
	at app/jdk.proxy3/jdk.proxy3.$Proxy388.deleteAll(Unknown Source)
	at app//de.tum.cit.aet.artemis.communication.OneToOneChatIntegrationTest.tearDown(OneToOneChatIntegrationTest.java:42)
	at [email protected]/java.lang.reflect.Method.invoke(Method.java:580)
	at [email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
	at [email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
	at [email protected]/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:179)
	at [email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
	at [email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
	at [email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
	at [email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
	at [email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
	at [email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
	at [email protected]/java.util.Iterator.forEachRemaining(Iterator.java:133)
	at [email protected]/java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1939)
	at [email protected]/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
	at [email protected]/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
	at [email protected]/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
	at [email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
	at [email protected]/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at [email protected]/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
	at [email protected]/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:276)
	at [email protected]/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1708)
	at [email protected]/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
	at [email protected]/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
	at [email protected]/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
	at [email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
	at [email protected]/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at [email protected]/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
	at [email protected]/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:276)
	at [email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
	at [email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
	at [email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
	at [email protected]/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1708)
	at [email protected]/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
	at [email protected]/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
	at [email protected]/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
	at [email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
	at [email protected]/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at [email protected]/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
	at [email protected]/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:276)
	at [email protected]/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1708)
	at [email protected]/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
	at [email protected]/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
	at [email protected]/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
	at [email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
	at [email protected]/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at [email protected]/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
	at [email protected]/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387)
	at [email protected]/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1312)
	at [email protected]/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1843)
	at [email protected]/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1808)
	at [email protected]/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:188)
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute batch [Referential integrity constraint violation: "FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]] [delete from conversation where id=?]
	at app//org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:97)
	at app//org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:58)
	at app//org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:108)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.lambda$performExecution$2(BatchImpl.java:294)
	at app//org.hibernate.engine.jdbc.mutation.internal.PreparedStatementGroupSingleTable.forEachStatement(PreparedStatementGroupSingleTable.java:59)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.performExecution(BatchImpl.java:264)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.execute(BatchImpl.java:242)
	at app//org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.getBatch(JdbcCoordinatorImpl.java:173)
	at app//org.hibernate.engine.jdbc.mutation.internal.MutationExecutorSingleBatched.resolveBatch(MutationExecutorSingleBatched.java:47)
	at app//org.hibernate.engine.jdbc.mutation.internal.MutationExecutorSingleBatched.getStatementGroup(MutationExecutorSingleBatched.java:40)
	at app//org.hibernate.engine.jdbc.mutation.internal.AbstractSingleMutationExecutor.getPreparedStatementDetails(AbstractSingleMutationExecutor.java:45)
	at app//org.hibernate.persister.entity.mutation.AbstractDeleteCoordinator.doStaticDelete(AbstractDeleteCoordinator.java:265)
	at app//org.hibernate.persister.entity.mutation.AbstractDeleteCoordinator.coordinateDelete(AbstractDeleteCoordinator.java:87)
	at app//org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2973)
	at app//org.hibernate.action.internal.EntityDeleteAction.execute(EntityDeleteAction.java:131)
	at app//org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:632)
	at app//org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:499)
	at app//org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:377)
	at app//org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:41)
	at app//org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:127)
	at app//org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1407)
	at app//org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:488)
	at app//org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:2329)
	at app//org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:1986)
	at app//org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:439)
	at app//org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:169)
	at app//org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:267)
	at app//org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101)
	at app//org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:562)
	... 65 more
Caused by: org.h2.jdbc.JdbcBatchUpdateException: Referential integrity constraint violation: "FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]
	at app//org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1282)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.lambda$performExecution$2(BatchImpl.java:279)
	... 90 more

org.springframework.dao.DataIntegrityViolationException: could not execute batch [Referential integrity constraint violation: "FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]] [delete from conversation where id=?]; SQL [delete from conversation where id=?]; constraint ["FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]]
	at app//org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:290)
	at app//org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:241)
	at app//org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:566)
	at app//org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:795)
	at app//org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:758)
	at app//org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:663)
	at app//org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:413)
	at app//org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:138)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:165)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:223)
	at app/jdk.proxy3/jdk.proxy3.$Proxy388.deleteAll(Unknown Source)
	at app//de.tum.cit.aet.artemis.communication.OneToOneChatIntegrationTest.tearDown(OneToOneChatIntegrationTest.java:42)
	at [email protected]/java.lang.reflect.Method.invoke(Method.java:580)
	at [email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
	at [email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
	at [email protected]/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:179)
	at [email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
	at [email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
	at [email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
	at [email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
	at [email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
	at [email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
	at [email protected]/java.util.Iterator.forEachRemaining(Iterator.java:133)
	at [email protected]/java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1939)
	at [email protected]/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
	at [email protected]/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
	at [email protected]/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
	at [email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
	at [email protected]/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at [email protected]/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
	at [email protected]/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:276)
	at [email protected]/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1708)
	at [email protected]/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
	at [email protected]/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
	at [email protected]/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
	at [email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
	at [email protected]/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at [email protected]/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
	at [email protected]/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:276)
	at [email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
	at [email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
	at [email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
	at [email protected]/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1708)
	at [email protected]/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
	at [email protected]/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
	at [email protected]/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
	at [email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
	at [email protected]/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at [email protected]/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
	at [email protected]/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:276)
	at [email protected]/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1708)
	at [email protected]/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
	at [email protected]/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
	at [email protected]/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
	at [email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
	at [email protected]/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at [email protected]/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
	at [email protected]/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387)
	at [email protected]/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1312)
	at [email protected]/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1843)
	at [email protected]/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1808)
	at [email protected]/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:188)
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute batch [Referential integrity constraint violation: "FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]] [delete from conversation where id=?]
	at app//org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:97)
	at app//org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:58)
	at app//org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:108)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.lambda$performExecution$2(BatchImpl.java:294)
	at app//org.hibernate.engine.jdbc.mutation.internal.PreparedStatementGroupSingleTable.forEachStatement(PreparedStatementGroupSingleTable.java:59)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.performExecution(BatchImpl.java:264)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.execute(BatchImpl.java:242)
	at app//org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.getBatch(JdbcCoordinatorImpl.java:173)
	at app//org.hibernate.engine.jdbc.mutation.internal.MutationExecutorSingleBatched.resolveBatch(MutationExecutorSingleBatched.java:47)
	at app//org.hibernate.engine.jdbc.mutation.internal.MutationExecutorSingleBatched.getStatementGroup(MutationExecutorSingleBatched.java:40)
	at app//org.hibernate.engine.jdbc.mutation.internal.AbstractSingleMutationExecutor.getPreparedStatementDetails(AbstractSingleMutationExecutor.java:45)
	at app//org.hibernate.persister.entity.mutation.AbstractDeleteCoordinator.doStaticDelete(AbstractDeleteCoordinator.java:265)
	at app//org.hibernate.persister.entity.mutation.AbstractDeleteCoordinator.coordinateDelete(AbstractDeleteCoordinator.java:87)
	at app//org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2973)
	at app//org.hibernate.action.internal.EntityDeleteAction.execute(EntityDeleteAction.java:131)
	at app//org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:632)
	at app//org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:499)
	at app//org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:377)
	at app//org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:41)
	at app//org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:127)
	at app//org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1407)
	at app//org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:488)
	at app//org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:2329)
	at app//org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:1986)
	at app//org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:439)
	at app//org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:169)
	at app//org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:267)
	at app//org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101)
	at app//org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:562)
	... 65 more
Caused by: org.h2.jdbc.JdbcBatchUpdateException: Referential integrity constraint violation: "FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]
	at app//org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1282)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.lambda$performExecution$2(BatchImpl.java:279)
	... 90 more

org.springframework.dao.DataIntegrityViolationException: could not execute batch [Referential integrity constraint violation: "FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]] [delete from conversation where id=?]; SQL [delete from conversation where id=?]; constraint ["FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]]
	at app//org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:290)
	at app//org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:241)
	at app//org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:566)
	at app//org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:795)
	at app//org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:758)
	at app//org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:663)
	at app//org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:413)
	at app//org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:138)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:165)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:223)
	at app/jdk.proxy3/jdk.proxy3.$Proxy388.deleteAll(Unknown Source)
	at app//de.tum.cit.aet.artemis.communication.OneToOneChatIntegrationTest.tearDown(OneToOneChatIntegrationTest.java:42)
	at [email protected]/java.lang.reflect.Method.invoke(Method.java:580)
	at [email protected]/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387)
	at [email protected]/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1312)
	at [email protected]/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1843)
	at [email protected]/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1808)
	at [email protected]/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:188)
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute batch [Referential integrity constraint violation: "FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]] [delete from conversation where id=?]
	at app//org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:97)
	at app//org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:58)
	at app//org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:108)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.lambda$performExecution$2(BatchImpl.java:294)
	at app//org.hibernate.engine.jdbc.mutation.internal.PreparedStatementGroupSingleTable.forEachStatement(PreparedStatementGroupSingleTable.java:59)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.performExecution(BatchImpl.java:264)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.execute(BatchImpl.java:242)
	at app//org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.getBatch(JdbcCoordinatorImpl.java:173)
	at app//org.hibernate.engine.jdbc.mutation.internal.MutationExecutorSingleBatched.resolveBatch(MutationExecutorSingleBatched.java:47)
	at app//org.hibernate.engine.jdbc.mutation.internal.MutationExecutorSingleBatched.getStatementGroup(MutationExecutorSingleBatched.java:40)
	at app//org.hibernate.engine.jdbc.mutation.internal.AbstractSingleMutationExecutor.getPreparedStatementDetails(AbstractSingleMutationExecutor.java:45)
	at app//org.hibernate.persister.entity.mutation.AbstractDeleteCoordinator.doStaticDelete(AbstractDeleteCoordinator.java:265)
	at app//org.hibernate.persister.entity.mutation.AbstractDeleteCoordinator.coordinateDelete(AbstractDeleteCoordinator.java:87)
	at app//org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2973)
	at app//org.hibernate.action.internal.EntityDeleteAction.execute(EntityDeleteAction.java:131)
	at app//org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:632)
	at app//org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:499)
	at app//org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:377)
	at app//org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:41)
	at app//org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:127)
	at app//org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1407)
	at app//org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:488)
	at app//org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:2329)
	at app//org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:1986)
	at app//org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:439)
	at app//org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:169)
	at app//org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:267)
	at app//org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101)
	at app//org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:562)
	... 21 more
Caused by: org.h2.jdbc.JdbcBatchUpdateException: Referential integrity constraint violation: "FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]
	at app//org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1282)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.lambda$performExecution$2(BatchImpl.java:279)
	... 46 more

org.springframework.dao.DataIntegrityViolationException: could not execute batch [Referential integrity constraint violation: "FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]] [delete from conversation where id=?]; SQL [delete from conversation where id=?]; constraint ["FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]]
	at app//org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:290)
	at app//org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:241)
	at app//org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:566)
	at app//org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:795)
	at app//org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:758)
	at app//org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:663)
	at app//org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:413)
	at app//org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:138)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:165)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:223)
	at app/jdk.proxy3/jdk.proxy3.$Proxy388.deleteAll(Unknown Source)
	at app//de.tum.cit.aet.artemis.communication.OneToOneChatIntegrationTest.tearDown(OneToOneChatIntegrationTest.java:42)
	at [email protected]/java.lang.reflect.Method.invoke(Method.java:580)
	at [email protected]/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387)
	at [email protected]/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1312)
	at [email protected]/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1843)
	at [email protected]/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1808)
	at [email protected]/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:188)
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute batch [Referential integrity constraint violation: "FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]] [delete from conversation where id=?]
	at app//org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:97)
	at app//org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:58)
	at app//org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:108)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.lambda$performExecution$2(BatchImpl.java:294)
	at app//org.hibernate.engine.jdbc.mutation.internal.PreparedStatementGroupSingleTable.forEachStatement(PreparedStatementGroupSingleTable.java:59)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.performExecution(BatchImpl.java:264)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.execute(BatchImpl.java:242)
	at app//org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.getBatch(JdbcCoordinatorImpl.java:173)
	at app//org.hibernate.engine.jdbc.mutation.internal.MutationExecutorSingleBatched.resolveBatch(MutationExecutorSingleBatched.java:47)
	at app//org.hibernate.engine.jdbc.mutation.internal.MutationExecutorSingleBatched.getStatementGroup(MutationExecutorSingleBatched.java:40)
	at app//org.hibernate.engine.jdbc.mutation.internal.AbstractSingleMutationExecutor.getPreparedStatementDetails(AbstractSingleMutationExecutor.java:45)
	at app//org.hibernate.persister.entity.mutation.AbstractDeleteCoordinator.doStaticDelete(AbstractDeleteCoordinator.java:265)
	at app//org.hibernate.persister.entity.mutation.AbstractDeleteCoordinator.coordinateDelete(AbstractDeleteCoordinator.java:87)
	at app//org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2973)
	at app//org.hibernate.action.internal.EntityDeleteAction.execute(EntityDeleteAction.java:131)
	at app//org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:632)
	at app//org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:499)
	at app//org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:377)
	at app//org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:41)
	at app//org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:127)
	at app//org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1407)
	at app//org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:488)
	at app//org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:2329)
	at app//org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:1986)
	at app//org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:439)
	at app//org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:169)
	at app//org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:267)
	at app//org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101)
	at app//org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:562)
	... 21 more
Caused by: org.h2.jdbc.JdbcBatchUpdateException: Referential integrity constraint violation: "FK_TUTORIAL_GROUP_CHANNEL: PUBLIC.TUTORIAL_GROUP FOREIGN KEY(TUTORIAL_GROUP_CHANNEL_ID) REFERENCES PUBLIC.CONVERSATION(ID) (CAST(1 AS BIGINT))"; SQL statement:
delete from conversation where id=? [23503-224]
	at app//org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1282)
	at app//org.hibernate.engine.jdbc.batch.internal.BatchImpl.lambda$performExecution$2(BatchImpl.java:279)
	... 46 more

org.thymeleaf.exceptions.TemplateProcessingException: Exception evaluating SpringEL expression: "reason.getMessage()" (template: "mail/dataExportFailedAdminEmail" - line 16, col 8)
	at app//org.thymeleaf.spring6.expression.SPELVariableExpressionEvaluator.evaluate(SPELVariableExpressionEvaluator.java:292)
	at app//org.thymeleaf.standard.expression.VariableExpression.executeVariableExpression(VariableExpression.java:166)
	at app//org.thymeleaf.standard.expression.SimpleExpression.executeSimple(SimpleExpression.java:66)
	at app//org.thymeleaf.standard.expression.Expression.execute(Expression.java:109)
	at app//org.thymeleaf.standard.expression.Expression.execute(Expression.java:138)
	at app//org.thymeleaf.standard.expression.MessageExpression.executeMessageExpression(MessageExpression.java:256)
	at app//org.thymeleaf.standard.expression.SimpleExpression.executeSimple(SimpleExpression.java:69)
	at app//org.thymeleaf.standard.expression.Expression.execute(Expression.java:109)
	at app//org.thymeleaf.standard.expression.Expression.execute(Expression.java:138)
	at app//org.thymeleaf.standard.processor.AbstractStandardExpressionAttributeTagProcessor.doProcess(AbstractStandardExpressionAttributeTagProcessor.java:144)
	at app//org.thymeleaf.processor.element.AbstractAttributeTagProcessor.doProcess(AbstractAttributeTagProcessor.java:74)
	at app//org.thymeleaf.processor.element.AbstractElementTagProcessor.process(AbstractElementTagProcessor.java:95)
	at app//org.thymeleaf.util.ProcessorConfigurationUtils$ElementTagProcessorWrapper.process(ProcessorConfigurationUtils.java:633)
	at app//org.thymeleaf.engine.ProcessorTemplateHandler.handleOpenElement(ProcessorTemplateHandler.java:1314)
	at app//org.thymeleaf.engine.OpenElementTag.beHandled(OpenElementTag.java:205)
	at app//org.thymeleaf.engine.TemplateModel.process(TemplateModel.java:136)
	at app//org.thymeleaf.engine.TemplateManager.parseAndProcess(TemplateManager.java:661)
	at app//org.thymeleaf.TemplateEngine.process(TemplateEngine.java:1103)
	at app//org.thymeleaf.TemplateEngine.process(TemplateEngine.java:1064)
	at app//org.thymeleaf.TemplateEngine.process(TemplateEngine.java:1053)
	at app//de.tum.cit.aet.artemis.communication.service.notifications.MailService.prepareTemplateAndSendEmailWithArgumentInSubject(MailService.java:152)
	at app//de.tum.cit.aet.artemis.communication.service.notifications.MailService.sendDataExportFailedEmailForAdmin(MailService.java:135)
	at app//de.tum.cit.aet.artemis.communication.service.notifications.MailService.sendDataExportFailedEmailForAdmin(MailService.java:131)
	at app//de.tum.cit.aet.artemis.communication.service.notifications.MailService.sendDataExportFailedEmailToAdmin(MailService.java:181)
	at app//de.tum.cit.aet.artemis.communication.service.notifications.MailService.sendDataExportFailedEmailToAdmin(MailService.java:180)
	at [email protected]/java.lang.reflect.Method.invoke(Method.java:580)
	at app//org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:355)
	at app//org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:716)
	at app//de.tum.cit.aet.artemis.communication.service.notifications.MailService$$SpringCGLIB$$0.sendDataExportFailedEmailToAdmin(<generated>)
	at app//de.tum.cit.aet.artemis.core.service.export.DataExportCreationService.handleCreationFailure(DataExportCreationService.java:174)
	at app//de.tum.cit.aet.artemis.core.service.export.DataExportCreationService.createDataExport(DataExportCreationService.java:142)
	at app//de.tum.cit.aet.artemis.core.service.DataExportScheduleService.createDataExport(DataExportScheduleService.java:106)
	at app//de.tum.cit.aet.artemis.core.service.DataExportScheduleService.lambda$createDataExportsAndDeleteOldOnes$0(DataExportScheduleService.java:76)
	at [email protected]/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
	at [email protected]/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
	at [email protected]/java.lang.Thread.run(Thread.java:1583)
Caused by: org.springframework.expression.EvaluationException: Calling method 'getMessage' is forbidden for type 'class java.lang.RuntimeException' in this expression context.
	at app//org.thymeleaf.spring6.expression.ThymeleafEvaluationContext$ThymeleafEvaluationContextACLMethodResolver.resolve(ThymeleafEvaluationContext.java:276)
	at app//org.springframework.expression.spel.ast.MethodReference.findAccessorForMethod(MethodReference.java:218)
	at app//org.springframework.expression.spel.ast.MethodReference.getValueInternal(MethodReference.java:148)
	at app//org.springframework.expression.spel.ast.MethodReference$MethodValueRef.getValue(MethodReference.java:401)
	at app//org.springframework.expression.spel.ast.CompoundExpression.getValueInternal(CompoundExpression.java:97)
	at app//org.springframework.expression.spel.ast.SpelNodeImpl.getValue(SpelNodeImpl.java:114)
	at app//org.springframework.expression.spel.standard.SpelExpression.getValue(SpelExpression.java:338)
	at app//org.thymeleaf.spring6.expression.SPELVariableExpressionEvaluator.evaluate(SPELVariableExpressionEvaluator.java:265)
	at app//org.thymeleaf.standard.expression.VariableExpression.executeVariableExpression(VariableExpression.java:166)
	at app//org.thymeleaf.standard.expression.SimpleExpression.executeSimple(SimpleExpression.java:66)
	at app//org.thymeleaf.standard.expression.Expression.execute(Expression.java:109)
	at app//org.thymeleaf.standard.expression.Expression.execute(Expression.java:138)
	at app//org.thymeleaf.standard.expression.MessageExpression.executeMessageExpression(MessageExpression.java:256)
	at app//org.thymeleaf.standard.expression.SimpleExpression.executeSimple(SimpleExpression.java:69)
	at app//org.thymeleaf.standard.expression.Expression.execute(Expression.java:109)
	at app//org.thymeleaf.standard.expression.Expression.execute(Expression.java:138)
	at app//org.thymeleaf.standard.processor.AbstractStandardExpressionAttributeTagProcessor.doProcess(AbstractStandardExpressionAttributeTagProcessor.java:144)
	at app//org.thymeleaf.processor.element.AbstractAttributeTagProcessor.doProcess(AbstractAttributeTagProcessor.java:74)
	at app//org.thymeleaf.processor.element.AbstractElementTagProcessor.process(AbstractElementTagProcessor.java:95)
	at app//org.thymeleaf.util.ProcessorConfigurationUtils$ElementTagProcessorWrapper.process(ProcessorConfigurationUtils.java:633)
	at app//org.thymeleaf.engine.ProcessorTemplateHandler.handleOpenElement(ProcessorTemplateHandler.java:1314)
	at app//org.thymeleaf.engine.OpenElementTag.beHandled(OpenElementTag.java:205)
	at app//org.thymeleaf.engine.TemplateModel.process(TemplateModel.java:136)
	at app//org.thymeleaf.engine.TemplateManager.parseAndProcess(TemplateManager.java:661)
	at app//org.thymeleaf.TemplateEngine.process(TemplateEngine.java:1103)
	at app//org.thymeleaf.TemplateEngine.process(TemplateEngine.java:1064)
	at app//org.thymeleaf.TemplateEngine.process(TemplateEngine.java:1053)
	at app//de.tum.cit.aet.artemis.communication.service.notifications.MailService.prepareTemplateAndSendEmailWithArgumentInSubject(MailService.java:152)
	at app//de.tum.cit.aet.artemis.communication.service.notifications.MailService.sendDataExportFailedEmailForAdmin(MailService.java:135)
	at [email protected]/java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:733)
	at org.mockito.internal.util.reflection.InstrumentationMemberAccessor$Dispatcher$ByteBuddy$mfj57EtQ.invokeWithArguments(Unknown Source)
	at app//org.mockito.internal.util.reflection.InstrumentationMemberAccessor.invoke(InstrumentationMemberAccessor.java:251)
	at app//org.mockito.internal.util.reflection.ModuleMemberAccessor.invoke(ModuleMemberAccessor.java:55)
	at app//org.mockito.internal.creation.bytebuddy.MockMethodAdvice.tryInvoke(MockMethodAdvice.java:314)
	at app//org.mockito.internal.creation.bytebuddy.MockMethodAdvice$RealMethodCall.invoke(MockMethodAdvice.java:234)
	at app//org.mockito.internal.invocation.InterceptedInvocation.callRealMethod(InterceptedInvocation.java:142)
	at app//org.mockito.internal.stubbing.answers.CallsRealMethods.answer(CallsRealMethods.java:45)
	at app//org.mockito.Answers.answer(Answers.java:90)
	at app//org.mockito.internal.handler.MockHandlerImpl.handle(MockHandlerImpl.java:111)
	at app//org.mockito.internal.handler.NullResultGuardian.handle(NullResultGuardian.java:29)
	at app//org.mockito.internal.handler.InvocationNotifierHandler.handle(InvocationNotifierHandler.java:34)
	at app//org.mockito.internal.creation.bytebuddy.MockMethodInterceptor.doIntercept(MockMethodInterceptor.java:82)
	at app//org.mockito.internal.creation.bytebuddy.MockMethodAdvice.handle(MockMethodAdvice.java:134)
	at app//de.tum.cit.aet.artemis.communication.service.notifications.MailService.sendDataExportFailedEmailForAdmin(MailService.java:131)
	at app//de.tum.cit.aet.artemis.communication.service.notifications.MailService.sendDataExportFailedEmailToAdmin(MailService.java:181)
	at [email protected]/java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:733)
	at org.mockito.internal.util.reflection.InstrumentationMemberAccessor$Dispatcher$ByteBuddy$mfj57EtQ.invokeWithArguments(Unknown Source)
	at app//org.mockito.internal.util.reflection.InstrumentationMemberAccessor.invoke(InstrumentationMemberAccessor.java:251)
	at app//org.mockito.internal.util.reflection.ModuleMemberAccessor.invoke(ModuleMemberAccessor.java:55)
	at app//org.mockito.internal.creation.bytebuddy.MockMethodAdvice.tryInvoke(MockMethodAdvice.java:314)
	at app//org.mockito.internal.creation.bytebuddy.MockMethodAdvice$RealMethodCall.invoke(MockMethodAdvice.java:234)
	at app//org.mockito.internal.invocation.InterceptedInvocation.callRealMethod(InterceptedInvocation.java:142)
	at app//org.mockito.internal.stubbing.answers.CallsRealMethods.answer(CallsRealMethods.java:45)
	at app//org.mockito.Answers.answer(Answers.java:90)
	at app//org.mockito.internal.handler.MockHandlerImpl.handle(MockHandlerImpl.java:111)
	at app//org.mockito.internal.handler.NullResultGuardian.handle(NullResultGuardian.java:29)
	at app//org.mockito.internal.handler.InvocationNotifierHandler.handle(InvocationNotifierHandler.java:34)
	at app//org.mockito.internal.creation.bytebuddy.MockMethodInterceptor.doIntercept(MockMethodInterceptor.java:82)
	at app//org.mockito.internal.creation.bytebuddy.MockMethodAdvice.handle(MockMethodAdvice.java:134)
	... 12 more

org.opentest4j.AssertionFailedError: 
expected: 13
 but was: 0
	at app//de.tum.cit.aet.artemis.programming.icl.LocalVCLocalCITestService.testLatestSubmission(LocalVCLocalCITestService.java:609)
	at app//de.tum.cit.aet.artemis.programming.icl.LocalVCLocalCITestService.testLatestSubmission(LocalVCLocalCITestService.java:617)
	at app//de.tum.cit.aet.artemis.programming.icl.LocalVCLocalCIIntegrationTest.testFetchPush_testsRepository(LocalVCLocalCIIntegrationTest.java:199)
	at [email protected]/java.lang.reflect.Method.invoke(Method.java:580)
	at [email protected]/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387)
	at [email protected]/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1312)
	at [email protected]/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1843)
	at [email protected]/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1808)
	at [email protected]/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:188)

org.opentest4j.AssertionFailedError: 
expected: 3
 but was: 4
	at app//de.tum.cit.aet.artemis.programming.icl.SharedQueueManagementServiceTest.testPushDockerImageCleanupInfo(SharedQueueManagementServiceTest.java:42)
	at [email protected]/java.lang.reflect.Method.invoke(Method.java:580)
	at [email protected]/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387)
	at [email protected]/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1312)
	at [email protected]/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1843)
	at [email protected]/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1808)
	at [email protected]/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:188)