HTTP ERROR: 503 Service Unavailable / Failed to initialize d

Need help? Post your questions here.

HTTP ERROR: 503 Service Unavailable / Failed to initialize d

Unread postby Matt Zornig » 21 Mar 2017, 21:45

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 536 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?
User avatar
Matt Zornig
Contributor
Contributor
 
Posts: 121
Joined: 14 Feb 2017, 12:03
Has thanked: 21 times
Been thanked: 14 times

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

Unread postby VatsanM » 04 Apr 2017, 01:01

Any luck in fixing the issue? I have the same problem.
VatsanM
 
Posts: 5
Joined: 06 Jul 2013, 16:39
Has thanked: 0 time
Been thanked: 0 time

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

Unread postby deusxanime » 25 May 2017, 22:38

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.
deusxanime
 
Posts: 2
Joined: 25 May 2017, 22:34
Has thanked: 0 time
Been thanked: 0 time


Return to Support 6.x

Who is online

Users browsing this forum: No registered users and 1 guest

cron