Project

General

Profile

Actions

Defect #719

closed

On develop cannot create database

Added by Marek Klement over 6 years ago. Updated about 5 years ago.

Status:
Closed
Priority:
High
Assignee:
Marek Klement
Category:
Infrastructure
Target version:
Start date:
09/26/2017
Due date:
% Done:

100%

Estimated time:
Affected versions:
Owner:

Description

When I drop schema of database and after that I need to run IDM, there is a problem of unexisting table of quartz.

Actions #1

Updated by Ondřej Kopr over 6 years ago

  • Status changed from New to Needs feedback
  • Assignee set to Marek Klement
Actions #2

Updated by Jan Helbich over 6 years ago

  • Category set to 20
  • Assignee changed from Marek Klement to Ondřej Kopr
  • Priority changed from Normal to High
  • Target version set to Diamond (7.4.0)

Happens also on my machine. Master is doing just fine.
I deploy to Postgres db (docker, fresh container) and Tomcat 8.5.20 (docker, fresh container).

While I was helping Marek to get this up and running, we dropped the database schema and recreated it, tested other Tomcat versions (8.0.latest), tried to alter tomcat privileges to be absolutely permissive, nothing helped. Therefore I suspect there is a new critical bug in develop. This makes nightly builds pretty much useless -> I'm raising the priority of this task.

Actions #3

Updated by Ondřej Kopr over 6 years ago

  • Status changed from Needs feedback to In Progress
Actions #4

Updated by Ondřej Kopr over 6 years ago

  • Assignee changed from Ondřej Kopr to Radek Tomiška
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'initAccScheduledTask': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private eu.bcvsolutions.idm.core.scheduler.api.service.SchedulerManager eu.bcvsolutions.idm.core.scheduler.config.AbstractScheduledTaskInitializer.schedulerService; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'schedulerManager' defined in class path resource [eu/bcvsolutions/idm/core/scheduler/config/SchedulerConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [eu.bcvsolutions.idm.core.scheduler.api.service.SchedulerManager]: Factory method 'schedulerManager' threw exception; nested exception is eu.bcvsolutions.idm.core.api.exception.CoreException
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:334)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1218)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:778)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:839)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:538)
    at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:118)
    at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:760)
    at org.springframework.boot.SpringApplication.createAndRefreshContext(SpringApplication.java:360)
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:306)
    at org.springframework.boot.context.web.SpringBootServletInitializer.run(SpringBootServletInitializer.java:150)
    at org.springframework.boot.context.web.SpringBootServletInitializer.createRootApplicationContext(SpringBootServletInitializer.java:130)
    at org.springframework.boot.context.web.SpringBootServletInitializer.onStartup(SpringBootServletInitializer.java:85)
    at org.springframework.web.SpringServletContainerInitializer.onStartup(SpringServletContainerInitializer.java:169)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5261)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1407)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1397)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:748)
Caused by: org.springframework.beans.factory.BeanCreationException: Could not autowire field: private eu.bcvsolutions.idm.core.scheduler.api.service.SchedulerManager eu.bcvsolutions.idm.core.scheduler.config.AbstractScheduledTaskInitializer.schedulerService; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'schedulerManager' defined in class path resource [eu/bcvsolutions/idm/core/scheduler/config/SchedulerConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [eu.bcvsolutions.idm.core.scheduler.api.service.SchedulerManager]: Factory method 'schedulerManager' threw exception; nested exception is eu.bcvsolutions.idm.core.api.exception.CoreException
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:573)
    at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88)
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:331)
    ... 26 common frames omitted
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'schedulerManager' defined in class path resource [eu/bcvsolutions/idm/core/scheduler/config/SchedulerConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [eu.bcvsolutions.idm.core.scheduler.api.service.SchedulerManager]: Factory method 'schedulerManager' threw exception; nested exception is eu.bcvsolutions.idm.core.api.exception.CoreException
    at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:599)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1127)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1022)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:510)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:1199)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1123)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1021)
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:545)
    ... 28 common frames omitted
Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [eu.bcvsolutions.idm.core.scheduler.api.service.SchedulerManager]: Factory method 'schedulerManager' threw exception; nested exception is eu.bcvsolutions.idm.core.api.exception.CoreException
    at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:189)
    at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:588)
    ... 40 common frames omitted
Caused by: eu.bcvsolutions.idm.core.api.exception.CoreException: null
    at eu.bcvsolutions.idm.core.scheduler.service.impl.DefaultSchedulerManager.getAllTasks(DefaultSchedulerManager.java:112)
    at eu.bcvsolutions.idm.core.scheduler.config.SchedulerConfig.schedulerManager(SchedulerConfig.java:86)
    at eu.bcvsolutions.idm.core.scheduler.config.SchedulerConfig$$EnhancerBySpringCGLIB$$cef53b79.CGLIB$schedulerManager$2(<generated>)
    at eu.bcvsolutions.idm.core.scheduler.config.SchedulerConfig$$EnhancerBySpringCGLIB$$cef53b79$$FastClassBySpringCGLIB$$9e8b2bcf.invoke(<generated>)
    at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
    at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:356)
    at eu.bcvsolutions.idm.core.scheduler.config.SchedulerConfig$$EnhancerBySpringCGLIB$$cef53b79.schedulerManager(<generated>)
    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:162)
    ... 41 common frames omitted
Caused by: org.quartz.JobPersistenceException: Couldn't obtain job names: ERROR: relation "qrtz_job_details" does not exist
  Pozice: 33
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.getJobNames(JobStoreSupport.java:1889)
    at org.quartz.impl.jdbcjobstore.JobStoreSupport$20.execute(JobStoreSupport.java:1877)
    at org.quartz.impl.jdbcjobstore.JobStoreCMT.executeInLock(JobStoreCMT.java:245)
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeWithoutLock(JobStoreSupport.java:3739)
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.getJobKeys(JobStoreSupport.java:1874)
    at org.quartz.core.QuartzScheduler.getJobKeys(QuartzScheduler.java:1464)
    at org.quartz.impl.StdScheduler.getJobKeys(StdScheduler.java:470)
    at eu.bcvsolutions.idm.core.scheduler.service.impl.DefaultSchedulerManager.getAllTasks(DefaultSchedulerManager.java:103)
    ... 52 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: relation "qrtz_job_details" does not exist
  Pozice: 33
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2458)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2158)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:291)
    at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:432)
    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:358)
    at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:171)
    at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:119)
    at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectJobsInGroup(StdJDBCDelegate.java:980)
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.getJobNames(JobStoreSupport.java:1887)
    ... 59 common frames omitted
Actions #5

Updated by Ondřej Kopr over 6 years ago

  • Status changed from In Progress to Needs feedback
  • Assignee changed from Radek Tomiška to Marek Klement
  • % Done changed from 0 to 90

Wa are fixed start up dependency
commit: https://github.com/bcvsolutions/CzechIdMng/commit/cb5024f131de662177cd51f563c592c01760293b

Please Marek could you make a test? Thank you.

Actions #6

Updated by Jan Helbich over 6 years ago

Works, thanks a lot, Ondra!

Actions #7

Updated by Marek Klement over 6 years ago

  • Status changed from Needs feedback to Closed
  • % Done changed from 90 to 100

It works, thanks!

Actions #8

Updated by Radek Tomiška about 5 years ago

  • Tracker changed from Task to Defect
  • Category changed from 20 to Infrastructure
Actions

Also available in: Atom PDF