iceScrum | iceScrum

iceScrum Forums Discuss on iceScrum

Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • Author
    Posts

  • Cmoi20
    Participant

    Bonjour,

    j’ai trouvé des informations concernant la cause de mon blocage.
    si avant de lancer l’installation, l’on positionne les informations de connexion a la base de donnée postgresql dans le fichier config.groovy , dans ce cas la, le service ne démarre plus correctement au redémarrage de tomcat.

    par contre, si l’on ne donne pas les informations de connexion a la bdd postgresql et que l’on laisse le processus d’installation les positionner, cela fonctionne parfaitement.

    je suis désolé pour le temps que je vous ai pris.

    Cordialement,


    Cmoi20
    Participant

    pour info, voici l’erreur rencontrée lors du redémarrage sans la modification du properties :

    2016-09-21 08:00:40,842 [172.17.41.23-startStop-1] ERROR org.springframework.web.context.ContextLoader  - Context initialization failed
    org.springframework.beans.factory.access.BootstrapException: Error executing bootstraps; nested exception is org.codehaus.groovy.runtime.InvokerInvocationException: liquibase.exception.LockException: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE databasechangeloglock (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP WITH TIME ZONE, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)); on jdbc:postgresql://172.17.41.23:5432/pocscrumINSERT INTO databasechangeloglock (ID, LOCKED) VALUES (1, FALSE): ERREUR: la relation « databasechangeloglock » existe déjà
            at org.codehaus.groovy.grails.web.context.GrailsContextLoader.createWebApplicationContext(GrailsContextLoader.java:87)
            at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
            at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
            at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4973)
            at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5467)
            at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
            at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
            at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
            at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
            at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1083)
            at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1880)
            at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
            at java.util.concurrent.FutureTask.run(FutureTask.java:262)
            at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
            at java.lang.Thread.run(Thread.java:745)
    Caused by: org.codehaus.groovy.runtime.InvokerInvocationException: liquibase.exception.LockException: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE databasechangeloglock (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP WITH TIME ZONE, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)); on jdbc:postgresql://172.17.41.23:5432/pocscrumINSERT INTO databasechangeloglock (ID, LOCKED) VALUES (1, FALSE): ERREUR: la relation « databasechangeloglock » existe déjà
            ... 5 more
    Caused by: liquibase.exception.LockException: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE databasechangeloglock (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP WITH TIME ZONE, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)); on jdbc:postgresql://172.17.41.23:5432/pocscrumINSERT INTO databasechangeloglock (ID, LOCKED) VALUES (1, FALSE): ERREUR: la relation « databasechangeloglock » existe déjà
            at liquibase.lockservice.LockService.acquireLock(LockService.java:121)
            at liquibase.lockservice.LockService.waitForLock(LockService.java:61)
            at liquibase.lockservice.LockService$waitForLock.call(Unknown Source)
            at liquibase.LiquibaseDsl.update(LiquibaseDsl.groovy:63)
            at liquibase.LiquibaseDsl$update.call(Unknown Source)
            at autobase.Autobase.migrate(Autobase.groovy:43)
            at autobase.Autobase$migrate.call(Unknown Source)
            at AutobaseGrailsPlugin$__clinit__closure9.doCall(AutobaseGrailsPlugin.groovy:103)
            at AutobaseGrailsPlugin.invokeMethod(AutobaseGrailsPlugin.groovy)
            at AutobaseGrailsPlugin$_closure2.doCall(AutobaseGrailsPlugin.groovy:114)
            ... 5 more
    Caused by: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE databasechangeloglock (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP WITH TIME ZONE, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)); on jdbc:postgresql://172.17.41.23:5432/pocscrumINSERT INTO databasechangeloglock (ID, LOCKED) VALUES (1, FALSE): ERREUR: la relation « databasechangeloglock » existe déjà
            at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
            at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
            at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:70)
            at liquibase.database.AbstractDatabase.checkDatabaseChangeLogLockTable(AbstractDatabase.java:564)
            at liquibase.lockservice.LockService.acquireLock(LockService.java:94)
            ... 14 more
    Caused by: org.postgresql.util.PSQLException: ERREUR: la relation « databasechangeloglock » existe déjà
            at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
            at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
            at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
            at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
            at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:406)
            at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:398)
            at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
            at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
            ... 18 more
    2016-09-21 08:00:40,844 [172.17.41.23-startStop-1] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[172.17.41.23].[/icescrum]  - Exception lors de l'envoi de l'évènement contexte initialisé (context initialized) à l'instance de classe d'écoute (listener) org.icescrum.core.IceScrumContextLoaderListener
    org.springframework.beans.factory.access.BootstrapException: Error executing bootstraps; nested exception is org.codehaus.groovy.runtime.InvokerInvocationException: liquibase.exception.LockException: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE databasechangeloglock (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP WITH TIME ZONE, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)); on jdbc:postgresql://172.17.41.23:5432/pocscrumINSERT INTO databasechangeloglock (ID, LOCKED) VALUES (1, FALSE): ERREUR: la relation « databasechangeloglock » existe déjà
            at org.codehaus.groovy.grails.web.context.GrailsContextLoader.createWebApplicationContext(GrailsContextLoader.java:87)
            at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
            at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
            at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4973)
            at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5467)
            at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
            at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
            at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
            at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
            at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1083)
            at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1880)
            at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
            at java.util.concurrent.FutureTask.run(FutureTask.java:262)
            at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
            at java.lang.Thread.run(Thread.java:745)
    Caused by: org.codehaus.groovy.runtime.InvokerInvocationException: liquibase.exception.LockException: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE databasechangeloglock (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP WITH TIME ZONE, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)); on jdbc:postgresql://172.17.41.23:5432/pocscrumINSERT INTO databasechangeloglock (ID, LOCKED) VALUES (1, FALSE): ERREUR: la relation « databasechangeloglock » existe déjà
            ... 5 more
    Caused by: liquibase.exception.LockException: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE databasechangeloglock (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP WITH TIME ZONE, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)); on jdbc:postgresql://172.17.41.23:5432/pocscrumINSERT INTO databasechangeloglock (ID, LOCKED) VALUES (1, FALSE): ERREUR: la relation « databasechangeloglock » existe déjà
            at liquibase.lockservice.LockService.acquireLock(LockService.java:121)
            at liquibase.lockservice.LockService.waitForLock(LockService.java:61)
            at liquibase.lockservice.LockService$waitForLock.call(Unknown Source)
            at liquibase.LiquibaseDsl.update(LiquibaseDsl.groovy:63)
            at liquibase.LiquibaseDsl$update.call(Unknown Source)
            at autobase.Autobase.migrate(Autobase.groovy:43)
            at autobase.Autobase$migrate.call(Unknown Source)
            at AutobaseGrailsPlugin$__clinit__closure9.doCall(AutobaseGrailsPlugin.groovy:103)
            at AutobaseGrailsPlugin.invokeMethod(AutobaseGrailsPlugin.groovy)
            at AutobaseGrailsPlugin$_closure2.doCall(AutobaseGrailsPlugin.groovy:114)
            ... 5 more
    Caused by: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE databasechangeloglock (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP WITH TIME ZONE, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)); on jdbc:postgresql://172.17.41.23:5432/pocscrumINSERT INTO databasechangeloglock (ID, LOCKED) VALUES (1, FALSE): ERREUR: la relation « databasechangeloglock » existe déjà
            at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
            at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
            at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:70)
            at liquibase.database.AbstractDatabase.checkDatabaseChangeLogLockTable(AbstractDatabase.java:564)
            at liquibase.lockservice.LockService.acquireLock(LockService.java:94)
            ... 14 more
    Caused by: org.postgresql.util.PSQLException: ERREUR: la relation « databasechangeloglock » existe déjà
            at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
            at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
            at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
            at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
            at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:406)
            at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:398)
            at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
            at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
            ... 18 more
    2016-09-21 08:00:40,877 [172.17.41.23-startStop-1] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[172.17.41.23].[/icescrum]  - Exception lors de l'envoi de l'évènement contexte détruit (context destroyed) à l'instance de classe d'écoute org.icescrum.core.IceScrumContextLoaderListener
    org.springframework.beans.factory.access.BootstrapException: Error executing bootstraps; nested exception is org.codehaus.groovy.runtime.InvokerInvocationException: liquibase.exception.LockException: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE databasechangeloglock (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP WITH TIME ZONE, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)); on jdbc:postgresql://172.17.41.23:5432/pocscrumINSERT INTO databasechangeloglock (ID, LOCKED) VALUES (1, FALSE): ERREUR: la relation « databasechangeloglock » existe déjà
            at org.codehaus.groovy.grails.web.context.GrailsContextLoader.createWebApplicationContext(GrailsContextLoader.java:87)
            at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
            at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
            at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4973)
            at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5467)
            at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
            at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
            at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
            at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
            at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1083)
            at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1880)
            at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
            at java.util.concurrent.FutureTask.run(FutureTask.java:262)
            at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
            at java.lang.Thread.run(Thread.java:745)
    Caused by: org.codehaus.groovy.runtime.InvokerInvocationException: liquibase.exception.LockException: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE databasechangeloglock (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP WITH TIME ZONE, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)); on jdbc:postgresql://172.17.41.23:5432/pocscrumINSERT INTO databasechangeloglock (ID, LOCKED) VALUES (1, FALSE): ERREUR: la relation « databasechangeloglock » existe déjà
            ... 5 more
    Caused by: liquibase.exception.LockException: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE databasechangeloglock (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP WITH TIME ZONE, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)); on jdbc:postgresql://172.17.41.23:5432/pocscrumINSERT INTO databasechangeloglock (ID, LOCKED) VALUES (1, FALSE): ERREUR: la relation « databasechangeloglock » existe déjà
            at liquibase.lockservice.LockService.acquireLock(LockService.java:121)
            at liquibase.lockservice.LockService.waitForLock(LockService.java:61)
            at liquibase.lockservice.LockService$waitForLock.call(Unknown Source)
            at liquibase.LiquibaseDsl.update(LiquibaseDsl.groovy:63)
            at liquibase.LiquibaseDsl$update.call(Unknown Source)
            at autobase.Autobase.migrate(Autobase.groovy:43)
            at autobase.Autobase$migrate.call(Unknown Source)
            at AutobaseGrailsPlugin$__clinit__closure9.doCall(AutobaseGrailsPlugin.groovy:103)
            at AutobaseGrailsPlugin.invokeMethod(AutobaseGrailsPlugin.groovy)
            at AutobaseGrailsPlugin$_closure2.doCall(AutobaseGrailsPlugin.groovy:114)
            ... 5 more
    Caused by: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE databasechangeloglock (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP WITH TIME ZONE, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)); on jdbc:postgresql://172.17.41.23:5432/pocscrumINSERT INTO databasechangeloglock (ID, LOCKED) VALUES (1, FALSE): ERREUR: la relation « databasechangeloglock » existe déjà
            at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
            at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
            at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:70)
            at liquibase.database.AbstractDatabase.checkDatabaseChangeLogLockTable(AbstractDatabase.java:564)
            at liquibase.lockservice.LockService.acquireLock(LockService.java:94)
            ... 14 more
    Caused by: org.postgresql.util.PSQLException: ERREUR: la relation « databasechangeloglock » existe déjà
            at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
            at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
            at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
            at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
            at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:406)
            at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:398)
            at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
            at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
            ... 18 more

    entre temps, nous avons réalisé divers tests via postgresql avec succès. notre DBA semble avoir sécurisé la base a chaque test et il y a une de ces sécurisation qui semble être la cause de cet incident. nous recherchons la cause précise de cette erreur.


    Cmoi20
    Participant

    Bonjour,

    j’ai un peu avancé.
    J’utilise postgresql pour mon installation. après l’installation, le service tomcat ne s’arrête pas correctement. je suis obligé de le killer.
    suite a ce kill, j’obtiens des erreurs dans le fichier de log. EDITED

    suite a cette modification, j’obtient l’erreur signalé en début de post.

    j’ai hier soir tenté 2 types d’installation différents :
    – utilisation de la base sur fichier local : cela fonctionne parfaitement
    – utilisation d’une base mariadb : cela fonctionne parfaitement.

    il semble donc que icescrum n’utilise pas correctement ma base postgresql.

    existe-t-il des contraintes de configuration coté postgresql ?

    Cordialement,


    Cmoi20
    Participant

    Encore merci pour vos réponses,

    je travail pour un POC en entreprise. actuellement, pas de docker disponible.
    nous sommes bloqués sur redhat, pas de debian ou ubuntu de possible. il est possible d’envisager une centos si besoin.

    l’installation du tomcat d’apache a été fait sur une machine différente de celle avec le tomcat de redhat, donc pas de “pollution” possible. J’ai un peu testé tout ce qui était possible sans succès pour le moment.

    Auriez vous une documentation exhaustive de ce qu’il faut faire pour faire fonctionner icescrum sur redhat ? je n’ai rien trouvé de ce type lors de mes recherches sur internet.

    Cordialement


    Cmoi20
    Participant

    je n’ai rien modifié de plus que ce qui est précisé dans la documentation d’installation.
    j’ai tenté avec le tomcat7 fournis par redhat. mais également avec le tomcat7 et le tomcat6 disponible chez apache.
    j’ai testé avec le openjdk 1.7.0 fournis par redhat mais également avec la jdk officielle de oracle.

    EDITED

    EDITED

    2016-09-20 09:36:25,513 [172.17.41.23-startStop-1] INFO  grails.spring.BeanBuilder  - [RuntimeConfiguration] Configuring data source for environment: PRODUCTION
    2016-09-20 09:36:30,425 [172.17.41.23-startStop-1] ERROR org.springframework.web.context.ContextLoader  - Context initialization failed
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'messageSource': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Cannot resolve reference to bean 'hibernateProperties' while setting bean property 'hibernateProperties'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateProperties': Cannot resolve reference to bean 'dialectDetector' while setting bean property 'properties' with key [hibernate.dialect]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialectDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is java.sql.SQLException: org.postgresql.Driver
            at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
            at java.util.concurrent.FutureTask.run(FutureTask.java:262)
            at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
            at java.lang.Thread.run(Thread.java:745)
    Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Cannot resolve reference to bean 'hibernateProperties' while setting bean property 'hibernateProperties'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateProperties': Cannot resolve reference to bean 'dialectDetector' while setting bean property 'properties' with key [hibernate.dialect]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialectDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is java.sql.SQLException: org.postgresql.Driver
            ... 5 more
    Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Cannot resolve reference to bean 'hibernateProperties' while setting bean property 'hibernateProperties'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateProperties': Cannot resolve reference to bean 'dialectDetector' while setting bean property 'properties' with key [hibernate.dialect]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialectDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is java.sql.SQLException: org.postgresql.Driver
            ... 5 more
    Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateProperties': Cannot resolve reference to bean 'dialectDetector' while setting bean property 'properties' with key [hibernate.dialect]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialectDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is java.sql.SQLException: org.postgresql.Driver
            ... 5 more
    Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialectDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is java.sql.SQLException: org.postgresql.Driver
            ... 5 more
    Caused by: org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is java.sql.SQLException: org.postgresql.Driver
            ... 5 more
    Caused by: java.sql.SQLException: org.postgresql.Driver
            at com.sun.proxy.$Proxy23.getMetaData(Unknown Source)
            ... 5 more
    Caused by: java.lang.ClassNotFoundException: org.postgresql.Driver
            at java.lang.Class.forName0(Native Method)
            at java.lang.Class.forName(Class.java:278)
            ... 6 more

    Cmoi20
    Participant

    Merci pour cette réponse rapide.

    voici le contenu de mon dossier lib de tomcat :

    lrwxrwxrwx. 1 root root      46 19 sept. 10:11 commons-collections.jar -> /usr/share/java/apache-commons-collections.jar
    lrwxrwxrwx. 1 root root      39 19 sept. 10:11 commons-dbcp.jar -> /usr/share/java/apache-commons-dbcp.jar
    lrwxrwxrwx. 1 root root      39 19 sept. 10:11 commons-pool.jar -> /usr/share/java/apache-commons-pool.jar
    lrwxrwxrwx. 1 root root      23 19 sept. 10:11 jasper-jdt.jar -> /usr/share/java/ecj.jar
    lrwxrwxrwx. 1 root root      25 19 sept. 10:11 log4j.jar -> /usr/share/java/log4j.jar
    lrwxrwxrwx. 1 root root      24 19 sept. 10:11 tomcat-el-2.2-api.jar -> ../tomcat-el-2.2-api.jar
    lrwxrwxrwx. 1 root root      25 19 sept. 10:11 tomcat-jsp-2.2-api.jar -> ../tomcat-jsp-2.2-api.jar
    lrwxrwxrwx. 1 root root      37 19 sept. 10:11 tomcat-juli.jar -> /usr/share/tomcat/bin/tomcat-juli.jar
    lrwxrwxrwx. 1 root root      29 19 sept. 10:11 tomcat-servlet-3.0-api.jar -> ../tomcat-servlet-3.0-api.jar
    -rw-r--r--. 1 root root   17715 12 mai    2015 annotations-api.jar
    -rw-r--r--. 1 root root   54236 12 mai    2015 catalina-ant.jar
    -rw-r--r--. 1 root root  135052 12 mai    2015 catalina-ha.jar
    -rw-r--r--. 1 root root 1594270 12 mai    2015 catalina.jar
    -rw-r--r--. 1 root root  259194 12 mai    2015 catalina-tribes.jar
    -rw-r--r--. 1 root root  125505 12 mai    2015 jasper-el.jar
    -rw-r--r--. 1 root root  603653 12 mai    2015 jasper.jar
    -rw-r--r--. 1 root root  181248 12 mai    2015 tomcat7-websocket.jar
    -rw-r--r--. 1 root root    7263 12 mai    2015 tomcat-api.jar
    -rw-r--r--. 1 root root  834269 12 mai    2015 tomcat-coyote.jar
    -rw-r--r--. 1 root root   77648 12 mai    2015 tomcat-i18n-es.jar
    -rw-r--r--. 1 root root   48356 12 mai    2015 tomcat-i18n-fr.jar
    -rw-r--r--. 1 root root   51011 12 mai    2015 tomcat-i18n-ja.jar
    lrwxrwxrwx. 1 root root      25 19 sept. 10:11 tomcat-jsp-2.2-api.jar -> ../tomcat-jsp-2.2-api.jar
    lrwxrwxrwx. 1 root root      29 19 sept. 10:11 tomcat-servlet-3.0-api.jar -> ../tomcat-servlet-3.0-api.jar
    -rw-r--r--. 1 root root   31374 12 mai    2015 tomcat-util.jar
    -rw-r--r--. 1 root root   36545 12 mai    2015 websocket-api.jar

    je n’ai pas installé de paquet grails et je suis partis d’une machine vierge pour mon installation.
    j’ai tenté de supprimer les commons* comme vu ailleurs dans ce forum mais cela n’a rien changé.

    Cordialement,

Viewing 6 posts - 1 through 6 (of 6 total)