Je rencontre un problème avec Squash TM 5.0.0 et MariaDB.
Les logs mentionnent une erreur de syntaxe SQL lorsque je consulte la liste des utilisateurs (première manipulation après installation et connexion au compte admin) :
Code : Tout sélectionner
[...]
[23-03-17 15:32:37.997] SquashTM - 7937 WARN [squashtest.tm.service.ThreadPoolTaskScheduler-1] [] --- org.hibernate.orm.deprecation: HHH90000022: Hibernate's legacy org.hibernate.Criteria A
PI is deprecated; use the JPA javax.persistence.criteria.CriteriaQuery instead
[23-03-17 15:32:46.053] SquashTM - 7937 ERROR [http-nio-7777-exec-4] [ServletWebRequest: uri=/squash/backend/users;client=127.0.0.1;session=0A4FDE95296C3F838A186B0CA522E468;user=admin] --- o
rg.squashtest.tm.web.backend.exceptionresolver.HandlerExceptionLogger: An exception occured while processing request : http://localhost:7777/squash/backend/users
org.jooq.exception.DataAccessException: SQL [select `CORE_USER`.`PARTY_ID`, `CORE_USER`.`ACTIVE`, `CORE_USER`.`LOGIN`, `CORE_GROUP`.`QUALIFIED_NAME` as `USER_GROUP`, `CORE_USER`.`FIRST_NAME`
, `CORE_USER`.`LAST_NAME`, `CORE_USER`.`EMAIL`, `CORE_USER`.`CREATED_ON`, `CORE_USER`.`CREATED_BY`, IFNULL(HABILITATION_COUNT, ?) as `HABILITATION_COUNT`, IFNULL(TEAM_COUNT, ?) as `TEAM_COUN
T`, `CORE_USER`.`LAST_CONNECTED_ON` from `CORE_USER` left outer join `CORE_GROUP_MEMBER` on `CORE_GROUP_MEMBER`.`PARTY_ID` = `CORE_USER`.`PARTY_ID` left outer join `CORE_GROUP` on `CORE_GROU
P_MEMBER`.`GROUP_ID` = `CORE_GROUP`.`ID` left outer join (select `CORE_USER`.`PARTY_ID` as `TEAM_MEMBER_ID`, COUNT(`CORE_TEAM_MEMBER`.`TEAM_ID`) as `TEAM_COUNT` from `CORE_USER` left outer j
oin `CORE_TEAM_MEMBER` on `CORE_TEAM_MEMBER`.`USER_ID` = `CORE_USER`.`PARTY_ID` group by `CORE_USER`.`PARTY_ID`) as `ALIAS_9928152` on `ALIAS_9928152`.`TEAM_MEMBER_ID` = `CORE_USER`.`PARTY_I
D` left outer join (select `CORE_USER`.`PARTY_ID` as `USER_ID`, COUNT(`ACL_RESPONSIBILITY_SCOPE_ENTRY`.`ID`) as `HABILITATION_COUNT` from `CORE_USER` left outer join `ACL_RESPONSIBILITY_SCOP
E_ENTRY` on `ACL_RESPONSIBILITY_SCOPE_ENTRY`.`PARTY_ID` = `CORE_USER`.`PARTY_ID` left outer join `ACL_OBJECT_IDENTITY` on `ACL_OBJECT_IDENTITY`.`ID` = `ACL_RESPONSIBILITY_SCOPE_ENTRY`.`OBJEC
T_IDENTITY_ID` where `ACL_OBJECT_IDENTITY`.`CLASS_ID` = ? group by `CORE_USER`.`PARTY_ID`) as `ALIAS_31927684` on `ALIAS_31927684`.`USER_ID` = `CORE_USER`.`PARTY_ID` where (? = ? and ? = ?)
order by UPPER(`CORE_USER`.`LOGIN`) asc offset ? rows fetch next ? rows only]; (conn=33) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server versio
n for the right syntax to use near 'offset 0 rows fetch next 25 rows only' at line 1
at org.jooq_3.16.11.MARIADB.debug(Unknown Source) ~[?:?]
at org.jooq.impl.Tools.translate(Tools.java:3103) ~[jooq-3.16.11.jar!/:?]
at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:670) ~[jooq-3.16.11.jar!/:?]
at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:354) ~[jooq-3.16.11.jar!/:?]
at org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:284) ~[jooq-3.16.11.jar!/:?]
at org.jooq.impl.SelectImpl.fetch(SelectImpl.java:2843) ~[jooq-3.16.11.jar!/:?]
at org.squashtest.tm.service.internal.display.grid.AbstractGrid.getRows(AbstractGrid.java:106) ~[tm.service-5.0.0.RELEASE.jar!/:?]
at org.squashtest.tm.service.internal.display.user.UserDisplayServiceImpl.findAll(UserDisplayServiceImpl.java:147) ~[tm.service-5.0.0.RELEASE.jar!/:?]
at org.squashtest.tm.service.internal.display.user.UserDisplayServiceImpl$$FastClassBySpringCGLIB$$bba114df.invoke(<generated>) ~[tm.service-5.0.0.RELEASE.jar!/:?]
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.23.jar!/:5.3.23]
[...]
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708) ~[spring-aop-5.3.23.jar!/:5.3.23]
at org.squashtest.tm.service.internal.display.user.UserDisplayServiceImpl$$EnhancerBySpringCGLIB$$b3d8330.findAll(<generated>) ~[tm.service-5.0.0.RELEASE.jar!/:?]
at org.squashtest.tm.web.backend.controller.user.UsersAdministrationController.getAllUsers(UsersAdministrationController.java:71) ~[classes!/:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
[...]
Je suis preneur de toute piste pour résoudre ce pb.
Cordialement,