# Checking port 26181 # Found port 26181 Name: primary Data directory: /tmp/cirrus-ci-build/src/test/recovery/tmp_check/t_027_stream_regress_primary_data/pgdata Backup directory: /tmp/cirrus-ci-build/src/test/recovery/tmp_check/t_027_stream_regress_primary_data/backup Archive directory: /tmp/cirrus-ci-build/src/test/recovery/tmp_check/t_027_stream_regress_primary_data/archives Connection string: port=26181 host=/tmp/M2d4d6kaJ4 Log file: /tmp/cirrus-ci-build/src/test/recovery/tmp_check/log/027_stream_regress_primary.log [17:19:52.380](0.021s) # initializing database system by copying initdb template # Running: cp -RPp /tmp/cirrus-ci-build/tmp_install/initdb-template /tmp/cirrus-ci-build/src/test/recovery/tmp_check/t_027_stream_regress_primary_data/pgdata # Running: /tmp/cirrus-ci-build/src/test/recovery/../../../src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/src/test/recovery/tmp_check/t_027_stream_regress_primary_data/pgdata ### Starting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/recovery/tmp_check/t_027_stream_regress_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/recovery/tmp_check/log/027_stream_regress_primary.log -o --cluster-name=primary start waiting for server to start.... done server started # Postmaster PID for node "primary" is 45444 (standby_1,) [17:19:52.701](0.321s) ok 1 - physical slot created on primary # Taking pg_basebackup my_backup from node "primary" # Running: pg_basebackup -D /tmp/cirrus-ci-build/src/test/recovery/tmp_check/t_027_stream_regress_primary_data/backup/my_backup -h /tmp/M2d4d6kaJ4 -p 26181 --checkpoint fast --no-sync # Backup finished # Checking port 26182 # Found port 26182 Name: standby_1 Data directory: /tmp/cirrus-ci-build/src/test/recovery/tmp_check/t_027_stream_regress_standby_1_data/pgdata Backup directory: /tmp/cirrus-ci-build/src/test/recovery/tmp_check/t_027_stream_regress_standby_1_data/backup Archive directory: /tmp/cirrus-ci-build/src/test/recovery/tmp_check/t_027_stream_regress_standby_1_data/archives Connection string: port=26182 host=/tmp/M2d4d6kaJ4 Log file: /tmp/cirrus-ci-build/src/test/recovery/tmp_check/log/027_stream_regress_standby_1.log # Initializing node "standby_1" from backup "my_backup" of node "primary" ### Enabling streaming replication for node "standby_1" ### Starting node "standby_1" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/recovery/tmp_check/t_027_stream_regress_standby_1_data/pgdata -l /tmp/cirrus-ci-build/src/test/recovery/tmp_check/log/027_stream_regress_standby_1.log -o --cluster-name=standby_1 start waiting for server to start.... done server started # Postmaster PID for node "standby_1" is 45527 # using postmaster on /tmp/M2d4d6kaJ4, port 26181 ok 1 - test_setup 507 ms # parallel group (20 tests): name pg_lsn uuid varchar text int2 oid char txid int4 regproc int8 money float4 float8 enum boolean bit numeric rangetypes ok 2 + boolean 756 ms ok 3 + char 304 ms ok 4 + name 202 ms ok 5 + varchar 258 ms ok 6 + text 271 ms ok 7 + int2 285 ms ok 8 + int4 344 ms ok 9 + int8 404 ms ok 10 + oid 295 ms ok 11 + float4 414 ms ok 12 + float8 480 ms ok 13 + bit 766 ms ok 14 + numeric 1332 ms ok 15 + txid 321 ms ok 16 + uuid 235 ms ok 17 + enum 589 ms ok 18 + money 394 ms ok 19 + rangetypes 1620 ms ok 20 + pg_lsn 215 ms ok 21 + regproc 372 ms # parallel group (20 tests): lseg line path time circle md5 timetz macaddr date numerology macaddr8 inet timestamp interval point strings timestamptz polygon box multirangetypes ok 22 + strings 882 ms ok 23 + md5 301 ms ok 24 + numerology 457 ms ok 25 + point 852 ms ok 26 + lseg 160 ms ok 27 + line 185 ms ok 28 + box 1715 ms ok 29 + path 216 ms ok 30 + polygon 1460 ms ok 31 + circle 274 ms ok 32 + date 428 ms ok 33 + time 254 ms ok 34 + timetz 322 ms ok 35 + timestamp 681 ms ok 36 + timestamptz 970 ms ok 37 + interval 770 ms ok 38 + inet 569 ms ok 39 + macaddr 420 ms ok 40 + macaddr8 448 ms ok 41 + multirangetypes 1855 ms # parallel group (13 tests): comments unicode misc_sanity xid tstypes expressions mvcc geometry type_sanity regex database horology opr_sanity ok 42 + geometry 683 ms ok 43 + horology 956 ms ok 44 + tstypes 382 ms ok 45 + regex 791 ms ok 46 + type_sanity 717 ms ok 47 + opr_sanity 1216 ms ok 48 + misc_sanity 212 ms ok 49 + comments 93 ms ok 50 + expressions 478 ms ok 51 + unicode 137 ms ok 52 + xid 321 ms ok 53 + mvcc 493 ms ok 54 + database 833 ms # parallel group (5 tests): copydml copyselect copy insert_conflict insert ok 55 + copy 355 ms ok 56 + copyselect 113 ms ok 57 + copydml 85 ms ok 58 + insert 1105 ms ok 59 + insert_conflict 545 ms # parallel group (7 tests): create_function_c create_operator create_type create_schema create_misc create_procedure create_table ok 60 + create_function_c 86 ms ok 61 + create_misc 249 ms ok 62 + create_operator 143 ms ok 63 + create_procedure 248 ms ok 64 + create_table 1028 ms ok 65 + create_type 192 ms ok 66 + create_schema 207 ms # parallel group (5 tests): index_including index_including_gist create_view create_index_spgist create_index ok 67 + create_index 2542 ms ok 68 + create_index_spgist 2225 ms ok 69 + create_view 1451 ms ok 70 + index_including 889 ms ok 71 + index_including_gist 971 ms # parallel group (16 tests): create_cast errors roleattributes hash_func create_aggregate drop_if_exists create_function_sql typed_table create_am select infinite_recurse constraints vacuum updatable_views inherit triggers ok 72 + create_aggregate 479 ms ok 73 + create_function_sql 932 ms ok 74 + create_cast 186 ms ok 75 + constraints 1325 ms ok 76 + triggers 3783 ms ok 77 + select 1068 ms ok 78 + inherit 2762 ms ok 79 + typed_table 935 ms ok 80 + vacuum 1717 ms ok 81 + drop_if_exists 477 ms ok 82 + updatable_views 2329 ms ok 83 + roleattributes 297 ms ok 84 + create_am 1056 ms ok 85 + hash_func 392 ms ok 86 + errors 288 ms ok 87 + infinite_recurse 1162 ms ok 88 - sanity_check 256 ms # parallel group (20 tests): select_distinct_on delete select_having case select_into select_implicit namespace random prepared_xacts transactions portals select_distinct arrays hash_index update union subselect btree_index aggregates join ok 89 + select_into 554 ms ok 90 + select_distinct 1148 ms ok 91 + select_distinct_on 257 ms ok 92 + select_implicit 572 ms ok 93 + select_having 330 ms not ok 94 + subselect 2448 ms ok 95 + union 2324 ms ok 96 + case 504 ms not ok 97 + join 4116 ms not ok 98 + aggregates 4091 ms ok 99 + transactions 1091 ms ok 100 + random 705 ms ok 101 + portals 1121 ms ok 102 + arrays 1394 ms ok 103 + btree_index 3604 ms ok 104 + hash_index 1969 ms ok 105 + update 2097 ms ok 106 + delete 279 ms ok 107 + namespace 589 ms ok 108 + prepared_xacts 739 ms # parallel group (20 tests): init_privs drop_operator security_label lock tablesample object_address password replica_identity collate matview identity spgist groupingsets generated gist rowsecurity gin join_hash brin privileges ok 109 + brin 11289 ms ok 110 + gin 4841 ms ok 111 + gist 4449 ms ok 112 + spgist 3839 ms ok 113 + privileges 12026 ms ok 114 + init_privs 155 ms ok 115 + security_label 575 ms ok 116 + collate 2314 ms ok 117 + matview 3377 ms ok 118 + lock 784 ms ok 119 + replica_identity 1480 ms ok 120 + rowsecurity 4599 ms ok 121 + object_address 1292 ms ok 122 + tablesample 827 ms ok 123 + groupingsets 4042 ms ok 124 + drop_operator 422 ms ok 125 + password 1419 ms ok 126 + identity 3419 ms ok 127 + generated 4320 ms ok 128 + join_hash 11252 ms # parallel group (2 tests): brin_bloom brin_multi ok 129 + brin_bloom 211 ms ok 130 + brin_multi 1096 ms # parallel group (17 tests): async dbsize collate.utf8 tid alter_operator tidscan tsrf create_role sysviews misc_functions alter_generic tidrangescan incremental_sort merge create_table_like misc collate.icu.utf8 ok 131 + create_table_like 1653 ms ok 132 + alter_generic 765 ms ok 133 + alter_operator 398 ms ok 134 + misc 1728 ms ok 135 + async 114 ms ok 136 + dbsize 128 ms ok 137 + merge 1556 ms ok 138 + misc_functions 709 ms ok 139 + sysviews 585 ms ok 140 + tsrf 457 ms ok 141 + tid 335 ms ok 142 + tidscan 429 ms ok 143 + tidrangescan 936 ms ok 144 + collate.utf8 185 ms ok 145 + collate.icu.utf8 1996 ms ok 146 + incremental_sort 1292 ms ok 147 + create_role 484 ms # parallel group (7 tests): collate.windows.win1252 amutils psql_crosstab collate.linux.utf8 rules psql stats_ext ok 148 + rules 1641 ms not ok 149 + psql 1749 ms ok 150 + psql_crosstab 135 ms ok 151 + amutils 132 ms ok 152 + stats_ext 3168 ms ok 153 + collate.linux.utf8 867 ms ok 154 + collate.windows.win1252 61 ms not ok 155 - select_parallel 4775 ms ok 156 - write_parallel 344 ms ok 157 - vacuum_parallel 232 ms # parallel group (2 tests): subscription publication ok 158 + publication 3189 ms ok 159 + subscription 144 ms # parallel group (17 tests): portals_p2 advisory_lock combocid tsdicts xmlmap equivclass guc functional_deps dependency select_views indirect_toast bitmapops window cluster foreign_data tsearch foreign_key ok 160 + select_views 1036 ms ok 161 + portals_p2 286 ms ok 162 + foreign_key 3542 ms ok 163 + cluster 2111 ms ok 164 + dependency 945 ms ok 165 + guc 771 ms ok 166 + bitmapops 1635 ms ok 167 + combocid 430 ms ok 168 + tsearch 3433 ms ok 169 + tsdicts 508 ms ok 170 + foreign_data 2454 ms ok 171 + window 1654 ms ok 172 + xmlmap 648 ms ok 173 + functional_deps 765 ms ok 174 + advisory_lock 277 ms ok 175 + indirect_toast 1494 ms ok 176 + equivclass 676 ms # parallel group (9 tests): jsonpath_encoding json_encoding jsonpath sqljson sqljson_jsontable jsonb_jsonpath json sqljson_queryfuncs jsonb ok 177 + json 489 ms ok 178 + jsonb 935 ms ok 179 + json_encoding 101 ms ok 180 + jsonpath 165 ms ok 181 + jsonpath_encoding 86 ms ok 182 + jsonb_jsonpath 435 ms ok 183 + sqljson 315 ms ok 184 + sqljson_queryfuncs 522 ms ok 185 + sqljson_jsontable 355 ms # parallel group (18 tests): prepare returning plancache limit conversion temp sequence copy2 rowtypes polymorphism largeobject truncate with domain rangefuncs plpgsql alter_table xml ok 186 + plancache 770 ms ok 187 + limit 923 ms ok 188 + plpgsql 4053 ms ok 189 + copy2 1657 ms ok 190 + temp 1212 ms ok 191 + domain 2275 ms ok 192 + rangefuncs 2552 ms ok 193 + prepare 338 ms ok 194 + conversion 1112 ms ok 195 + truncate 1962 ms ok 196 + alter_table 4958 ms ok 197 + sequence 1504 ms ok 198 + polymorphism 1732 ms ok 199 + rowtypes 1657 ms ok 200 + returning 585 ms ok 201 + largeobject 1764 ms not ok 202 + with 2125 ms ok 203 + xml 6028 ms # parallel group (15 tests): hash_part reloptions predicate explain partition_info compression partition_merge stats memoize partition_split partition_aggregate partition_join tuplesort indexing partition_prune ok 204 + partition_merge 2773 ms ok 205 + partition_split 3408 ms ok 206 + partition_join 4274 ms ok 207 + partition_prune 5385 ms ok 208 + reloptions 382 ms ok 209 + hash_part 246 ms ok 210 + indexing 4404 ms ok 211 + partition_aggregate 3556 ms ok 212 + partition_info 633 ms ok 213 + tuplesort 4371 ms ok 214 + explain 543 ms ok 215 + compression 1333 ms not ok 216 + memoize 3201 ms ok 217 + stats 3112 ms ok 218 + predicate 395 ms # parallel group (2 tests): oidjoins event_trigger ok 219 + oidjoins 580 ms ok 220 + event_trigger 683 ms ok 221 - event_trigger_login 91 ms ok 222 - fast_default 476 ms ok 223 - tablespace 1022 ms 1..223 # 7 of 223 tests failed. # The differences that caused some tests to fail can be viewed in the file "/tmp/cirrus-ci-build/src/test/recovery/tmp_check/regression.diffs". # A copy of the test summary that you see above is saved in the file "/tmp/cirrus-ci-build/src/test/recovery/tmp_check/regression.out". === dumping /tmp/cirrus-ci-build/src/test/recovery/tmp_check/regression.diffs === diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/subselect.out --- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2024-07-26 17:13:16.431440699 +0000 +++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/subselect.out 2024-07-26 17:20:10.078406092 +0000 @@ -1403,7 +1403,7 @@ -> Seq Scan on public.tenk1 b Output: b.unique1, b.unique2, b.two, b.four, b.ten, b.twenty, b.hundred, b.thousand, b.twothousand, b.fivethous, b.tenthous, b.odd, b.even, b.stringu1, b.stringu2, b.string4 SubPlan 1 - -> Index Only Scan using tenk1_unique1 on public.tenk1 a + -> Index Only Scan using idx_int4 on public.tenk1 a Output: a.unique1 (10 rows) diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/join.out --- /tmp/cirrus-ci-build/src/test/regress/expected/join.out 2024-07-26 17:13:16.379440698 +0000 +++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/join.out 2024-07-26 17:20:11.750405683 +0000 @@ -6460,7 +6460,7 @@ Aggregate -> Nested Loop -> Nested Loop - -> Index Only Scan using tenk1_unique1 on tenk1 a + -> Index Only Scan using idx_int4 on tenk1 a -> Values Scan on "*VALUES*" -> Memoize Cache Key: "*VALUES*".column1 diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/aggregates.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/aggregates.out --- /tmp/cirrus-ci-build/src/test/regress/expected/aggregates.out 2024-07-26 17:13:16.335440697 +0000 +++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/aggregates.out 2024-07-26 17:20:11.726405689 +0000 @@ -1106,10 +1106,29 @@ DROP AGGREGATE my_int_max(int4); DROP OPERATOR CLASS my_int_ops USING btree CASCADE; NOTICE: drop cascades to index idx_int4 +ERROR: deadlock detected +DETAIL: Process 46825 waits for AccessExclusiveLock on relation 16418 of database 16384; blocked by process 46821. +Process 46821 waits for AccessShareLock on relation 24393 of database 16384; blocked by process 46825. +HINT: See server log for query details. DROP OPERATOR FAMILY my_family USING btree; +ERROR: cannot drop operator family my_family for access method btree because other objects depend on it +DETAIL: index idx_int4 depends on operator class my_int_ops for access method btree +HINT: Use DROP ... CASCADE to drop the dependent objects too. DROP OPERATOR @>@ (int4, int4); +ERROR: cannot drop operator @>@(integer,integer) because other objects depend on it +DETAIL: operator class my_int_ops for access method btree depends on operator @>@(integer,integer) +index idx_int4 depends on operator class my_int_ops for access method btree +HINT: Use DROP ... CASCADE to drop the dependent objects too. DROP OPERATOR @<@ (int4, int4); +ERROR: cannot drop operator @<@(integer,integer) because other objects depend on it +DETAIL: operator class my_int_ops for access method btree depends on operator @<@(integer,integer) +index idx_int4 depends on operator class my_int_ops for access method btree +HINT: Use DROP ... CASCADE to drop the dependent objects too. DROP OPERATOR @=@ (int4, int4); +ERROR: cannot drop operator @=@(integer,integer) because other objects depend on it +DETAIL: operator class my_int_ops for access method btree depends on operator @=@(integer,integer) +index idx_int4 depends on operator class my_int_ops for access method btree +HINT: Use DROP ... CASCADE to drop the dependent objects too. -- But even then, the index can't be used if we order by multiple columns. explain (costs off) select max(unique1 ORDER BY unique1, tenthous) from tenk1; diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/psql.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/psql.out --- /tmp/cirrus-ci-build/src/test/regress/expected/psql.out 2024-07-26 17:13:16.411440698 +0000 +++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/psql.out 2024-07-26 17:20:28.778401554 +0000 @@ -5080,7 +5080,8 @@ AM | Operator family | Applicable types -------+-----------------+--------------------------- btree | integer_ops | smallint, integer, bigint -(1 row) + btree | my_family | integer +(2 rows) \dAo+ btree float_ops List of operators of operator families diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/select_parallel.out --- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2024-07-26 17:13:16.423440698 +0000 +++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/select_parallel.out 2024-07-26 17:20:34.998400062 +0000 @@ -257,13 +257,13 @@ explain (costs off) select sum(sp_parallel_restricted(unique1)) from tenk1 group by(sp_parallel_restricted(unique1)); - QUERY PLAN -------------------------------------------------------------------- + QUERY PLAN +-------------------------------------------------------------- HashAggregate Group Key: sp_parallel_restricted(unique1) -> Gather Workers Planned: 4 - -> Parallel Index Only Scan using tenk1_unique1 on tenk1 + -> Parallel Index Only Scan using idx_int4 on tenk1 (5 rows) -- test prepared statement @@ -907,13 +907,13 @@ -- check parallelized int8 aggregate (bug #14897) explain (costs off) select avg(unique1::int8) from tenk1; - QUERY PLAN -------------------------------------------------------------------------- + QUERY PLAN +-------------------------------------------------------------------- Finalize Aggregate -> Gather Workers Planned: 4 -> Partial Aggregate - -> Parallel Index Only Scan using tenk1_unique1 on tenk1 + -> Parallel Index Only Scan using idx_int4 on tenk1 (5 rows) select avg(unique1::int8) from tenk1; @@ -1111,8 +1111,8 @@ explain (costs off, verbose) select count(*) from tenk1 a where (unique1, two) in (select unique1, row_number() over() from tenk1 b); - QUERY PLAN ----------------------------------------------------------------------------------------- + QUERY PLAN +------------------------------------------------------------------------------------ Aggregate Output: count(*) -> Hash Right Semi Join @@ -1122,7 +1122,7 @@ -> Gather Output: b.unique1 Workers Planned: 4 - -> Parallel Index Only Scan using tenk1_unique1 on public.tenk1 b + -> Parallel Index Only Scan using idx_int4 on public.tenk1 b Output: b.unique1 -> Hash Output: a.unique1, a.two @@ -1315,13 +1315,13 @@ EXPLAIN (COSTS OFF) SELECT 1 FROM tenk1_vw_sec WHERE (SELECT sum(f1) FROM int4_tbl WHERE f1 < unique1) < 100; - QUERY PLAN -------------------------------------------------------------------- + QUERY PLAN +-------------------------------------------------------------- Subquery Scan on tenk1_vw_sec Filter: ((SubPlan 1) < 100) -> Gather Workers Planned: 4 - -> Parallel Index Only Scan using tenk1_unique1 on tenk1 + -> Parallel Index Only Scan using idx_int4 on tenk1 SubPlan 1 -> Aggregate -> Seq Scan on int4_tbl diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/with.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/with.out --- /tmp/cirrus-ci-build/src/test/regress/expected/with.out 2024-07-26 17:13:16.447440699 +0000 +++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/with.out 2024-07-26 17:20:45.502397557 +0000 @@ -646,7 +646,7 @@ ------------------------------------------------------------ Aggregate CTE x - -> Index Only Scan using tenk1_unique1 on tenk1 b + -> Index Only Scan using idx_int4 on tenk1 b -> Hash Semi Join Hash Cond: (a.unique1 = x.unique1) -> Index Only Scan using tenk1_unique1 on tenk1 a diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/memoize.out --- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out 2024-07-26 17:13:16.387440698 +0000 +++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/memoize.out 2024-07-26 17:20:52.670395858 +0000 @@ -134,8 +134,8 @@ SELECT COUNT(*), AVG(t1.twenty) FROM tenk1 t1 LEFT JOIN LATERAL (SELECT t1.two+1 AS c1, t2.unique1 AS c2 FROM tenk1 t2) s ON TRUE WHERE s.c1 = s.c2 AND t1.unique1 < 1000;', false); - explain_memoize -------------------------------------------------------------------------------------------- + explain_memoize +-------------------------------------------------------------------------------------- Aggregate (actual rows=1 loops=N) -> Nested Loop (actual rows=1000 loops=N) -> Seq Scan on tenk1 t1 (actual rows=1000 loops=N) @@ -145,7 +145,7 @@ Cache Key: (t1.two + 1) Cache Mode: binary Hits: 998 Misses: 2 Evictions: Zero Overflows: 0 Memory Usage: NkB - -> Index Only Scan using tenk1_unique1 on tenk1 t2 (actual rows=1 loops=N) + -> Index Only Scan using idx_int4 on tenk1 t2 (actual rows=1 loops=N) Filter: ((t1.two + 1) = unique1) Rows Removed by Filter: 9999 Heap Fetches: N === EOF === [17:20:57.190](64.489s) not ok 2 - regression tests pass [17:20:57.190](0.000s) [17:20:57.191](0.000s) # Failed test 'regression tests pass' # at t/027_stream_regress.pl line 95. [17:20:57.191](0.000s) # got: '256' # expected: '0' 2 2 1 5 9 5 5 3 4 3 4 4 1 32 1 1 1 6 104 4001 2 1 1006 1 2 41 5 17 -2 33 34 9 1 1 1 1 1 -1 1 1 -1 -32768 32767 46 1 1 Waiting for replication conn standby_1's replay_lsn to pass 0/14AE32D8 on primary done # Running: pg_dumpall -f /tmp/cirrus-ci-build/src/test/recovery/tmp_check/primary.dump --no-sync -p 26181 --no-unlogged-table-data [17:21:00.005](2.814s) ok 3 - dump primary server # Running: pg_dumpall -f /tmp/cirrus-ci-build/src/test/recovery/tmp_check/standby.dump --no-sync -p 26182 [17:21:02.907](2.903s) ok 4 - dump standby server # Running: diff /tmp/cirrus-ci-build/src/test/recovery/tmp_check/primary.dump /tmp/cirrus-ci-build/src/test/recovery/tmp_check/standby.dump [17:21:02.932](0.025s) ok 5 - compare primary and standby dumps ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/recovery/tmp_check/t_027_stream_regress_primary_data/pgdata -l /tmp/cirrus-ci-build/src/test/recovery/tmp_check/log/027_stream_regress_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 50096 Waiting for replication conn standby_1's replay_lsn to pass 0/14E8E7F0 on primary done # Running: pg_dump --schema pg_catalog -f /tmp/cirrus-ci-build/src/test/recovery/tmp_check/catalogs_primary.dump --no-sync -p 26181 --no-unlogged-table-data regression pg_dump: warning: typtype of data type "any" appears to be invalid pg_dump: warning: typtype of data type "anyarray" appears to be invalid pg_dump: warning: typtype of data type "anycompatible" appears to be invalid pg_dump: warning: typtype of data type "anycompatiblearray" appears to be invalid pg_dump: warning: typtype of data type "anycompatiblemultirange" appears to be invalid pg_dump: warning: typtype of data type "anycompatiblenonarray" appears to be invalid pg_dump: warning: typtype of data type "anycompatiblerange" appears to be invalid pg_dump: warning: typtype of data type "anyelement" appears to be invalid pg_dump: warning: typtype of data type "anyenum" appears to be invalid pg_dump: warning: typtype of data type "anymultirange" appears to be invalid pg_dump: warning: typtype of data type "anynonarray" appears to be invalid pg_dump: warning: typtype of data type "anyrange" appears to be invalid pg_dump: warning: typtype of data type "cstring" appears to be invalid pg_dump: warning: typtype of data type "event_trigger" appears to be invalid pg_dump: warning: typtype of data type "fdw_handler" appears to be invalid pg_dump: warning: typtype of data type "index_am_handler" appears to be invalid pg_dump: warning: typtype of data type "internal" appears to be invalid pg_dump: warning: typtype of data type "language_handler" appears to be invalid pg_dump: warning: typtype of data type "pg_ddl_command" appears to be invalid pg_dump: warning: typtype of data type "record" appears to be invalid pg_dump: warning: typtype of data type "table_am_handler" appears to be invalid pg_dump: warning: typtype of data type "trigger" appears to be invalid pg_dump: warning: typtype of data type "tsm_handler" appears to be invalid pg_dump: warning: typtype of data type "unknown" appears to be invalid pg_dump: warning: typtype of data type "void" appears to be invalid [17:21:06.735](3.802s) ok 6 - dump catalogs of primary server # Running: pg_dump --schema pg_catalog -f /tmp/cirrus-ci-build/src/test/recovery/tmp_check/catalogs_standby.dump --no-sync -p 26182 regression pg_dump: warning: typtype of data type "any" appears to be invalid pg_dump: warning: typtype of data type "anyarray" appears to be invalid pg_dump: warning: typtype of data type "anycompatible" appears to be invalid pg_dump: warning: typtype of data type "anycompatiblearray" appears to be invalid pg_dump: warning: typtype of data type "anycompatiblemultirange" appears to be invalid pg_dump: warning: typtype of data type "anycompatiblenonarray" appears to be invalid pg_dump: warning: typtype of data type "anycompatiblerange" appears to be invalid pg_dump: warning: typtype of data type "anyelement" appears to be invalid pg_dump: warning: typtype of data type "anyenum" appears to be invalid pg_dump: warning: typtype of data type "anymultirange" appears to be invalid pg_dump: warning: typtype of data type "anynonarray" appears to be invalid pg_dump: warning: typtype of data type "anyrange" appears to be invalid pg_dump: warning: typtype of data type "cstring" appears to be invalid pg_dump: warning: typtype of data type "event_trigger" appears to be invalid pg_dump: warning: typtype of data type "fdw_handler" appears to be invalid pg_dump: warning: typtype of data type "index_am_handler" appears to be invalid pg_dump: warning: typtype of data type "internal" appears to be invalid pg_dump: warning: typtype of data type "language_handler" appears to be invalid pg_dump: warning: typtype of data type "pg_ddl_command" appears to be invalid pg_dump: warning: typtype of data type "record" appears to be invalid pg_dump: warning: typtype of data type "table_am_handler" appears to be invalid pg_dump: warning: typtype of data type "trigger" appears to be invalid pg_dump: warning: typtype of data type "tsm_handler" appears to be invalid pg_dump: warning: typtype of data type "unknown" appears to be invalid pg_dump: warning: typtype of data type "void" appears to be invalid [17:21:09.911](3.177s) ok 7 - dump catalogs of standby server # Running: diff /tmp/cirrus-ci-build/src/test/recovery/tmp_check/catalogs_primary.dump /tmp/cirrus-ci-build/src/test/recovery/tmp_check/catalogs_standby.dump [17:21:09.932](0.021s) ok 8 - compare primary and standby catalog dumps [17:21:10.197](0.265s) ok 9 - check contents of pg_stat_statements on regression database ### Stopping node "standby_1" using mode fast # Running: pg_ctl -D /tmp/cirrus-ci-build/src/test/recovery/tmp_check/t_027_stream_regress_standby_1_data/pgdata -m fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "standby_1" ### Stopping node "primary" using mode fast # Running: pg_ctl -D /tmp/cirrus-ci-build/src/test/recovery/tmp_check/t_027_stream_regress_primary_data/pgdata -m fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "primary" [17:21:10.418](0.220s) 1..9 [17:21:10.419](0.002s) # Looks like you failed 1 test of 9.