· 6 years ago · Dec 17, 2019, 04:52 PM
1jenkins@pco-dev-01:/srv/pco-dev-compose$ docker logs -f --tail 100 pcodevcompose_fgup-pco-core_1
2Migration 20191214_0232__archive_event.sql failed
3-------------------------------------------------
4SQL State : 3F000
5Error Code : 0
6Message : ERROR: schema "pco_central" does not exist
7 Position: 28
8Location : db/migration/default/20191214_0232__archive_event.sql (/srv/pco/file:/srv/pco/lib/pco-service-0.0.1.958.jar!/db/migration/default/20191214_0232__archive_event.sql)
9Line : 3
10Statement : CREATE TABLE IF NOT EXISTS pco_central.archive_events (
11 id BIGSERIAL NOT NULL CONSTRAINT archive_events_pk PRIMARY KEY,
12 server_time TIMESTAMP WITH TIME ZONE NOT NULL,
13 issue_id VARCHAR(36),
14 zone_number BIGINT,
15 broadcast_device_number BIGINT NOT NULL,
16 text VARCHAR(255),
17 type BIGINT,
18 code BIGINT,
19 device_guid BIGINT,
20 device_account BIGINT,
21 event_mode VARCHAR(10) NOT NULL,
22 alarm_handler_employee VARCHAR(255),
23 alarm_handler_time TIMESTAMP WITH TIME ZONE,
24 alarm_process_employee VARCHAR(255),
25 alarm_process_time TIMESTAMP WITH TIME ZONE,
26 alarm_process_reason VARCHAR(255),
27 alarm_process_comment VARCHAR(255),
28 alarm_process_team VARCHAR(255),
29 alarm_process_team_time TIMESTAMP WITH TIME ZONE,
30 alarm_process_team_id VARCHAR(36),
31 main BOOLEAN NOT NULL,
32 branch_id VARCHAR(36) NOT NULL,
33 observation_id VARCHAR(36),
34 connection_id VARCHAR(36),
35 connection VARCHAR(255),
36 observation VARCHAR(255),
37 observation_type VARCHAR(255),
38 event_class_type VARCHAR(20),
39 color VARCHAR(255)
40)
41
42 at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:345)
43 at org.flywaydb.core.internal.command.DbMigrate.access$900(DbMigrate.java:53)
44 at org.flywaydb.core.internal.command.DbMigrate$4.call(DbMigrate.java:276)
45 at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:75)
46 at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:273)
47 at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:53)
48 at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:210)
49 at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:146)
50 at org.flywaydb.core.internal.dbsupport.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:68)
51 at org.flywaydb.core.internal.dbsupport.postgresql.PostgreSQLDbSupport.lock(PostgreSQLDbSupport.java:162)
52 at org.flywaydb.core.internal.metadatatable.MetaDataTableImpl.lock(MetaDataTableImpl.java:174)
53 at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:146)
54 at org.flywaydb.core.Flyway$1.execute(Flyway.java:1010)
55 at org.flywaydb.core.Flyway$1.execute(Flyway.java:971)
56 at org.flywaydb.core.Flyway.execute(Flyway.java:1464)
57 at org.flywaydb.core.Flyway.migrate(Flyway.java:971)
58 at org.flywaydb.play.PlayInitializer.$anonfun$migrateAutomatically$1(PlayInitializer.scala:156)
59 at org.flywaydb.play.PlayInitializer.$anonfun$migrateAutomatically$1$adapted(PlayInitializer.scala:155)
60 at scala.Option.foreach(Option.scala:257)
61 at org.flywaydb.play.PlayInitializer.migrateAutomatically(PlayInitializer.scala:155)
62 at org.flywaydb.play.PlayInitializer.$anonfun$onStart$1(PlayInitializer.scala:147)
63 at org.flywaydb.play.PlayInitializer.$anonfun$onStart$1$adapted(PlayInitializer.scala:145)
64 at scala.collection.Iterator.foreach(Iterator.scala:929)
65 at scala.collection.Iterator.foreach$(Iterator.scala:929)
66 at scala.collection.AbstractIterator.foreach(Iterator.scala:1417)
67 at scala.collection.MapLike$DefaultKeySet.foreach(MapLike.scala:178)
68 at org.flywaydb.play.PlayInitializer.onStart(PlayInitializer.scala:145)
69 at org.flywaydb.play.PlayInitializer.<init>(PlayInitializer.scala:164)
70 at org.flywaydb.play.PlayInitializer$$FastClassByGuice$$fd53e8fe.newInstance(<generated>)
71 at com.google.inject.internal.DefaultConstructionProxyFactory$FastClassProxy.newInstance(DefaultConstructionProxyFactory.java:89)
72 at com.google.inject.internal.ConstructorInjector.provision(ConstructorInjector.java:111)
73 at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:90)
74 at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:268)
75 at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(ProviderToInternalFactoryAdapter.java:46)
76 at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1092)
77 at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(ProviderToInternalFactoryAdapter.java:40)
78 at com.google.inject.internal.SingletonScope$1.get(SingletonScope.java:194)
79 at com.google.inject.internal.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:41)
80 at com.google.inject.internal.InternalInjectorCreator$1.call(InternalInjectorCreator.java:205)
81 at com.google.inject.internal.InternalInjectorCreator$1.call(InternalInjectorCreator.java:199)
82 at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1085)
83 at com.google.inject.internal.InternalInjectorCreator.loadEagerSingletons(InternalInjectorCreator.java:199)
84 at com.google.inject.internal.InternalInjectorCreator.injectDynamically(InternalInjectorCreator.java:180)
85 ... 9 more
86Caused by: org.postgresql.util.PSQLException: ERROR: schema "pco_central" does not exist
87 Position: 28
88 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2477)
89 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2190)
90 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300)
91 at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
92 at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
93 at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:301)
94 at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:287)
95 at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:264)
96 at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:260)
97 at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:267)
98 at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:142)
99 at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:76)
100 at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:343)