guestAT

Untitled

Jun 29th, 2021
970
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. 2021-06-29_17:55:42.449 [main] DEBUG c.s.c.c.DatabaseAwareApplicationPropertiesInitializer [] - Found 475 properties in default and tomcat
  2. 2021-06-29_17:55:52.472 [main] INFO  c.s.c.c.DbMigrationManager [] - Trying to migrate the database schema if needed
  3. 2021-06-29_17:55:52.765 [main] INFO  c.g.flyway.core.command.DbMigrate [] - Current version of schema "public": 00076
  4. 2021-06-29_17:55:52.765 [main] INFO  c.g.flyway.core.command.DbMigrate [] - Migrating schema "public" to version 00077
  5. 2021-06-29_17:55:52.795 [main] ERROR c.g.flyway.core.command.DbMigrate [] - Migration of schema "public" to version 00077 failed! Changes successfully rolled back.
  6. 2021-06-29_17:55:52.819 [main] ERROR o.s.web.context.ContextLoader [] - Context initialization failed
  7. org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor#0': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dbMigrationManager' defined in URL [jar:file:/opt/tomcat6/webapps/cpgu/WEB-INF/lib/cpgu-model-1.0-SNAPSHOT.jar!/META-INF/spring/cpgu-model-app-context.xml]: Invocation of init method failed; nested exception is com.googlecode.flyway.core.command.FlywaySqlScriptException: Error executing statement at line 1: INSERT INTO cpgu_user (id, password, username, display_name, phone, code, first_name, last_name, patronymic,
  8.                        active_directory_login, is_new_interface, position, warrant_number, warrant_date,
  9.                        is_permitted_to_edit_wiki, damask_password, damask_login, auto_ping_queue,
  10.                        change_timestamp,
  11.                        signature_key_alias, fake_queue, advanced_monitoring_call_center, is_damask_manual_authorization,
  12.                        pk_pvd_login,
  13.                        pk_pvd_password, call_by_ticket_id, redirect_to_other_windows, permitted_to_edit_expert_system,
  14.                        is_interface_threedotzero, email, control_regulations_role, kr_role, reset_password,
  15.                        is_equeue_use, token, password_next, change_timestamp_password_next)
  16. VALUES (nextval('hibernate_sequence'), '', '111-222-333 00', 'Пользователь ARM Юрист', '', '', 'ARM', 'ARM', 'ARM',
  17.         null, true, '', '', null, true, '', '', false, null, '', false, false, false, null, null,
  18.         true, true, false, false, null, null, null, false, false, null, null, null)
  19.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:527) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  20.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  21.         at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  22.         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  23.         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  24.         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  25.         at org.springframework.context.support.AbstractApplicationContext.registerBeanPostProcessors(AbstractApplicationContext.java:733) ~[spring-context-3.1.2.RELEASE.jar:3.1.2.RELEASE]
  26.         at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:454) ~[spring-context-3.1.2.RELEASE.jar:3.1.2.RELEASE]
  27.         at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:383) ~[spring-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  28.         at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283) ~[spring-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  29.         at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111) [spring-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  30.         at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4210) [catalina.jar:6.0.44]
  31.         at org.apache.catalina.core.StandardContext.start(StandardContext.java:4709) [catalina.jar:6.0.44]
  32.         at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:802) [catalina.jar:6.0.44]
  33.         at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779) [catalina.jar:6.0.44]
  34.         at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:583) [catalina.jar:6.0.44]
  35.         at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:944) [catalina.jar:6.0.44]
  36.         at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:779) [catalina.jar:6.0.44]
  37.         at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:505) [catalina.jar:6.0.44]
  38.         at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1322) [catalina.jar:6.0.44]
  39.         at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:325) [catalina.jar:6.0.44]
  40.         at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) [catalina.jar:6.0.44]
  41.         at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1068) [catalina.jar:6.0.44]
  42.         at org.apache.catalina.core.StandardHost.start(StandardHost.java:822) [catalina.jar:6.0.44]
  43.         at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1060) [catalina.jar:6.0.44]
  44.         at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463) [catalina.jar:6.0.44]
  45.         at org.apache.catalina.core.StandardService.start(StandardService.java:525) [catalina.jar:6.0.44]
  46.         at org.apache.catalina.core.StandardServer.start(StandardServer.java:759) [catalina.jar:6.0.44]
  47.         at org.apache.catalina.startup.Catalina.start(Catalina.java:595) [catalina.jar:6.0.44]
  48.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_172]
  49.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_172]
  50.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_172]
  51.         at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_172]
  52.         at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) [bootstrap.jar:6.0.44]
  53.         at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) [bootstrap.jar:6.0.44]
  54. Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dbMigrationManager' defined in URL [jar:file:/opt/tomcat6/webapps/cpgu/WEB-INF/lib/cpgu-model-1.0-SNAPSHOT.jar!/META-INF/spring/cpgu-model-app-context.xml]: Invocation of init method failed; nested exception is com.googlecode.flyway.core.command.FlywaySqlScriptException: Error executing statement at line 1: INSERT INTO cpgu_user (id, password, username, display_name, phone, code, first_name, last_name, patronymic,
  55.                        active_directory_login, is_new_interface, position, warrant_number, warrant_date,
  56.                        is_permitted_to_edit_wiki, damask_password, damask_login, auto_ping_queue,
  57.                        change_timestamp,
  58.                        signature_key_alias, fake_queue, advanced_monitoring_call_center, is_damask_manual_authorization,
  59.                        pk_pvd_login,
  60.                        pk_pvd_password, call_by_ticket_id, redirect_to_other_windows, permitted_to_edit_expert_system,
  61.                        is_interface_threedotzero, email, control_regulations_role, kr_role, reset_password,
  62.                        is_equeue_use, token, password_next, change_timestamp_password_next)
  63. VALUES (nextval('hibernate_sequence'), '', '111-222-333 00', 'Пользователь ARM Юрист', '', '', 'ARM', 'ARM', 'ARM',
  64.         null, true, '', '', null, true, '', '', false, null, '', false, false, false, null, null,
  65.         true, true, false, false, null, null, null, false, false, null, null, null)
  66.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1455) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  67.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  68.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  69.         at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  70.         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  71.         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  72.         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  73.         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:284) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  74.         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  75.         at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:420) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  76.         at org.springframework.beans.factory.BeanFactoryUtils.beansOfTypeIncludingAncestors(BeanFactoryUtils.java:277) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  77.         at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.detectPersistenceExceptionTranslators(PersistenceExceptionTranslationInterceptor.java:139) ~[spring-tx-3.1.2.RELEASE.jar:3.1.2.RELEASE]
  78.         at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.<init>(PersistenceExceptionTranslationInterceptor.java:79) ~[spring-tx-3.1.2.RELEASE.jar:3.1.2.RELEASE]
  79.         at org.springframework.dao.annotation.PersistenceExceptionTranslationAdvisor.<init>(PersistenceExceptionTranslationAdvisor.java:70) ~[spring-tx-3.1.2.RELEASE.jar:3.1.2.RELEASE]
  80.         at org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor.setBeanFactory(PersistenceExceptionTranslationPostProcessor.java:103) ~[spring-tx-3.1.2.RELEASE.jar:3.1.2.RELEASE]
  81.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeAwareMethods(AbstractAutowireCapableBeanFactory.java:1475) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  82.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1443) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  83.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  84.         ... 34 common frames omitted
  85. Caused by: com.googlecode.flyway.core.command.FlywaySqlScriptException: Error executing statement at line 1: INSERT INTO cpgu_user (id, password, username, display_name, phone, code, first_name, last_name, patronymic,
  86.                        active_directory_login, is_new_interface, position, warrant_number, warrant_date,
  87.                        is_permitted_to_edit_wiki, damask_password, damask_login, auto_ping_queue,
  88.                        change_timestamp,
  89.                        signature_key_alias, fake_queue, advanced_monitoring_call_center, is_damask_manual_authorization,
  90.                        pk_pvd_login,
  91.                        pk_pvd_password, call_by_ticket_id, redirect_to_other_windows, permitted_to_edit_expert_system,
  92.                        is_interface_threedotzero, email, control_regulations_role, kr_role, reset_password,
  93.                        is_equeue_use, token, password_next, change_timestamp_password_next)
  94. VALUES (nextval('hibernate_sequence'), '', '111-222-333 00', 'Пользователь ARM Юрист', '', '', 'ARM', 'ARM', 'ARM',
  95.         null, true, '', '', null, true, '', '', false, null, '', false, false, false, null, null,
  96.         true, true, false, false, null, null, null, false, false, null, null, null)
  97.         at com.googlecode.flyway.core.dbsupport.SqlScript.execute(SqlScript.java:92) ~[flyway-core-2.3.1.jar:na]
  98.         at com.googlecode.flyway.core.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:72) ~[flyway-core-2.3.1.jar:na]
  99.         at com.googlecode.flyway.core.command.DbMigrate$2.doInTransaction(DbMigrate.java:243) ~[flyway-core-2.3.1.jar:na]
  100.         at com.googlecode.flyway.core.command.DbMigrate$2.doInTransaction(DbMigrate.java:241) ~[flyway-core-2.3.1.jar:na]
  101.         at com.googlecode.flyway.core.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72) ~[flyway-core-2.3.1.jar:na]
  102.         at com.googlecode.flyway.core.command.DbMigrate.applyMigration(DbMigrate.java:241) ~[flyway-core-2.3.1.jar:na]
  103.         at com.googlecode.flyway.core.command.DbMigrate.access$700(DbMigrate.java:44) ~[flyway-core-2.3.1.jar:na]
  104.         at com.googlecode.flyway.core.command.DbMigrate$1.doInTransaction(DbMigrate.java:186) ~[flyway-core-2.3.1.jar:na]
  105.         at com.googlecode.flyway.core.command.DbMigrate$1.doInTransaction(DbMigrate.java:135) ~[flyway-core-2.3.1.jar:na]
  106.         at com.googlecode.flyway.core.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72) ~[flyway-core-2.3.1.jar:na]
  107.         at com.googlecode.flyway.core.command.DbMigrate.migrate(DbMigrate.java:135) ~[flyway-core-2.3.1.jar:na]
  108.         at com.googlecode.flyway.core.Flyway$1.execute(Flyway.java:872) ~[flyway-core-2.3.1.jar:na]
  109.         at com.googlecode.flyway.core.Flyway$1.execute(Flyway.java:819) ~[flyway-core-2.3.1.jar:na]
  110.         at com.googlecode.flyway.core.Flyway.execute(Flyway.java:1200) ~[flyway-core-2.3.1.jar:na]
  111.         at com.googlecode.flyway.core.Flyway.migrate(Flyway.java:819) ~[flyway-core-2.3.1.jar:na]
  112.         at com.sc.cpgu.configuration.DbMigrationManager.manageMigrations(DbMigrationManager.java:32) ~[cpgu-model-1.0-SNAPSHOT.jar:na]
  113.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_172]
  114.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_172]
  115.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_172]
  116.         at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_172]
  117.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1581) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  118.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1522) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  119.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1452) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  120.         ... 51 common frames omitted
  121. Caused by: org.postgresql.util.PSQLException: ERROR: column "kr_role" of relation "cpgu_user" does not exist
  122.   Позиция: 714
  123.         at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) ~[postgresql-9.1-901-1.jdbc4.jar:na]
  124.         at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) ~[postgresql-9.1-901-1.jdbc4.jar:na]
  125.         at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) ~[postgresql-9.1-901-1.jdbc4.jar:na]
  126.         at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) ~[postgresql-9.1-901-1.jdbc4.jar:na]
  127.         at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) ~[postgresql-9.1-901-1.jdbc4.jar:na]
  128.         at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366) ~[postgresql-9.1-901-1.jdbc4.jar:na]
  129.         at com.googlecode.flyway.core.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:230) ~[flyway-core-2.3.1.jar:na]
  130.         at com.googlecode.flyway.core.dbsupport.SqlScript.execute(SqlScript.java:90) ~[flyway-core-2.3.1.jar:na]
  131.         ... 73 common frames omitted
RAW Paste Data