· 8 years ago · Oct 03, 2017, 05:36 PM
1wrx@wrx-HP-EliteBook-8770w /opt/flyway-4.0.3 $ sudo ./flyway -configFile=conf/flyway.test.conf migrate -X && ./flyway -configFile=conf/flyway.test.conf info
2Flyway 4.0.3 by Boxfuse
3
4DEBUG: Java 1.8.0_74 (Oracle Corporation)
5DEBUG: Linux 4.8.0-53-generic amd64
6
7DEBUG: Loading config file: /opt/flyway-4.0.3/conf/flyway.conf
8DEBUG: Unable to load config file: /root/flyway.conf
9DEBUG: Unable to load config file: /opt/flyway-4.0.3/flyway.conf
10DEBUG: Loading config file: /opt/flyway-4.0.3/conf/flyway.test.conf
11DEBUG: Using configuration:
12DEBUG: flyway.locations -> filesystem:/opt/egron-db-pg-migration/sql/migration
13DEBUG: flyway.baselineVersion -> 0
14DEBUG: flyway.placeholders.shard_keys_list -> '0,24,27,53,69,72,84,88,books,borders,right_registry_entities'
15DEBUG: flyway.placeholders.locations -> /opt/egron-db-pg-migration/sql/migration
16DEBUG: flyway.password -> *****
17DEBUG: flyway.placeholders.discovery_postgres_url -> postgres://map_reduce:egron@pg-attribute.egron.test/pg_%{shard_group_name}_%{shard_key_hostname}
18DEBUG: flyway.placeholders.discovery_postgres_fdw -> host ''pg-attribute.egron.test'', dbname ''pg-%{shard_group_name}-%{shard_key_hostname}'', port ''5432''
19DEBUG: flyway.schemas -> version
20DEBUG: flyway.baselineDescription -> Base version
21DEBUG: flyway.sqlMigrationSeparator -> __pkurp_
22DEBUG: flyway.url -> jdbc:postgresql://pg-attribute.egron.test:5432/migration
23DEBUG: flyway.placeholders.map_reduce_options -> host ''pg-attribute.egron.test'', dbname ''pg_map_reduce''
24DEBUG: flyway.validateOnMigrate -> true
25DEBUG: flyway.user -> dba
26DEBUG: flyway.configFile -> conf/flyway.test.conf
27DEBUG: flyway.sqlMigrationSuffix -> .sql
28DEBUG: flyway.jarDirs -> /opt/flyway-4.0.3/jars
29DEBUG: Adding location to classpath: /opt/flyway-4.0.3/drivers/derbyclient-10.12.1.1.jar
30DEBUG: Adding location to classpath: /opt/flyway-4.0.3/drivers/hsqldb-2.3.3.jar
31DEBUG: Adding location to classpath: /opt/flyway-4.0.3/drivers/mariadb-java-client-1.4.5.jar
32DEBUG: Adding location to classpath: /opt/flyway-4.0.3/drivers/h2-1.4.191.jar
33DEBUG: Adding location to classpath: /opt/flyway-4.0.3/drivers/derby-10.12.1.1.jar
34DEBUG: Adding location to classpath: /opt/flyway-4.0.3/drivers/jtds-1.3.1.jar
35DEBUG: Adding location to classpath: /opt/flyway-4.0.3/drivers/postgresql-9.4.1208.jre6.jar
36DEBUG: Adding location to classpath: /opt/flyway-4.0.3/drivers/sqlite-jdbc-3.7.15-M1.jar
37Database: jdbc:postgresql://pg-attribute.egron.test:5432/migration (PostgreSQL 9.6)
38DEBUG: DDL Transactions Supported: true
39DEBUG: Schema: version
40DEBUG: Spring Jdbc available: false
41DEBUG: Scanning for SQL callbacks ...
42DEBUG: Scanning for filesystem resources at '/opt/egron-db-pg-migration/sql/migration' (Prefix: '', Suffix: '.sql')
43DEBUG: Scanning for resources in path: /opt/egron-db-pg-migration/sql/migration (/opt/egron-db-pg-migration/sql/migration)
44DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000001_0004__pkurp_pg-replica_index_record_section_number.sql.manual (filename: V000001_0004__pkurp_pg-replica_index_record_section_number.sql.manual)
45DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000005_0001__pkurp_pg-master_timestamp_columns.sql.manual (filename: V000005_0001__pkurp_pg-master_timestamp_columns.sql.manual)
46DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000014_0001__pkurp_pg-attribute_all_indexes.sql.manual (filename: V000014_0001__pkurp_pg-attribute_all_indexes.sql.manual)
47DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000015_0001__pkurp_pg-master_reindex_file_system_number.sql.manual (filename: V000015_0001__pkurp_pg-master_reindex_file_system_number.sql.manual)
48DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000018_0001__pkurp_pg-master_file_stat.sql.manual (filename: V000018_0001__pkurp_pg-master_file_stat.sql.manual)
49DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000019_0003__pkurp_pg-attribute_freeze_write_grants_to_api.sql.manual (filename: V000019_0003__pkurp_pg-attribute_freeze_write_grants_to_api.sql.manual)
50DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000020_0001__pkurp_pg-reservation_add_rg_as_external_system.sql.manual (filename: V000020_0001__pkurp_pg-reservation_add_rg_as_external_system.sql.manual)
51DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000022_0001__pkurp_pg-reservation_rg_type.sql.manual (filename: V000022_0001__pkurp_pg-reservation_rg_type.sql.manual)
52DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000056_0001__pkurp_pg-reservation-alter-type.sql.manual (filename: V000056_0001__pkurp_pg-reservation-alter-type.sql.manual)
53DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000059_0001__pkurp_pg-reservation_migration_claim.sql.manual (filename: V000059_0001__pkurp_pg-reservation_migration_claim.sql.manual)
54DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000062_0001__pkurp_pg-master-replica_shard_key_index.sql.manual (filename: V000062_0001__pkurp_pg-master-replica_shard_key_index.sql.manual)
55DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000063_0001__pkurp_pg-attribute_indexer.sql.manual (filename: V000063_0001__pkurp_pg-attribute_indexer.sql.manual)
56DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000064_0001__pkurp_pg-master-replica-shard_atom_key_index.sql.manual (filename: V000064_0001__pkurp_pg-master-replica-shard_atom_key_index.sql.manual)
57DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000064_0004__pkurp_pg-master-replica-shard_atom_key_index_function.sql.manual (filename: V000064_0004__pkurp_pg-master-replica-shard_atom_key_index_function.sql.manual)
58DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000064_0007__pkurp_pg-master-replica-cadastral_number_index_function.sql.manual (filename: V000064_0007__pkurp_pg-master-replica-cadastral_number_index_function.sql.manual)
59DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000001_0001__pkurp_pg-attribute_add_tables.sql
60DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000001_0002__pkurp_pg-attribute_add_cols_search_record.sql
61DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000001_0003__pkurp_pg-attribute_add_cols_record_section_number.sql
62DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000001_0004__pkurp_pg-replica_index_record_section_number.sql
63DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000001_0005__pkurp_pg-attribute_add_grants.sql
64DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000002_0001__pkurp_pg-attribute_add_books_tables.sql
65DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000003_0001__pkurp_pg-attribute_change_cols_type_varchar_to_text.sql
66DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000004_0001__pkurp_pg-reservation_external_locks.sql
67DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000005_0001__pkurp_pg-master_timestamp_columns.sql
68DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000005_0002__pkurp_pg-attribute_add_grants_for_sequences.sql
69DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000005_0003__pkurp_pg-attribute_add_grants_for_sequences_fixed.sql
70DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000007_0001__pkurp_pg-master_trigger_fix.sql
71DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000008_0001__pkurp_pg-master_add_view_about_all_db_size.sql
72DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000009_0001__pkurp_pg-attribute_add_col_for_address.sql
73DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000009_0002__pkurp_pg-attribute-right-registry-entities_update_new_attr_db.sql
74DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000009_0003__pkurp_pg-attribute_add_cols_address.sql
75DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000009_0004__pkurp_pg-master_add_view_about_all_db_activity.sql
76DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000010_0001__pkurp_pg-attribute-border_add_index_for_search_border.sql
77DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000010_0002__pkurp_pg-reservation_reservation-lock-check.sql
78DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000010_0003__pkurp_pg-reservation_reservation-fix.sql
79DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000011_0001__pkurp_pg-reservation-reservation_delete_duplicates.sql
80DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000011_0002__pkurp_pg-reservation-reservation_counter.sql
81DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000012_0001__pkurp_pg-replica_checks_for_V000001_0004.sql
82DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000013_0001__pkurp_pg-master_add_view_about_all_db_indexes.sql
83DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000014_0002__pkurp_pg-attribute_checks_for_all_indexes_V000014_0001.sql
84DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000015_0001__pkurp_pg-master_reindex_file_system_number.sql
85DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000016_0001__pkurp_pg-attribute_add_table.sql
86DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000016_0002__pkurp_pg-attribute_add_cols_for_search_kua_record_table.sql
87DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000016_0003__pkurp_pg-attribute_add_ix_for_search_kua_record_table_new_cols.sql
88DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000016_0004__pkurp_pg-attribute_add_grants_for_migration_sequence.sql
89DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000017_0001__pkurp_pg-attribute_drop_pmpp.sql
90DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000018_0001__pkurp_pg-master_file_stat.sql
91DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000018_0002__pkurp_pg-attribute-right-registry-entities_update_new_attr_db.sql
92DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000019_0001__pkurp_pg-reservation_freeze.sql
93DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000019_0002__pkurp_pg-master_freeze_write_grants_to_api.sql
94DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000019_0004__pkurp_pg-reservation_freeze_write_grants_to_api.sql
95DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000021_0001__pkurp_pg-attribute_drop_not_null_from_business_number.sql
96DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000022_0002__pkurp_pg-reservation_rg.sql
97DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000023_0001__pkurp_pg-master-replica_drop_not_null_from_cadastral_number.sql
98DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000024_0001__pkurp_pg-master-replica_right_records_stat.sql
99DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000025_0001__pkurp_pg-attribute_drop_pglogical.sql
100DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000026_0001__pkurp_pg-master-replica_right_records_stat_fix.sql
101DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000026_0002__pkurp_pg-master-replica_right_records_stat_fix_2.sql
102DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000027_0001__pkurp_pg-attribute_cadlink_search.sql
103DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000027_0002__pkurp_pg-attribute_cadlink_seq_grants.sql
104DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000028_0001__pkurp_pg-master-replica_right_record_fix_3.sql
105DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000028_0002__pkurp_pg-master-replica_api_write_permissions.sql
106DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000029_0001__pkurp_pg-attribute-books_kua_report.sql
107DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000030_0001__pkurp_pg-master_checks_for_timestamp_columns_V000005_0001.sql
108DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000031_0001__pkurp_pg-attribute-right-registry-entities_update_new_attr_db.sql
109DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000031_0002__pkurp_pg-attribute-80_update_new_attr_db.sql
110DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000031_0003__pkurp_pg-attribute-82_update_new_attr_db.sql
111DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000032_0001__pkurp_pg-map-reduce_attribute_tables.sql
112DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000033_0001__pkurp_pg-attribute_document_series_ix.sql
113DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000034_0001__pkurp_pg-reservation_right_record_counters.sql
114DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000035_0001__pkurp_pg-attribute_add_immutable_array-to-string_and_ix_on_address.sql
115DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000036_0001__pkurp_pg-reservation_right_record_counters-fix-1.sql
116DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000037_0001__pkurp_pg-reservation_borders_reservation.sql
117DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000038_0001__pkurp_pg-reservation_counters_check_connection.sql
118DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000039_0001__pkurp_pg-reservation_counters_check_fix.sql
119DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000040_0001__pkurp_pg-attribute_attributes_update.sql
120DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000040_0002__pkurp_pg-map-reduce_attributes_update.sql
121DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000041_0001__pkurp_pg-master_replace_view_about_all_db_size.sql
122DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000042_0001__pkurp_pg-all_add_pgstattuple.sql
123DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000042_0002__pkurp_pg-master_add_view_about_all_db_pgstattuple-approx.sql
124DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000042_0003__pkurp_pg-all_set_fillfactor_100_for_indices.sql
125DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000042_0004__pkurp_pg-master_add_view_about_all_db_bloat.sql
126DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000043_0001__pkurp_pg-master_add_view_about_all_db_schema_version_errors.sql
127DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000044_0001__pkurp_pg-attribute_add_note_for_address_and_ix_address.sql
128DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000044_0002__pkurp_pg-map-reduce_add_note_for_address.sql
129DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000045_0001__pkurp_pg-reservation_add_group-write_grants_on_frozen-section.sql
130DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000046_0001__pkurp_pg-attribute_pg-map-reduce_drop_record-unverified.sql
131DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000047_0001__pkurp_pg-attribute_attributes_update.sql
132DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000047_0002__pkurp_pg-map-reduce_attributes_update.sql
133DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000047_0003__pkurp_pg-attribute_attributes_serial.sql
134DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000047_0004__pkurp_pg-attribute_attributes_serial_grants.sql
135DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000047_0005__pkurp_pg-attribute_attributes_kua_tables.sql
136DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000047_0006__pkurp_pg-map-reduce_public_formation.sql
137DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000048_0001__pkurp_pg-reservation_reserve_number.sql
138DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000049_0001__pkurp_pg-attribute-delete-rights-on-attributes.sql
139DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000049_0002__pkurp_pg-attribute-add_fields_for_report.sql
140DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000049_0003__pkurp_pg-attribute-add_fields_for_report_2.sql
141DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000049_0004__pkurp_pg-attribute-borders_report.sql
142DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000050_0001__pkurp_pg-master_add_view_about_all_db_test_conn.sql
143DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000051_0001__pkurp_pg-map-reduce_sync_cols.sql
144DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000052_0001__pkurp_pg-reservation-migration_check.sql
145DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000052_0002__pkurp_pg-reservation-migration_check_fix.sql
146DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000053_0001__pkurp_pg-master_fix_view_about_all_db_bloat.sql
147DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000054_0001__pkurp_pg-reservation-froze_reserved_numbers.sql
148DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000055_0001__pkurp_pg-attribute-fix_books_kua_report.sql
149DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000055_0002__pkurp_pg-all_zabbix_mapping.sql
150DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000056_0002__pkurp_pg-reservation-alter-type-assert.sql
151DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000057_0001__pkurp_pg-reservation-migration.sql
152DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000058_0001__pkurp_pg-reservation_add_time_insert.sql
153DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000059_0002__pkurp_pg-reservation_migration_claim-assert.sql
154DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000059_0003__pkurp_pg-reservation_migration_claim-procs.sql
155DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000060_0001__pkurp_pg-attribute_ix_for_kua_object.sql
156DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000060_0002__pkurp_pg-attribute_ix_for_kua_object-function-wrapper.sql
157DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000061_0001__pkurp_pg-reservation-reserve_number_fix.sql
158DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000061_0002__pkurp_pg-reservation-reservation_constraint_fix.sql
159DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000062_0002__pkurp_pg-master-replica_shard_key_index-assert.sql
160DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000063_0002__pkurp_pg-attribute_indexer.sql
161DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000064_0002__pkurp_pg-master-replica-shard_atom_key_index_assert.sql
162DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000064_0003__pkurp_pg-master-replica-normalize_function.sql
163DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000064_0005__pkurp_pg-master-replica-shard_atom_key_index_function_assert.sql
164DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000064_0006__pkurp_pg-master-replica-normalize_cadnum_function.sql
165DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000064_0008__pkurp_pg-master-replica-cadastral_number_index_function_assert.sql
166DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/afterEachMigrate.sql
167DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/afterMigrate.sql
168DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/beforeEachMigrate.sql
169DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/beforeMigrate.sql
170DEBUG: Found statement at line 4: SET client_min_messages='ERROR'
171DEBUG: Found statement at line 5: DROP TRIGGER IF EXISTS tr_schema_version_auid ON version.schema_version
172DEBUG: Found statement at line 6: DROP TABLE IF EXISTS version.trf_schema_version_uid
173DEBUG: Found statement at line 7: RESET client_min_messages
174DEBUG: Found statement at line 4: SET client_min_messages='ERROR'
175DEBUG: Found statement at line 5: DROP TABLE IF EXISTS version.trf_schema_version_uid
176DEBUG: Found statement at line 6: RESET client_min_messages
177DEBUG: Found statement at line 4: CREATE TEMP TABLE flyway_conf AS SELECT '/opt/egron-db-pg-migration/sql/migration'::TEXT AS locations
178DEBUG: Found statement at line 10: CREATE OR REPLACE FUNCTION version.trf_schema_version_uid()
179 RETURNS TRIGGER AS
180$BODY$
181DECLARE
182 lT_url TEXT;
183 lT_url_error TEXT;
184BEGIN
185
186 BEGIN
187
188 IF EXISTS (SELECT 1 FROM pg_tables WHERE tablename = 'trf_schema_version_uid' AND schemaname = 'version') THEN
189
190 FOR lT_url IN SELECT url FROM version.trf_schema_version_uid LOOP
191
192 lT_url_error = lT_url;
193 IF TG_OP = 'INSERT' THEN
194 PERFORM dblink_connect(lT_url, lT_url);
195 PERFORM dblink_exec(lT_url, 'BEGIN');
196 PERFORM version.f_current_version(lT_url);
197 PERFORM dblink_exec(lT_url, FORMAT('INSERT INTO version.schema_version SELECT (''%1$s''::version.schema_version).*', NEW::TEXT));
198 ELSIF TG_OP = 'DELETE' THEN
199 ELSIF TG_OP = 'UPDATE' THEN
200 END IF;
201
202 END LOOP;
203 END IF;
204
205 EXCEPTION WHEN OTHERS THEN
206
207 --Обрабатываем иÑключение, еÑли обновление верÑии на каком-либо из узлов завершилоÑÑŒ Ñ Ð¾ÑˆÐ¸Ð±ÐºÐ¾Ð¹
208 IF array_length(dblink_get_connections(), 1) IS NOT NULL THEN
209 FOREACH lT_url in ARRAY dblink_get_connections() LOOP
210 PERFORM dblink_exec(lT_url, 'ROLLBACK;'); --откатываем транзакцию на каждом из узлов
211 PERFORM dblink_disconnect(lT_url); --закрываем ÑÐ¾ÐµÐ´Ð¸Ð½ÐµÐ½Ð¸Ñ Ñ ÑƒÐ·Ð»Ð°Ð¼Ð¸
212 END LOOP;
213 END IF;
214
215 RAISE EXCEPTION '%: %', lT_url_error, SQLERRM; --генерируем иÑключение <узел: ошибка>
216
217 END;
218
219 IF array_length(dblink_get_connections(), 1) IS NOT NULL THEN
220 FOREACH lT_url in ARRAY dblink_get_connections() LOOP
221 PERFORM dblink_exec(lT_url, 'COMMIT;'); --подтверждаем уÑпешные транзакции
222 PERFORM dblink_disconnect(lT_url); --закрываем ÑÐ¾ÐµÐ´Ð¸Ð½ÐµÐ½Ð¸Ñ Ñ ÑƒÐ·Ð»Ð°Ð¼Ð¸
223 END LOOP;
224 END IF;
225
226 RETURN NEW;
227END;
228$BODY$
229 LANGUAGE plpgsql VOLATILE SECURITY DEFINER
230DEBUG: Found statement at line 62: ALTER FUNCTION version.trf_schema_version_uid() OWNER TO CURRENT_USER
231DEBUG: Found statement at line 64: SET client_min_messages='ERROR'
232DEBUG: Found statement at line 65: DROP TRIGGER IF EXISTS tr_schema_version_auid ON version.schema_version
233DEBUG: Found statement at line 66: RESET client_min_messages
234DEBUG: Found statement at line 68: CREATE TRIGGER tr_schema_version_auid
235 AFTER INSERT OR DELETE OR UPDATE
236 ON version.schema_version
237 FOR EACH ROW
238 EXECUTE PROCEDURE version.trf_schema_version_uid()
239DEBUG: Validating migrations ...
240DEBUG: Scanning for filesystem resources at '/opt/egron-db-pg-migration/sql/migration' (Prefix: 'V', Suffix: '.sql')
241DEBUG: Scanning for resources in path: /opt/egron-db-pg-migration/sql/migration (/opt/egron-db-pg-migration/sql/migration)
242DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000001_0004__pkurp_pg-replica_index_record_section_number.sql.manual (filename: V000001_0004__pkurp_pg-replica_index_record_section_number.sql.manual)
243DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000005_0001__pkurp_pg-master_timestamp_columns.sql.manual (filename: V000005_0001__pkurp_pg-master_timestamp_columns.sql.manual)
244DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000014_0001__pkurp_pg-attribute_all_indexes.sql.manual (filename: V000014_0001__pkurp_pg-attribute_all_indexes.sql.manual)
245DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000015_0001__pkurp_pg-master_reindex_file_system_number.sql.manual (filename: V000015_0001__pkurp_pg-master_reindex_file_system_number.sql.manual)
246DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000018_0001__pkurp_pg-master_file_stat.sql.manual (filename: V000018_0001__pkurp_pg-master_file_stat.sql.manual)
247DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000019_0003__pkurp_pg-attribute_freeze_write_grants_to_api.sql.manual (filename: V000019_0003__pkurp_pg-attribute_freeze_write_grants_to_api.sql.manual)
248DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000020_0001__pkurp_pg-reservation_add_rg_as_external_system.sql.manual (filename: V000020_0001__pkurp_pg-reservation_add_rg_as_external_system.sql.manual)
249DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000022_0001__pkurp_pg-reservation_rg_type.sql.manual (filename: V000022_0001__pkurp_pg-reservation_rg_type.sql.manual)
250DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000056_0001__pkurp_pg-reservation-alter-type.sql.manual (filename: V000056_0001__pkurp_pg-reservation-alter-type.sql.manual)
251DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000059_0001__pkurp_pg-reservation_migration_claim.sql.manual (filename: V000059_0001__pkurp_pg-reservation_migration_claim.sql.manual)
252DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000062_0001__pkurp_pg-master-replica_shard_key_index.sql.manual (filename: V000062_0001__pkurp_pg-master-replica_shard_key_index.sql.manual)
253DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000063_0001__pkurp_pg-attribute_indexer.sql.manual (filename: V000063_0001__pkurp_pg-attribute_indexer.sql.manual)
254DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000064_0001__pkurp_pg-master-replica-shard_atom_key_index.sql.manual (filename: V000064_0001__pkurp_pg-master-replica-shard_atom_key_index.sql.manual)
255DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000064_0004__pkurp_pg-master-replica-shard_atom_key_index_function.sql.manual (filename: V000064_0004__pkurp_pg-master-replica-shard_atom_key_index_function.sql.manual)
256DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000064_0007__pkurp_pg-master-replica-cadastral_number_index_function.sql.manual (filename: V000064_0007__pkurp_pg-master-replica-cadastral_number_index_function.sql.manual)
257DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/afterEachMigrate.sql (filename: afterEachMigrate.sql)
258DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/afterMigrate.sql (filename: afterMigrate.sql)
259DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/beforeEachMigrate.sql (filename: beforeEachMigrate.sql)
260DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/beforeMigrate.sql (filename: beforeMigrate.sql)
261DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000001_0001__pkurp_pg-attribute_add_tables.sql
262DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000001_0002__pkurp_pg-attribute_add_cols_search_record.sql
263DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000001_0003__pkurp_pg-attribute_add_cols_record_section_number.sql
264DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000001_0004__pkurp_pg-replica_index_record_section_number.sql
265DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000001_0005__pkurp_pg-attribute_add_grants.sql
266DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000002_0001__pkurp_pg-attribute_add_books_tables.sql
267DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000003_0001__pkurp_pg-attribute_change_cols_type_varchar_to_text.sql
268DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000004_0001__pkurp_pg-reservation_external_locks.sql
269DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000005_0001__pkurp_pg-master_timestamp_columns.sql
270DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000005_0002__pkurp_pg-attribute_add_grants_for_sequences.sql
271DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000005_0003__pkurp_pg-attribute_add_grants_for_sequences_fixed.sql
272DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000007_0001__pkurp_pg-master_trigger_fix.sql
273DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000008_0001__pkurp_pg-master_add_view_about_all_db_size.sql
274DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000009_0001__pkurp_pg-attribute_add_col_for_address.sql
275DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000009_0002__pkurp_pg-attribute-right-registry-entities_update_new_attr_db.sql
276DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000009_0003__pkurp_pg-attribute_add_cols_address.sql
277DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000009_0004__pkurp_pg-master_add_view_about_all_db_activity.sql
278DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000010_0001__pkurp_pg-attribute-border_add_index_for_search_border.sql
279DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000010_0002__pkurp_pg-reservation_reservation-lock-check.sql
280DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000010_0003__pkurp_pg-reservation_reservation-fix.sql
281DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000011_0001__pkurp_pg-reservation-reservation_delete_duplicates.sql
282DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000011_0002__pkurp_pg-reservation-reservation_counter.sql
283DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000012_0001__pkurp_pg-replica_checks_for_V000001_0004.sql
284DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000013_0001__pkurp_pg-master_add_view_about_all_db_indexes.sql
285DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000014_0002__pkurp_pg-attribute_checks_for_all_indexes_V000014_0001.sql
286DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000015_0001__pkurp_pg-master_reindex_file_system_number.sql
287DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000016_0001__pkurp_pg-attribute_add_table.sql
288DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000016_0002__pkurp_pg-attribute_add_cols_for_search_kua_record_table.sql
289DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000016_0003__pkurp_pg-attribute_add_ix_for_search_kua_record_table_new_cols.sql
290DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000016_0004__pkurp_pg-attribute_add_grants_for_migration_sequence.sql
291DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000017_0001__pkurp_pg-attribute_drop_pmpp.sql
292DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000018_0001__pkurp_pg-master_file_stat.sql
293DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000018_0002__pkurp_pg-attribute-right-registry-entities_update_new_attr_db.sql
294DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000019_0001__pkurp_pg-reservation_freeze.sql
295DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000019_0002__pkurp_pg-master_freeze_write_grants_to_api.sql
296DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000019_0004__pkurp_pg-reservation_freeze_write_grants_to_api.sql
297DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000021_0001__pkurp_pg-attribute_drop_not_null_from_business_number.sql
298DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000022_0002__pkurp_pg-reservation_rg.sql
299DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000023_0001__pkurp_pg-master-replica_drop_not_null_from_cadastral_number.sql
300DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000024_0001__pkurp_pg-master-replica_right_records_stat.sql
301DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000025_0001__pkurp_pg-attribute_drop_pglogical.sql
302DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000026_0001__pkurp_pg-master-replica_right_records_stat_fix.sql
303DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000026_0002__pkurp_pg-master-replica_right_records_stat_fix_2.sql
304DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000027_0001__pkurp_pg-attribute_cadlink_search.sql
305DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000027_0002__pkurp_pg-attribute_cadlink_seq_grants.sql
306DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000028_0001__pkurp_pg-master-replica_right_record_fix_3.sql
307DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000028_0002__pkurp_pg-master-replica_api_write_permissions.sql
308DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000029_0001__pkurp_pg-attribute-books_kua_report.sql
309DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000030_0001__pkurp_pg-master_checks_for_timestamp_columns_V000005_0001.sql
310DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000031_0001__pkurp_pg-attribute-right-registry-entities_update_new_attr_db.sql
311DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000031_0002__pkurp_pg-attribute-80_update_new_attr_db.sql
312DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000031_0003__pkurp_pg-attribute-82_update_new_attr_db.sql
313DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000032_0001__pkurp_pg-map-reduce_attribute_tables.sql
314DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000033_0001__pkurp_pg-attribute_document_series_ix.sql
315DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000034_0001__pkurp_pg-reservation_right_record_counters.sql
316DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000035_0001__pkurp_pg-attribute_add_immutable_array-to-string_and_ix_on_address.sql
317DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000036_0001__pkurp_pg-reservation_right_record_counters-fix-1.sql
318DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000037_0001__pkurp_pg-reservation_borders_reservation.sql
319DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000038_0001__pkurp_pg-reservation_counters_check_connection.sql
320DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000039_0001__pkurp_pg-reservation_counters_check_fix.sql
321DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000040_0001__pkurp_pg-attribute_attributes_update.sql
322DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000040_0002__pkurp_pg-map-reduce_attributes_update.sql
323DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000041_0001__pkurp_pg-master_replace_view_about_all_db_size.sql
324DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000042_0001__pkurp_pg-all_add_pgstattuple.sql
325DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000042_0002__pkurp_pg-master_add_view_about_all_db_pgstattuple-approx.sql
326DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000042_0003__pkurp_pg-all_set_fillfactor_100_for_indices.sql
327DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000042_0004__pkurp_pg-master_add_view_about_all_db_bloat.sql
328DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000043_0001__pkurp_pg-master_add_view_about_all_db_schema_version_errors.sql
329DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000044_0001__pkurp_pg-attribute_add_note_for_address_and_ix_address.sql
330DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000044_0002__pkurp_pg-map-reduce_add_note_for_address.sql
331DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000045_0001__pkurp_pg-reservation_add_group-write_grants_on_frozen-section.sql
332DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000046_0001__pkurp_pg-attribute_pg-map-reduce_drop_record-unverified.sql
333DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000047_0001__pkurp_pg-attribute_attributes_update.sql
334DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000047_0002__pkurp_pg-map-reduce_attributes_update.sql
335DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000047_0003__pkurp_pg-attribute_attributes_serial.sql
336DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000047_0004__pkurp_pg-attribute_attributes_serial_grants.sql
337DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000047_0005__pkurp_pg-attribute_attributes_kua_tables.sql
338DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000047_0006__pkurp_pg-map-reduce_public_formation.sql
339DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000048_0001__pkurp_pg-reservation_reserve_number.sql
340DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000049_0001__pkurp_pg-attribute-delete-rights-on-attributes.sql
341DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000049_0002__pkurp_pg-attribute-add_fields_for_report.sql
342DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000049_0003__pkurp_pg-attribute-add_fields_for_report_2.sql
343DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000049_0004__pkurp_pg-attribute-borders_report.sql
344DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000050_0001__pkurp_pg-master_add_view_about_all_db_test_conn.sql
345DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000051_0001__pkurp_pg-map-reduce_sync_cols.sql
346DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000052_0001__pkurp_pg-reservation-migration_check.sql
347DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000052_0002__pkurp_pg-reservation-migration_check_fix.sql
348DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000053_0001__pkurp_pg-master_fix_view_about_all_db_bloat.sql
349DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000054_0001__pkurp_pg-reservation-froze_reserved_numbers.sql
350DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000055_0001__pkurp_pg-attribute-fix_books_kua_report.sql
351DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000055_0002__pkurp_pg-all_zabbix_mapping.sql
352DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000056_0002__pkurp_pg-reservation-alter-type-assert.sql
353DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000057_0001__pkurp_pg-reservation-migration.sql
354DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000058_0001__pkurp_pg-reservation_add_time_insert.sql
355DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000059_0002__pkurp_pg-reservation_migration_claim-assert.sql
356DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000059_0003__pkurp_pg-reservation_migration_claim-procs.sql
357DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000060_0001__pkurp_pg-attribute_ix_for_kua_object.sql
358DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000060_0002__pkurp_pg-attribute_ix_for_kua_object-function-wrapper.sql
359DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000061_0001__pkurp_pg-reservation-reserve_number_fix.sql
360DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000061_0002__pkurp_pg-reservation-reservation_constraint_fix.sql
361DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000062_0002__pkurp_pg-master-replica_shard_key_index-assert.sql
362DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000063_0002__pkurp_pg-attribute_indexer.sql
363DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000064_0002__pkurp_pg-master-replica-shard_atom_key_index_assert.sql
364DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000064_0003__pkurp_pg-master-replica-normalize_function.sql
365DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000064_0005__pkurp_pg-master-replica-shard_atom_key_index_function_assert.sql
366DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000064_0006__pkurp_pg-master-replica-normalize_cadnum_function.sql
367DEBUG: Found filesystem resource: /opt/egron-db-pg-migration/sql/migration/V000064_0008__pkurp_pg-master-replica-cadastral_number_index_function_assert.sql
368DEBUG: Scanning for filesystem resources at '/opt/egron-db-pg-migration/sql/migration' (Prefix: 'R', Suffix: '.sql')
369DEBUG: Scanning for resources in path: /opt/egron-db-pg-migration/sql/migration (/opt/egron-db-pg-migration/sql/migration)
370DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000001_0001__pkurp_pg-attribute_add_tables.sql (filename: V000001_0001__pkurp_pg-attribute_add_tables.sql)
371DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000001_0002__pkurp_pg-attribute_add_cols_search_record.sql (filename: V000001_0002__pkurp_pg-attribute_add_cols_search_record.sql)
372DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000001_0003__pkurp_pg-attribute_add_cols_record_section_number.sql (filename: V000001_0003__pkurp_pg-attribute_add_cols_record_section_number.sql)
373DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000001_0004__pkurp_pg-replica_index_record_section_number.sql (filename: V000001_0004__pkurp_pg-replica_index_record_section_number.sql)
374DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000001_0004__pkurp_pg-replica_index_record_section_number.sql.manual (filename: V000001_0004__pkurp_pg-replica_index_record_section_number.sql.manual)
375DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000001_0005__pkurp_pg-attribute_add_grants.sql (filename: V000001_0005__pkurp_pg-attribute_add_grants.sql)
376DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000002_0001__pkurp_pg-attribute_add_books_tables.sql (filename: V000002_0001__pkurp_pg-attribute_add_books_tables.sql)
377DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000003_0001__pkurp_pg-attribute_change_cols_type_varchar_to_text.sql (filename: V000003_0001__pkurp_pg-attribute_change_cols_type_varchar_to_text.sql)
378DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000004_0001__pkurp_pg-reservation_external_locks.sql (filename: V000004_0001__pkurp_pg-reservation_external_locks.sql)
379DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000005_0001__pkurp_pg-master_timestamp_columns.sql (filename: V000005_0001__pkurp_pg-master_timestamp_columns.sql)
380DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000005_0001__pkurp_pg-master_timestamp_columns.sql.manual (filename: V000005_0001__pkurp_pg-master_timestamp_columns.sql.manual)
381DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000005_0002__pkurp_pg-attribute_add_grants_for_sequences.sql (filename: V000005_0002__pkurp_pg-attribute_add_grants_for_sequences.sql)
382DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000005_0003__pkurp_pg-attribute_add_grants_for_sequences_fixed.sql (filename: V000005_0003__pkurp_pg-attribute_add_grants_for_sequences_fixed.sql)
383DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000007_0001__pkurp_pg-master_trigger_fix.sql (filename: V000007_0001__pkurp_pg-master_trigger_fix.sql)
384DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000008_0001__pkurp_pg-master_add_view_about_all_db_size.sql (filename: V000008_0001__pkurp_pg-master_add_view_about_all_db_size.sql)
385DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000009_0001__pkurp_pg-attribute_add_col_for_address.sql (filename: V000009_0001__pkurp_pg-attribute_add_col_for_address.sql)
386DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000009_0002__pkurp_pg-attribute-right-registry-entities_update_new_attr_db.sql (filename: V000009_0002__pkurp_pg-attribute-right-registry-entities_update_new_attr_db.sql)
387DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000009_0003__pkurp_pg-attribute_add_cols_address.sql (filename: V000009_0003__pkurp_pg-attribute_add_cols_address.sql)
388DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000009_0004__pkurp_pg-master_add_view_about_all_db_activity.sql (filename: V000009_0004__pkurp_pg-master_add_view_about_all_db_activity.sql)
389DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000010_0001__pkurp_pg-attribute-border_add_index_for_search_border.sql (filename: V000010_0001__pkurp_pg-attribute-border_add_index_for_search_border.sql)
390DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000010_0002__pkurp_pg-reservation_reservation-lock-check.sql (filename: V000010_0002__pkurp_pg-reservation_reservation-lock-check.sql)
391DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000010_0003__pkurp_pg-reservation_reservation-fix.sql (filename: V000010_0003__pkurp_pg-reservation_reservation-fix.sql)
392DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000011_0001__pkurp_pg-reservation-reservation_delete_duplicates.sql (filename: V000011_0001__pkurp_pg-reservation-reservation_delete_duplicates.sql)
393DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000011_0002__pkurp_pg-reservation-reservation_counter.sql (filename: V000011_0002__pkurp_pg-reservation-reservation_counter.sql)
394DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000012_0001__pkurp_pg-replica_checks_for_V000001_0004.sql (filename: V000012_0001__pkurp_pg-replica_checks_for_V000001_0004.sql)
395DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000013_0001__pkurp_pg-master_add_view_about_all_db_indexes.sql (filename: V000013_0001__pkurp_pg-master_add_view_about_all_db_indexes.sql)
396DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000014_0001__pkurp_pg-attribute_all_indexes.sql.manual (filename: V000014_0001__pkurp_pg-attribute_all_indexes.sql.manual)
397DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000014_0002__pkurp_pg-attribute_checks_for_all_indexes_V000014_0001.sql (filename: V000014_0002__pkurp_pg-attribute_checks_for_all_indexes_V000014_0001.sql)
398DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000015_0001__pkurp_pg-master_reindex_file_system_number.sql (filename: V000015_0001__pkurp_pg-master_reindex_file_system_number.sql)
399DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000015_0001__pkurp_pg-master_reindex_file_system_number.sql.manual (filename: V000015_0001__pkurp_pg-master_reindex_file_system_number.sql.manual)
400DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000016_0001__pkurp_pg-attribute_add_table.sql (filename: V000016_0001__pkurp_pg-attribute_add_table.sql)
401DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000016_0002__pkurp_pg-attribute_add_cols_for_search_kua_record_table.sql (filename: V000016_0002__pkurp_pg-attribute_add_cols_for_search_kua_record_table.sql)
402DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000016_0003__pkurp_pg-attribute_add_ix_for_search_kua_record_table_new_cols.sql (filename: V000016_0003__pkurp_pg-attribute_add_ix_for_search_kua_record_table_new_cols.sql)
403DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000016_0004__pkurp_pg-attribute_add_grants_for_migration_sequence.sql (filename: V000016_0004__pkurp_pg-attribute_add_grants_for_migration_sequence.sql)
404DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000017_0001__pkurp_pg-attribute_drop_pmpp.sql (filename: V000017_0001__pkurp_pg-attribute_drop_pmpp.sql)
405DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000018_0001__pkurp_pg-master_file_stat.sql (filename: V000018_0001__pkurp_pg-master_file_stat.sql)
406DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000018_0001__pkurp_pg-master_file_stat.sql.manual (filename: V000018_0001__pkurp_pg-master_file_stat.sql.manual)
407DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000018_0002__pkurp_pg-attribute-right-registry-entities_update_new_attr_db.sql (filename: V000018_0002__pkurp_pg-attribute-right-registry-entities_update_new_attr_db.sql)
408DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000019_0001__pkurp_pg-reservation_freeze.sql (filename: V000019_0001__pkurp_pg-reservation_freeze.sql)
409DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000019_0002__pkurp_pg-master_freeze_write_grants_to_api.sql (filename: V000019_0002__pkurp_pg-master_freeze_write_grants_to_api.sql)
410DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000019_0003__pkurp_pg-attribute_freeze_write_grants_to_api.sql.manual (filename: V000019_0003__pkurp_pg-attribute_freeze_write_grants_to_api.sql.manual)
411DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000019_0004__pkurp_pg-reservation_freeze_write_grants_to_api.sql (filename: V000019_0004__pkurp_pg-reservation_freeze_write_grants_to_api.sql)
412DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000020_0001__pkurp_pg-reservation_add_rg_as_external_system.sql.manual (filename: V000020_0001__pkurp_pg-reservation_add_rg_as_external_system.sql.manual)
413DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000021_0001__pkurp_pg-attribute_drop_not_null_from_business_number.sql (filename: V000021_0001__pkurp_pg-attribute_drop_not_null_from_business_number.sql)
414DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000022_0001__pkurp_pg-reservation_rg_type.sql.manual (filename: V000022_0001__pkurp_pg-reservation_rg_type.sql.manual)
415DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000022_0002__pkurp_pg-reservation_rg.sql (filename: V000022_0002__pkurp_pg-reservation_rg.sql)
416DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000023_0001__pkurp_pg-master-replica_drop_not_null_from_cadastral_number.sql (filename: V000023_0001__pkurp_pg-master-replica_drop_not_null_from_cadastral_number.sql)
417DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000024_0001__pkurp_pg-master-replica_right_records_stat.sql (filename: V000024_0001__pkurp_pg-master-replica_right_records_stat.sql)
418DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000025_0001__pkurp_pg-attribute_drop_pglogical.sql (filename: V000025_0001__pkurp_pg-attribute_drop_pglogical.sql)
419DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000026_0001__pkurp_pg-master-replica_right_records_stat_fix.sql (filename: V000026_0001__pkurp_pg-master-replica_right_records_stat_fix.sql)
420DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000026_0002__pkurp_pg-master-replica_right_records_stat_fix_2.sql (filename: V000026_0002__pkurp_pg-master-replica_right_records_stat_fix_2.sql)
421DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000027_0001__pkurp_pg-attribute_cadlink_search.sql (filename: V000027_0001__pkurp_pg-attribute_cadlink_search.sql)
422DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000027_0002__pkurp_pg-attribute_cadlink_seq_grants.sql (filename: V000027_0002__pkurp_pg-attribute_cadlink_seq_grants.sql)
423DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000028_0001__pkurp_pg-master-replica_right_record_fix_3.sql (filename: V000028_0001__pkurp_pg-master-replica_right_record_fix_3.sql)
424DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000028_0002__pkurp_pg-master-replica_api_write_permissions.sql (filename: V000028_0002__pkurp_pg-master-replica_api_write_permissions.sql)
425DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000029_0001__pkurp_pg-attribute-books_kua_report.sql (filename: V000029_0001__pkurp_pg-attribute-books_kua_report.sql)
426DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000030_0001__pkurp_pg-master_checks_for_timestamp_columns_V000005_0001.sql (filename: V000030_0001__pkurp_pg-master_checks_for_timestamp_columns_V000005_0001.sql)
427DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000031_0001__pkurp_pg-attribute-right-registry-entities_update_new_attr_db.sql (filename: V000031_0001__pkurp_pg-attribute-right-registry-entities_update_new_attr_db.sql)
428DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000031_0002__pkurp_pg-attribute-80_update_new_attr_db.sql (filename: V000031_0002__pkurp_pg-attribute-80_update_new_attr_db.sql)
429DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000031_0003__pkurp_pg-attribute-82_update_new_attr_db.sql (filename: V000031_0003__pkurp_pg-attribute-82_update_new_attr_db.sql)
430DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000032_0001__pkurp_pg-map-reduce_attribute_tables.sql (filename: V000032_0001__pkurp_pg-map-reduce_attribute_tables.sql)
431DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000033_0001__pkurp_pg-attribute_document_series_ix.sql (filename: V000033_0001__pkurp_pg-attribute_document_series_ix.sql)
432DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000034_0001__pkurp_pg-reservation_right_record_counters.sql (filename: V000034_0001__pkurp_pg-reservation_right_record_counters.sql)
433DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000035_0001__pkurp_pg-attribute_add_immutable_array-to-string_and_ix_on_address.sql (filename: V000035_0001__pkurp_pg-attribute_add_immutable_array-to-string_and_ix_on_address.sql)
434DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000036_0001__pkurp_pg-reservation_right_record_counters-fix-1.sql (filename: V000036_0001__pkurp_pg-reservation_right_record_counters-fix-1.sql)
435DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000037_0001__pkurp_pg-reservation_borders_reservation.sql (filename: V000037_0001__pkurp_pg-reservation_borders_reservation.sql)
436DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000038_0001__pkurp_pg-reservation_counters_check_connection.sql (filename: V000038_0001__pkurp_pg-reservation_counters_check_connection.sql)
437DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000039_0001__pkurp_pg-reservation_counters_check_fix.sql (filename: V000039_0001__pkurp_pg-reservation_counters_check_fix.sql)
438DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000040_0001__pkurp_pg-attribute_attributes_update.sql (filename: V000040_0001__pkurp_pg-attribute_attributes_update.sql)
439DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000040_0002__pkurp_pg-map-reduce_attributes_update.sql (filename: V000040_0002__pkurp_pg-map-reduce_attributes_update.sql)
440DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000041_0001__pkurp_pg-master_replace_view_about_all_db_size.sql (filename: V000041_0001__pkurp_pg-master_replace_view_about_all_db_size.sql)
441DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000042_0001__pkurp_pg-all_add_pgstattuple.sql (filename: V000042_0001__pkurp_pg-all_add_pgstattuple.sql)
442DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000042_0002__pkurp_pg-master_add_view_about_all_db_pgstattuple-approx.sql (filename: V000042_0002__pkurp_pg-master_add_view_about_all_db_pgstattuple-approx.sql)
443DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000042_0003__pkurp_pg-all_set_fillfactor_100_for_indices.sql (filename: V000042_0003__pkurp_pg-all_set_fillfactor_100_for_indices.sql)
444DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000042_0004__pkurp_pg-master_add_view_about_all_db_bloat.sql (filename: V000042_0004__pkurp_pg-master_add_view_about_all_db_bloat.sql)
445DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000043_0001__pkurp_pg-master_add_view_about_all_db_schema_version_errors.sql (filename: V000043_0001__pkurp_pg-master_add_view_about_all_db_schema_version_errors.sql)
446DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000044_0001__pkurp_pg-attribute_add_note_for_address_and_ix_address.sql (filename: V000044_0001__pkurp_pg-attribute_add_note_for_address_and_ix_address.sql)
447DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000044_0002__pkurp_pg-map-reduce_add_note_for_address.sql (filename: V000044_0002__pkurp_pg-map-reduce_add_note_for_address.sql)
448DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000045_0001__pkurp_pg-reservation_add_group-write_grants_on_frozen-section.sql (filename: V000045_0001__pkurp_pg-reservation_add_group-write_grants_on_frozen-section.sql)
449DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000046_0001__pkurp_pg-attribute_pg-map-reduce_drop_record-unverified.sql (filename: V000046_0001__pkurp_pg-attribute_pg-map-reduce_drop_record-unverified.sql)
450DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000047_0001__pkurp_pg-attribute_attributes_update.sql (filename: V000047_0001__pkurp_pg-attribute_attributes_update.sql)
451DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000047_0002__pkurp_pg-map-reduce_attributes_update.sql (filename: V000047_0002__pkurp_pg-map-reduce_attributes_update.sql)
452DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000047_0003__pkurp_pg-attribute_attributes_serial.sql (filename: V000047_0003__pkurp_pg-attribute_attributes_serial.sql)
453DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000047_0004__pkurp_pg-attribute_attributes_serial_grants.sql (filename: V000047_0004__pkurp_pg-attribute_attributes_serial_grants.sql)
454DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000047_0005__pkurp_pg-attribute_attributes_kua_tables.sql (filename: V000047_0005__pkurp_pg-attribute_attributes_kua_tables.sql)
455DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000047_0006__pkurp_pg-map-reduce_public_formation.sql (filename: V000047_0006__pkurp_pg-map-reduce_public_formation.sql)
456DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000048_0001__pkurp_pg-reservation_reserve_number.sql (filename: V000048_0001__pkurp_pg-reservation_reserve_number.sql)
457DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000049_0001__pkurp_pg-attribute-delete-rights-on-attributes.sql (filename: V000049_0001__pkurp_pg-attribute-delete-rights-on-attributes.sql)
458DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000049_0002__pkurp_pg-attribute-add_fields_for_report.sql (filename: V000049_0002__pkurp_pg-attribute-add_fields_for_report.sql)
459DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000049_0003__pkurp_pg-attribute-add_fields_for_report_2.sql (filename: V000049_0003__pkurp_pg-attribute-add_fields_for_report_2.sql)
460DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000049_0004__pkurp_pg-attribute-borders_report.sql (filename: V000049_0004__pkurp_pg-attribute-borders_report.sql)
461DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000050_0001__pkurp_pg-master_add_view_about_all_db_test_conn.sql (filename: V000050_0001__pkurp_pg-master_add_view_about_all_db_test_conn.sql)
462DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000051_0001__pkurp_pg-map-reduce_sync_cols.sql (filename: V000051_0001__pkurp_pg-map-reduce_sync_cols.sql)
463DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000052_0001__pkurp_pg-reservation-migration_check.sql (filename: V000052_0001__pkurp_pg-reservation-migration_check.sql)
464DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000052_0002__pkurp_pg-reservation-migration_check_fix.sql (filename: V000052_0002__pkurp_pg-reservation-migration_check_fix.sql)
465DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000053_0001__pkurp_pg-master_fix_view_about_all_db_bloat.sql (filename: V000053_0001__pkurp_pg-master_fix_view_about_all_db_bloat.sql)
466DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000054_0001__pkurp_pg-reservation-froze_reserved_numbers.sql (filename: V000054_0001__pkurp_pg-reservation-froze_reserved_numbers.sql)
467DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000055_0001__pkurp_pg-attribute-fix_books_kua_report.sql (filename: V000055_0001__pkurp_pg-attribute-fix_books_kua_report.sql)
468DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000055_0002__pkurp_pg-all_zabbix_mapping.sql (filename: V000055_0002__pkurp_pg-all_zabbix_mapping.sql)
469DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000056_0001__pkurp_pg-reservation-alter-type.sql.manual (filename: V000056_0001__pkurp_pg-reservation-alter-type.sql.manual)
470DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000056_0002__pkurp_pg-reservation-alter-type-assert.sql (filename: V000056_0002__pkurp_pg-reservation-alter-type-assert.sql)
471DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000057_0001__pkurp_pg-reservation-migration.sql (filename: V000057_0001__pkurp_pg-reservation-migration.sql)
472DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000058_0001__pkurp_pg-reservation_add_time_insert.sql (filename: V000058_0001__pkurp_pg-reservation_add_time_insert.sql)
473DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000059_0001__pkurp_pg-reservation_migration_claim.sql.manual (filename: V000059_0001__pkurp_pg-reservation_migration_claim.sql.manual)
474DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000059_0002__pkurp_pg-reservation_migration_claim-assert.sql (filename: V000059_0002__pkurp_pg-reservation_migration_claim-assert.sql)
475DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000059_0003__pkurp_pg-reservation_migration_claim-procs.sql (filename: V000059_0003__pkurp_pg-reservation_migration_claim-procs.sql)
476DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000060_0001__pkurp_pg-attribute_ix_for_kua_object.sql (filename: V000060_0001__pkurp_pg-attribute_ix_for_kua_object.sql)
477DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000060_0002__pkurp_pg-attribute_ix_for_kua_object-function-wrapper.sql (filename: V000060_0002__pkurp_pg-attribute_ix_for_kua_object-function-wrapper.sql)
478DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000061_0001__pkurp_pg-reservation-reserve_number_fix.sql (filename: V000061_0001__pkurp_pg-reservation-reserve_number_fix.sql)
479DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000061_0002__pkurp_pg-reservation-reservation_constraint_fix.sql (filename: V000061_0002__pkurp_pg-reservation-reservation_constraint_fix.sql)
480DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000062_0001__pkurp_pg-master-replica_shard_key_index.sql.manual (filename: V000062_0001__pkurp_pg-master-replica_shard_key_index.sql.manual)
481DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000062_0002__pkurp_pg-master-replica_shard_key_index-assert.sql (filename: V000062_0002__pkurp_pg-master-replica_shard_key_index-assert.sql)
482DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000063_0001__pkurp_pg-attribute_indexer.sql.manual (filename: V000063_0001__pkurp_pg-attribute_indexer.sql.manual)
483DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000063_0002__pkurp_pg-attribute_indexer.sql (filename: V000063_0002__pkurp_pg-attribute_indexer.sql)
484DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000064_0001__pkurp_pg-master-replica-shard_atom_key_index.sql.manual (filename: V000064_0001__pkurp_pg-master-replica-shard_atom_key_index.sql.manual)
485DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000064_0002__pkurp_pg-master-replica-shard_atom_key_index_assert.sql (filename: V000064_0002__pkurp_pg-master-replica-shard_atom_key_index_assert.sql)
486DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000064_0003__pkurp_pg-master-replica-normalize_function.sql (filename: V000064_0003__pkurp_pg-master-replica-normalize_function.sql)
487DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000064_0004__pkurp_pg-master-replica-shard_atom_key_index_function.sql.manual (filename: V000064_0004__pkurp_pg-master-replica-shard_atom_key_index_function.sql.manual)
488DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000064_0005__pkurp_pg-master-replica-shard_atom_key_index_function_assert.sql (filename: V000064_0005__pkurp_pg-master-replica-shard_atom_key_index_function_assert.sql)
489DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000064_0006__pkurp_pg-master-replica-normalize_cadnum_function.sql (filename: V000064_0006__pkurp_pg-master-replica-normalize_cadnum_function.sql)
490DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000064_0007__pkurp_pg-master-replica-cadastral_number_index_function.sql.manual (filename: V000064_0007__pkurp_pg-master-replica-cadastral_number_index_function.sql.manual)
491DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/V000064_0008__pkurp_pg-master-replica-cadastral_number_index_function_assert.sql (filename: V000064_0008__pkurp_pg-master-replica-cadastral_number_index_function_assert.sql)
492DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/afterEachMigrate.sql (filename: afterEachMigrate.sql)
493DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/afterMigrate.sql (filename: afterMigrate.sql)
494DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/beforeEachMigrate.sql (filename: beforeEachMigrate.sql)
495DEBUG: Filtering out resource: /opt/egron-db-pg-migration/sql/migration/beforeMigrate.sql (filename: beforeMigrate.sql)
496Successfully validated 108 migrations (execution time 00:00.119s)
497DEBUG: Schema "version" already exists. Skipping schema creation.
498Executing SQL callback: beforeMigrate
499DEBUG: Executing SQL: CREATE TEMP TABLE flyway_conf AS SELECT '/opt/egron-db-pg-migration/sql/migration'::TEXT AS locations
500DEBUG: Update Count: 0
501DEBUG: Executing SQL: CREATE OR REPLACE FUNCTION version.trf_schema_version_uid()
502 RETURNS TRIGGER AS
503$BODY$
504DECLARE
505 lT_url TEXT;
506 lT_url_error TEXT;
507BEGIN
508
509 BEGIN
510
511 IF EXISTS (SELECT 1 FROM pg_tables WHERE tablename = 'trf_schema_version_uid' AND schemaname = 'version') THEN
512
513 FOR lT_url IN SELECT url FROM version.trf_schema_version_uid LOOP
514
515 lT_url_error = lT_url;
516 IF TG_OP = 'INSERT' THEN
517 PERFORM dblink_connect(lT_url, lT_url);
518 PERFORM dblink_exec(lT_url, 'BEGIN');
519 PERFORM version.f_current_version(lT_url);
520 PERFORM dblink_exec(lT_url, FORMAT('INSERT INTO version.schema_version SELECT (''%1$s''::version.schema_version).*', NEW::TEXT));
521 ELSIF TG_OP = 'DELETE' THEN
522 ELSIF TG_OP = 'UPDATE' THEN
523 END IF;
524
525 END LOOP;
526 END IF;
527
528 EXCEPTION WHEN OTHERS THEN
529
530 --Обрабатываем иÑключение, еÑли обновление верÑии на каком-либо из узлов завершилоÑÑŒ Ñ Ð¾ÑˆÐ¸Ð±ÐºÐ¾Ð¹
531 IF array_length(dblink_get_connections(), 1) IS NOT NULL THEN
532 FOREACH lT_url in ARRAY dblink_get_connections() LOOP
533 PERFORM dblink_exec(lT_url, 'ROLLBACK;'); --откатываем транзакцию на каждом из узлов
534 PERFORM dblink_disconnect(lT_url); --закрываем ÑÐ¾ÐµÐ´Ð¸Ð½ÐµÐ½Ð¸Ñ Ñ ÑƒÐ·Ð»Ð°Ð¼Ð¸
535 END LOOP;
536 END IF;
537
538 RAISE EXCEPTION '%: %', lT_url_error, SQLERRM; --генерируем иÑключение <узел: ошибка>
539
540 END;
541
542 IF array_length(dblink_get_connections(), 1) IS NOT NULL THEN
543 FOREACH lT_url in ARRAY dblink_get_connections() LOOP
544 PERFORM dblink_exec(lT_url, 'COMMIT;'); --подтверждаем уÑпешные транзакции
545 PERFORM dblink_disconnect(lT_url); --закрываем ÑÐ¾ÐµÐ´Ð¸Ð½ÐµÐ½Ð¸Ñ Ñ ÑƒÐ·Ð»Ð°Ð¼Ð¸
546 END LOOP;
547 END IF;
548
549 RETURN NEW;
550END;
551$BODY$
552 LANGUAGE plpgsql VOLATILE SECURITY DEFINER
553DEBUG: Update Count: 0
554DEBUG: Executing SQL: ALTER FUNCTION version.trf_schema_version_uid() OWNER TO CURRENT_USER
555DEBUG: Update Count: 0
556DEBUG: Executing SQL: SET client_min_messages='ERROR'
557DEBUG: Update Count: 0
558DEBUG: Executing SQL: DROP TRIGGER IF EXISTS tr_schema_version_auid ON version.schema_version
559DEBUG: Update Count: 0
560DEBUG: Executing SQL: RESET client_min_messages
561DEBUG: Update Count: 0
562DEBUG: Executing SQL: CREATE TRIGGER tr_schema_version_auid
563 AFTER INSERT OR DELETE OR UPDATE
564 ON version.schema_version
565 FOR EACH ROW
566 EXECUTE PROCEDURE version.trf_schema_version_uid()
567DEBUG: Update Count: 0
568DEBUG: Locking table "version"."schema_version"...
569DEBUG: Lock acquired for table "version"."schema_version"
570Current version of schema "version": 0
571Migrating schema "version" to version 000001.0001 - pg-attribute add tables
572Executing SQL callback: beforeEachMigrate
573DEBUG: Executing SQL: SET client_min_messages='ERROR'
574DEBUG: Update Count: 0
575DEBUG: Executing SQL: DROP TABLE IF EXISTS version.trf_schema_version_uid
576DEBUG: Update Count: 0
577DEBUG: Executing SQL: RESET client_min_messages
578DEBUG: Update Count: 0
579DEBUG: Found statement at line 1: SELECT array_agg(fsexec.foreign_server_name::TEXT) as foreign_server_name,
580 version.f_sql_distribute(json_object(array_agg(fs.foreign_server_name::text), array_agg(fsexec.foreign_server_name IS NOT NULL)::TEXT[]),
581$SQL$
582
583CREATE TABLE public.family_member (
584 id BIGSERIAL PRIMARY KEY,
585 file_id BIGINT NOT NULL,
586 surname VARCHAR(255),
587 name VARCHAR(255),
588 patronymic VARCHAR(255)
589);
590
591CREATE INDEX ON public.family_member (file_id);
592CREATE INDEX ON public.family_member (lower(surname) varchar_pattern_ops);
593CREATE INDEX ON public.family_member (lower(name) varchar_pattern_ops);
594CREATE INDEX ON public.family_member (lower(patronymic) varchar_pattern_ops);
595
596CREATE TABLE public.incapacity (
597 id BIGSERIAL PRIMARY KEY,
598 file_id BIGINT NOT NULL,
599 court_name VARCHAR(255)
600);
601
602CREATE INDEX ON public.incapacity (file_id);
603CREATE INDEX ON public.incapacity (lower(court_name) varchar_pattern_ops);
604
605$SQL$) AS res
606
607 FROM information_schema.foreign_servers fs
608 LEFT JOIN information_schema.foreign_servers fsexec ON fs.foreign_server_name = fsexec.foreign_server_name AND
609 fsexec.foreign_server_name like '%attribute%'
610 WHERE fs.foreign_server_name like '%pg-%'
611DEBUG: Executing SQL: SELECT array_agg(fsexec.foreign_server_name::TEXT) as foreign_server_name,
612 version.f_sql_distribute(json_object(array_agg(fs.foreign_server_name::text), array_agg(fsexec.foreign_server_name IS NOT NULL)::TEXT[]),
613$SQL$
614
615CREATE TABLE public.family_member (
616 id BIGSERIAL PRIMARY KEY,
617 file_id BIGINT NOT NULL,
618 surname VARCHAR(255),
619 name VARCHAR(255),
620 patronymic VARCHAR(255)
621);
622
623CREATE INDEX ON public.family_member (file_id);
624CREATE INDEX ON public.family_member (lower(surname) varchar_pattern_ops);
625CREATE INDEX ON public.family_member (lower(name) varchar_pattern_ops);
626CREATE INDEX ON public.family_member (lower(patronymic) varchar_pattern_ops);
627
628CREATE TABLE public.incapacity (
629 id BIGSERIAL PRIMARY KEY,
630 file_id BIGINT NOT NULL,
631 court_name VARCHAR(255)
632);
633
634CREATE INDEX ON public.incapacity (file_id);
635CREATE INDEX ON public.incapacity (lower(court_name) varchar_pattern_ops);
636
637$SQL$) AS res
638
639 FROM information_schema.foreign_servers fs
640 LEFT JOIN information_schema.foreign_servers fsexec ON fs.foreign_server_name = fsexec.foreign_server_name AND
641 fsexec.foreign_server_name like '%attribute%'
642 WHERE fs.foreign_server_name like '%pg-%'
643DEBUG: Rolling back transaction...
644DEBUG: Transaction rolled back
645ERROR: Migration of schema "version" to version 000001.0001 - pg-attribute add tables failed! Changes successfully rolled back.
646ERROR: Unexpected error
647org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
648Migration V000001_0001__pkurp_pg-attribute_add_tables.sql failed
649----------------------------------------------------------------
650SQL State : 22004
651Error Code : 0
652Message : ERROR: FOREACH expression must not be null
653 Где: PL/pgSQL function f_sql_distribute(json,text,boolean) line 123 at FOREACH over array
654Location : /opt/egron-db-pg-migration/sql/migration/V000001_0001__pkurp_pg-attribute_add_tables.sql (/opt/egron-db-pg-migration/sql/migration/V000001_0001__pkurp_pg-attribute_add_tables.sql)
655Line : 1
656Statement : SELECT array_agg(fsexec.foreign_server_name::TEXT) as foreign_server_name,
657 version.f_sql_distribute(json_object(array_agg(fs.foreign_server_name::text), array_agg(fsexec.foreign_server_name IS NOT NULL)::TEXT[]),
658$SQL$
659
660CREATE TABLE public.family_member (
661 id BIGSERIAL PRIMARY KEY,
662 file_id BIGINT NOT NULL,
663 surname VARCHAR(255),
664 name VARCHAR(255),
665 patronymic VARCHAR(255)
666);
667
668CREATE INDEX ON public.family_member (file_id);
669CREATE INDEX ON public.family_member (lower(surname) varchar_pattern_ops);
670CREATE INDEX ON public.family_member (lower(name) varchar_pattern_ops);
671CREATE INDEX ON public.family_member (lower(patronymic) varchar_pattern_ops);
672
673CREATE TABLE public.incapacity (
674 id BIGSERIAL PRIMARY KEY,
675 file_id BIGINT NOT NULL,
676 court_name VARCHAR(255)
677);
678
679CREATE INDEX ON public.incapacity (file_id);
680CREATE INDEX ON public.incapacity (lower(court_name) varchar_pattern_ops);
681
682$SQL$) AS res
683
684 FROM information_schema.foreign_servers fs
685 LEFT JOIN information_schema.foreign_servers fsexec ON fs.foreign_server_name = fsexec.foreign_server_name AND
686 fsexec.foreign_server_name like '%attribute%'
687 WHERE fs.foreign_server_name like '%pg-%'
688
689 at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:117)
690 at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:71)
691 at org.flywaydb.core.internal.command.DbMigrate.doMigrate(DbMigrate.java:352)
692 at org.flywaydb.core.internal.command.DbMigrate.access$1100(DbMigrate.java:47)
693 at org.flywaydb.core.internal.command.DbMigrate$4.doInTransaction(DbMigrate.java:308)
694 at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
695 at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:305)
696 at org.flywaydb.core.internal.command.DbMigrate.access$1000(DbMigrate.java:47)
697 at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:230)
698 at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:173)
699 at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
700 at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:173)
701 at org.flywaydb.core.Flyway$1.execute(Flyway.java:959)
702 at org.flywaydb.core.Flyway$1.execute(Flyway.java:917)
703 at org.flywaydb.core.Flyway.execute(Flyway.java:1373)
704 at org.flywaydb.core.Flyway.migrate(Flyway.java:917)
705 at org.flywaydb.commandline.Main.executeOperation(Main.java:139)
706 at org.flywaydb.commandline.Main.main(Main.java:102)
707Caused by: org.postgresql.util.PSQLException: ERROR: FOREACH expression must not be null
708 Где: PL/pgSQL function f_sql_distribute(json,text,boolean) line 123 at FOREACH over array
709 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2284)
710 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2003)
711 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:200)
712 at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424)
713 at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:321)
714 at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:313)
715 at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:238)
716 at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:114)
717 ... 17 more