iceScrum | Problème lancement après installation – iceScrum

iceScrum Forums Discuss on iceScrum

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

  • Author
    Posts
  • #905781

    vincent.galy
    Participant

    Bonjour,

    Je viens d’installer IceScrum 7.54 (client .JAR) sur mon serveur linux afin de tester. J’ai lancé le programme à l’aide de la commande suivante (OpenJDK 8 Update 302):
    sudo java -Xmx1024M -jar icescrum.jar port=8081 context=/

    La configuration etc se passe parfaitement, je renseigne mon serveur BDD MySQL (Version 15.1 Distrib 10.4.17-MariaDB) et au redémarrage de IceScrum (requis pour finaliser l’installation/configuration). Le serveur ne se lance pas malgré que les tables (bien que vide) soient créés sur MySQL. Voici le log alors généré par IceScrum:

    2021-11-15 15:04:19,188 [localhost-startStop-1] INFO  grails.plugin.hibernate4.HibernatePluginSupport  - Set db generation strategy to 'update' for datasource DEFAULT
    2021-11-15 15:04:28,812 [localhost-startStop-1] WARN  net.sf.ehcache.config.ConfigurationFactory  - No configuration found. Configuring ehcache from ehcache-failsafe.xml  found in the classpath: jar:file:/tmp/standalone-war/embedded5205040041853074749-exploded-1636988608716/WEB-INF/lib/ehcache-2.9.0.jar!/ehcache-failsafe.xml
    2021-11-15 15:04:41,641 [localhost-startStop-1] INFO  CacheHeadersGrailsPlugin  - Caching enabled in Config: true
    2021-11-15 15:04:41,747 [localhost-startStop-1] INFO  net.sf.ehcache.pool.sizeof.filter.AnnotationSizeOfFilter  - Using regular expression provided through VM argument net.sf.ehcache.pool.sizeof.ignore.pattern for IgnoreSizeOf annotation : ^.*cache\..*IgnoreSizeOf$
    2021-11-15 15:04:41,750 [localhost-startStop-1] INFO  net.sf.ehcache.pool.sizeof.AgentLoader  - Unavailable or unrecognised attach API : java.lang.ClassNotFoundException: com.sun.tools.attach.VirtualMachine
    2021-11-15 15:04:41,761 [localhost-startStop-1] INFO  net.sf.ehcache.pool.sizeof.JvmInformation  - Detected JVM data model settings of: 64-Bit OpenJDK JVM with Compressed OOPs
    2021-11-15 15:04:41,762 [localhost-startStop-1] INFO  net.sf.ehcache.pool.impl.DefaultSizeOfEngine  - using Unsafe sizeof engine
    2021-11-15 15:04:41,766 [localhost-startStop-1] INFO  net.sf.ehcache.pool.impl.DefaultSizeOfEngine  - using Unsafe sizeof engine
    2021-11-15 15:04:43,256 [localhost-startStop-1] INFO  grails.plugin.databasemigration.MigrationRunner  - updateOnStart enabled for 'dataSource'
    2021-11-15 15:04:45,641 [localhost-startStop-1] INFO  liquibase  - Reading from <code>DATABASECHANGELOG</code>
    2021-11-15 15:05:06,264 [localhost-startStop-1] ERROR org.codehaus.groovy.grails.web.context.GrailsContextLoaderListener  - Error initializing the application: Error executing SQL SELECT FILENAME,AUTHOR,ID,MD5SUM,DATEEXECUTED,ORDEREXECUTED,TAG,EXECTYPE FROM <code>DATABASECHANGELOG</code> ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC: Table 'icescrum.databasechangelog' doesn't exist
    liquibase.exception.DatabaseException: Error executing SQL SELECT FILENAME,AUTHOR,ID,MD5SUM,DATEEXECUTED,ORDEREXECUTED,TAG,EXECTYPE FROM <code>DATABASECHANGELOG</code> ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC: Table 'icescrum.databasechangelog' doesn't exist
    	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
    	at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:142)
    	at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:150)
    	at liquibase.executor.jvm.JdbcExecutor.queryForList(JdbcExecutor.java:202)
    	at liquibase.executor.jvm.JdbcExecutor.queryForList(JdbcExecutor.java:197)
    	at liquibase.database.AbstractDatabase.getRanChangeSetList(AbstractDatabase.java:921)
    	at liquibase.changelog.DatabaseChangeLog.validate(DatabaseChangeLog.java:132)
    	at liquibase.Liquibase.listUnrunChangeSets(Liquibase.java:625)
    	at grails.plugin.databasemigration.MigrationRunner.runMigrations(MigrationRunner.groovy:107)
    	at grails.plugin.databasemigration.MigrationRunner$_autoRun_closure1.doCall(MigrationRunner.groovy:87)
    	at grails.plugin.databasemigration.MigrationUtils.executeInSession(MigrationUtils.groovy:137)
    	at grails.plugin.databasemigration.MigrationRunner.autoRun(MigrationRunner.groovy:58)
    	at DatabaseMigrationGrailsPlugin$_closure2.doCall(DatabaseMigrationGrailsPlugin.groovy:97)
    	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    	at java.lang.Thread.run(Thread.java:748)
    Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'icescrum.databasechangelog' doesn't exist
    	at com.mysql.jdbc.Util.handleNewInstance(Util.java:403)
    	at com.mysql.jdbc.Util.getInstance(Util.java:386)
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)
    	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
    	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675)
    	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
    	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2439)
    	at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1365)
    	at liquibase.executor.jvm.JdbcExecutor$1QueryStatementCallback.doInStatement(JdbcExecutor.java:128)
    	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
    	... 16 more
    2021-11-15 15:05:06,267 [localhost-startStop-1] ERROR org.codehaus.groovy.grails.web.context.GrailsContextLoaderListener  - Error initializing Grails: Error executing SQL SELECT FILENAME,AUTHOR,ID,MD5SUM,DATEEXECUTED,ORDEREXECUTED,TAG,EXECTYPE FROM <code>DATABASECHANGELOG</code> ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC: Table 'icescrum.databasechangelog' doesn't exist
    liquibase.exception.DatabaseException: Error executing SQL SELECT FILENAME,AUTHOR,ID,MD5SUM,DATEEXECUTED,ORDEREXECUTED,TAG,EXECTYPE FROM <code>DATABASECHANGELOG</code> ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC: Table 'icescrum.databasechangelog' doesn't exist
    	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
    	at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:142)
    	at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:150)
    	at liquibase.executor.jvm.JdbcExecutor.queryForList(JdbcExecutor.java:202)
    	at liquibase.executor.jvm.JdbcExecutor.queryForList(JdbcExecutor.java:197)
    	at liquibase.database.AbstractDatabase.getRanChangeSetList(AbstractDatabase.java:921)
    	at liquibase.changelog.DatabaseChangeLog.validate(DatabaseChangeLog.java:132)
    	at liquibase.Liquibase.listUnrunChangeSets(Liquibase.java:625)
    	at grails.plugin.databasemigration.MigrationRunner.runMigrations(MigrationRunner.groovy:107)
    	at grails.plugin.databasemigration.MigrationRunner$_autoRun_closure1.doCall(MigrationRunner.groovy:87)
    	at grails.plugin.databasemigration.MigrationUtils.executeInSession(MigrationUtils.groovy:137)
    	at grails.plugin.databasemigration.MigrationRunner.autoRun(MigrationRunner.groovy:58)
    	at DatabaseMigrationGrailsPlugin$_closure2.doCall(DatabaseMigrationGrailsPlugin.groovy:97)
    	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    	at java.lang.Thread.run(Thread.java:748)
    Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'icescrum.databasechangelog' doesn't exist
    	at com.mysql.jdbc.Util.handleNewInstance(Util.java:403)
    	at com.mysql.jdbc.Util.getInstance(Util.java:386)
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)
    	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
    	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675)
    	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
    	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2439)
    	at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1365)
    	at liquibase.executor.jvm.JdbcExecutor$1QueryStatementCallback.doInStatement(JdbcExecutor.java:128)
    	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
    	... 16 more
    2021-11-15 15:05:06,274 [localhost-startStop-1] ERROR org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/]  - Exception sending context initialized event to listener instance of class [org.codehaus.groovy.grails.web.context.GrailsContextLoaderListener]
    org.springframework.beans.factory.access.BootstrapException: Error executing bootstraps; nested exception is liquibase.exception.DatabaseException: Error executing SQL SELECT FILENAME,AUTHOR,ID,MD5SUM,DATEEXECUTED,ORDEREXECUTED,TAG,EXECTYPE FROM <code>DATABASECHANGELOG</code> ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC: Table 'icescrum.databasechangelog' doesn't exist
    	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    	at java.lang.Thread.run(Thread.java:748)
    Caused by: liquibase.exception.DatabaseException: Error executing SQL SELECT FILENAME,AUTHOR,ID,MD5SUM,DATEEXECUTED,ORDEREXECUTED,TAG,EXECTYPE FROM <code>DATABASECHANGELOG</code> ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC: Table 'icescrum.databasechangelog' doesn't exist
    	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
    	at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:142)
    	at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:150)
    	at liquibase.executor.jvm.JdbcExecutor.queryForList(JdbcExecutor.java:202)
    	at liquibase.executor.jvm.JdbcExecutor.queryForList(JdbcExecutor.java:197)
    	at liquibase.database.AbstractDatabase.getRanChangeSetList(AbstractDatabase.java:921)
    	at liquibase.changelog.DatabaseChangeLog.validate(DatabaseChangeLog.java:132)
    	at liquibase.Liquibase.listUnrunChangeSets(Liquibase.java:625)
    	at grails.plugin.databasemigration.MigrationRunner.runMigrations(MigrationRunner.groovy:107)
    	at grails.plugin.databasemigration.MigrationRunner$_autoRun_closure1.doCall(MigrationRunner.groovy:87)
    	at grails.plugin.databasemigration.MigrationUtils.executeInSession(MigrationUtils.groovy:137)
    	at grails.plugin.databasemigration.MigrationRunner.autoRun(MigrationRunner.groovy:58)
    	at DatabaseMigrationGrailsPlugin$_closure2.doCall(DatabaseMigrationGrailsPlugin.groovy:97)
    	... 4 more
    Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'icescrum.databasechangelog' doesn't exist
    	at com.mysql.jdbc.Util.handleNewInstance(Util.java:403)
    	at com.mysql.jdbc.Util.getInstance(Util.java:386)
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)
    	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
    	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675)
    	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
    	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2439)
    	at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1365)
    	at liquibase.executor.jvm.JdbcExecutor$1QueryStatementCallback.doInStatement(JdbcExecutor.java:128)
    	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
    	... 16 more
    2021-11-15 15:05:06,329 [localhost-startStop-1] ERROR org.apache.catalina.core.StandardContext  - One or more listeners failed to start. Full details will be found in the appropriate container log file
    2021-11-15 15:05:06,367 [localhost-startStop-1] ERROR org.apache.catalina.core.StandardContext  - Context [] startup failed due to previous errors
    2021-11-15 15:05:06,370 [localhost-startStop-1] INFO  org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/]  - Closing Spring root WebApplicationContext
    2021-11-15 15:05:06,385 [localhost-startStop-1] WARN  org.codehaus.groovy.grails.lifecycle.ShutdownOperations  - Error occurred running shutdown operation: BeanFactory not initialized or already closed - call 'refresh' before accessing beans via the ApplicationContext
    java.lang.IllegalStateException: BeanFactory not initialized or already closed - call 'refresh' before accessing beans via the ApplicationContext
    	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    	at java.lang.Thread.run(Thread.java:748)
    

    Avez-vous une idée d’où cela peut provenir ?

    Merci et bonne journée ;

    #905790

    Vincent Barrier
    Keymaster

    Bonjour,

    Une table n’est pas correctement créée : databasechangelog êtes vous sur de vos paramètres de connexion ?

    #905793

    vincent.galy
    Participant

    Je suis sur de mes informations de connexion, IceScrum arrive même à créer les autres tables sur ma bdd mysql !

    • This reply was modified 2 weeks, 6 days ago by vincent.galy.
    #906057

    Nicolas Noullet
    Keymaster

    Bonjour,

    Le problème peut venir de l’utilisation de MariaDB, qui est un fork de MySQL pas forcément 100% compatible.

    Nous recommandons l’utilisation de MySQL 5.7. La version MySQL 8 n’est pas supportée.

    #906058

    vincent.galy
    Participant

    Bonjour,

    Je ne comprends pas vraiment pourquoi cette erreur est là, j’avais déjà essayé auparavant tout fonctionnais. J’ai voulu redémarrer l’application pour appliquer des changements dans la configuration et j’ai eu cette erreur. Même en supprimant toute la BDD IceScrum + les fichiers, cette erreur reste à présent.

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

You must be logged in to reply to this topic.