liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE cattle.volume ADD access_mode VARCHAR(255) NULL: Can't create table 'cattle.#sql-18_7' (errno: -1)

GitHub | jmreicha | 5 months ago
  1. 0

    Error upgrading from rancher-server 1.0.1 to 1.1.1

    GitHub | 5 months ago | jmreicha
    liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE cattle.volume ADD access_mode VARCHAR(255) NULL: Can't create table 'cattle.#sql-18_7' (errno: -1)
  2. 0

    Key is too long with external MySQL container

    GitHub | 1 year ago | andrefreitas
    liquibase.exception.DatabaseException: Error executing SQL CREATE INDEX idx_label_key_value ON cattle.label(`key`, value): Specified key was too long; max key length is 767 bytes
  3. 0

    create with external MySQL: Specified key was too long; max key length is 767 bytes

    GitHub | 8 months ago | xlight
    liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE rancher.config_item ADD CONSTRAINT idx_config_item__name UNIQUE (name): Specified key was too long; max key length is 767 bytes
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    SQL error encountered when installing rancher-server

    GitHub | 7 months ago | sangeethah
    liquibase.exception.DatabaseException: Error executing SQL CREATE INDEX idx_volume_uri ON cattle.volume(uri): Index column size too large. The maximum column size is 767 bytes.
  6. 0

    The job_queue table creation is failing on SQL Server with the following errors in the log {noformat} DEV: 10:13:30.813 [main] INFO o.j.s.c.logging.LogBackConfigLoader - Configured Logback with config file from: C:\src\ssp-local\logback.xml DEV: 10:13:31.141 [main] INFO o.j.s.c.BeanProfileApplicationContextInitializer - Loaded properties file from C:\src\ssp-local\ssp-config.properties for determining spring profile. DEV: 10:13:31.141 [main] INFO o.j.s.c.BeanProfileApplicationContextInitializer - Loaded properties file from classpath:ssp-config.default.properties for determining spring profile. DEV: 10:13:42.825 [main] INFO o.s.s.c.ThreadPoolTaskScheduler - Initializing ExecutorService 'sspScheduler' DEV: 10:14:14.382 [main] INFO o.s.s.c.ThreadPoolTaskScheduler - Shutting down ExecutorService 'sspScheduler' DEV: 10:14:14.397 [main] ERROR o.s.web.context.ContextLoader - Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'webProperties': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private transient org.jasig.ssp.service.reference.ConfigService org.jasig.ssp.config.WebProperties.configService; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'configServiceImpl': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private transient org.jasig.ssp.dao.reference.ConfigDao org.jasig.ssp.service.reference.impl.ConfigServiceImpl.dao; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'configDao': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: protected transient org.hibernate.SessionFactory org.jasig.ssp.dao.AbstractDao.sessionFactory; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in ServletContext resource [/WEB-INF/spring/app-config.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set org/jasig/ssp/database/changesets/000156.xml::create table job_queue::tony.arland: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: There is already an object named 'watch_modified_person_id' in the database. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:289) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1146) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:628) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932) ~[spring-context-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479) ~[spring-context-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410) ~[spring-web-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306) ~[spring-web-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112) [spring-web-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206) [catalina.jar:6.0.36] at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705) [catalina.jar:6.0.36] at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799) [catalina.jar:6.0.36] at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779) [catalina.jar:6.0.36] at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601) [catalina.jar:6.0.36] at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675) [catalina.jar:6.0.36] at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601) [catalina.jar:6.0.36] at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502) [catalina.jar:6.0.36] at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317) [catalina.jar:6.0.36] at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324) [catalina.jar:6.0.36] at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) [catalina.jar:6.0.36] at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065) [catalina.jar:6.0.36] at org.apache.catalina.core.StandardHost.start(StandardHost.java:840) [catalina.jar:6.0.36] at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057) [catalina.jar:6.0.36] at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463) [catalina.jar:6.0.36] at org.apache.catalina.core.StandardService.start(StandardService.java:525) [catalina.jar:6.0.36] at org.apache.catalina.core.StandardServer.start(StandardServer.java:754) [catalina.jar:6.0.36] at org.apache.catalina.startup.Catalina.start(Catalina.java:595) [catalina.jar:6.0.36] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.7.0_67] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[na:1.7.0_67] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_67] at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_67] at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) [bootstrap.jar:6.0.36] at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) [bootstrap.jar:6.0.36] Caused by: org.springframework.beans.factory.BeanCreationException: Could not autowire field: private transient org.jasig.ssp.service.reference.ConfigService org.jasig.ssp.config.WebProperties.configService; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'configServiceImpl': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private transient org.jasig.ssp.dao.reference.ConfigDao org.jasig.ssp.service.reference.impl.ConfigServiceImpl.dao; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'configDao': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: protected transient org.hibernate.SessionFactory org.jasig.ssp.dao.AbstractDao.sessionFactory; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in ServletContext resource [/WEB-INF/spring/app-config.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set org/jasig/ssp/database/changesets/000156.xml::create table job_queue::tony.arland: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: There is already an object named 'watch_modified_person_id' in the database. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:517) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:286) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] ... 37 common frames omitted Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'configServiceImpl': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private transient org.jasig.ssp.dao.reference.ConfigDao org.jasig.ssp.service.reference.impl.ConfigServiceImpl.dao; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'configDao': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: protected transient org.hibernate.SessionFactory org.jasig.ssp.dao.AbstractDao.sessionFactory; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in ServletContext resource [/WEB-INF/spring/app-config.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set org/jasig/ssp/database/changesets/000156.xml::create table job_queue::tony.arland: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: There is already an object named 'watch_modified_person_id' in the database. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:289) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1146) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:912) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:855) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:770) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:489) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] ... 39 common frames omitted Caused by: org.springframework.beans.factory.BeanCreationException: Could not autowire field: private transient org.jasig.ssp.dao.reference.ConfigDao org.jasig.ssp.service.reference.impl.ConfigServiceImpl.dao; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'configDao': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: protected transient org.hibernate.SessionFactory org.jasig.ssp.dao.AbstractDao.sessionFactory; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in ServletContext resource [/WEB-INF/spring/app-config.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set org/jasig/ssp/database/changesets/000156.xml::create table job_queue::tony.arland: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: There is already an object named 'watch_modified_person_id' in the database. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:517) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:286) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] ... 50 common frames omitted Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'configDao': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: protected transient org.hibernate.SessionFactory org.jasig.ssp.dao.AbstractDao.sessionFactory; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in ServletContext resource [/WEB-INF/spring/app-config.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set org/jasig/ssp/database/changesets/000156.xml::create table job_queue::tony.arland: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: There is already an object named 'watch_modified_person_id' in the database. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:289) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1146) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:912) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:855) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:770) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:489) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] ... 52 common frames omitted Caused by: org.springframework.beans.factory.BeanCreationException: Could not autowire field: protected transient org.hibernate.SessionFactory org.jasig.ssp.dao.AbstractDao.sessionFactory; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in ServletContext resource [/WEB-INF/spring/app-config.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set org/jasig/ssp/database/changesets/000156.xml::create table job_queue::tony.arland: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: There is already an object named 'watch_modified_person_id' in the database. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:517) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:286) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] ... 63 common frames omitted Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in ServletContext resource [/WEB-INF/spring/app-config.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set org/jasig/ssp/database/changesets/000156.xml::create table job_queue::tony.arland: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: There is already an object named 'watch_modified_person_id' in the database. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1512) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:286) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:912) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:855) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:770) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:489) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] ... 65 common frames omitted Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set org/jasig/ssp/database/changesets/000156.xml::create table job_queue::tony.arland: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: There is already an object named 'watch_modified_person_id' in the database. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347) ~[liquibase-core-2.0.3.jar:na] at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27) ~[liquibase-core-2.0.3.jar:na] at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58) ~[liquibase-core-2.0.3.jar:na] at liquibase.Liquibase.update(Liquibase.java:113) ~[liquibase-core-2.0.3.jar:na] at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:244) ~[liquibase-core-2.0.3.jar:na] at org.jasig.ssp.util.liquibase.ExtendedSpringLiquibase.afterPropertiesSet(ExtendedSpringLiquibase.java:67) ~[ExtendedSpringLiquibase.class:na] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1571) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1509) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] ... 77 common frames omitted Caused by: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62) ~[liquibase-core-2.0.3.jar:na] at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104) ~[liquibase-core-2.0.3.jar:na] at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1075) ~[liquibase-core-2.0.3.jar:na] at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1059) ~[liquibase-core-2.0.3.jar:na] at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317) ~[liquibase-core-2.0.3.jar:na] ... 84 common frames omitted Caused by: java.sql.SQLException: There is already an object named 'watch_modified_person_id' in the database. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) ~[jtds-1.2.4.jar:1.2.4] at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820) ~[jtds-1.2.4.jar:1.2.4] at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258) ~[jtds-1.2.4.jar:1.2.4] at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632) ~[jtds-1.2.4.jar:1.2.4] at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584) ~[jtds-1.2.4.jar:1.2.4] at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546) ~[jtds-1.2.4.jar:1.2.4] at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723) ~[jtds-1.2.4.jar:1.2.4] at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1160) ~[jtds-1.2.4.jar:1.2.4] at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92) ~[liquibase-core-2.0.3.jar:na] at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) ~[liquibase-core-2.0.3.jar:na] ... 88 common frames omitted {noformat}

    Apereo Issues | 2 years ago | Jason Elwood
    liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: There is already an object named 'watch_modified_person_id' in the database.

  1. Malcshour 26 times, last 6 months ago
1 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. liquibase.exception.DatabaseException

    Error executing SQL ALTER TABLE cattle.volume ADD access_mode VARCHAR(255) NULL: Can't create table 'cattle.#sql-18_7' (errno: -1)

    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean()
  2. Spring Beans
    DefaultListableBeanFactory.preInstantiateSingletons
    1. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1512)[spring-beans-3.2.5.RELEASE.jar:3.2.5.RELEASE]
    2. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521)[spring-beans-3.2.5.RELEASE.jar:3.2.5.RELEASE]
    3. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)[spring-beans-3.2.5.RELEASE.jar:3.2.5.RELEASE]
    4. org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)[spring-beans-3.2.5.RELEASE.jar:3.2.5.RELEASE]
    5. org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)[spring-beans-3.2.5.RELEASE.jar:3.2.5.RELEASE]
    6. org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)[spring-beans-3.2.5.RELEASE.jar:3.2.5.RELEASE]
    7. org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)[spring-beans-3.2.5.RELEASE.jar:3.2.5.RELEASE]
    8. org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:628)[spring-beans-3.2.5.RELEASE.jar:3.2.5.RELEASE]
    8 frames
  3. Spring Context
    AbstractApplicationContext.refresh
    1. org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932)[spring-context-3.2.4.RELEASE.jar:3.2.4.RELEASE]
    2. org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)[spring-context-3.2.4.RELEASE.jar:3.2.4.RELEASE]
    2 frames
  4. org.apache.cloudstack
    CloudStackSpringContext.<init>
    1. org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.java:184)[cattle-framework-spring-module-0.5.0-SNAPSHOT.jar:na]
    2. org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:157)[cattle-framework-spring-module-0.5.0-SNAPSHOT.jar:na]
    3. org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:348)[cattle-framework-spring-module-0.5.0-SNAPSHOT.jar:na]
    4. org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:358)[cattle-framework-spring-module-0.5.0-SNAPSHOT.jar:na]
    5. org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:333)[cattle-framework-spring-module-0.5.0-SNAPSHOT.jar:na]
    6. org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.java:152)[cattle-framework-spring-module-0.5.0-SNAPSHOT.jar:na]
    7. org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:97)[cattle-framework-spring-module-0.5.0-SNAPSHOT.jar:na]
    8. org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37)[cattle-framework-spring-module-0.5.0-SNAPSHOT.jar:na]
    9. org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.init(CloudStackSpringContext.java:75)[cattle-framework-spring-module-0.5.0-SNAPSHOT.jar:na]
    10. org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:56)[cattle-framework-spring-module-0.5.0-SNAPSHOT.jar:na]
    10 frames
  5. io.cattle.platform
    WebContextLoaderListener.constructCloudStackSpringContext
    1. io.cattle.platform.context.SpringContext.<init>(SpringContext.java:11)[cattle-iaas-system-0.5.0-SNAPSHOT.jar:na]
    2. io.cattle.platform.context.WebContextLoaderListener.constructCloudStackSpringContext(WebContextLoaderListener.java:15)[cattle-iaas-system-0.5.0-SNAPSHOT.jar:na]
    2 frames
  6. org.apache.cloudstack
    CloudStackContextLoaderListener.contextInitialized
    1. org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:51)[cattle-framework-spring-module-0.5.0-SNAPSHOT.jar:na]
    1 frame
  7. Jetty
    AbstractLifeCycle.start
    1. org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:800)[jetty-server-9.2.11.v20150529.jar:9.2.11.v20150529]
    2. org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:444)[jetty-servlet-9.2.11.v20150529.jar:9.2.11.v20150529]
    3. org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:791)[jetty-server-9.2.11.v20150529.jar:9.2.11.v20150529]
    4. org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:294)[jetty-servlet-9.2.11.v20150529.jar:9.2.11.v20150529]
    5. org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1349)[jetty-webapp-9.2.11.v20150529.jar:9.2.11.v20150529]
    6. org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1342)[jetty-webapp-9.2.11.v20150529.jar:9.2.11.v20150529]
    7. org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:741)[jetty-server-9.2.11.v20150529.jar:9.2.11.v20150529]
    8. org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:505)[jetty-webapp-9.2.11.v20150529.jar:9.2.11.v20150529]
    9. org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)[jetty-util-9.2.11.v20150529.jar:9.2.11.v20150529]
    10. org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:132)[jetty-util-9.2.11.v20150529.jar:9.2.11.v20150529]
    11. org.eclipse.jetty.server.Server.start(Server.java:387)[jetty-server-9.2.11.v20150529.jar:9.2.11.v20150529]
    12. org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:114)[jetty-util-9.2.11.v20150529.jar:9.2.11.v20150529]
    13. org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:61)[jetty-server-9.2.11.v20150529.jar:9.2.11.v20150529]
    14. org.eclipse.jetty.server.Server.doStart(Server.java:354)[jetty-server-9.2.11.v20150529.jar:9.2.11.v20150529]
    15. org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)[jetty-util-9.2.11.v20150529.jar:9.2.11.v20150529]
    15 frames
  8. io.cattle.platform
    Main.main
    1. io.cattle.platform.launcher.jetty.Main.main(Main.java:145)[8cd6a40e20d8c693d8b4ac1f1d27d4b2/:na]
    1 frame
  9. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.7.0_95]
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)[na:1.7.0_95]
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.7.0_95]
    4. java.lang.reflect.Method.invoke(Method.java:606)[na:1.7.0_95]
    4 frames
  10. io.cattle.platform
    Main.main
    1. io.cattle.platform.launcher.Main.run(Main.java:188)[8cd6a40e20d8c693d8b4ac1f1d27d4b2/:na]
    2. io.cattle.platform.launcher.Main.main(Main.java:251)[8cd6a40e20d8c693d8b4ac1f1d27d4b2/:na]
    2 frames