SHARE
TWEET

madsonic.log

a guest May 20th, 2018 114 in 11 hours
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. [2018-05-20 22:36:32,805] WARN HsqlDaoHelper - Checking HSQLDB database schema ...
  2. [2018-05-20 22:36:36,307] INFO HSqlSchema02 - Updating database schema to version 202.
  3. [2018-05-20 22:36:36,546] INFO HSqlSchema02 - Created index for podcast_episode.url
  4. [2018-05-20 22:36:37,034] INFO HSqlSchema02 - Database table 'audio_ad' not found.  Creating it.
  5. [2018-05-20 22:36:37,118] ERROR HsqlDaoHelper - Failed to initialize HSQLDB database.
  6. org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create table audio_ad (id identity,media_file_id int,weight double,comment varchar,enabled boolean default false not null,created datetime not null,changed datetime not null,foreign key (media_file_id) references media_file(id) on delete cascade)]; nested exception is java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: MEDIA_FILE in statement [create table audio_ad (id identity,media_file_id int,weight double,comment varchar,enabled boolean default false not null,created datetime not null,changed datetime not null,foreign key (media_file_id) references media_file(id) on delete cascade)]
  7.     at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:92)
  8.     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
  9.     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
  10.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
  11.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:428)
  12.     at org.madsonic.dao.schema.hsql.HSqlSchema02.execute(HSqlSchema02.java:53)
  13.     at org.madsonic.dao.HsqlDaoHelper.checkDatabase(HsqlDaoHelper.java:120)
  14.     at org.madsonic.dao.HsqlDaoHelper.<init>(HsqlDaoHelper.java:57)
  15.     at org.madsonic.dao.DaoHelperFactory.create(DaoHelperFactory.java:41)
  16.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  17.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  18.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  19.     at java.lang.reflect.Method.invoke(Method.java:498)
  20.     at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:160)
  21.     at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:592)
  22.     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1057)
  23.     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:953)
  24.     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
  25.     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
  26.     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
  27.     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
  28.     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
  29.     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191)
  30.     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
  31.     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
  32.     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1419)
  33.     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1160)
  34.     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
  35.     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
  36.     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
  37.     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
  38.     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
  39.     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191)
  40.     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
  41.     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
  42.     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1419)
  43.     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1160)
  44.     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
  45.     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
  46.     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
  47.     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
  48.     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
  49.     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191)
  50.     at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:923)
  51.     at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:866)
  52.     at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:781)
  53.     at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:503)
  54.     at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88)
  55.     at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:295)
  56.     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1148)
  57.     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
  58.     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
  59.     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
  60.     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
  61.     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
  62.     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191)
  63.     at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:923)
  64.     at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:866)
  65.     at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:781)
  66.     at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:503)
  67.     at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88)
  68.     at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:295)
  69.     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1148)
  70.     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
  71.     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
  72.     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
  73.     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
  74.     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
  75.     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191)
  76.     at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:638)
  77.     at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:942)
  78.     at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)
  79.     at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)
  80.     at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
  81.     at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)
  82.     at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:782)
  83.     at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:424)
  84.     at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:774)
  85.     at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:249)
  86.     at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1242)
  87.     at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:717)
  88.     at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:494)
  89.     at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)
  90.     at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:95)
  91.     at org.eclipse.jetty.server.Server.doStart(Server.java:282)
  92.     at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64)
  93.     at org.madsonic.booter.deployer.MadsonicDeployer.deployWebApp(MadsonicDeployer.java:247)
  94.     at org.madsonic.booter.deployer.MadsonicDeployer.<init>(MadsonicDeployer.java:102)
  95.     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  96.     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  97.     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  98.     at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  99.     at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:148)
  100.     at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:87)
  101.     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:1032)
  102.     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:985)
  103.     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
  104.     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
  105.     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
  106.     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
  107.     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
  108.     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191)
  109.     at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:638)
  110.     at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:942)
  111.     at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)
  112.     at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
  113.     at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83)
  114.     at org.madsonic.booter.Main.<init>(Main.java:46)
  115.     at org.madsonic.booter.Main.main(Main.java:85)
  116. Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: MEDIA_FILE in statement [create table audio_ad (id identity,media_file_id int,weight double,comment varchar,enabled boolean default false not null,created datetime not null,changed datetime not null,foreign key (media_file_id) references media_file(id) on delete cascade)]
  117.     at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
  118.     at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
  119.     at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
  120.     at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
  121.     at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:421)
  122.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
  123.     ... 105 more
  124. Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: MEDIA_FILE
  125.     at org.hsqldb.error.Error.error(Unknown Source)
  126.     at org.hsqldb.error.Error.error(Unknown Source)
  127.     at org.hsqldb.ParserTable.addForeignKey(Unknown Source)
  128.     at org.hsqldb.ParserTable.addTableConstraintDefinitions(Unknown Source)
  129.     at org.hsqldb.StatementSchema.getResult(Unknown Source)
  130.     at org.hsqldb.StatementSchema.execute(Unknown Source)
  131.     at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
  132.     at org.hsqldb.Session.executeDirectStatement(Unknown Source)
  133.     at org.hsqldb.Session.execute(Unknown Source)
  134.     ... 109 more
  135.  
  136. [2018-05-20 22:36:37,151] INFO HsqlDaoHelper - Checking HSQLDB version: 2.4.0
  137. [2018-05-20 22:36:37,700] INFO SecurityService - Updating database schema to version 201. (securing user passwords)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top