HTTP ERROR: 503 Service Unavailable / Failed to initialize d

Need help? Post your questions here.
User avatar
Matt Zornig
Contributor
Contributor
Posts: 242
Joined: 14 Feb 2017, 12:03
Has thanked: 38 times
Been thanked: 28 times

HTTP ERROR: 503 Service Unavailable / Failed to initialize d

Unread post by Matt Zornig »

Code: Select all

=========================================================================================
VERSION: MADSONIC 6.2 | BUILD: 9080.619dd31.20161222.0327
REST: MADSONIC REST API v2.5.0, SUBSONIC REST API v1.14.0
OS: Linux 3.10.77 #8451 SMP Wed Jan 4 00:31:32 CST 2017 x86_64 GNU/Linux
SERVER: jetty/8.y.z-SNAPSHOT, java 1.8.0_121, Linux 3.10.77 (amd64) 
HOST: Synology NAS 1815+ (DSM 6.1-15047 Update 1) | CPU: INTEL Atom C2538| ARCH: X64 | MEMORY: 6GB | HDD: 36TB, RAID6
BROWSER: FF 52.x
CLIENT: see browser
JAVA: ORACLE JDK 1.8.121
logged in as admin
=========================================================================================
today, out of the blue, I only see this, after trying to open the webguy

Code: Select all

HTTP ERROR: 503

Problem accessing /. Reason:

    Service Unavailable

Powered by Jetty:// 8.y.z-SNAPSHOT 
503.png
503.png (6.28 KiB) Viewed 4707 times
stoping/starting the madsonic package log:

Code: Select all

[2017-03-21 21:35:17,008] WARN HsqlDaoHelper - Checking database schema ...
[2017-03-21 21:35:19,791] INFO HSqlSchema02 - Database table 'music_folder_tasks' not found.  Creating it.
[2017-03-21 21:35:19,802] ERROR HsqlDaoHelper - Failed to initialize database.
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create cached table music_folder_tasks (id identity,music_folder_id int not null,found int default 0 not null,scan datetime not null,status varchar,result varchar,comment varchar,enabled boolean default true not null,foreign key (music_folder_id) references music_folder(id) on delete cascade)]; nested exception is java.sql.SQLSyntaxErrorException: object name already exists: MUSIC_FOLDER_TASKS in statement [create cached table music_folder_tasks (id identity,music_folder_id int not null,found int default 0 not null,scan datetime not null,status varchar,result varchar,comment varchar,enabled boolean default true not null,foreign key (music_folder_id) references music_folder(id) on delete cascade)]
	at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:92)
	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:90)
	at org.madsonic.dao.HsqlDaoHelper.checkDatabase(HsqlDaoHelper.java:129)
	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:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	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:938)
	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:100)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:148)
	at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:87)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:1032)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:985)
	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.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:636)
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:938)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)
	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.SQLSyntaxErrorException: object name already exists: MUSIC_FOLDER_TASKS in statement [create cached table music_folder_tasks (id identity,music_folder_id int not null,found int default 0 not null,scan datetime not null,status varchar,result varchar,comment varchar,enabled boolean default true not null,foreign key (music_folder_id) references music_folder(id) on delete cascade)]
	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)
	... 69 more
Caused by: org.hsqldb.HsqlException: object name already exists: MUSIC_FOLDER_TASKS
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
	at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
	at org.hsqldb.StatementSchema.getResult(Unknown Source)
	at org.hsqldb.StatementSchema.execute(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 73 more

[2017-03-21 21:35:19,819] INFO HsqlDaoHelper - Checking HSQLDB version: 2.3.4
[2017-03-21 21:35:20,978] INFO SettingsService - Java: 1.8.0_121, OS: Linux
[2017-03-21 21:35:20,999] INFO SettingsService - write transcode path to property file: /bin
[2017-03-21 21:35:21,203] INFO SettingsService - ffmpeg: ffmpeg version 2.7.1 (22.02.2017) Copyright (c) 2000-2015 the FFmpeg developers
[2017-03-21 21:35:21,203] INFO SettingsService - Madsonic scanMode: MIXED
[2017-03-21 21:35:21,205] DEBUG VersionService - Resolved local Madsonic version to: 6.2.9080.619dd31
[2017-03-21 21:35:21,254] DEBUG UserService - Checking User accounts ...
[2017-03-21 21:35:21,461] DEBUG SecurityService - Updated user default
[2017-03-21 21:35:21,461] DEBUG UserService - Checking Default User. Done
[2017-03-21 21:35:21,488] DEBUG SecurityService - Updated user guest
[2017-03-21 21:35:21,489] DEBUG UserService - Checking Guest User. Done
[2017-03-21 21:35:21,534] DEBUG SecurityService - Updated user node
[2017-03-21 21:35:21,535] DEBUG UserService - Checking Node User. Done
[2017-03-21 21:35:21,734] DEBUG MediaScannerService - WATCHDOG:RUN: doUpdateTasks() 
what could it be?
VatsanM
Posts: 6
Joined: 06 Jul 2013, 16:39
Has thanked: 0
Been thanked: 0

Re: HTTP ERROR: 503 Service Unavailable / Failed to initiali

Unread post by VatsanM »

Any luck in fixing the issue? I have the same problem.
deusxanime
Posts: 2
Joined: 25 May 2017, 22:34
Has thanked: 0
Been thanked: 0

Re: HTTP ERROR: 503 Service Unavailable / Failed to initiali

Unread post by deusxanime »

I think I figured this out, if it is the same thing I had. Did you change the user name that madsonic runs under in the /etc/sysconfig/madsonic file and restart service before logging in for the first time? I think it can't create/initialize the db if you do that. Set it back to run as root, access the site for the first time and log in as admin, reset password, maybe do a couple things so that the db is created. Then go back and change the madsonic config file and change the user and restart the service.
Post Reply