# Checking port 53116
# Found port 53116
Name: primary
Data directory: C:\cirrus\build/testrun/recovery/027_stream_regress\data/t_027_stream_regress_primary_data/pgdata
Backup directory: C:\cirrus\build/testrun/recovery/027_stream_regress\data/t_027_stream_regress_primary_data/backup
Archive directory: C:\cirrus\build/testrun/recovery/027_stream_regress\data/t_027_stream_regress_primary_data/archives
Connection string: port=53116 host=C:/Windows/TEMP/FqmMWozeqI
Log file: C:\cirrus\build/testrun/recovery/027_stream_regress\log/027_stream_regress_primary.log
[16:23:25.683](0.075s) # initializing database system by copying initdb template
# Running: robocopy /E /NJS /NJH /NFL /NDL /NP C:/cirrus/build/tmp_install/initdb-template C:\cirrus\build/testrun/recovery/027_stream_regress\data/t_027_stream_regress_primary_data/pgdata

# Running: C:\cirrus\build\src/test\regress\pg_regress.exe --config-auth C:\cirrus\build/testrun/recovery/027_stream_regress\data/t_027_stream_regress_primary_data/pgdata
### Starting node "primary"
# Running: pg_ctl -w -D C:\cirrus\build/testrun/recovery/027_stream_regress\data/t_027_stream_regress_primary_data/pgdata -l C:\cirrus\build/testrun/recovery/027_stream_regress\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 8044
(standby_1,)
[16:23:27.458](1.775s) ok 1 - physical slot created on primary
# Taking pg_basebackup my_backup from node "primary"
# Running: pg_basebackup -D C:\cirrus\build/testrun/recovery/027_stream_regress\data/t_027_stream_regress_primary_data/backup/my_backup -h C:/Windows/TEMP/FqmMWozeqI -p 53116 --checkpoint fast --no-sync
# Backup finished
# Checking port 53117
# Found port 53117
Name: standby_1
Data directory: C:\cirrus\build/testrun/recovery/027_stream_regress\data/t_027_stream_regress_standby_1_data/pgdata
Backup directory: C:\cirrus\build/testrun/recovery/027_stream_regress\data/t_027_stream_regress_standby_1_data/backup
Archive directory: C:\cirrus\build/testrun/recovery/027_stream_regress\data/t_027_stream_regress_standby_1_data/archives
Connection string: port=53117 host=C:/Windows/TEMP/FqmMWozeqI
Log file: C:\cirrus\build/testrun/recovery/027_stream_regress\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 C:\cirrus\build/testrun/recovery/027_stream_regress\data/t_027_stream_regress_standby_1_data/pgdata -l C:\cirrus\build/testrun/recovery/027_stream_regress\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 7588
# using postmaster on C:/Windows/TEMP/FqmMWozeqI, port 53116
ok 1         - test_setup                                732 ms
# parallel group (20 tests):  oid char float4 txid money text uuid pg_lsn name boolean int4 float8 bit int8 varchar int2 enum regproc rangetypes numeric
ok 2         + boolean                                  1258 ms
ok 3         + char                                      836 ms
ok 4         + name                                     1230 ms
ok 5         + varchar                                  1371 ms
ok 6         + text                                      937 ms
ok 7         + int2                                     1368 ms
ok 8         + int4                                     1258 ms
ok 9         + int8                                     1364 ms
ok 10        + oid                                       742 ms
ok 11        + float4                                    825 ms
ok 12        + float8                                   1320 ms
ok 13        + bit                                      1357 ms
ok 14        + numeric                                  1960 ms
ok 15        + txid                                      820 ms
ok 16        + uuid                                      924 ms
ok 17        + enum                                     1354 ms
ok 18        + money                                     815 ms
ok 19        + rangetypes                               1804 ms
ok 20        + pg_lsn                                   1050 ms
ok 21        + regproc                                  1351 ms
# parallel group (20 tests):  circle md5 numerology point inet macaddr8 path line timestamp multirangetypes strings polygon lseg macaddr timetz time box date interval timestamptz
ok 22        + strings                                  1325 ms
ok 23        + md5                                       972 ms
ok 24        + numerology                                970 ms
ok 25        + point                                    1062 ms
ok 26        + lseg                                     1331 ms
ok 27        + line                                     1154 ms
ok 28        + box                                      1348 ms
ok 29        + path                                     1108 ms
ok 30        + polygon                                  1325 ms
ok 31        + circle                                    959 ms
ok 32        + date                                     1342 ms
ok 33        + time                                     1328 ms
ok 34        + timetz                                   1326 ms
ok 35        + timestamp                                1182 ms
ok 36        + timestamptz                              1648 ms
ok 37        + interval                                 1632 ms
ok 38        + inet                                     1038 ms
ok 39        + macaddr                                  1311 ms
ok 40        + macaddr8                                 1083 ms
ok 41        + multirangetypes                          1287 ms
# parallel group (12 tests):  xid tstypes mvcc type_sanity misc_sanity geometry horology unicode comments expressions regex opr_sanity
ok 42        + geometry                                  661 ms
ok 43        + horology                                  740 ms
ok 44        + tstypes                                   573 ms
ok 45        + regex                                     992 ms
ok 46        + type_sanity                               622 ms
ok 47        + opr_sanity                               1577 ms
ok 48        + misc_sanity                               617 ms
ok 49        + comments                                  729 ms
ok 50        + expressions                               843 ms
ok 51        + unicode                                   725 ms
ok 52        + xid                                       557 ms
ok 53        + mvcc                                      555 ms
# parallel group (5 tests):  copydml copyselect copy insert_conflict insert
ok 54        + copy                                      841 ms
ok 55        + copyselect                                326 ms
ok 56        + copydml                                   308 ms
ok 57        + insert                                   1383 ms
ok 58        + insert_conflict                           870 ms
# parallel group (7 tests):  create_function_c create_operator create_schema create_procedure create_misc create_type create_table
ok 59        + create_function_c                         711 ms
ok 60        + create_misc                              1210 ms
ok 61        + create_operator                           955 ms
ok 62        + create_procedure                         1199 ms
ok 63        + create_table                             1794 ms
ok 64        + create_type                              1202 ms
ok 65        + create_schema                            1192 ms
# parallel group (5 tests):  index_including create_view create_index_spgist index_including_gist create_index
ok 66        + create_index                             3563 ms
ok 67        + create_index_spgist                      1605 ms
ok 68        + create_view                              1604 ms
ok 69        + index_including                          1552 ms
ok 70        + index_including_gist                     1717 ms
# parallel group (16 tests):  create_am create_aggregate select create_function_sql hash_func create_cast infinite_recurse roleattributes drop_if_exists typed_table errors constraints vacuum updatable_views inherit triggers
ok 71        + create_aggregate                         1825 ms
ok 72        + create_function_sql                      1908 ms
ok 73        + create_cast                              1948 ms
ok 74        + constraints                              2568 ms
ok 75        + triggers                                 5978 ms
ok 76        + select                                   1898 ms
ok 77        + inherit                                  5228 ms
ok 78        + typed_table                              2378 ms
ok 79        + vacuum                                   4428 ms
ok 80        + drop_if_exists                           2375 ms
ok 81        + updatable_views                          4636 ms
ok 82        + roleattributes                           2372 ms
ok 83        + create_am                                1395 ms
ok 84        + hash_func                                1893 ms
ok 85        + errors                                   2450 ms
ok 86        + infinite_recurse                         1928 ms
ok 87        - sanity_check                              685 ms
# parallel group (20 tests):  select_having select_implicit namespace random select_into select_distinct_on case subselect union prepared_xacts delete select_distinct portals arrays transactions hash_index join update aggregates btree_index
ok 88        + select_into                              1436 ms
ok 89        + select_distinct                          2194 ms
ok 90        + select_distinct_on                       1434 ms
ok 91        + select_implicit                          1334 ms
ok 92        + select_having                            1333 ms
ok 93        + subselect                                1626 ms
ok 94        + union                                    1760 ms
ok 95        + case                                     1528 ms
ok 96        + join                                     3316 ms
ok 97        + aggregates                               4082 ms
ok 98        + transactions                             2384 ms
ok 99        + random                                   1323 ms
ok 100       + portals                                  2350 ms
ok 101       + arrays                                   2377 ms
ok 102       + btree_index                              5004 ms
ok 103       + hash_index                               2950 ms
ok 104       + update                                   3504 ms
ok 105       + delete                                   1969 ms
ok 106       + namespace                                1313 ms
ok 107       + prepared_xacts                           1741 ms
# parallel group (20 tests):  password init_privs replica_identity security_label drop_operator object_address lock tablesample groupingsets collate matview identity generated spgist rowsecurity gin gist join_hash brin privileges
ok 108       + brin                                     9175 ms
ok 109       + gin                                      4495 ms
ok 110       + gist                                     4766 ms
ok 111       + spgist                                   4428 ms
ok 112       + privileges                              10555 ms
ok 113       + init_privs                               1478 ms
ok 114       + security_label                           1703 ms
ok 115       + collate                                  3374 ms
ok 116       + matview                                  4174 ms
ok 117       + lock                                     2145 ms
ok 118       + replica_identity                         1697 ms
ok 119       + rowsecurity                              4416 ms
ok 120       + object_address                           2011 ms
ok 121       + tablesample                              2492 ms
ok 122       + groupingsets                             2712 ms
ok 123       + drop_operator                            1690 ms
ok 124       + password                                 1461 ms
ok 125       + identity                                 4161 ms
ok 126       + generated                                4371 ms
ok 127       + join_hash                                9126 ms
# parallel group (2 tests):  brin_bloom brin_multi
ok 128       + brin_bloom                                454 ms
ok 129       + brin_multi                               2230 ms
# parallel group (17 tests):  create_role async collate.icu.utf8 dbsize sysviews tidrangescan alter_generic alter_operator misc merge without_overlaps tsrf tid incremental_sort tidscan misc_functions create_table_like
ok 130       + create_table_like                        1656 ms
ok 131       + alter_generic                            1085 ms
ok 132       + alter_operator                           1083 ms
ok 133       + misc                                     1142 ms
ok 134       + async                                     871 ms
ok 135       + dbsize                                   1043 ms
ok 136       + merge                                    1156 ms
ok 137       + misc_functions                           1293 ms
ok 138       + sysviews                                 1060 ms
ok 139       + tsrf                                     1197 ms
ok 140       + tid                                      1229 ms
ok 141       + tidscan                                  1229 ms
ok 142       + tidrangescan                             1055 ms
ok 143       + collate.icu.utf8                          924 ms
ok 144       + incremental_sort                         1224 ms
ok 145       + create_role                               855 ms
ok 146       + without_overlaps                         1142 ms
# parallel group (7 tests):  collate.linux.utf8 amutils psql_crosstab collate.windows.win1252 psql rules stats_ext
ok 147       + rules                                    1741 ms
ok 148       + psql                                     1656 ms
ok 149       + psql_crosstab                             383 ms
ok 150       + amutils                                   299 ms
ok 151       + stats_ext                                5014 ms
ok 152       + collate.linux.utf8                        296 ms
ok 153       + collate.windows.win1252                   867 ms
not ok 154   - select_parallel                          7338 ms
ok 155       - write_parallel                            754 ms
ok 156       - vacuum_parallel                           495 ms
# parallel group (2 tests):  subscription publication
ok 157       + publication                              1302 ms
ok 158       + subscription                              337 ms
# parallel group (17 tests):  functional_deps advisory_lock select_views portals_p2 guc equivclass xmlmap combocid tsdicts cluster dependency indirect_toast tsearch window bitmapops foreign_data foreign_key
ok 159       + select_views                             1167 ms
ok 160       + portals_p2                               1165 ms
ok 161       + foreign_key                              4620 ms
ok 162       + cluster                                  2223 ms
ok 163       + dependency                               2222 ms
ok 164       + guc                                      1159 ms
ok 165       + bitmapops                                2960 ms
ok 166       + combocid                                 1159 ms
ok 167       + tsearch                                  2695 ms
ok 168       + tsdicts                                  2155 ms
ok 169       + foreign_data                             3338 ms
ok 170       + window                                   2852 ms
ok 171       + xmlmap                                   1151 ms
ok 172       + functional_deps                          1021 ms
ok 173       + advisory_lock                            1095 ms
ok 174       + indirect_toast                           2511 ms
ok 175       + equivclass                               1144 ms
# parallel group (7 tests):  json_encoding jsonpath_encoding jsonpath json jsonb_jsonpath sqljson jsonb
ok 176       + json                                     1148 ms
ok 177       + jsonb                                    1942 ms
ok 178       + json_encoding                            1016 ms
ok 179       + jsonpath                                 1062 ms
ok 180       + jsonpath_encoding                        1013 ms
ok 181       + jsonb_jsonpath                           1305 ms
ok 182       + sqljson                                  1359 ms
# parallel group (18 tests):  plancache prepare conversion limit domain copy2 rowtypes returning with sequence xml largeobject polymorphism rangefuncs truncate temp plpgsql alter_table
ok 183       + plancache                                1349 ms
ok 184       + limit                                    2057 ms
ok 185       + plpgsql                                  4197 ms
ok 186       + copy2                                    2210 ms
ok 187       + temp                                     3378 ms
ok 188       + domain                                   2084 ms
ok 189       + rangefuncs                               2649 ms
ok 190       + prepare                                  1338 ms
ok 191       + conversion                               1337 ms
ok 192       + truncate                                 3154 ms
ok 193       + alter_table                              5822 ms
ok 194       + sequence                                 2601 ms
ok 195       + polymorphism                             2638 ms
ok 196       + rowtypes                                 2193 ms
ok 197       + returning                                2484 ms
ok 198       + largeobject                              2634 ms
ok 199       + with                                     2567 ms
ok 200       + xml                                      2591 ms
# parallel group (13 tests):  hash_part partition_info reloptions compression predicate memoize explain indexing partition_join stats tuplesort partition_aggregate partition_prune
ok 201       + partition_join                           3406 ms
ok 202       + partition_prune                          6706 ms
ok 203       + reloptions                               1509 ms
ok 204       + hash_part                                 809 ms
ok 205       + indexing                                 3141 ms
ok 206       + partition_aggregate                      4358 ms
ok 207       + partition_info                            930 ms
ok 208       + tuplesort                                4239 ms
ok 209       + explain                                  1938 ms
ok 210       + compression                              1504 ms
ok 211       + memoize                                  1864 ms
ok 212       + stats                                    4065 ms
ok 213       + predicate                                1500 ms
# parallel group (2 tests):  oidjoins event_trigger
ok 214       + oidjoins                                 1183 ms
ok 215       + event_trigger                            1995 ms
ok 216       - event_trigger_login                       425 ms
ok 217       - fast_default                              565 ms
ok 218       - tablespace                               1322 ms
1..218
# 1 of 218 tests failed.
# The differences that caused some tests to fail can be viewed in the file "C:/cirrus/build/testrun/recovery/027_stream_regress/data/regression.diffs".
# A copy of the test summary that you see above is saved in the file "C:/cirrus/build/testrun/recovery/027_stream_regress/data/regression.out".
=== dumping C:\cirrus\build/testrun/recovery/027_stream_regress\data/regression.diffs ===
diff -w -U3 C:/cirrus/src/test/regress/expected/select_parallel.out C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out
--- C:/cirrus/src/test/regress/expected/select_parallel.out	2024-03-02 16:19:28.388541700 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out	2024-03-02 16:24:54.330794600 +0000
@@ -452,25 +452,35 @@
   where tenk1.four = t.four
 );
                                                                                                                           QUERY PLAN                                                                                                                           
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
- Seq Scan on public.tenk1 t
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+ Hash Join
    Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.tenthous, t.odd, t.even, t.stringu1, t.stringu2, t.string4
-   Filter: (SubPlan 1)
-   SubPlan 1
-     ->  Hash Join
-           Output: t.two
-           Hash Cond: (tenk1.stringu1 = t3.stringu1)
-           ->  Seq Scan on public.tenk1
-                 Output: tenk1.unique1, tenk1.unique2, tenk1.two, tenk1.four, tenk1.ten, tenk1.twenty, tenk1.hundred, tenk1.thousand, tenk1.twothousand, tenk1.fivethous, tenk1.tenthous, tenk1.odd, tenk1.even, tenk1.stringu1, tenk1.stringu2, tenk1.string4
-                 Filter: (tenk1.four = t.four)
+   Inner Unique: true
+   Hash Cond: (t.four = tenk1.four)
+   ->  Gather
+         Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.tenthous, t.odd, t.even, t.stringu1, t.stringu2, t.string4
+         Workers Planned: 4
+         ->  Parallel Seq Scan on public.tenk1 t
+               Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.tenthous, t.odd, t.even, t.stringu1, t.stringu2, t.string4
+               Filter: (t.two IS NOT NULL)
            ->  Hash
-                 Output: t3.stringu1
+         Output: tenk1.four
+         ->  HashAggregate
+               Output: tenk1.four
+               Group Key: tenk1.four
                  ->  Gather
-                       Output: t3.stringu1
+                     Output: tenk1.four
                        Workers Planned: 4
+                     ->  Parallel Hash Join
+                           Output: tenk1.four
+                           Hash Cond: (tenk1.stringu1 = t3.stringu1)
+                           ->  Parallel Seq Scan on public.tenk1
+                                 Output: tenk1.unique1, tenk1.unique2, tenk1.two, tenk1.four, tenk1.ten, tenk1.twenty, tenk1.hundred, tenk1.thousand, tenk1.twothousand, tenk1.fivethous, tenk1.tenthous, tenk1.odd, tenk1.even, tenk1.stringu1, tenk1.stringu2, tenk1.string4
+                           ->  Parallel Hash
+                                 Output: t3.stringu1
                        ->  Parallel Seq Scan on public.tenk1 t3
                              Output: t3.stringu1
-(17 rows)
+(27 rows)
 
 -- this is not parallel-safe due to use of random() within SubLink's testexpr:
 explain (costs off)
=== EOF ===
[16:25:32.859](125.401s) not ok 2 - regression tests pass
[16:25:32.875](0.016s) #   Failed test 'regression tests pass'
#   at C:/cirrus/src/test/recovery/t/027_stream_regress.pl line 95.
[16:25:32.875](0.000s) #          got: '256'
#     expected: '0'
1
1
1
1
2
1
9
1
5
5
3
4
3
4
4
1
32
1
1
1
6
4001
104
2
1
5
1006
1
2
41
5
17
33
34
-2
1
1
1
1
-1
1
1
-1
-32768
32767
9
1
46
1
1
Waiting for replication conn standby_1's replay_lsn to pass 0/146E6670 on primary
done
# Running: pg_dumpall -f C:\cirrus\build/testrun/recovery/027_stream_regress\data/primary.dump --no-sync -p 53116 --no-unlogged-table-data
[16:25:38.121](5.246s) ok 3 - dump primary server
# Running: pg_dumpall -f C:\cirrus\build/testrun/recovery/027_stream_regress\data/standby.dump --no-sync -p 53117
[16:25:43.159](5.038s) ok 4 - dump standby server
# Running: diff C:\cirrus\build/testrun/recovery/027_stream_regress\data/primary.dump C:\cirrus\build/testrun/recovery/027_stream_regress\data/standby.dump
[16:25:43.249](0.090s) ok 5 - compare primary and standby dumps
[16:25:43.864](0.614s) ok 6 - check contents of pg_stat_statements on regression database
### Stopping node "standby_1" using mode fast
# Running: pg_ctl -D C:\cirrus\build/testrun/recovery/027_stream_regress\data/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 C:\cirrus\build/testrun/recovery/027_stream_regress\data/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"
[16:25:44.435](0.571s) 1..6
[16:25:44.446](0.011s) # Looks like you failed 1 test of 6.