I've upgraded via RPM (CentOS) my server and It doesn't start.
HEre the error:
Code: Select all
[2015-12-18 17:29:15,739] WARN HsqlDaoHelper - Checking database schema ...
[2015-12-18 17:29:22,046] INFO HSqlSchema02 - Updating database schema to version 202.
[2015-12-18 17:29:22,060] INFO HSqlSchema02 - Created index for podcast_episode.url
[2015-12-18 17:29:22,144] INFO HSqlSchema02 - Database table 'audio_ad' not found. Creating it.
[2015-12-18 17:29:22,146] INFO HSqlSchema02 - Database table 'audio_ad' was created successfully.
[2015-12-18 17:29:22,147] INFO HSqlSchema02 - Database table 'play_queue' not found. Creating it.
[2015-12-18 17:29:22,148] INFO HSqlSchema02 - Database table 'play_queue' was created successfully.
[2015-12-18 17:29:22,149] INFO HSqlSchema02 - Database table 'play_queue_file' not found. Creating it.
[2015-12-18 17:29:22,150] INFO HSqlSchema02 - Database table 'play_queue_file' was created successfully.
[2015-12-18 17:29:22,151] INFO HSqlSchema02 - Database table 'music_folder_tasks' not found. Creating it.
[2015-12-18 17:29:22,152] INFO HSqlSchema02 - Database table 'music_folder_tasks' was created successfully.
[2015-12-18 17:29:22,153] INFO HSqlSchema02 - Updating database schema to version 205.
[2015-12-18 17:29:22,168] INFO HSqlSchema02 - Avatar templates updated successfully.
[2015-12-18 17:29:22,169] INFO HSqlSchema02 - Database column 'user_settings.main_bpm' not found. Creating it.
[2015-12-18 17:29:22,179] INFO HSqlSchema02 - Database column 'user_settings.main_bpm' was added successfully.
[2015-12-18 17:29:22,180] INFO HSqlSchema02 - Database column 'user_settings.playlist_bpm' not found. Creating it.
[2015-12-18 17:29:22,189] INFO HSqlSchema02 - Database column 'user_settings.playlist_bpm' was added successfully.
[2015-12-18 17:29:22,190] INFO HSqlSchema02 - Database column 'user_settings.main_composer' not found. Creating it.
[2015-12-18 17:29:22,199] INFO HSqlSchema02 - Database column 'user_settings.main_composer' was added successfully.
[2015-12-18 17:29:22,200] INFO HSqlSchema02 - Database column 'user_settings.playlist_composer' not found. Creating it.
[2015-12-18 17:29:22,209] INFO HSqlSchema02 - Database column 'user_settings.playlist_composer' was added successfully.
[2015-12-18 17:29:22,210] INFO HSqlSchema02 - Database column 'podcast_channel.image_url' not found. Creating it.
[2015-12-18 17:29:22,211] INFO HSqlSchema02 - Database column 'podcast_channel.image_url' was added successfully.
[2015-12-18 17:29:22,212] INFO HSqlSchema02 - Database column 'user_settings.show_artist_info' not found. Creating it.
[2015-12-18 17:29:22,221] INFO HSqlSchema02 - Database column 'user_settings.show_artist_info' was added successfully.
[2015-12-18 17:29:22,223] INFO HSqlSchema02 - Group 'LDAP' not found in database. Creating it.
[2015-12-18 17:29:22,227] INFO HSqlSchema02 - Group 'SIGNUP' not found in database. Creating it.
[2015-12-18 17:29:22,233] INFO HSqlSchema02 - new roles not found in database. Creating it.
[2015-12-18 17:29:22,235] ERROR HsqlDaoHelper - Failed to initialize database.
org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL [insert into role values (NULL, 'image')]; integrity constraint violation: NOT NULL check constraint; SYS_CT_10094 table: ROLE column: ID; nested exception is java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: NOT NULL check constraint; SYS_CT_10094 table: ROLE column: ID
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:86)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:428)
at org.madsonic.dao.schema.hsql.HSqlSchema02.execute(HSqlSchema02.java:184)
at org.madsonic.dao.HsqlDaoHelper.checkDatabase(HsqlDaoHelper.java:125)
at org.madsonic.dao.HsqlDaoHelper.<init>(HsqlDaoHelper.java:58)
at org.madsonic.dao.DaoHelperFactory.create(DaoHelperFactory.java:39)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:160)
at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:592)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1057)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:953)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:487)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1419)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1160)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:636)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:934)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)
at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:782)
at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:424)
at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:774)
at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:249)
at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1242)
at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:717)
at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:494)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)
at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:95)
at org.eclipse.jetty.server.Server.doStart(Server.java:282)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)
at org.madsonic.booter.deployer.MadsonicDeployer.deployWebApp(MadsonicDeployer.java:243)
at org.madsonic.booter.deployer.MadsonicDeployer.<init>(MadsonicDeployer.java:103)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:100)
at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:61)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:877)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:839)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83)
at org.madsonic.booter.Main.<init>(Main.java:43)
at org.madsonic.booter.Main.main(Main.java:82)
Caused by: java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: NOT NULL check constraint; SYS_CT_10094 table: ROLE column: ID
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:421)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
... 72 more
Caused by: org.hsqldb.HsqlException: integrity constraint violation: NOT NULL check constraint; SYS_CT_10094 table: ROLE column: ID
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.Table.enforceRowConstraints(Unknown Source)
at org.hsqldb.Table.insertSingleRow(Unknown Source)
at org.hsqldb.StatementDML.insertSingleRow(Unknown Source)
at org.hsqldb.StatementInsert.getResult(Unknown Source)
at org.hsqldb.StatementDMQL.execute(Unknown Source)
at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
at org.hsqldb.Session.executeDirectStatement(Unknown Source)
at org.hsqldb.Session.execute(Unknown Source)
... 76 more
[2015-12-18 17:29:22,244] INFO HsqlDaoHelper - Checking HSQLDB version: 2.3.3
[2015-12-18 17:29:22,488] INFO SettingsService - Java: 1.7.0_85, OS: Linux
[2015-12-18 17:29:22,488] DEBUG VersionService - Resolved local Madsonic version to: 6.0.7820.016da13
[2015-12-18 17:29:22,656] INFO SecurityService - Updating database schema to version 201. (securing user passwords)
HTTP ERROR: 503
Problem accessing /. Reason:
Service Unavailable
I've updated from 5.2 to 'madsonic-6.0-7820.i386'.
I would like to maintain the old settings and statistics.
Thanks for help!
Simon