installation sous postgresql

[CedricLevasseur]

Bonjour,
J'essaie d'installer squashtm sous postgresql mais je me retrouve avec des erreurs hibernates que je ne sais pas interpréter .. !
SquashTM ne démarre plus, et voici ses logs au démarrage :

[19-04-23 09:29:17.112] SquashTM - 35115 WARN [main] [] --- org.hibernate.orm.deprecation: HHH90000016: Found use of deprecated 'collection property' syntax in HQL/JPQL query [mil.campaigns.size]; use collection function syntax instead [size(mil.campaigns)].
[19-04-23 09:29:17.337] SquashTM - 35115 WARN [main] [] --- org.hibernate.orm.deprecation: HHH90000017: Found use of deprecated entity-type selector syntax in HQL/JPQL query ['step.class']; use TYPE operator instead : type(step)
[19-04-23 09:29:17.380] SquashTM - 35115 WARN [main] [] --- org.hibernate.orm.deprecation: HHH90000017: Found use of deprecated entity-type selector syntax in HQL/JPQL query ['cfv.class']; use TYPE operator instead : type(cfv)
[19-04-23 09:29:17.391] SquashTM - 35115 ERROR [main] [] --- org.hibernate.internal.SessionFactoryImpl: HHH000177: Error in named query: requirement.findFolderPaths
org.hibernate.QueryException: No data type for node: org.hibernate.hql.internal.ast.tree.MethodNode
\-[METHOD_CALL] MethodNode: '('
+-[METHOD_NAME] IdentNode: 'group_concat' {originalText=group_concat}
\-[EXPR_LIST] SqlNode: 'exprList'
+-[DOT] DotNode: 'simplereso3_1_.NAME' {propertyName=name,dereferenceType=PRIMITIVE,getPropertyPath=name,path=folder.resource.name,tableAlias=simplereso3_,className=org.squashtest.tm.domain.resource.SimpleResource,classAlias=null}
| +-[DOT] DotNode: 'requiremen1_.RES_ID' {propertyName=resource,dereferenceType=ENTITY,getPropertyPath=resource,path=folder.resource,tableAlias=simplereso3_,className=org.squashtest.tm.domain.resource.SimpleResource,classAlias=null}
| | +-[ALIAS_REF] IdentNode: 'requiremen1_.RLN_ID' {alias=folder, className=org.squashtest.tm.domain.requirement.RequirementFolder, tableAlias=requiremen1_}
| | \-[IDENT] IdentNode: 'resource' {originalText=resource}
| \-[IDENT] IdentNode: 'name' {originalText=name}
+-[QUOTED_STRING] LiteralNode: ''order by''
+-[DOT] DotNode: 'requiremen2_.DEPTH' {propertyName=depth,dereferenceType=PRIMITIVE,getPropertyPath=depth,path=closure.depth,tableAlias=requiremen2_,className=org.squashtest.tm.domain.requirement.RequirementPathEdge,classAlias=closure}
| +-[ALIAS_REF] IdentNode: '(requiremen2_.ANCESTOR_ID, requiremen2_.DESCENDANT_ID)' {alias=closure, className=org.squashtest.tm.domain.requirement.RequirementPathEdge, tableAlias=requiremen2_}
| \-[IDENT] IdentNode: 'depth' {originalText=depth}
+-[QUOTED_STRING] LiteralNode: ''desc''
\-[QUOTED_STRING] LiteralNode: ''^_''
[select requirement1.id , group_concat(folder.resource.name, 'order by', closure.depth, 'desc', '^_') from org.squashtest.tm.domain.requirement.Requirement requirement1, org.squashtest.tm.domain.requirement.RequirementFolder folder, org.squashtest.tm.domain.requirement.RequirementPathEdge closure where closure.ancestorId = folder.id and closure.descendantId = requirement1.id and requirement1.id in :requirementIds and closure.depth != 0 group by requirement1.id]
at org.hibernate.QueryException.generateQueryException(QueryException.java:120) ~[hibernate-core-5.2.12.Final.jar!/:5.2.12.Final]
at org.hibernate.QueryException.wrapWithQueryString(QueryException.java:103) ~[hibernate-core-5.2.12.Final.jar!/:5.2.12.Final]
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:217) ~[hibernate-core-5.2.12.Final.jar!/:5.2.12.Final]
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:141) ~[hibernate-core-5.2.12.Final.jar!/:5.2.12.Final]
at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:115) ~[hibernate-core-5.2.12.Final.jar!/:5.2.12.Final]
at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:77) ~[hibernate-core-5.2.12.Final.jar!/:5.2.12.Final]
at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:153) ~[hibernate-core-5.2.12.Final.jar!/:5.2.12.Final]
at org.hibernate.query.spi.NamedQueryRepository.checkNamedQueries(NamedQueryRepository.java:157) ~[hibernate-core-5.2.12.Final.jar!/:5.2.12.Final]
at org.hibernate.internal.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:534) ~[hibernate-core-5.2.12.Final.jar!/:5.2.12.Final]
at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:324) ~[hibernate-core-5.2.12.Final.jar!/:5.2.12.Final]
at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:452) ~[hibernate-core-5.2.12.Final.jar!/:5.2.12.Final]
at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:889) ~[hibernate-core-5.2.12.Final.jar!/:5.2.12.Final]
at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:57) ~[spring-orm-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365) ~[spring-orm-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:390) ~[spring-orm-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:377) ~[spring-orm-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:341) ~[spring-orm-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1767) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1704) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:581) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:503) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:317) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:315) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:224) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveNamedBean(DefaultListableBeanFactory.java:1015) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveNamedBean(DefaultListableBeanFactory.java:984) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.findDefaultEntityManagerFactory(PersistenceAnnotationBeanPostProcessor.java:568) ~[spring-orm-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.findEntityManagerFactory(PersistenceAnnotationBeanPostProcessor.java:531) ~[spring-orm-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor$PersistenceElement.resolveEntityManager(PersistenceAnnotationBeanPostProcessor.java:699) ~[spring-orm-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor$PersistenceElement.getResourceToInject(PersistenceAnnotationBeanPostProcessor.java:672) ~[spring-orm-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:177) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:91) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor.postProcessPropertyValues(PersistenceAnnotationBeanPostProcessor.java:352) ~[spring-orm-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1350) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:580) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:503) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:317) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:315) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:251) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1065) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:584) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:91) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:373) ~[spring-beans-5.0.7.RELEASE.jar!/:5.0.7.RELEASE]





Merci de votre aide.
Cordialement

[CedricLevasseur]

Pour info :
voici ma version de postgresql : rpm -qa | grep postgresql
postgresql-libs-9.2.24-1.el7_5.x86_64
postgresql-contrib-9.2.24-1.el7_5.x86_64
postgresql-server-9.2.24-1.el7_5.x86_64
postgresql-9.2.24-1.el7_5.x86_64

Pour ce qui est de squashtm, la version de java est (rpm) jdk1.8-1.8.0_181
Mes machines sont sous Red Hat Enterprise Linux Server release 7.4

[agoethals]

Bonjour,

merci pour ces informations.
Pouvez-vous nous préciser quelle est la version de squash-tm ?

[CedricLevasseur]

C'est la version 1.19 installé à partir du RPM : squash-tm-1.19.2.RELEASE-6.el6.noarch.rpm

Pour la base de données, j'ai utilisée les commandes suivantes :
CREATE DATABASE "squashtm2" WITH ENCODING='UTF8';
GRANT ALL PRIVILEGES ON DATABASE squashtm2 TO "squashtm";

Et j'ai utilisé une commande pour passer l'utilisateur squashtm en Superuser aussi !

Enfin, j'ai lancé le script suivant depuis la machine qui héberge squashtm (squashtm et postgresql sont sur deux machines différentes)
psql -h <monip> -U squashtm squashtm2 -f /usr/share/doc/squash-tm/database-scripts/postgresql-full-install-version-1.19.2.RELEASE.sql

[agoethals]

Merci, c'est bien la bonne méthode pour installation.
Pourriez vous nous faire parvenir le log complet (en attendant que la fonctionnalité de pièces jointes soit disponible, vous pouvez l'héberger sur pastebin par exemple), pour transmission à l'équipe de développement ?

[CedricLevasseur]

Voici :

https://pastebin.com/T8QjiD58


Merci

[agoethals]

Merci, je remonte l'incident.

[agoethals]

Re bonjour,

après échanges avec l'équipe développement, pouvez-vous essayer en modifiant un des fichiers de configuration de squash (par exemple /etc/sysconfig/squash-tm si l'installation a été faite par le rpm), pour y ajouter les lignes suivantes:

Code : Tout sélectionner

spring.jpa.properties.hibernate.dialect=org.squashtest.tm.domain.jpql.PostgresEnhancedDialect
jooq.sql.dialect=POSTGRES

puis redémarrer le service squash-tm ?

[CedricLevasseur]

Bonjour

Pas mieux. J'ai détruit/reconstruit la base de donnée pour être sur. Mais non.
https://pastebin.com/LWy0dSz9

Cordialement

[CedricLevasseur]

Bonjour

Je viens d'installer mysql (innobd) et de redémarrer squashtm
Tout s'est bien passé.

Je ne comprends pas ce qui s'est passé avec postgresql pour que cela ne fonctionne pas.

J'essayerais d'investiguer pour éventuellement vous fournir un bug, si je trouve un peu de temps.

Bon weekend

Cédric