Skip to content

Merge branch 'feature/adaptive-learning/competency-link-weight' into … #835

Merge branch 'feature/adaptive-learning/competency-link-weight' into …

Merge branch 'feature/adaptive-learning/competency-link-weight' into … #835

GitHub Actions / MySQL Tests failed Oct 23, 2024 in 1s

8307 passed, 11 failed and 2 skipped

Tests failed
Report exceeded GitHub limit of 65535 bytes and has been trimmed

Annotations

Check failure on line 654 in src/test/java/de/tum/cit/aet/artemis/core/util/RequestUtilService.java

See this annotation in the file changed.

@github-actions github-actions / MySQL Tests

de.tum.cit.aet.artemis.atlas.competency.CourseCompetencyIntegrationTest$GetCompetencyStudentProgress ► getCompetencyStudentProgressShouldReturnProgress()

Failed test found in:
  build/test-results/test/TEST-de.tum.cit.aet.artemis.atlas.competency.CourseCompetencyIntegrationTest$GetCompetencyStudentProgress.xml
Error:
  java.lang.AssertionError: Response status expected:<200> but was:<500>
Raw output
java.lang.AssertionError: Response status expected:<200> but was:<500>
	at org.springframework.test.util.AssertionErrors.fail(AssertionErrors.java:59)
	at org.springframework.test.util.AssertionErrors.assertEquals(AssertionErrors.java:122)
	at org.springframework.test.web.servlet.result.StatusResultMatchers.lambda$is$1(StatusResultMatchers.java:64)
	at org.springframework.test.web.servlet.MockMvc$1.andExpect(MockMvc.java:214)
	at de.tum.cit.aet.artemis.core.util.RequestUtilService.get(RequestUtilService.java:654)
	at de.tum.cit.aet.artemis.core.util.RequestUtilService.get(RequestUtilService.java:620)
	at de.tum.cit.aet.artemis.core.util.RequestUtilService.get(RequestUtilService.java:598)
	at de.tum.cit.aet.artemis.atlas.competency.CourseCompetencyIntegrationTest$GetCompetencyStudentProgress.getCompetencyStudentProgressShouldReturnProgress(CourseCompetencyIntegrationTest.java:296)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at java.base/java.util.concurrent.RecursiveAction.exec(RecursiveAction.java:194)
	at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387)
	at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1312)
	at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1843)
	at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1808)
	at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:188)

Check failure on line 654 in src/test/java/de/tum/cit/aet/artemis/core/util/RequestUtilService.java

See this annotation in the file changed.

@github-actions github-actions / MySQL Tests

de.tum.cit.aet.artemis.atlas.competency.CourseCompetencyIntegrationTest$GetCompetencyStudentProgress ► getCompetencyStudentProgressMultipleExercises()

Failed test found in:
  build/test-results/test/TEST-de.tum.cit.aet.artemis.atlas.competency.CourseCompetencyIntegrationTest$GetCompetencyStudentProgress.xml
Error:
  java.lang.AssertionError: Response status expected:<200> but was:<500>
Raw output
java.lang.AssertionError: Response status expected:<200> but was:<500>
	at org.springframework.test.util.AssertionErrors.fail(AssertionErrors.java:59)
	at org.springframework.test.util.AssertionErrors.assertEquals(AssertionErrors.java:122)
	at org.springframework.test.web.servlet.result.StatusResultMatchers.lambda$is$1(StatusResultMatchers.java:64)
	at org.springframework.test.web.servlet.MockMvc$1.andExpect(MockMvc.java:214)
	at de.tum.cit.aet.artemis.core.util.RequestUtilService.get(RequestUtilService.java:654)
	at de.tum.cit.aet.artemis.core.util.RequestUtilService.get(RequestUtilService.java:620)
	at de.tum.cit.aet.artemis.core.util.RequestUtilService.get(RequestUtilService.java:598)
	at de.tum.cit.aet.artemis.atlas.competency.CourseCompetencyIntegrationTest$GetCompetencyStudentProgress.getCompetencyStudentProgressMultipleExercises(CourseCompetencyIntegrationTest.java:331)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at java.base/java.util.concurrent.RecursiveAction.exec(RecursiveAction.java:194)
	at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387)
	at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1312)
	at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1843)
	at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1808)
	at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:188)

Check failure on line 212 in src/main/java/de/tum/cit/aet/artemis/atlas/service/competency/CompetencyProgressService.java

See this annotation in the file changed.

@github-actions github-actions / MySQL Tests

de.tum.cit.aet.artemis.atlas.learningpath.LearningPathIntegrationTest ► testGetLearningPathNavigation()

Failed test found in:
  build/test-results/test/TEST-de.tum.cit.aet.artemis.atlas.learningpath.LearningPathIntegrationTest.xml
Error:
  org.springframework.dao.InvalidDataAccessResourceUsageException: JDBC exception executing SQL [select e1_0.max_points,e1_0.difficulty,case when e1_0.discriminator='P' then 1 else 0 end,cl1_0.link_weight,coalesce(ss1_0.last_score,ts1_0.last_score),coalesce(ss1_0.last_points,ts1_0.last_points),coalesce(ss1_0.last_modified_date,ts1_0.last_modified_date),count(s3_0.id) from competency cc1_0 left join competency_exercise el1_0 on cc1_0.id=el1_0.competency_id left join exercise e1_0 on e1_0.id=el1_0.exercise_id left join competency_exercise cl1_0 on e1_0.id=cl1_0.exercise_id and cl1_0.competency_id=cc1_0.id left join ((select * from participation t where t.discriminator in ('PESP', 'SP')) sp1_0 join team t1_0 on t1_0.id=sp1_0.team_id) on e1_0.id=sp1_0.exercise_id and (sp1_0.student_id=? or ? in (select s2_0.student_id from team_student s2_0 where t1_0.id=s2_0.team_id)) left join submission s3_0 on sp1_0.id=s3_0.participation_id left join (select * from participant_score t where t.discriminator='SS') ss1_0 on ss1_0.exercise_id=e1_0.id and ss1_0.user_id=? left join ((select * from participant_score t where t.discriminator='TS') ts1_0 join team t2_0 on t2_0.id=ts1_0.team_id) on ts1_0.exercise_id=e1_0.id and ? in (select s4_0.student_id from team_student s4_0 where t2_0.id=s4_0.team_id) where cc1_0.id=? and el1_0.exercise_id is not null group by e1_0.max_points,e1_0.difficulty,e1_0.discriminator,ss1_0.last_score,ts1_0.last_score,ss1_0.last_points,ts1_0.last_points,ss1_0.last_modified_date,ts1_0.last_modified_date] [Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.cl1_0.link_weight' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by] [n/a]; SQL [n/a]
Raw output
org.springframework.dao.InvalidDataAccessResourceUsageException: JDBC exception executing SQL [select e1_0.max_points,e1_0.difficulty,case when e1_0.discriminator='P' then 1 else 0 end,cl1_0.link_weight,coalesce(ss1_0.last_score,ts1_0.last_score),coalesce(ss1_0.last_points,ts1_0.last_points),coalesce(ss1_0.last_modified_date,ts1_0.last_modified_date),count(s3_0.id) from competency cc1_0 left join competency_exercise el1_0 on cc1_0.id=el1_0.competency_id left join exercise e1_0 on e1_0.id=el1_0.exercise_id left join competency_exercise cl1_0 on e1_0.id=cl1_0.exercise_id and cl1_0.competency_id=cc1_0.id left join ((select * from participation t where t.discriminator in ('PESP', 'SP')) sp1_0 join team t1_0 on t1_0.id=sp1_0.team_id) on e1_0.id=sp1_0.exercise_id and (sp1_0.student_id=? or ? in (select s2_0.student_id from team_student s2_0 where t1_0.id=s2_0.team_id)) left join submission s3_0 on sp1_0.id=s3_0.participation_id left join (select * from participant_score t where t.discriminator='SS') ss1_0 on ss1_0.exercise_id=e1_0.id and ss1_0.user_id=? left join ((select * from participant_score t where t.discriminator='TS') ts1_0 join team t2_0 on t2_0.id=ts1_0.team_id) on ts1_0.exercise_id=e1_0.id and ? in (select s4_0.student_id from team_student s4_0 where t2_0.id=s4_0.team_id) where cc1_0.id=? and el1_0.exercise_id is not null group by e1_0.max_points,e1_0.difficulty,e1_0.discriminator,ss1_0.last_score,ts1_0.last_score,ss1_0.last_points,ts1_0.last_points,ss1_0.last_modified_date,ts1_0.last_modified_date] [Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.cl1_0.link_weight' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by] [n/a]; SQL [n/a]
	at app//org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:277)
	at app//org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:241)
	at app//org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:550)
	at app//org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:61)
	at app//org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:335)
	at app//org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:160)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:136)
	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.$Proxy395.findAllExerciseInfoByCompetencyId(Unknown Source)
	at [email protected]/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	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.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:216)
	at app/jdk.proxy3/jdk.proxy3.$Proxy395.findAllExerciseInfoByCompetencyId(Unknown Source)
	at app//de.tum.cit.aet.artemis.atlas.service.competency.CompetencyProgressService.updateCompetencyProgress(CompetencyProgressService.java:212)
	at app//de.tum.cit.aet.artemis.atlas.service.competency.CompetencyProgressService.updateCompetencyProgress(CompetencyProgressService.java:202)
	at [email protected]/java.lang.Iterable.forEach(Iterable.java:75)
	at app//de.tum.cit.aet.artemis.atlas.service.competency.CompetencyProgressService.updateProgressByLearningObjectSync(CompetencyProgressService.java:190)
	at app//de.tum.cit.aet.artemis.atlas.service.competency.CompetencyProgressService.updateProgressByLearningObjectSync(CompetencyProgressService.java:185)
	at [email protected]/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	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.atlas.service.competency.CompetencyProgressService$$SpringCGLIB$$0.updateProgressByLearningObjectSync(<generated>)
	at app//de.tum.cit.aet.artemis.atlas.learningpath.LearningPathIntegrationTest.testGetLearningPathNavigation(LearningPathIntegrationTest.java:645)
	at [email protected]/java.lang.reflect.Method.invoke(Method.java:580)
	at [email protected]/java.util.concurrent.RecursiveAction.exec(RecursiveAction.java:194)
	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.SQLGrammarException: JDBC exception executing SQL [select e1_0.max_points,e1_0.difficulty,case when e1_0.discriminator='P' then 1 else 0 end,cl1_0.link_weight,coalesce(ss1_0.last_score,ts1_0.last_score),coalesce(ss1_0.last_points,ts1_0.last_points),coalesce(ss1_0.last_modified_date,ts1_0.last_modified_date),count(s3_0.id) from competency cc1_0 left join competency_exercise el1_0 on cc1_0.id=el1_0.competency_id left join exercise e1_0 on e1_0.id=el1_0.exercise_id left join competency_exercise cl1_0 on e1_0.id=cl1_0.exercise_id and cl1_0.competency_id=cc1_0.id left join ((select * from participation t where t.discriminator in ('PESP', 'SP')) sp1_0 join team t1_0 on t1_0.id=sp1_0.team_id) on e1_0.id=sp1_0.exercise_id and (sp1_0.student_id=? or ? in (select s2_0.student_id from team_student s2_0 where t1_0.id=s2_0.team_id)) left join submission s3_0 on sp1_0.id=s3_0.participation_id left join (select * from participant_score t where t.discriminator='SS') ss1_0 on ss1_0.exercise_id=e1_0.id and ss1_0.user_id=? left join ((select * from participant_score t where t.discriminator='TS') ts1_0 join team t2_0 on t2_0.id=ts1_0.team_id) on ts1_0.exercise_id=e1_0.id and ? in (select s4_0.student_id from team_student s4_0 where t2_0.id=s4_0.team_id) where cc1_0.id=? and el1_0.exercise_id is not null group by e1_0.max_points,e1_0.difficulty,e1_0.discriminator,ss1_0.last_score,ts1_0.last_score,ss1_0.last_points,ts1_0.last_points,ss1_0.last_modified_date,ts1_0.last_modified_date] [Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.cl1_0.link_weight' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by] [n/a]
	at app//org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:66)
	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.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:94)
	at app//org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.executeQuery(DeferredResultSetAccess.java:264)
	at app//org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.getResultSet(DeferredResultSetAccess.java:167)
	at app//org.hibernate.sql.results.jdbc.internal.JdbcValuesResultSetImpl.advanceNext(JdbcValuesResultSetImpl.java:218)
	at app//org.hibernate.sql.results.jdbc.internal.JdbcValuesResultSetImpl.processNext(JdbcValuesResultSetImpl.java:98)
	at app//org.hibernate.sql.results.jdbc.internal.AbstractJdbcValues.next(AbstractJdbcValues.java:19)
	at app//org.hibernate.sql.results.internal.RowProcessingStateStandardImpl.next(RowProcessingStateStandardImpl.java:66)
	at app//org.hibernate.sql.results.spi.ListResultsConsumer.consume(ListResultsConsumer.java:202)
	at app//org.hibernate.sql.results.spi.ListResultsConsumer.consume(ListResultsConsumer.java:33)
	at app//org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.doExecuteQuery(JdbcSelectExecutorStandardImpl.java:209)
	at app//org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.executeQuery(JdbcSelectExecutorStandardImpl.java:83)
	at app//org.hibernate.sql.exec.spi.JdbcSelectExecutor.list(JdbcSelectExecutor.java:76)
	at app//org.hibernate.sql.exec.spi.JdbcSelectExecutor.list(JdbcSelectExecutor.java:65)
	at app//org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.lambda$new$2(ConcreteSqmSelectQueryPlan.java:137)
	at app//org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.withCacheableSqmInterpretation(ConcreteSqmSelectQueryPlan.java:381)
	at app//org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.performList(ConcreteSqmSelectQueryPlan.java:303)
	at app//org.hibernate.query.sqm.internal.QuerySqmImpl.doList(QuerySqmImpl.java:509)
	at app//org.hibernate.query.spi.AbstractSelectionQuery.list(AbstractSelectionQuery.java:427)
	at app//org.hibernate.query.Query.getResultList(Query.java:120)
	at [email protected]/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at [email protected]/java.lang.reflect.Method.invoke(Method.java:580)
	at app//org.springframework.orm.jpa.SharedEntityManagerCreator$DeferredQueryInvocationHandler.invoke(SharedEntityManagerCreator.java:418)
	at app/jdk.proxy3/jdk.proxy3.$Proxy588.getResultList(Unknown Source)
	at app//org.springframework.data.jpa.repository.query.JpaQueryExecution$CollectionExecution.doExecute(JpaQueryExecution.java:129)
	at app//org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:92)
	at app//org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:152)
	at app//org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:140)
	at app//org.springframework.data.repository.core.support.RepositoryMethodInvoker.doInvoke(RepositoryMethodInvoker.java:170)
	at app//org.springframework.data.repository.core.support.RepositoryMethodInvoker.invoke(RepositoryMethodInvoker.java:158)
	at app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.doInvoke(QueryExecutorMethodInterceptor.java:169)
	at app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.invoke(QueryExecutorMethodInterceptor.java:148)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:70)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:379)
	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:136)
	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.$Proxy395.findAllExerciseInfoByCompetencyId(Unknown Source)
	at [email protected]/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	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.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:216)
	at app/jdk.proxy3/jdk.proxy3.$Proxy395.findAllExerciseInfoByCompetencyId(Unknown Source)
	at app//de.tum.cit.aet.artemis.atlas.service.competency.CompetencyProgressService.updateCompetencyProgress(CompetencyProgressService.java:212)
	at [email protected]/java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:733)
	at org.mockito.internal.util.reflection.InstrumentationMemberAccessor$Dispatcher$ByteBuddy$rNW3SvCH.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.atlas.service.competency.CompetencyProgressService.updateCompetencyProgress(CompetencyProgressService.java:202)
	at app//de.tum.cit.aet.artemis.atlas.service.competency.CompetencyProgressService.lambda$updateProgressByLearningObjectSync$7(CompetencyProgressService.java:190)
	at [email protected]/java.lang.Iterable.forEach(Iterable.java:75)
	at app//de.tum.cit.aet.artemis.atlas.service.competency.CompetencyProgressService.updateProgressByLearningObjectSync(CompetencyProgressService.java:190)
	at [email protected]/java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:733)
	at org.mockito.internal.util.reflection.InstrumentationMemberAccessor$Dispatcher$ByteBuddy$rNW3SvCH.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)
	... 14 more
Caused by: java.sql.SQLSyntaxErrorException: Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.cl1_0.link_weight' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:112)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:114)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:988)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1056)
	at org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.executeQuery(DeferredResultSetAccess.java:246)
	... 95 more

Check failure on line 654 in src/test/java/de/tum/cit/aet/artemis/core/util/RequestUtilService.java

See this annotation in the file changed.

@github-actions github-actions / MySQL Tests

de.tum.cit.aet.artemis.atlas.learningpath.LearningPathIntegrationTest ► testGetCompetencyProgressForLearningPathByOwner()

Failed test found in:
  build/test-results/test/TEST-de.tum.cit.aet.artemis.atlas.learningpath.LearningPathIntegrationTest.xml
Error:
  java.lang.AssertionError: Response status expected:<200> but was:<500>
Raw output
java.lang.AssertionError: Response status expected:<200> but was:<500>
	at org.springframework.test.util.AssertionErrors.fail(AssertionErrors.java:59)
	at org.springframework.test.util.AssertionErrors.assertEquals(AssertionErrors.java:122)
	at org.springframework.test.web.servlet.result.StatusResultMatchers.lambda$is$1(StatusResultMatchers.java:64)
	at org.springframework.test.web.servlet.MockMvc$1.andExpect(MockMvc.java:214)
	at de.tum.cit.aet.artemis.core.util.RequestUtilService.get(RequestUtilService.java:654)
	at de.tum.cit.aet.artemis.core.util.RequestUtilService.get(RequestUtilService.java:620)
	at de.tum.cit.aet.artemis.core.util.RequestUtilService.get(RequestUtilService.java:598)
	at de.tum.cit.aet.artemis.atlas.learningpath.LearningPathIntegrationTest.testGetCompetencyProgressForLearningPath(LearningPathIntegrationTest.java:836)
	at de.tum.cit.aet.artemis.atlas.learningpath.LearningPathIntegrationTest.testGetCompetencyProgressForLearningPathByOwner(LearningPathIntegrationTest.java:629)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at java.base/java.util.concurrent.RecursiveAction.exec(RecursiveAction.java:194)
	at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387)
	at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1312)
	at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1843)
	at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1808)
	at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:188)

Check failure on line 654 in src/test/java/de/tum/cit/aet/artemis/core/util/RequestUtilService.java

See this annotation in the file changed.

@github-actions github-actions / MySQL Tests

de.tum.cit.aet.artemis.atlas.learningpath.LearningPathIntegrationTest ► testGetCompetencyProgressForLearningPathByInstructor()

Failed test found in:
  build/test-results/test/TEST-de.tum.cit.aet.artemis.atlas.learningpath.LearningPathIntegrationTest.xml
Error:
  java.lang.AssertionError: Response status expected:<200> but was:<500>
Raw output
java.lang.AssertionError: Response status expected:<200> but was:<500>
	at org.springframework.test.util.AssertionErrors.fail(AssertionErrors.java:59)
	at org.springframework.test.util.AssertionErrors.assertEquals(AssertionErrors.java:122)
	at org.springframework.test.web.servlet.result.StatusResultMatchers.lambda$is$1(StatusResultMatchers.java:64)
	at org.springframework.test.web.servlet.MockMvc$1.andExpect(MockMvc.java:214)
	at de.tum.cit.aet.artemis.core.util.RequestUtilService.get(RequestUtilService.java:654)
	at de.tum.cit.aet.artemis.core.util.RequestUtilService.get(RequestUtilService.java:620)
	at de.tum.cit.aet.artemis.core.util.RequestUtilService.get(RequestUtilService.java:598)
	at de.tum.cit.aet.artemis.atlas.learningpath.LearningPathIntegrationTest.testGetCompetencyProgressForLearningPath(LearningPathIntegrationTest.java:836)
	at de.tum.cit.aet.artemis.atlas.learningpath.LearningPathIntegrationTest.testGetCompetencyProgressForLearningPathByInstructor(LearningPathIntegrationTest.java:635)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at java.base/java.util.concurrent.RecursiveAction.exec(RecursiveAction.java:194)
	at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387)
	at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1312)
	at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1843)
	at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1808)
	at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:188)

Check failure on line 212 in src/main/java/de/tum/cit/aet/artemis/atlas/service/competency/CompetencyProgressService.java

See this annotation in the file changed.

@github-actions github-actions / MySQL Tests

de.tum.cit.aet.artemis.atlas.learningpath.LearningPathIntegrationTest ► testGetLearningPathCompetencyGraph()

Failed test found in:
  build/test-results/test/TEST-de.tum.cit.aet.artemis.atlas.learningpath.LearningPathIntegrationTest.xml
Error:
  org.springframework.dao.InvalidDataAccessResourceUsageException: JDBC exception executing SQL [select e1_0.max_points,e1_0.difficulty,case when e1_0.discriminator='P' then 1 else 0 end,cl1_0.link_weight,coalesce(ss1_0.last_score,ts1_0.last_score),coalesce(ss1_0.last_points,ts1_0.last_points),coalesce(ss1_0.last_modified_date,ts1_0.last_modified_date),count(s3_0.id) from competency cc1_0 left join competency_exercise el1_0 on cc1_0.id=el1_0.competency_id left join exercise e1_0 on e1_0.id=el1_0.exercise_id left join competency_exercise cl1_0 on e1_0.id=cl1_0.exercise_id and cl1_0.competency_id=cc1_0.id left join ((select * from participation t where t.discriminator in ('PESP', 'SP')) sp1_0 join team t1_0 on t1_0.id=sp1_0.team_id) on e1_0.id=sp1_0.exercise_id and (sp1_0.student_id=? or ? in (select s2_0.student_id from team_student s2_0 where t1_0.id=s2_0.team_id)) left join submission s3_0 on sp1_0.id=s3_0.participation_id left join (select * from participant_score t where t.discriminator='SS') ss1_0 on ss1_0.exercise_id=e1_0.id and ss1_0.user_id=? left join ((select * from participant_score t where t.discriminator='TS') ts1_0 join team t2_0 on t2_0.id=ts1_0.team_id) on ts1_0.exercise_id=e1_0.id and ? in (select s4_0.student_id from team_student s4_0 where t2_0.id=s4_0.team_id) where cc1_0.id=? and el1_0.exercise_id is not null group by e1_0.max_points,e1_0.difficulty,e1_0.discriminator,ss1_0.last_score,ts1_0.last_score,ss1_0.last_points,ts1_0.last_points,ss1_0.last_modified_date,ts1_0.last_modified_date] [Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.cl1_0.link_weight' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by] [n/a]; SQL [n/a]
Raw output
org.springframework.dao.InvalidDataAccessResourceUsageException: JDBC exception executing SQL [select e1_0.max_points,e1_0.difficulty,case when e1_0.discriminator='P' then 1 else 0 end,cl1_0.link_weight,coalesce(ss1_0.last_score,ts1_0.last_score),coalesce(ss1_0.last_points,ts1_0.last_points),coalesce(ss1_0.last_modified_date,ts1_0.last_modified_date),count(s3_0.id) from competency cc1_0 left join competency_exercise el1_0 on cc1_0.id=el1_0.competency_id left join exercise e1_0 on e1_0.id=el1_0.exercise_id left join competency_exercise cl1_0 on e1_0.id=cl1_0.exercise_id and cl1_0.competency_id=cc1_0.id left join ((select * from participation t where t.discriminator in ('PESP', 'SP')) sp1_0 join team t1_0 on t1_0.id=sp1_0.team_id) on e1_0.id=sp1_0.exercise_id and (sp1_0.student_id=? or ? in (select s2_0.student_id from team_student s2_0 where t1_0.id=s2_0.team_id)) left join submission s3_0 on sp1_0.id=s3_0.participation_id left join (select * from participant_score t where t.discriminator='SS') ss1_0 on ss1_0.exercise_id=e1_0.id and ss1_0.user_id=? left join ((select * from participant_score t where t.discriminator='TS') ts1_0 join team t2_0 on t2_0.id=ts1_0.team_id) on ts1_0.exercise_id=e1_0.id and ? in (select s4_0.student_id from team_student s4_0 where t2_0.id=s4_0.team_id) where cc1_0.id=? and el1_0.exercise_id is not null group by e1_0.max_points,e1_0.difficulty,e1_0.discriminator,ss1_0.last_score,ts1_0.last_score,ss1_0.last_points,ts1_0.last_points,ss1_0.last_modified_date,ts1_0.last_modified_date] [Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.cl1_0.link_weight' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by] [n/a]; SQL [n/a]
	at app//org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:277)
	at app//org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:241)
	at app//org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:550)
	at app//org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:61)
	at app//org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:335)
	at app//org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:160)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:136)
	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.$Proxy395.findAllExerciseInfoByCompetencyId(Unknown Source)
	at [email protected]/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	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.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:216)
	at app/jdk.proxy3/jdk.proxy3.$Proxy395.findAllExerciseInfoByCompetencyId(Unknown Source)
	at app//de.tum.cit.aet.artemis.atlas.service.competency.CompetencyProgressService.updateCompetencyProgress(CompetencyProgressService.java:212)
	at app//de.tum.cit.aet.artemis.atlas.service.competency.CompetencyProgressService.updateCompetencyProgress(CompetencyProgressService.java:202)
	at [email protected]/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	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.atlas.service.competency.CompetencyProgressService$$SpringCGLIB$$0.updateCompetencyProgress(<generated>)
	at app//de.tum.cit.aet.artemis.atlas.learningpath.LearningPathIntegrationTest.lambda$testGetLearningPathCompetencyGraph$5(LearningPathIntegrationTest.java:419)
	at [email protected]/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:1024)
	at [email protected]/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:762)
	at app//de.tum.cit.aet.artemis.atlas.learningpath.LearningPathIntegrationTest.testGetLearningPathCompetencyGraph(LearningPathIntegrationTest.java:419)
	at [email protected]/java.lang.reflect.Method.invoke(Method.java:580)
	at [email protected]/java.util.concurrent.RecursiveAction.exec(RecursiveAction.java:194)
	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.SQLGrammarException: JDBC exception executing SQL [select e1_0.max_points,e1_0.difficulty,case when e1_0.discriminator='P' then 1 else 0 end,cl1_0.link_weight,coalesce(ss1_0.last_score,ts1_0.last_score),coalesce(ss1_0.last_points,ts1_0.last_points),coalesce(ss1_0.last_modified_date,ts1_0.last_modified_date),count(s3_0.id) from competency cc1_0 left join competency_exercise el1_0 on cc1_0.id=el1_0.competency_id left join exercise e1_0 on e1_0.id=el1_0.exercise_id left join competency_exercise cl1_0 on e1_0.id=cl1_0.exercise_id and cl1_0.competency_id=cc1_0.id left join ((select * from participation t where t.discriminator in ('PESP', 'SP')) sp1_0 join team t1_0 on t1_0.id=sp1_0.team_id) on e1_0.id=sp1_0.exercise_id and (sp1_0.student_id=? or ? in (select s2_0.student_id from team_student s2_0 where t1_0.id=s2_0.team_id)) left join submission s3_0 on sp1_0.id=s3_0.participation_id left join (select * from participant_score t where t.discriminator='SS') ss1_0 on ss1_0.exercise_id=e1_0.id and ss1_0.user_id=? left join ((select * from participant_score t where t.discriminator='TS') ts1_0 join team t2_0 on t2_0.id=ts1_0.team_id) on ts1_0.exercise_id=e1_0.id and ? in (select s4_0.student_id from team_student s4_0 where t2_0.id=s4_0.team_id) where cc1_0.id=? and el1_0.exercise_id is not null group by e1_0.max_points,e1_0.difficulty,e1_0.discriminator,ss1_0.last_score,ts1_0.last_score,ss1_0.last_points,ts1_0.last_points,ss1_0.last_modified_date,ts1_0.last_modified_date] [Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.cl1_0.link_weight' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by] [n/a]
	at app//org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:66)
	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.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:94)
	at app//org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.executeQuery(DeferredResultSetAccess.java:264)
	at app//org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.getResultSet(DeferredResultSetAccess.java:167)
	at app//org.hibernate.sql.results.jdbc.internal.JdbcValuesResultSetImpl.advanceNext(JdbcValuesResultSetImpl.java:218)
	at app//org.hibernate.sql.results.jdbc.internal.JdbcValuesResultSetImpl.processNext(JdbcValuesResultSetImpl.java:98)
	at app//org.hibernate.sql.results.jdbc.internal.AbstractJdbcValues.next(AbstractJdbcValues.java:19)
	at app//org.hibernate.sql.results.internal.RowProcessingStateStandardImpl.next(RowProcessingStateStandardImpl.java:66)
	at app//org.hibernate.sql.results.spi.ListResultsConsumer.consume(ListResultsConsumer.java:202)
	at app//org.hibernate.sql.results.spi.ListResultsConsumer.consume(ListResultsConsumer.java:33)
	at app//org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.doExecuteQuery(JdbcSelectExecutorStandardImpl.java:209)
	at app//org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.executeQuery(JdbcSelectExecutorStandardImpl.java:83)
	at app//org.hibernate.sql.exec.spi.JdbcSelectExecutor.list(JdbcSelectExecutor.java:76)
	at app//org.hibernate.sql.exec.spi.JdbcSelectExecutor.list(JdbcSelectExecutor.java:65)
	at app//org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.lambda$new$2(ConcreteSqmSelectQueryPlan.java:137)
	at app//org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.withCacheableSqmInterpretation(ConcreteSqmSelectQueryPlan.java:381)
	at app//org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.performList(ConcreteSqmSelectQueryPlan.java:303)
	at app//org.hibernate.query.sqm.internal.QuerySqmImpl.doList(QuerySqmImpl.java:509)
	at app//org.hibernate.query.spi.AbstractSelectionQuery.list(AbstractSelectionQuery.java:427)
	at app//org.hibernate.query.Query.getResultList(Query.java:120)
	at [email protected]/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at [email protected]/java.lang.reflect.Method.invoke(Method.java:580)
	at app//org.springframework.orm.jpa.SharedEntityManagerCreator$DeferredQueryInvocationHandler.invoke(SharedEntityManagerCreator.java:418)
	at app/jdk.proxy3/jdk.proxy3.$Proxy588.getResultList(Unknown Source)
	at app//org.springframework.data.jpa.repository.query.JpaQueryExecution$CollectionExecution.doExecute(JpaQueryExecution.java:129)
	at app//org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:92)
	at app//org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:152)
	at app//org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:140)
	at app//org.springframework.data.repository.core.support.RepositoryMethodInvoker.doInvoke(RepositoryMethodInvoker.java:170)
	at app//org.springframework.data.repository.core.support.RepositoryMethodInvoker.invoke(RepositoryMethodInvoker.java:158)
	at app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.doInvoke(QueryExecutorMethodInterceptor.java:169)
	at app//org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.invoke(QueryExecutorMethodInterceptor.java:148)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:70)
	at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at app//org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:379)
	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:136)
	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.$Proxy395.findAllExerciseInfoByCompetencyId(Unknown Source)
	at [email protected]/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	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.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:216)
	at app/jdk.proxy3/jdk.proxy3.$Proxy395.findAllExerciseInfoByCompetencyId(Unknown Source)
	at app//de.tum.cit.aet.artemis.atlas.service.competency.CompetencyProgressService.updateCompetencyProgress(CompetencyProgressService.java:212)
	at [email protected]/java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:733)
	at org.mockito.internal.util.reflection.InstrumentationMemberAccessor$Dispatcher$ByteBuddy$rNW3SvCH.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)
	... 17 more
Caused by: java.sql.SQLSyntaxErrorException: Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.cl1_0.link_weight' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:112)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:114)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:988)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1056)
	at org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.executeQuery(DeferredResultSetAccess.java:246)
	... 80 more

Check failure on line 255 in src/test/java/de/tum/cit/aet/artemis/core/service/DataExportCreationServiceTest.java

See this annotation in the file changed.

@github-actions github-actions / MySQL Tests

de.tum.cit.aet.artemis.core.service.DataExportCreationServiceTest ► testDataExportCreationSuccess_containsCorrectCourseContent()

Failed test found in:
  build/test-results/test/TEST-de.tum.cit.aet.artemis.core.service.DataExportCreationServiceTest.xml
Error:
  java.lang.AssertionError: 
Raw output
java.lang.AssertionError: 
Expecting actual:
  [de.tum.cit.aet.artemis.atlas.domain.science.ScienceEvent@0,
    de.tum.cit.aet.artemis.atlas.domain.science.ScienceEvent@0,
    de.tum.cit.aet.artemis.atlas.domain.science.ScienceEvent@0]
to contain exactly in any order:
  [de.tum.cit.aet.artemis.atlas.domain.science.ScienceEvent@41,
    de.tum.cit.aet.artemis.atlas.domain.science.ScienceEvent@42,
    de.tum.cit.aet.artemis.atlas.domain.science.ScienceEvent@40]
elements not found:
  [de.tum.cit.aet.artemis.atlas.domain.science.ScienceEvent@41,
    de.tum.cit.aet.artemis.atlas.domain.science.ScienceEvent@42,
    de.tum.cit.aet.artemis.atlas.domain.science.ScienceEvent@40]
and elements not expected:
  [de.tum.cit.aet.artemis.atlas.domain.science.ScienceEvent@0,
    de.tum.cit.aet.artemis.atlas.domain.science.ScienceEvent@0,
    de.tum.cit.aet.artemis.atlas.domain.science.ScienceEvent@0]
when comparing values using Comparator$$Lambda/0x00007fe5b4267ee8
	at de.tum.cit.aet.artemis.core.service.DataExportCreationServiceTest.assertScienceEventsCSVFile(DataExportCreationServiceTest.java:255)
	at de.tum.cit.aet.artemis.core.service.DataExportCreationServiceTest.testDataExportCreationSuccess_containsCorrectCourseContent(DataExportCreationServiceTest.java:214)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at java.base/java.util.concurrent.RecursiveAction.exec(RecursiveAction.java:194)
	at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387)
	at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1312)
	at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1843)
	at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1808)
	at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:188)

Check failure on line 769 in src/test/java/de/tum/cit/aet/artemis/core/util/RequestUtilService.java

See this annotation in the file changed.

@github-actions github-actions / MySQL Tests

de.tum.cit.aet.artemis.quiz.QuizExerciseIntegrationTest ► testDeleteQuizExerciseWithSubmittedAnswers(QuizMode) [1] quizMode=SYNCHRONIZED

Failed test found in:
  build/test-results/test/TEST-de.tum.cit.aet.artemis.quiz.QuizExerciseIntegrationTest.xml
  build/test-results/test/TEST-de.tum.cit.aet.artemis.quiz.QuizExerciseIntegrationTest.xml
  build/test-results/test/TEST-de.tum.cit.aet.artemis.quiz.QuizExerciseIntegrationTest.xml
Error:
  java.lang.AssertionError: Response status expected:<200> but was:<500>
Raw output
java.lang.AssertionError: Response status expected:<200> but was:<500>
	at org.springframework.test.util.AssertionErrors.fail(AssertionErrors.java:59)
	at org.springframework.test.util.AssertionErrors.assertEquals(AssertionErrors.java:122)
	at org.springframework.test.web.servlet.result.StatusResultMatchers.lambda$is$1(StatusResultMatchers.java:64)
	at org.springframework.test.web.servlet.MockMvc$1.andExpect(MockMvc.java:214)
	at de.tum.cit.aet.artemis.core.util.RequestUtilService.delete(RequestUtilService.java:769)
	at de.tum.cit.aet.artemis.quiz.QuizExerciseIntegrationTest.testDeleteQuizExerciseWithSubmittedAnswers(QuizExerciseIntegrationTest.java:518)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
	at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:179)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
	at java.base/java.util.Iterator.forEachRemaining(Iterator.java:133)
	at java.base/java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1939)
	at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
	at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
	at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:276)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1708)
	at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
	at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
	at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:276)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1708)
	at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
	at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
	at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:276)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1708)
	at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
	at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
	at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
	at java.base/java.util.concurrent.RecursiveAction.exec(RecursiveAction.java:194)
	at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387)
	at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1312)
	at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1843)
	at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1808)
	at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:188)

Check failure on line 769 in src/test/java/de/tum/cit/aet/artemis/core/util/RequestUtilService.java

See this annotation in the file changed.

@github-actions github-actions / MySQL Tests

de.tum.cit.aet.artemis.quiz.QuizSubmissionIntegrationTest ► testQuizSubmitScheduledAndDeleted()

Failed test found in:
  build/test-results/test/TEST-de.tum.cit.aet.artemis.quiz.QuizSubmissionIntegrationTest.xml
Error:
  java.lang.AssertionError: Response status expected:<200> but was:<500>
Raw output
java.lang.AssertionError: Response status expected:<200> but was:<500>
	at org.springframework.test.util.AssertionErrors.fail(AssertionErrors.java:59)
	at org.springframework.test.util.AssertionErrors.assertEquals(AssertionErrors.java:122)
	at org.springframework.test.web.servlet.result.StatusResultMatchers.lambda$is$1(StatusResultMatchers.java:64)
	at org.springframework.test.web.servlet.MockMvc$1.andExpect(MockMvc.java:214)
	at de.tum.cit.aet.artemis.core.util.RequestUtilService.delete(RequestUtilService.java:769)
	at de.tum.cit.aet.artemis.quiz.QuizSubmissionIntegrationTest.testQuizSubmitScheduledAndDeleted(QuizSubmissionIntegrationTest.java:593)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at java.base/java.util.concurrent.RecursiveAction.exec(RecursiveAction.java:194)
	at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387)
	at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1312)
	at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1843)
	at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1808)
	at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:188)