Problème lancement après installation

[vincent.galy]

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 ;

[Vincent Barrier]

Bonjour,

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

[vincent.galy]

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 3 years ago by vincent.galy.

[Nicolas Noullet]

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.

[vincent.galy]

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.

[Author]

Posts