UPGRADE from 5.x to 6.x failed

Need help? Post your questions here.
xefil
Posts: 16
Joined: 20 Sep 2013, 08:31
Has thanked: 3 times
Been thanked: 7 times

UPGRADE from 5.x to 6.x failed

Unread post by xefil »

HEllo,

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)
If I try to open the url, I got:

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
boco
Posts: 35
Joined: 28 Dec 2012, 23:48
Has thanked: 38 times
Been thanked: 13 times

Re: UPGRADE from 5.x to 6.x failed

Unread post by boco »

See this link:
http://beta.madsonic.org/pages/downloadBeta.jsp

and note the following...

Attention!
At the moment Madsonic 6.0 is not compatible to the old Madsonic/Subsonic 5.x db schema!!!
Don't try to migrate old properties or database files, cleanup old data files and try the improved playlist importer.
xefil
Posts: 16
Joined: 20 Sep 2013, 08:31
Has thanked: 3 times
Been thanked: 7 times

Re: UPGRADE from 5.x to 6.x failed

Unread post by xefil »

I've read it but then read a lot of steps to upgrade and was confused. So I've tried.
It's ok. I'll try to import/export, but what about all the users?
All lost? :o :shock:
User avatar
Madsonic
Administrator
Administrator
Posts: 984
Joined: 07 Dec 2012, 03:58
Answers: 7
Has thanked: 1201 times
Been thanked: 470 times

Re: UPGRADE from 5.x to 6.x failed

Unread post by Madsonic »

i can provide a better export function with a smoother migration for user, favorites and ratings with the limitation that the old user password can't be recoverd.
xefil
Posts: 16
Joined: 20 Sep 2013, 08:31
Has thanked: 3 times
Been thanked: 7 times

Re: UPGRADE from 5.x to 6.x failed

Unread post by xefil »

Madevil wrote:i can provide a better export function with a smoother migration for user, favorites and ratings with the limitation that the old user password can't be recoverd.
That would be nice.
BTW, on the Madsonic5 I can query the database. Wouldn't be possible to export the users from there and import it (with SQL commands) to the new database?
Fortunately I've taken a copy of the old DB so I've rolled back to Madsonic 5.

Thanks!

Simon
xefil
Posts: 16
Joined: 20 Sep 2013, 08:31
Has thanked: 3 times
Been thanked: 7 times

Re: UPGRADE from 5.x to 6.x failed

Unread post by xefil »

Hello!!

Any news about that?
I would like to maintain users, stats and whatever.

Thanks!

Simon
Post Reply