Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 2019-03-23 17:51:13.481 INFO [] [main] org.eclipse.jetty.util.log : Logging initialized @6102ms to org.eclipse.jetty.util.log.Slf4jLog
- 2019-03-23 17:51:13.604 INFO [] [main] e.j.JettyEmbeddedServletContainerFactory : Server initialized with port: 8191
- 2019-03-23 17:51:13.750 INFO [] [main] org.eclipse.jetty.server.Server : jetty-9.4.12.v20180830; built: 2018-08-30T13:59:14.071Z; git: 27208684755d94a92186989f695db2d7b21ebc51; jvm 1.8.0_181-b13
- 2019-03-23 17:51:13.983 INFO [] [main] org.eclipse.jetty.server.session : DefaultSessionIdManager workerName=node0
- 2019-03-23 17:51:13.984 INFO [] [main] org.eclipse.jetty.server.session : No SessionScavenger set, using defaults
- 2019-03-23 17:51:13.986 INFO [] [main] org.eclipse.jetty.server.session : node0 Scavenging every 660000ms
- 2019-03-23 17:51:13.995 INFO [] [main] o.e.j.s.h.ContextHandler.application : Initializing Spring embedded WebApplicationContext
- 2019-03-23 17:51:13.995 INFO [] [main] o.s.web.context.ContextLoader : Root WebApplicationContext: initialization completed in 4444 ms
- 2019-03-23 17:51:15.039 INFO [] [main] o.s.b.w.servlet.FilterRegistrationBean : Mapping filter: 'metricsFilter' to: [/*]
- 2019-03-23 17:51:15.041 INFO [] [main] o.s.b.w.servlet.FilterRegistrationBean : Mapping filter: 'characterEncodingFilter' to: [/*]
- 2019-03-23 17:51:15.042 INFO [] [main] o.s.b.w.servlet.FilterRegistrationBean : Mapping filter: 'traceFilter' to: [/*]
- 2019-03-23 17:51:15.043 INFO [] [main] o.s.b.w.servlet.FilterRegistrationBean : Mapping filter: 'hiddenHttpMethodFilter' to: [/*]
- 2019-03-23 17:51:15.044 INFO [] [main] o.s.b.w.servlet.FilterRegistrationBean : Mapping filter: 'httpPutFormContentFilter' to: [/*]
- 2019-03-23 17:51:15.046 INFO [] [main] o.s.b.w.servlet.FilterRegistrationBean : Mapping filter: 'requestContextFilter' to: [/*]
- 2019-03-23 17:51:15.047 INFO [] [main] o.s.b.w.servlet.FilterRegistrationBean : Mapping filter: 'webRequestLoggingFilter' to: [/*]
- 2019-03-23 17:51:15.048 INFO [] [main] o.s.b.w.servlet.FilterRegistrationBean : Mapping filter: 'controllerUserLocaleFilter' to urls: [/api/*]
- 2019-03-23 17:51:15.049 INFO [] [main] o.s.b.w.servlet.FilterRegistrationBean : Mapping filter: 'applicationContextIdFilter' to: [/*]
- 2019-03-23 17:51:15.051 INFO [] [main] o.s.b.w.servlet.ServletRegistrationBean : Mapping servlet: 'dispatcherServlet' to [/]
- 2019-03-23 17:51:15.057 INFO [] [main] o.e.jetty.server.handler.ContextHandler : Started o.s.b.c.e.j.JettyEmbeddedWebAppContext@31e3250d{application,/,[file:///tmp/jetty-docbase.5626358214750317247.8191/,
- jar:file:/var/opt/cdek/clientQuestions/releases/20190323104632Z/clientQuestions-1.0-25.jar!/BOOT-INF/lib/springfox-swagger-ui-2.9.2.jar!/META-INF/resources],AVAILABLE}
- 2019-03-23 17:51:15.127 INFO [] [main] org.eclipse.jetty.server.Server : Started @7750ms
- 2019-03-23 17:51:15.335 INFO [] [main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Started.
- 2019-03-23 17:51:15.968 INFO [] [main] c.c.client.questions.ApplicationConfig : ::: Flyway APPLICATION :::
- 2019-03-23 17:51:15.981 INFO [] [main] o.f.core.internal.util.VersionPrinter : Flyway Community Edition 5.1.4 by Boxfuse
- 2019-03-23 17:51:15.999 INFO [] [main] o.f.c.internal.database.DatabaseFactory : Database: jdbc:postgresql://172.16.100.92:5432/client_questions (PostgreSQL 10.6)
- 2019-03-23 17:51:16.091 INFO [] [main] o.f.core.internal.command.DbValidate : Successfully validated 7 migrations (execution time 00:00.029s)
- 2019-03-23 17:51:16.105 INFO [] [main] o.f.core.internal.command.DbMigrate : Current version of schema "client_questions": null
- 2019-03-23 17:51:16.133 INFO [] [main] o.f.core.internal.command.DbMigrate : Migrating schema "client_questions" to version 2 - create tables
- 2019-03-23 17:51:16.320 ERROR [] [main] o.f.core.internal.command.DbMigrate : Migration of schema "client_questions" to version 2 - create tables failed! Changes successfully rolled back.
- 2019-03-23 17:51:16.327 WARN [] [main] ationConfigEmbeddedWebApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'questionDaoImpl' defined in URL [jar:file:/var/opt/cdek/clientQuestions/releases/20190323104632Z/clientQuestions-1.0-25.jar!/BOOT-INF/classes!/com/cdek/client/questions/dao/impl/QuestionDaoImpl.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'questionRepository' defined in URL [jar:file:/var/opt/cdek/clientQuestions/releases/20190323104632Z/clientQuestions-1.0-25.jar!/BOOT-INF/classes!/com/cdek/client/questions/dao/QuestionRepository.class]: Unsatisfied dependency expressed through bean property 'sqlSessionTemplate'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [com/cdek/client/questions/ApplicationConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.jdbc.datasource.DataSourceTransactionManager]: Factory method 'transactionManager' threw exception; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
- Migration V2__create_tables.sql failed
- --------------------------------------
- SQL State : 42883
- Error Code : 0
- Message : ERROR: function gen_random_uuid() does not exist
- Подсказка: No function matches the given name and argument types. You might need to add explicit type casts.
- Location : db/migrations/questions/V2__create_tables.sql (/var/opt/cdek/clientQuestions/releases/20190323104632Z/file:/var/opt/cdek/clientQuestions/releases/20190323104632Z/clientQuestions-1.0-25.jar!/BOOT-INF/classes!/db/migrations/questions/V2__create_tables.sql)
- Line : 120
- Statement : CREATE TABLE IF NOT EXISTS client_questions.question (
- uuid UUID PRIMARY KEY NOT NULL DEFAULT gen_random_uuid(),
- number BIGSERIAL UNIQUE,
- text TEXT DEFAULT NULL,
- draft_text TEXT DEFAULT NULL,
- creation_date TIMESTAMP NOT NULL DEFAULT now(),
- status_current question_status_type NOT NULL,
- status_backup question_status_type DEFAULT NULL,
- question_category_id BIGINT NOT NULL,
- question_problem_id BIGINT DEFAULT NULL,
- question_channel_code question_channel_type NOT NULL,
- contragent_uuid TEXT DEFAULT NULL,
- sender_email TEXT DEFAULT NULL,
- sender_name TEXT DEFAULT NULL,
- sender_city_code TEXT DEFAULT NULL,
- mistake_city_code TEXT DEFAULT NULL,
- mistake_office_code TEXT DEFAULT NULL,
- mistake_group_id BIGINT DEFAULT NULL,
- last_reply_date TIMESTAMP DEFAULT NULL,
- timer BIGINT DEFAULT NULL,
- block_moment TIMESTAMP DEFAULT NULL,
- blocked_user VARCHAR(8) DEFAULT NULL,
- notification_error_code TEXT,
- CONSTRAINT question_status_fk FOREIGN KEY (status_current) REFERENCES client_questions.question_status (code),
- CONSTRAINT question_category_fk FOREIGN KEY (question_category_id) REFERENCES client_questions.question_category (id),
- CONSTRAINT question_problem_fk FOREIGN KEY (question_problem_id) REFERENCES client_questions.question_problem (id),
- CONSTRAINT question_channel_fk FOREIGN KEY (question_channel_code) REFERENCES client_questions.question_channel (code),
- CONSTRAINT question_mistake_group_fk FOREIGN KEY (mistake_group_id) REFERENCES client_questions.group (id),
- CONSTRAINT question_contragent_fk FOREIGN KEY (contragent_uuid) REFERENCES client_questions.contragent (uuid)
- )
- 2019-03-23 17:51:16.328 INFO [] [main] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Close initiated...
- 2019-03-23 17:51:16.354 INFO [] [main] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Closed.
- 2019-03-23 17:51:16.357 INFO [] [main] org.eclipse.jetty.server.session : node0 Stopped scavenging
- 2019-03-23 17:51:16.365 INFO [] [main] o.e.jetty.server.handler.ContextHandler : Stopped o.s.b.c.e.j.JettyEmbeddedWebAppContext@31e3250d{application,/,[file:///tmp/jetty-docbase.5626358214750317247.8191/,
- jar:file:/var/opt/cdek/clientQuestions/releases/20190323104632Z/clientQuestions-1.0-25.jar!/BOOT-INF/lib/springfox-swagger-ui-2.9.2.jar!/META-INF/resources],UNAVAILABLE}
- 2019-03-23 17:51:16.387 INFO [] [main] utoConfigurationReportLoggingInitializer :
- Error starting ApplicationContext. To display the auto-configuration report re-run your application with 'debug' enabled.
- 2019-03-23 17:51:16.396 ERROR [] [main] o.s.boot.SpringApplication : Application startup failed
- org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'questionDaoImpl' defined in URL [jar:file:/var/opt/cdek/clientQuestions/releases/20190323104632Z/clientQuestions-1.0-25.jar!/BOOT-INF/classes!/com/cdek/client/questions/dao/impl/QuestionDaoImpl.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'questionRepository' defined in URL [jar:file:/var/opt/cdek/clientQuestions/releases/20190323104632Z/clientQuestions-1.0-25.jar!/BOOT-INF/classes!/com/cdek/client/questions/dao/QuestionRepository.class]: Unsatisfied dependency expressed through bean property 'sqlSessionTemplate'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [com/cdek/client/questions/ApplicationConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.jdbc.datasource.DataSourceTransactionManager]: Factory method 'transactionManager' threw exception; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
- Migration V2__create_tables.sql failed
- --------------------------------------
- SQL State : 42883
- Error Code : 0
- Message : ERROR: function gen_random_uuid() does not exist
- Подсказка: No function matches the given name and argument types. You might need to add explicit type casts.
- Location : db/migrations/questions/V2__create_tables.sql (/var/opt/cdek/clientQuestions/releases/20190323104632Z/file:/var/opt/cdek/clientQuestions/releases/20190323104632Z/clientQuestions-1.0-25.jar!/BOOT-INF/classes!/db/migrations/questions/V2__create_tables.sql)
- Line : 120
- Statement : CREATE TABLE IF NOT EXISTS client_questions.question (
- uuid UUID PRIMARY KEY NOT NULL DEFAULT gen_random_uuid(),
- number BIGSERIAL UNIQUE,
- text TEXT DEFAULT NULL,
- draft_text TEXT DEFAULT NULL,
- creation_date TIMESTAMP NOT NULL DEFAULT now(),
- status_current question_status_type NOT NULL,
- status_backup question_status_type DEFAULT NULL,
- question_category_id BIGINT NOT NULL,
- question_problem_id BIGINT DEFAULT NULL,
- question_channel_code question_channel_type NOT NULL,
- contragent_uuid TEXT DEFAULT NULL,
- sender_email TEXT DEFAULT NULL,
- sender_name TEXT DEFAULT NULL,
- sender_city_code TEXT DEFAULT NULL,
- mistake_city_code TEXT DEFAULT NULL,
- mistake_office_code TEXT DEFAULT NULL,
- mistake_group_id BIGINT DEFAULT NULL,
- last_reply_date TIMESTAMP DEFAULT NULL,
- timer BIGINT DEFAULT NULL,
- block_moment TIMESTAMP DEFAULT NULL,
- blocked_user VARCHAR(8) DEFAULT NULL,
- notification_error_code TEXT,
- CONSTRAINT question_status_fk FOREIGN KEY (status_current) REFERENCES client_questions.question_status (code),
- CONSTRAINT question_category_fk FOREIGN KEY (question_category_id) REFERENCES client_questions.question_category (id),
- CONSTRAINT question_problem_fk FOREIGN KEY (question_problem_id) REFERENCES client_questions.question_problem (id),
- CONSTRAINT question_channel_fk FOREIGN KEY (question_channel_code) REFERENCES client_questions.question_channel (code),
- CONSTRAINT question_mistake_group_fk FOREIGN KEY (mistake_group_id) REFERENCES client_questions.group (id),
- CONSTRAINT question_contragent_fk FOREIGN KEY (contragent_uuid) REFERENCES client_questions.contragent (uuid)
- )
- at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:749) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1198) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1100) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867) ~[spring-context-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543) ~[spring-context-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:122) ~[spring-boot-1.5.16.RELEASE.jar!/:1.5.16.RELEASE]
- at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:693) [spring-boot-1.5.16.RELEASE.jar!/:1.5.16.RELEASE]
- at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:360) [spring-boot-1.5.16.RELEASE.jar!/:1.5.16.RELEASE]
- at org.springframework.boot.SpringApplication.run(SpringApplication.java:303) [spring-boot-1.5.16.RELEASE.jar!/:1.5.16.RELEASE]
- at org.springframework.boot.SpringApplication.run(SpringApplication.java:1118) [spring-boot-1.5.16.RELEASE.jar!/:1.5.16.RELEASE]
- at org.springframework.boot.SpringApplication.run(SpringApplication.java:1107) [spring-boot-1.5.16.RELEASE.jar!/:1.5.16.RELEASE]
- at com.cdek.client.questions.ClientQuestionsApplication.main(ClientQuestionsApplication.java:21) [classes!/:1.0-25]
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_181]
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_181]
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_181]
- at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_181]
- at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48) [clientQuestions-1.0-25.jar:1.0-25]
- at org.springframework.boot.loader.Launcher.launch(Launcher.java:87) [clientQuestions-1.0-25.jar:1.0-25]
- at org.springframework.boot.loader.Launcher.launch(Launcher.java:50) [clientQuestions-1.0-25.jar:1.0-25]
- at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51) [clientQuestions-1.0-25.jar:1.0-25]
- Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'questionRepository' defined in URL [jar:file:/var/opt/cdek/clientQuestions/releases/20190323104632Z/clientQuestions-1.0-25.jar!/BOOT-INF/classes!/com/cdek/client/questions/dao/QuestionRepository.class]: Unsatisfied dependency expressed through bean property 'sqlSessionTemplate'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [com/cdek/client/questions/ApplicationConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.jdbc.datasource.DataSourceTransactionManager]: Factory method 'transactionManager' threw exception; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
- Migration V2__create_tables.sql failed
- --------------------------------------
- SQL State : 42883
- Error Code : 0
- Message : ERROR: function gen_random_uuid() does not exist
- Подсказка: No function matches the given name and argument types. You might need to add explicit type casts.
- Location : db/migrations/questions/V2__create_tables.sql (/var/opt/cdek/clientQuestions/releases/20190323104632Z/file:/var/opt/cdek/clientQuestions/releases/20190323104632Z/clientQuestions-1.0-25.jar!/BOOT-INF/classes!/db/migrations/questions/V2__create_tables.sql)
- Line : 120
- Statement : CREATE TABLE IF NOT EXISTS client_questions.question (
- uuid UUID PRIMARY KEY NOT NULL DEFAULT gen_random_uuid(),
- number BIGSERIAL UNIQUE,
- text TEXT DEFAULT NULL,
- draft_text TEXT DEFAULT NULL,
- creation_date TIMESTAMP NOT NULL DEFAULT now(),
- status_current question_status_type NOT NULL,
- status_backup question_status_type DEFAULT NULL,
- question_category_id BIGINT NOT NULL,
- question_problem_id BIGINT DEFAULT NULL,
- question_channel_code question_channel_type NOT NULL,
- contragent_uuid TEXT DEFAULT NULL,
- sender_email TEXT DEFAULT NULL,
- sender_name TEXT DEFAULT NULL,
- sender_city_code TEXT DEFAULT NULL,
- mistake_city_code TEXT DEFAULT NULL,
- mistake_office_code TEXT DEFAULT NULL,
- mistake_group_id BIGINT DEFAULT NULL,
- last_reply_date TIMESTAMP DEFAULT NULL,
- timer BIGINT DEFAULT NULL,
- block_moment TIMESTAMP DEFAULT NULL,
- blocked_user VARCHAR(8) DEFAULT NULL,
- notification_error_code TEXT,
- CONSTRAINT question_status_fk FOREIGN KEY (status_current) REFERENCES client_questions.question_status (code),
- CONSTRAINT question_category_fk FOREIGN KEY (question_category_id) REFERENCES client_questions.question_category (id),
- CONSTRAINT question_problem_fk FOREIGN KEY (question_problem_id) REFERENCES client_questions.question_problem (id),
- CONSTRAINT question_channel_fk FOREIGN KEY (question_channel_code) REFERENCES client_questions.question_channel (code),
- CONSTRAINT question_mistake_group_fk FOREIGN KEY (mistake_group_id) REFERENCES client_questions.group (id),
- CONSTRAINT question_contragent_fk FOREIGN KEY (contragent_uuid) REFERENCES client_questions.contragent (uuid)
- )
- at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByType(AbstractAutowireCapableBeanFactory.java:1362) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1254) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:551) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1136) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1064) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:741) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- ... 27 common frames omitted
- Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [com/cdek/client/questions/ApplicationConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.jdbc.datasource.DataSourceTransactionManager]: Factory method 'transactionManager' threw exception; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
- Migration V2__create_tables.sql failed
- --------------------------------------
- SQL State : 42883
- Error Code : 0
- Message : ERROR: function gen_random_uuid() does not exist
- Подсказка: No function matches the given name and argument types. You might need to add explicit type casts.
- Location : db/migrations/questions/V2__create_tables.sql (/var/opt/cdek/clientQuestions/releases/20190323104632Z/file:/var/opt/cdek/clientQuestions/releases/20190323104632Z/clientQuestions-1.0-25.jar!/BOOT-INF/classes!/db/migrations/questions/V2__create_tables.sql)
- Line : 120
- Statement : CREATE TABLE IF NOT EXISTS client_questions.question (
- uuid UUID PRIMARY KEY NOT NULL DEFAULT gen_random_uuid(),
- number BIGSERIAL UNIQUE,
- text TEXT DEFAULT NULL,
- draft_text TEXT DEFAULT NULL,
- creation_date TIMESTAMP NOT NULL DEFAULT now(),
- status_current question_status_type NOT NULL,
- status_backup question_status_type DEFAULT NULL,
- question_category_id BIGINT NOT NULL,
- question_problem_id BIGINT DEFAULT NULL,
- question_channel_code question_channel_type NOT NULL,
- contragent_uuid TEXT DEFAULT NULL,
- sender_email TEXT DEFAULT NULL,
- sender_name TEXT DEFAULT NULL,
- sender_city_code TEXT DEFAULT NULL,
- mistake_city_code TEXT DEFAULT NULL,
- mistake_office_code TEXT DEFAULT NULL,
- mistake_group_id BIGINT DEFAULT NULL,
- last_reply_date TIMESTAMP DEFAULT NULL,
- timer BIGINT DEFAULT NULL,
- block_moment TIMESTAMP DEFAULT NULL,
- blocked_user VARCHAR(8) DEFAULT NULL,
- notification_error_code TEXT,
- CONSTRAINT question_status_fk FOREIGN KEY (status_current) REFERENCES client_questions.question_status (code),
- CONSTRAINT question_category_fk FOREIGN KEY (question_category_id) REFERENCES client_questions.question_category (id),
- CONSTRAINT question_problem_fk FOREIGN KEY (question_problem_id) REFERENCES client_questions.question_problem (id),
- CONSTRAINT question_channel_fk FOREIGN KEY (question_channel_code) REFERENCES client_questions.question_channel (code),
- CONSTRAINT question_mistake_group_fk FOREIGN KEY (mistake_group_id) REFERENCES client_questions.group (id),
- CONSTRAINT question_contragent_fk FOREIGN KEY (contragent_uuid) REFERENCES client_questions.contragent (uuid)
- )
- at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:599) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1178) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1072) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:297) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1136) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1064) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByType(AbstractAutowireCapableBeanFactory.java:1347) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- ... 39 common frames omitted
- Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.jdbc.datasource.DataSourceTransactionManager]: Factory method 'transactionManager' threw exception; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
- Migration V2__create_tables.sql failed
- --------------------------------------
- SQL State : 42883
- Error Code : 0
- Message : ERROR: function gen_random_uuid() does not exist
- Подсказка: No function matches the given name and argument types. You might need to add explicit type casts.
- Location : db/migrations/questions/V2__create_tables.sql (/var/opt/cdek/clientQuestions/releases/20190323104632Z/file:/var/opt/cdek/clientQuestions/releases/20190323104632Z/clientQuestions-1.0-25.jar!/BOOT-INF/classes!/db/migrations/questions/V2__create_tables.sql)
- Line : 120
- Statement : CREATE TABLE IF NOT EXISTS client_questions.question (
- uuid UUID PRIMARY KEY NOT NULL DEFAULT gen_random_uuid(),
- number BIGSERIAL UNIQUE,
- text TEXT DEFAULT NULL,
- draft_text TEXT DEFAULT NULL,
- creation_date TIMESTAMP NOT NULL DEFAULT now(),
- status_current question_status_type NOT NULL,
- status_backup question_status_type DEFAULT NULL,
- question_category_id BIGINT NOT NULL,
- question_problem_id BIGINT DEFAULT NULL,
- question_channel_code question_channel_type NOT NULL,
- contragent_uuid TEXT DEFAULT NULL,
- sender_email TEXT DEFAULT NULL,
- sender_name TEXT DEFAULT NULL,
- sender_city_code TEXT DEFAULT NULL,
- mistake_city_code TEXT DEFAULT NULL,
- mistake_office_code TEXT DEFAULT NULL,
- mistake_group_id BIGINT DEFAULT NULL,
- last_reply_date TIMESTAMP DEFAULT NULL,
- timer BIGINT DEFAULT NULL,
- block_moment TIMESTAMP DEFAULT NULL,
- blocked_user VARCHAR(8) DEFAULT NULL,
- notification_error_code TEXT,
- CONSTRAINT question_status_fk FOREIGN KEY (status_current) REFERENCES client_questions.question_status (code),
- CONSTRAINT question_category_fk FOREIGN KEY (question_category_id) REFERENCES client_questions.question_category (id),
- CONSTRAINT question_problem_fk FOREIGN KEY (question_problem_id) REFERENCES client_questions.question_problem (id),
- CONSTRAINT question_channel_fk FOREIGN KEY (question_channel_code) REFERENCES client_questions.question_channel (code),
- CONSTRAINT question_mistake_group_fk FOREIGN KEY (mistake_group_id) REFERENCES client_questions.group (id),
- CONSTRAINT question_contragent_fk FOREIGN KEY (contragent_uuid) REFERENCES client_questions.contragent (uuid)
- )
- at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:189) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:588) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- ... 53 common frames omitted
- Caused by: org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
- Migration V2__create_tables.sql failed
- --------------------------------------
- SQL State : 42883
- Error Code : 0
- Message : ERROR: function gen_random_uuid() does not exist
- Подсказка: No function matches the given name and argument types. You might need to add explicit type casts.
- Location : db/migrations/questions/V2__create_tables.sql (/var/opt/cdek/clientQuestions/releases/20190323104632Z/file:/var/opt/cdek/clientQuestions/releases/20190323104632Z/clientQuestions-1.0-25.jar!/BOOT-INF/classes!/db/migrations/questions/V2__create_tables.sql)
- Line : 120
- Statement : CREATE TABLE IF NOT EXISTS client_questions.question (
- uuid UUID PRIMARY KEY NOT NULL DEFAULT gen_random_uuid(),
- number BIGSERIAL UNIQUE,
- text TEXT DEFAULT NULL,
- draft_text TEXT DEFAULT NULL,
- creation_date TIMESTAMP NOT NULL DEFAULT now(),
- status_current question_status_type NOT NULL,
- status_backup question_status_type DEFAULT NULL,
- question_category_id BIGINT NOT NULL,
- question_problem_id BIGINT DEFAULT NULL,
- question_channel_code question_channel_type NOT NULL,
- contragent_uuid TEXT DEFAULT NULL,
- sender_email TEXT DEFAULT NULL,
- sender_name TEXT DEFAULT NULL,
- sender_city_code TEXT DEFAULT NULL,
- mistake_city_code TEXT DEFAULT NULL,
- mistake_office_code TEXT DEFAULT NULL,
- mistake_group_id BIGINT DEFAULT NULL,
- last_reply_date TIMESTAMP DEFAULT NULL,
- timer BIGINT DEFAULT NULL,
- block_moment TIMESTAMP DEFAULT NULL,
- blocked_user VARCHAR(8) DEFAULT NULL,
- notification_error_code TEXT,
- CONSTRAINT question_status_fk FOREIGN KEY (status_current) REFERENCES client_questions.question_status (code),
- CONSTRAINT question_category_fk FOREIGN KEY (question_category_id) REFERENCES client_questions.question_category (id),
- CONSTRAINT question_problem_fk FOREIGN KEY (question_problem_id) REFERENCES client_questions.question_problem (id),
- CONSTRAINT question_channel_fk FOREIGN KEY (question_channel_code) REFERENCES client_questions.question_channel (code),
- CONSTRAINT question_mistake_group_fk FOREIGN KEY (mistake_group_id) REFERENCES client_questions.group (id),
- CONSTRAINT question_contragent_fk FOREIGN KEY (contragent_uuid) REFERENCES client_questions.contragent (uuid)
- )
- at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:355) ~[flyway-core-5.1.4.jar!/:na]
- at org.flywaydb.core.internal.command.DbMigrate.access$200(DbMigrate.java:53) ~[flyway-core-5.1.4.jar!/:na]
- at org.flywaydb.core.internal.command.DbMigrate$3.call(DbMigrate.java:282) ~[flyway-core-5.1.4.jar!/:na]
- at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:74) ~[flyway-core-5.1.4.jar!/:na]
- at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:279) ~[flyway-core-5.1.4.jar!/:na]
- at org.flywaydb.core.internal.command.DbMigrate.migrateGroup(DbMigrate.java:244) ~[flyway-core-5.1.4.jar!/:na]
- at org.flywaydb.core.internal.command.DbMigrate.access$100(DbMigrate.java:53) ~[flyway-core-5.1.4.jar!/:na]
- at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:163) ~[flyway-core-5.1.4.jar!/:na]
- at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:160) ~[flyway-core-5.1.4.jar!/:na]
- at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:71) ~[flyway-core-5.1.4.jar!/:na]
- at org.flywaydb.core.internal.database.postgresql.PostgreSQLConnection.lock(PostgreSQLConnection.java:92) ~[flyway-core-5.1.4.jar!/:na]
- at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:150) ~[flyway-core-5.1.4.jar!/:na]
- at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:160) ~[flyway-core-5.1.4.jar!/:na]
- at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:138) ~[flyway-core-5.1.4.jar!/:na]
- at org.flywaydb.core.Flyway$1.execute(Flyway.java:947) ~[flyway-core-5.1.4.jar!/:na]
- at org.flywaydb.core.Flyway$1.execute(Flyway.java:910) ~[flyway-core-5.1.4.jar!/:na]
- at org.flywaydb.core.Flyway.execute(Flyway.java:1238) ~[flyway-core-5.1.4.jar!/:na]
- at org.flywaydb.core.Flyway.migrate(Flyway.java:910) ~[flyway-core-5.1.4.jar!/:na]
- at com.cdek.client.questions.ApplicationConfig.migrateApplicationSchema(ApplicationConfig.java:156) ~[classes!/:1.0-25]
- at com.cdek.client.questions.ApplicationConfig.transactionManager(ApplicationConfig.java:70) ~[classes!/:1.0-25]
- at com.cdek.client.questions.ApplicationConfig$$EnhancerBySpringCGLIB$$c6e04207.CGLIB$transactionManager$7(<generated>) ~[classes!/:1.0-25]
- at com.cdek.client.questions.ApplicationConfig$$EnhancerBySpringCGLIB$$c6e04207$$FastClassBySpringCGLIB$$d7505174.invoke(<generated>) ~[classes!/:1.0-25]
- at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) ~[spring-core-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:358) ~[spring-context-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- at com.cdek.client.questions.ApplicationConfig$$EnhancerBySpringCGLIB$$c6e04207.transactionManager(<generated>) ~[classes!/:1.0-25]
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_181]
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_181]
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_181]
- at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_181]
- at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:162) ~[spring-beans-4.3.19.RELEASE.jar!/:4.3.19.RELEASE]
- ... 54 common frames omitted
- Caused by: org.flywaydb.core.internal.sqlscript.FlywaySqlScriptException:
- Migration V2__create_tables.sql failed
- --------------------------------------
- SQL State : 42883
- Error Code : 0
- Message : ERROR: function gen_random_uuid() does not exist
- Подсказка: No function matches the given name and argument types. You might need to add explicit type casts.
- Location : db/migrations/questions/V2__create_tables.sql (/var/opt/cdek/clientQuestions/releases/20190323104632Z/file:/var/opt/cdek/clientQuestions/releases/20190323104632Z/clientQuestions-1.0-25.jar!/BOOT-INF/classes!/db/migrations/questions/V2__create_tables.sql)
- Line : 120
- Statement : CREATE TABLE IF NOT EXISTS client_questions.question (
- uuid UUID PRIMARY KEY NOT NULL DEFAULT gen_random_uuid(),
- number BIGSERIAL UNIQUE,
- text TEXT DEFAULT NULL,
- draft_text TEXT DEFAULT NULL,
- creation_date TIMESTAMP NOT NULL DEFAULT now(),
- status_current question_status_type NOT NULL,
- status_backup question_status_type DEFAULT NULL,
- question_category_id BIGINT NOT NULL,
- question_problem_id BIGINT DEFAULT NULL,
- question_channel_code question_channel_type NOT NULL,
- contragent_uuid TEXT DEFAULT NULL,
- sender_email TEXT DEFAULT NULL,
- sender_name TEXT DEFAULT NULL,
- sender_city_code TEXT DEFAULT NULL,
- mistake_city_code TEXT DEFAULT NULL,
- mistake_office_code TEXT DEFAULT NULL,
- mistake_group_id BIGINT DEFAULT NULL,
- last_reply_date TIMESTAMP DEFAULT NULL,
- timer BIGINT DEFAULT NULL,
- block_moment TIMESTAMP DEFAULT NULL,
- blocked_user VARCHAR(8) DEFAULT NULL,
- notification_error_code TEXT,
- CONSTRAINT question_status_fk FOREIGN KEY (status_current) REFERENCES client_questions.question_status (code),
- CONSTRAINT question_category_fk FOREIGN KEY (question_category_id) REFERENCES client_questions.question_category (id),
- CONSTRAINT question_problem_fk FOREIGN KEY (question_problem_id) REFERENCES client_questions.question_problem (id),
- CONSTRAINT question_channel_fk FOREIGN KEY (question_channel_code) REFERENCES client_questions.question_channel (code),
- CONSTRAINT question_mistake_group_fk FOREIGN KEY (mistake_group_id) REFERENCES client_questions.group (id),
- CONSTRAINT question_contragent_fk FOREIGN KEY (contragent_uuid) REFERENCES client_questions.contragent (uuid)
- )
- at org.flywaydb.core.internal.database.ExecutableSqlScript.handleException(ExecutableSqlScript.java:331) ~[flyway-core-5.1.4.jar!/:na]
- at org.flywaydb.core.internal.database.ExecutableSqlScript.executeStatement(ExecutableSqlScript.java:301) ~[flyway-core-5.1.4.jar!/:na]
- at org.flywaydb.core.internal.database.ExecutableSqlScript.execute(ExecutableSqlScript.java:243) ~[flyway-core-5.1.4.jar!/:na]
- at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:91) ~[flyway-core-5.1.4.jar!/:na]
- at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:352) ~[flyway-core-5.1.4.jar!/:na]
- ... 83 common frames omitted
- Caused by: org.postgresql.util.PSQLException: ERROR: function gen_random_uuid() does not exist
- Подсказка: No function matches the given name and argument types. You might need to add explicit type casts.
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433) ~[postgresql-42.2.2.jar!/:42.2.2]
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178) ~[postgresql-42.2.2.jar!/:42.2.2]
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306) ~[postgresql-42.2.2.jar!/:42.2.2]
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) ~[postgresql-42.2.2.jar!/:42.2.2]
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) ~[postgresql-42.2.2.jar!/:42.2.2]
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307) ~[postgresql-42.2.2.jar!/:42.2.2]
- at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293) ~[postgresql-42.2.2.jar!/:42.2.2]
- at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270) ~[postgresql-42.2.2.jar!/:42.2.2]
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:266) ~[postgresql-42.2.2.jar!/:42.2.2]
- at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95) ~[HikariCP-2.5.1.jar!/:na]
- at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) ~[HikariCP-2.5.1.jar!/:na]
- at org.flywaydb.core.internal.util.jdbc.JdbcTemplate.executeStatement(JdbcTemplate.java:244) ~[flyway-core-5.1.4.jar!/:na]
- at org.flywaydb.core.internal.database.StandardSqlStatement.execute(StandardSqlStatement.java:44) ~[flyway-core-5.1.4.jar!/:na]
- at org.flywaydb.core.internal.database.ExecutableSqlScript.executeStatement(ExecutableSqlScript.java:280) ~[flyway-core-5.1.4.jar!/:na]
- ... 86 common frames omitted
- ^C
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement