Closed karl0ss closed 5 years ago
I have the same problem right now. Even pulled the latest image and it still does not work. Why was this issue closed and archived?
airsonic | 2019-11-16 21:02:11.765 INFO --- org.airsonic.player.Application : The following profiles are active: legacy
airsonic | 2019-11-16 21:02:13.928 INFO --- o.a.p.service.SettingsService : Java: 1.8.0_222, OS: Linux
airsonic | 2019-11-16 21:02:14.070 INFO --- org.airsonic.player.Application : Detected Tomcat web server
airsonic | 2019-11-16 21:02:18.706 ERROR --- o.a.p.spring.SpringLiquibase : ===============================================
airsonic | 2019-11-16 21:02:18.706 ERROR --- o.a.p.spring.SpringLiquibase : An exception occurred during database migration
airsonic | 2019-11-16 21:02:18.706 ERROR --- o.a.p.spring.SpringLiquibase : A rollback file has been generated at /config/rollback.sql
airsonic | 2019-11-16 21:02:18.706 ERROR --- o.a.p.spring.SpringLiquibase : Execute it within your database to rollback any changes
airsonic | 2019-11-16 21:02:18.710 ERROR --- o.a.p.spring.SpringLiquibase : The exception is as follows
airsonic |
airsonic |
airsonic | liquibase.exception.DatabaseException: java.sql.SQLException: User not found: SA
airsonic | at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:307) ~[liquibase-core-3.6.3.jar!/:na]
airsonic | at org.airsonic.player.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:25) ~[classes!/:10.5.0-RELEASE]
airsonic | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1688) [spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1626) [spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553) [spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481) [spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312) [spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) [spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308) [spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) [spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:297) [spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) [spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:211) [spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1131) [spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1059) [spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:583) [spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87) [spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:364) [spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1268) [spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:551) [spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481) [spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312) [spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) [spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308) [spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) [spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:756) [spring-beans-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867) [spring-context-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:542) [spring-context-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:123) [spring-boot-1.5.22.RELEASE.jar!/:1.5.22.RELEASE]
airsonic | at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:666) [spring-boot-1.5.22.RELEASE.jar!/:1.5.22.RELEASE]
airsonic | at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:353) [spring-boot-1.5.22.RELEASE.jar!/:1.5.22.RELEASE]
airsonic | at org.springframework.boot.SpringApplication.run(SpringApplication.java:300) [spring-boot-1.5.22.RELEASE.jar!/:1.5.22.RELEASE]
airsonic | at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:135) [spring-boot-1.5.22.RELEASE.jar!/:1.5.22.RELEASE]
airsonic | at org.airsonic.player.Application.main(Application.java:221) [classes!/:10.5.0-RELEASE]
airsonic | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_222]
airsonic | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_222]
airsonic | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_222]
airsonic | at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_222]
airsonic | at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48) [airsonic.war:10.5.0-RELEASE]
airsonic | at org.springframework.boot.loader.Launcher.launch(Launcher.java:87) [airsonic.war:10.5.0-RELEASE]
airsonic | at org.springframework.boot.loader.Launcher.launch(Launcher.java:50) [airsonic.war:10.5.0-RELEASE]
airsonic | at org.springframework.boot.loader.WarLauncher.main(WarLauncher.java:59) [airsonic.war:10.5.0-RELEASE]
airsonic | Caused by: java.sql.SQLException: User not found: SA
airsonic | at org.hsqldb.jdbc.Util.sqlException(Unknown Source) ~[hsqldb-1.8.0.7.jar!/:private-2006/09/24-10:30:15]
airsonic | at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source) ~[hsqldb-1.8.0.7.jar!/:private-2006/09/24-10:30:15]
airsonic | at org.hsqldb.jdbcDriver.getConnection(Unknown Source) ~[hsqldb-1.8.0.7.jar!/:private-2006/09/24-10:30:15]
airsonic | at org.hsqldb.jdbcDriver.connect(Unknown Source) ~[hsqldb-1.8.0.7.jar!/:private-2006/09/24-10:30:15]
airsonic | at java.sql.DriverManager.getConnection(DriverManager.java:664) ~[na:1.8.0_222]
airsonic | at java.sql.DriverManager.getConnection(DriverManager.java:208) ~[na:1.8.0_222]
airsonic | at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:153) ~[spring-jdbc-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:144) ~[spring-jdbc-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:196) ~[spring-jdbc-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:159) ~[spring-jdbc-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
airsonic | at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:302) ~[liquibase-core-3.6.3.jar!/:na]
airsonic | ... 41 common frames omitted
airsonic |
airsonic | 2019-11-16 21:02:18.711 ERROR --- o.a.p.spring.SpringLiquibase : ===============================================
airsonic | 2019-11-16 21:02:18.712 WARN --- ationConfigEmbeddedWebApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with nam
e 'randomPlayQueueController': Unsatisfied dependency expressed through field 'playerService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [applicationContext-db.xml]:
Invocation of init method failed; nested exception is liquibase.exception.DatabaseException: java.sql.SQLException: User not found: SA
airsonic | 2019-11-16 21:02:18.718 WARN --- .s.c.a.CommonAnnotationBeanPostProcessor : Invocation of destroy method failed on bean with name 'daoHelper': org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is
java.sql.SQLException: User not found: SA
airsonic | 2019-11-16 21:02:18.743 ERROR --- o.s.boot.SpringApplication : Application startup failed```
@maluramichael I didn't close the issue either, but I did get it working again, something has messed up your database, I had to delete all my data folder and start again to get it to work..
Is it possible to extract a list of all my podcast urls before i clear my db?
The issue was closed by the user opening the issue.
If your database is corrupt, you probably can't extract the podcast urls.
Everything has been working fine for months, but I rebooted my server the other day, and now my docker container wont come back...any ideas please?