8355 passed, 7 failed and 2 skipped
Annotations
Check failure on line 654 in src/test/java/de/tum/cit/aet/artemis/core/util/RequestUtilService.java
github-actions / PostgreSQL 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
github-actions / PostgreSQL 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)
github-actions / PostgreSQL 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.id,e1_0.max_points,e1_0.difficulty,case when e1_0.discriminator='P' then true else false end,el1_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 ((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.id,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] [ERROR: column "el1_0.link_weight" must appear in the GROUP BY clause or be used in an aggregate function
Raw output
org.springframework.dao.InvalidDataAccessResourceUsageException: JDBC exception executing SQL [select e1_0.id,e1_0.max_points,e1_0.difficulty,case when e1_0.discriminator='P' then true else false end,el1_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 ((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.id,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] [ERROR: column "el1_0.link_weight" must appear in the GROUP BY clause or be used in an aggregate function
Position: 106] [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.findAllExerciseInfoByCompetencyIdAndUser(Unknown Source)
at java.base@21.0.5/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base@21.0.5/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.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
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.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:223)
at app/jdk.proxy3/jdk.proxy3.$Proxy395.findAllExerciseInfoByCompetencyIdAndUser(Unknown Source)
at app//de.tum.cit.aet.artemis.atlas.service.competency.CompetencyProgressService.updateCompetencyProgress(CompetencyProgressService.java:211)
at app//de.tum.cit.aet.artemis.atlas.service.competency.CompetencyProgressService.updateCompetencyProgress(CompetencyProgressService.java:203)
at java.base@21.0.5/java.lang.Iterable.forEach(Iterable.java:75)
at app//de.tum.cit.aet.artemis.atlas.service.competency.CompetencyProgressService.updateProgressByLearningObjectSync(CompetencyProgressService.java:191)
at app//de.tum.cit.aet.artemis.atlas.service.competency.CompetencyProgressService.updateProgressByLearningObjectSync(CompetencyProgressService.java:186)
at java.base@21.0.5/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base@21.0.5/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:537)
at java.base@21.0.5/java.lang.reflect.Method.invoke(Method.java:580)
at java.base@21.0.5/java.util.concurrent.RecursiveAction.exec(RecursiveAction.java:194)
at java.base@21.0.5/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387)
at java.base@21.0.5/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1312)
at java.base@21.0.5/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1843)
at java.base@21.0.5/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1808)
at java.base@21.0.5/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:188)
Caused by: org.hibernate.exception.SQLGrammarException: JDBC exception executing SQL [select e1_0.id,e1_0.max_points,e1_0.difficulty,case when e1_0.discriminator='P' then true else false end,el1_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 ((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.id,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] [ERROR: column "el1_0.link_weight" must appear in the GROUP BY clause or be used in an aggregate function
Position: 106] [n/a]
at app//org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:91)
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 java.base@21.0.5/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base@21.0.5/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.$Proxy589.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.findAllExerciseInfoByCompetencyIdAndUser(Unknown Source)
at java.base@21.0.5/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base@21.0.5/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.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
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.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:223)
at app/jdk.proxy3/jdk.proxy3.$Proxy395.findAllExerciseInfoByCompetencyIdAndUser(Unknown Source)
at app//de.tum.cit.aet.artemis.atlas.service.competency.CompetencyProgressService.updateCompetencyProgress(CompetencyProgressService.java:211)
at java.base@21.0.5/java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:733)
at org.mockito.internal.util.reflection.InstrumentationMemberAccessor$Dispatcher$ByteBuddy$iAFyRvJa.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:203)
at app//de.tum.cit.aet.artemis.atlas.service.competency.CompetencyProgressService.lambda$updateProgressByLearningObjectSync$7(CompetencyProgressService.java:191)
at java.base@21.0.5/java.lang.Iterable.forEach(Iterable.java:75)
at app//de.tum.cit.aet.artemis.atlas.service.competency.CompetencyProgressService.updateProgressByLearningObjectSync(CompetencyProgressService.java:191)
at java.base@21.0.5/java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:733)
at org.mockito.internal.util.reflection.InstrumentationMemberAccessor$Dispatcher$ByteBuddy$iAFyRvJa.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: org.postgresql.util.PSQLException: ERROR: column "el1_0.link_weight" must appear in the GROUP BY clause or be used in an aggregate function
Position: 106
at app//org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2733)
at app//org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2420)
at app//org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:372)
at app//org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:517)
at app//org.postgresql.jdbc.PgStatement.execute(PgStatement.java:434)
at app//org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:194)
at app//org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:137)
at app//org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.executeQuery(DeferredResultSetAccess.java:246)
... 99 more
Check failure on line 654 in src/test/java/de/tum/cit/aet/artemis/core/util/RequestUtilService.java
github-actions / PostgreSQL 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:728)
at de.tum.cit.aet.artemis.atlas.learningpath.LearningPathIntegrationTest.testGetCompetencyProgressForLearningPathByOwner(LearningPathIntegrationTest.java:521)
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
github-actions / PostgreSQL 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:728)
at de.tum.cit.aet.artemis.atlas.learningpath.LearningPathIntegrationTest.testGetCompetencyProgressForLearningPathByInstructor(LearningPathIntegrationTest.java:527)
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)
github-actions / PostgreSQL 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.id,e1_0.max_points,e1_0.difficulty,case when e1_0.discriminator='P' then true else false end,el1_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 ((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.id,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] [ERROR: column "el1_0.link_weight" must appear in the GROUP BY clause or be used in an aggregate function
Raw output
org.springframework.dao.InvalidDataAccessResourceUsageException: JDBC exception executing SQL [select e1_0.id,e1_0.max_points,e1_0.difficulty,case when e1_0.discriminator='P' then true else false end,el1_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 ((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.id,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] [ERROR: column "el1_0.link_weight" must appear in the GROUP BY clause or be used in an aggregate function
Position: 106] [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.findAllExerciseInfoByCompetencyIdAndUser(Unknown Source)
at java.base@21.0.5/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base@21.0.5/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.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
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.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:223)
at app/jdk.proxy3/jdk.proxy3.$Proxy395.findAllExerciseInfoByCompetencyIdAndUser(Unknown Source)
at app//de.tum.cit.aet.artemis.atlas.service.competency.CompetencyProgressService.updateCompetencyProgress(CompetencyProgressService.java:211)
at app//de.tum.cit.aet.artemis.atlas.service.competency.CompetencyProgressService.updateCompetencyProgress(CompetencyProgressService.java:203)
at java.base@21.0.5/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base@21.0.5/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:397)
at java.base@21.0.5/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:1024)
at java.base@21.0.5/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:762)
at app//de.tum.cit.aet.artemis.atlas.learningpath.LearningPathIntegrationTest.testGetLearningPathCompetencyGraph(LearningPathIntegrationTest.java:397)
at java.base@21.0.5/java.lang.reflect.Method.invoke(Method.java:580)
at java.base@21.0.5/java.util.concurrent.RecursiveAction.exec(RecursiveAction.java:194)
at java.base@21.0.5/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387)
at java.base@21.0.5/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1312)
at java.base@21.0.5/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1843)
at java.base@21.0.5/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1808)
at java.base@21.0.5/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:188)
Caused by: org.hibernate.exception.SQLGrammarException: JDBC exception executing SQL [select e1_0.id,e1_0.max_points,e1_0.difficulty,case when e1_0.discriminator='P' then true else false end,el1_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 ((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.id,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] [ERROR: column "el1_0.link_weight" must appear in the GROUP BY clause or be used in an aggregate function
Position: 106] [n/a]
at app//org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:91)
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 java.base@21.0.5/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base@21.0.5/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.$Proxy589.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.findAllExerciseInfoByCompetencyIdAndUser(Unknown Source)
at java.base@21.0.5/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base@21.0.5/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.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
at app//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
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.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:223)
at app/jdk.proxy3/jdk.proxy3.$Proxy395.findAllExerciseInfoByCompetencyIdAndUser(Unknown Source)
at app//de.tum.cit.aet.artemis.atlas.service.competency.CompetencyProgressService.updateCompetencyProgress(CompetencyProgressService.java:211)
at java.base@21.0.5/java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:733)
at org.mockito.internal.util.reflection.InstrumentationMemberAccessor$Dispatcher$ByteBuddy$iAFyRvJa.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: org.postgresql.util.PSQLException: ERROR: column "el1_0.link_weight" must appear in the GROUP BY clause or be used in an aggregate function
Position: 106
at app//org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2733)
at app//org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2420)
at app//org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:372)
at app//org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:517)
at app//org.postgresql.jdbc.PgStatement.execute(PgStatement.java:434)
at app//org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:194)
at app//org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:137)
at app//org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.executeQuery(DeferredResultSetAccess.java:246)
... 84 more
github-actions / PostgreSQL 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@42,
de.tum.cit.aet.artemis.atlas.domain.science.ScienceEvent@41,
de.tum.cit.aet.artemis.atlas.domain.science.ScienceEvent@40]
elements not found:
[de.tum.cit.aet.artemis.atlas.domain.science.ScienceEvent@42,
de.tum.cit.aet.artemis.atlas.domain.science.ScienceEvent@41,
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/0x00007fd25c2672d0
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)