· 10 years ago · Jul 14, 2016, 01:30 PM
1[2016-07-14 16:25:42] +-----------------+
2[2016-07-14 16:25:42] | HOME MANAGEMENT |
3[2016-07-14 16:25:42] | UPDATE |
4[2016-07-14 16:25:42] +-----------------+
5[2016-07-14 16:25:42] Running UPDATE using url: jdbc:postgresql://192.168.50.8:5454
6INFO 7/14/16 4:25 PM: liquibase: Successfully acquired change log lock
7INFO 7/14/16 4:25 PM: liquibase: Reading from public.databasechangelog
8INFO 7/14/16 4:25 PM: liquibase: Successfully released change log lock
9Liquibase Update Successful
10INFO 7/14/16 4:25 PM: liquibase: Successfully acquired change log lock
11INFO 7/14/16 4:25 PM: liquibase: Reading from public.databasechangelog
12INFO 7/14/16 4:25 PM: liquibase: prerun_hm.xml: prerun_hm.xml::preHCSINT-17653-20160428-001f::soldatov: Stored procedure created
13INFO 7/14/16 4:25 PM: liquibase: prerun_hm.xml: prerun_hm.xml::preHCSINT-17653-20160428-001f::soldatov: ChangeSet prerun_hm.xml::preHCSINT-17653-20160428-001f::soldatov ran successfully in 11ms
14INFO 7/14/16 4:25 PM: liquibase: Successfully released change log lock
15Liquibase Update Successful
16INFO 7/14/16 4:25 PM: liquibase: Successfully acquired change log lock
17INFO 7/14/16 4:25 PM: liquibase: Reading from public.databasechangelog
18SEVERE 7/14/16 4:25 PM: liquibase: master_hm.xml: hcshmdb/8.8.0.xml::HCS-32172-20160630-01::ptukach: Change Set hcshmdb/8.8.0.xml::HCS-32172-20160630-01::ptukach failed. Error: Error executing SQL DO $$
19BEGIN
20 drop table if exists hmsm.nsi_house_hcsint_20451;
21
22 if (SELECT count(1) FROM pg_user_mappings where srvname = 'hcsnsidb' and usename = 'postgres') = 0 then
23 CREATE USER MAPPING FOR postgres SERVER hcsnsidb OPTIONS (user 'hcs_nsi_rw', password 'hcs_nsi_rw');
24
25 create table hmsm.nsi_house_hcsint_20451
26 as
27 select houseid, eststatus from hmsm.nsi_house_f;
28
29 DROP USER MAPPING IF EXISTS FOR postgres SERVER hcsnsidb;
30 else
31 create table hmsm.nsi_house_hcsint_20451
32 as
33 select houseid, eststatus from hmsm.nsi_house_f;
34
35 end if;
36
37 create index idx_house_20451 on hmsm.nsi_house_hcsint_20451 USING btree (houseid COLLATE pg_catalog."C");
38
39 analyse hmsm.nsi_house_hcsint_20451;
40
41 UPDATE hmsm.hm_house_resource_provision_managed_objects m
42 SET eststatus = f.eststatus
43 FROM hmsm.nsi_house_hcsint_20451 f
44 WHERE f.houseid = m.house_guid;
45
46 UPDATE hmsm.hm_managed_objects m
47 SET eststatus = f.eststatus
48 FROM hmsm.nsi_house_hcsint_20451 f
49 WHERE f.houseid = m.house_guid;
50
51 UPDATE hmsm.house m
52 SET eststatus = f.eststatus
53 FROM hmsm.nsi_house_hcsint_20451 f
54 WHERE f.houseid = m.houseid;
55
56 drop table hmsm.nsi_house_hcsint_20451;
57
58END $$;: ERROR: MultiXactId 839462960 has not been created yet -- apparent wraparound
59 Where: Remote SQL command: SELECT houseid, eststatus FROM nsism.nsi_house
60SQL statement "create table hmsm.nsi_house_hcsint_20451
61 as
62 select houseid, eststatus from hmsm.nsi_house_f"
63PL/pgSQL function inline_code_block line 14 at SQL statement
64liquibase.exception.DatabaseException: Error executing SQL DO $$
65BEGIN
66 drop table if exists hmsm.nsi_house_hcsint_20451;
67
68 if (SELECT count(1) FROM pg_user_mappings where srvname = 'hcsnsidb' and usename = 'postgres') = 0 then
69 CREATE USER MAPPING FOR postgres SERVER hcsnsidb OPTIONS (user 'hcs_nsi_rw', password 'hcs_nsi_rw');
70
71 create table hmsm.nsi_house_hcsint_20451
72 as
73 select houseid, eststatus from hmsm.nsi_house_f;
74
75 DROP USER MAPPING IF EXISTS FOR postgres SERVER hcsnsidb;
76 else
77 create table hmsm.nsi_house_hcsint_20451
78 as
79 select houseid, eststatus from hmsm.nsi_house_f;
80
81 end if;
82
83 create index idx_house_20451 on hmsm.nsi_house_hcsint_20451 USING btree (houseid COLLATE pg_catalog."C");
84
85 analyse hmsm.nsi_house_hcsint_20451;
86
87 UPDATE hmsm.hm_house_resource_provision_managed_objects m
88 SET eststatus = f.eststatus
89 FROM hmsm.nsi_house_hcsint_20451 f
90 WHERE f.houseid = m.house_guid;
91
92 UPDATE hmsm.hm_managed_objects m
93 SET eststatus = f.eststatus
94 FROM hmsm.nsi_house_hcsint_20451 f
95 WHERE f.houseid = m.house_guid;
96
97 UPDATE hmsm.house m
98 SET eststatus = f.eststatus
99 FROM hmsm.nsi_house_hcsint_20451 f
100 WHERE f.houseid = m.houseid;
101
102 drop table hmsm.nsi_house_hcsint_20451;
103
104END $$;: ERROR: MultiXactId 839462960 has not been created yet -- apparent wraparound
105 Where: Remote SQL command: SELECT houseid, eststatus FROM nsism.nsi_house
106SQL statement "create table hmsm.nsi_house_hcsint_20451
107 as
108 select houseid, eststatus from hmsm.nsi_house_f"
109PL/pgSQL function inline_code_block line 14 at SQL statement
110 at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
111 at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)
112 at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1206)
113 at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1189)
114 at liquibase.changelog.ChangeSet.execute(ChangeSet.java:528)
115 at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:43)
116 at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:70)
117 at liquibase.Liquibase.update(Liquibase.java:195)
118 at liquibase.Liquibase.update(Liquibase.java:174)
119 at liquibase.integration.commandline.Main.doMigration(Main.java:997)
120 at liquibase.integration.commandline.Main.run(Main.java:170)
121 at liquibase.integration.commandline.Main.main(Main.java:89)
122Caused by: org.postgresql.util.PSQLException: ERROR: MultiXactId 839462960 has not been created yet -- apparent wraparound
123 Where: Remote SQL command: SELECT houseid, eststatus FROM nsism.nsi_house
124SQL statement "create table hmsm.nsi_house_hcsint_20451
125 as
126 select houseid, eststatus from hmsm.nsi_house_f"
127PL/pgSQL function inline_code_block line 14 at SQL statement
128 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
129 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
130 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
131 at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
132 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:406)
133 at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:398)
134 at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:310)
135 at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
136 ... 11 more
137INFO 7/14/16 4:25 PM: liquibase: hcshmdb/8.8.0.xml::HCS-32172-20160630-01::ptukach: Successfully released change log lock
138Unexpected error running Liquibase: Error executing SQL DO $$
139BEGIN
140 drop table if exists hmsm.nsi_house_hcsint_20451;
141
142 if (SELECT count(1) FROM pg_user_mappings where srvname = 'hcsnsidb' and usename = 'postgres') = 0 then
143 CREATE USER MAPPING FOR postgres SERVER hcsnsidb OPTIONS (user 'hcs_nsi_rw', password 'hcs_nsi_rw');
144
145 create table hmsm.nsi_house_hcsint_20451
146 as
147 select houseid, eststatus from hmsm.nsi_house_f;
148
149 DROP USER MAPPING IF EXISTS FOR postgres SERVER hcsnsidb;
150 else
151 create table hmsm.nsi_house_hcsint_20451
152 as
153 select houseid, eststatus from hmsm.nsi_house_f;
154
155 end if;
156
157 create index idx_house_20451 on hmsm.nsi_house_hcsint_20451 USING btree (houseid COLLATE pg_catalog."C");
158
159 analyse hmsm.nsi_house_hcsint_20451;
160
161 UPDATE hmsm.hm_house_resource_provision_managed_objects m
162 SET eststatus = f.eststatus
163 FROM hmsm.nsi_house_hcsint_20451 f
164 WHERE f.houseid = m.house_guid;
165
166 UPDATE hmsm.hm_managed_objects m
167 SET eststatus = f.eststatus
168 FROM hmsm.nsi_house_hcsint_20451 f
169 WHERE f.houseid = m.house_guid;
170
171 UPDATE hmsm.house m
172 SET eststatus = f.eststatus
173 FROM hmsm.nsi_house_hcsint_20451 f
174 WHERE f.houseid = m.houseid;
175
176 drop table hmsm.nsi_house_hcsint_20451;
177
178END $$;: ERROR: MultiXactId 839462960 has not been created yet -- apparent wraparound
179 Where: Remote SQL command: SELECT houseid, eststatus FROM nsism.nsi_house
180SQL statement "create table hmsm.nsi_house_hcsint_20451
181 as
182 select houseid, eststatus from hmsm.nsi_house_f"
183PL/pgSQL function inline_code_block line 14 at SQL statement
184
185SEVERE 7/14/16 4:25 PM: liquibase: hcshmdb/8.8.0.xml::HCS-32172-20160630-01::ptukach: Error executing SQL DO $$
186BEGIN
187 drop table if exists hmsm.nsi_house_hcsint_20451;
188
189 if (SELECT count(1) FROM pg_user_mappings where srvname = 'hcsnsidb' and usename = 'postgres') = 0 then
190 CREATE USER MAPPING FOR postgres SERVER hcsnsidb OPTIONS (user 'hcs_nsi_rw', password 'hcs_nsi_rw');
191
192 create table hmsm.nsi_house_hcsint_20451
193 as
194 select houseid, eststatus from hmsm.nsi_house_f;
195
196 DROP USER MAPPING IF EXISTS FOR postgres SERVER hcsnsidb;
197 else
198 create table hmsm.nsi_house_hcsint_20451
199 as
200 select houseid, eststatus from hmsm.nsi_house_f;
201
202 end if;
203
204 create index idx_house_20451 on hmsm.nsi_house_hcsint_20451 USING btree (houseid COLLATE pg_catalog."C");
205
206 analyse hmsm.nsi_house_hcsint_20451;
207
208 UPDATE hmsm.hm_house_resource_provision_managed_objects m
209 SET eststatus = f.eststatus
210 FROM hmsm.nsi_house_hcsint_20451 f
211 WHERE f.houseid = m.house_guid;
212
213 UPDATE hmsm.hm_managed_objects m
214 SET eststatus = f.eststatus
215 FROM hmsm.nsi_house_hcsint_20451 f
216 WHERE f.houseid = m.house_guid;
217
218 UPDATE hmsm.house m
219 SET eststatus = f.eststatus
220 FROM hmsm.nsi_house_hcsint_20451 f
221 WHERE f.houseid = m.houseid;
222
223 drop table hmsm.nsi_house_hcsint_20451;
224
225END $$;: ERROR: MultiXactId 839462960 has not been created yet -- apparent wraparound
226 Where: Remote SQL command: SELECT houseid, eststatus FROM nsism.nsi_house
227SQL statement "create table hmsm.nsi_house_hcsint_20451
228 as
229 select houseid, eststatus from hmsm.nsi_house_f"
230PL/pgSQL function inline_code_block line 14 at SQL statement
231liquibase.exception.MigrationFailedException: Migration failed for change set hcshmdb/8.8.0.xml::HCS-32172-20160630-01::ptukach:
232 Reason: liquibase.exception.DatabaseException: Error executing SQL DO $$
233BEGIN
234 drop table if exists hmsm.nsi_house_hcsint_20451;
235
236 if (SELECT count(1) FROM pg_user_mappings where srvname = 'hcsnsidb' and usename = 'postgres') = 0 then
237 CREATE USER MAPPING FOR postgres SERVER hcsnsidb OPTIONS (user 'hcs_nsi_rw', password 'hcs_nsi_rw');
238
239 create table hmsm.nsi_house_hcsint_20451
240 as
241 select houseid, eststatus from hmsm.nsi_house_f;
242
243 DROP USER MAPPING IF EXISTS FOR postgres SERVER hcsnsidb;
244 else
245 create table hmsm.nsi_house_hcsint_20451
246 as
247 select houseid, eststatus from hmsm.nsi_house_f;
248
249 end if;
250
251 create index idx_house_20451 on hmsm.nsi_house_hcsint_20451 USING btree (houseid COLLATE pg_catalog."C");
252
253 analyse hmsm.nsi_house_hcsint_20451;
254
255 UPDATE hmsm.hm_house_resource_provision_managed_objects m
256 SET eststatus = f.eststatus
257 FROM hmsm.nsi_house_hcsint_20451 f
258 WHERE f.houseid = m.house_guid;
259
260 UPDATE hmsm.hm_managed_objects m
261 SET eststatus = f.eststatus
262 FROM hmsm.nsi_house_hcsint_20451 f
263 WHERE f.houseid = m.house_guid;
264
265 UPDATE hmsm.house m
266 SET eststatus = f.eststatus
267 FROM hmsm.nsi_house_hcsint_20451 f
268 WHERE f.houseid = m.houseid;
269
270 drop table hmsm.nsi_house_hcsint_20451;
271
272END $$;: ERROR: MultiXactId 839462960 has not been created yet -- apparent wraparound
273 Where: Remote SQL command: SELECT houseid, eststatus FROM nsism.nsi_house
274SQL statement "create table hmsm.nsi_house_hcsint_20451
275 as
276 select houseid, eststatus from hmsm.nsi_house_f"
277PL/pgSQL function inline_code_block line 14 at SQL statement
278 at liquibase.changelog.ChangeSet.execute(ChangeSet.java:564)
279 at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:43)
280 at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:70)
281 at liquibase.Liquibase.update(Liquibase.java:195)
282 at liquibase.Liquibase.update(Liquibase.java:174)
283 at liquibase.integration.commandline.Main.doMigration(Main.java:997)
284 at liquibase.integration.commandline.Main.run(Main.java:170)
285 at liquibase.integration.commandline.Main.main(Main.java:89)
286Caused by: liquibase.exception.DatabaseException: Error executing SQL DO $$
287BEGIN
288 drop table if exists hmsm.nsi_house_hcsint_20451;
289
290 if (SELECT count(1) FROM pg_user_mappings where srvname = 'hcsnsidb' and usename = 'postgres') = 0 then
291 CREATE USER MAPPING FOR postgres SERVER hcsnsidb OPTIONS (user 'hcs_nsi_rw', password 'hcs_nsi_rw');
292
293 create table hmsm.nsi_house_hcsint_20451
294 as
295 select houseid, eststatus from hmsm.nsi_house_f;
296
297 DROP USER MAPPING IF EXISTS FOR postgres SERVER hcsnsidb;
298 else
299 create table hmsm.nsi_house_hcsint_20451
300 as
301 select houseid, eststatus from hmsm.nsi_house_f;
302
303 end if;
304
305 create index idx_house_20451 on hmsm.nsi_house_hcsint_20451 USING btree (houseid COLLATE pg_catalog."C");
306
307 analyse hmsm.nsi_house_hcsint_20451;
308
309 UPDATE hmsm.hm_house_resource_provision_managed_objects m
310 SET eststatus = f.eststatus
311 FROM hmsm.nsi_house_hcsint_20451 f
312 WHERE f.houseid = m.house_guid;
313
314 UPDATE hmsm.hm_managed_objects m
315 SET eststatus = f.eststatus
316 FROM hmsm.nsi_house_hcsint_20451 f
317 WHERE f.houseid = m.house_guid;
318
319 UPDATE hmsm.house m
320 SET eststatus = f.eststatus
321 FROM hmsm.nsi_house_hcsint_20451 f
322 WHERE f.houseid = m.houseid;
323
324 drop table hmsm.nsi_house_hcsint_20451;
325
326END $$;: ERROR: MultiXactId 839462960 has not been created yet -- apparent wraparound
327 Where: Remote SQL command: SELECT houseid, eststatus FROM nsism.nsi_house
328SQL statement "create table hmsm.nsi_house_hcsint_20451
329 as
330 select houseid, eststatus from hmsm.nsi_house_f"
331PL/pgSQL function inline_code_block line 14 at SQL statement
332 at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
333 at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)
334 at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1206)
335 at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1189)
336 at liquibase.changelog.ChangeSet.execute(ChangeSet.java:528)
337 ... 7 more
338Caused by: org.postgresql.util.PSQLException: ERROR: MultiXactId 839462960 has not been created yet -- apparent wraparound
339 Where: Remote SQL command: SELECT houseid, eststatus FROM nsism.nsi_house
340SQL statement "create table hmsm.nsi_house_hcsint_20451
341 as
342 select houseid, eststatus from hmsm.nsi_house_f"
343PL/pgSQL function inline_code_block line 14 at SQL statement
344 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
345 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
346 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
347 at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
348 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:406)
349 at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:398)
350 at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:310)
351 at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
352 ... 11 more