[13:46:32.045](0.030s) # testing using transfer mode --copy
# Checking port 51484
# Found port 51484
Name: old_node
Data directory: C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_old_node_data/pgdata
Backup directory: C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_old_node_data/backup
Archive directory: C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_old_node_data/archives
Connection string: port=51484 host=C:/Windows/TEMP/LZFgcOhnGj
Log file: C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\log/002_pg_upgrade_old_node.log
[13:46:32.119](0.074s) # initializing database system by running initdb
# Running: initdb -D C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_old_node_data/pgdata -A trust -N --wal-segsize 1 --allow-group-access --encoding UTF-8 --lc-collate C --lc-ctype C --locale-provider builtin --builtin-locale C.UTF-8
The files belonging to this database system will be owned by user "SYSTEM".
This user must also own the server process.

The database cluster will be initialized with this locale configuration:
  locale provider:   builtin
  default collation: C.UTF-8
  LC_COLLATE:  C
  LC_CTYPE:    C
  LC_MESSAGES: English_United States.1252
  LC_MONETARY: English_United States.1252
  LC_NUMERIC:  English_United States.1252
  LC_TIME:     English_United States.1252
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... windows
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Atlantic/Reykjavik
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok

Sync to disk skipped.
The data directory might become corrupt if the operating system crashes.

Success. You can now start the database server using:

    pg_ctl -D ^"C^:^\cirrus^\build^/testrun^/pg^_upgrade^/002^_pg^_upgrade^\data^/t^_002^_pg^_upgrade^_old^_node^_data^/pgdata^" -l logfile start

# Running: C:\cirrus\build\src/test\regress\pg_regress.exe --config-auth C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_old_node_data/pgdata
### Starting node "old_node"
# Running: pg_ctl -w -D C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_old_node_data/pgdata -l C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\log/002_pg_upgrade_old_node.log -o --cluster-name=old_node start
waiting for server to start.... done
server started
# Postmaster PID for node "old_node" is 6968
[13:46:36.744](4.624s) ok 1 - check locales in original cluster
# Running: createdb regression\"\
	 !"#$%&'()*+,-\\"\\\
[13:46:37.171](0.427s) ok 2 - created database with ASCII characters from 1 to 45
# Running: createdb regression./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ
[13:46:37.902](0.731s) ok 3 - created database with ASCII characters from 46 to 90
# Running: createdb regression[\]^_`abcdefghijklmnopqrstuvwxyz{|}~
[13:46:38.305](0.403s) ok 4 - created database with ASCII characters from 91 to 127
[13:46:38.308](0.003s) # running regression tests in old instance
# using postmaster on C:/Windows/TEMP/LZFgcOhnGj, port 51484
ok 1         - test_setup                                536 ms
# parallel group (20 tests):  boolean name int2 oid uuid int4 text regproc enum char varchar txid money bit pg_lsn int8 float4 float8 rangetypes numeric
ok 2         + boolean                                   551 ms
ok 3         + char                                      682 ms
ok 4         + name                                      548 ms
ok 5         + varchar                                   679 ms
ok 6         + text                                      633 ms
ok 7         + int2                                      544 ms
ok 8         + int4                                      584 ms
ok 9         + int8                                      712 ms
ok 10        + oid                                       540 ms
ok 11        + float4                                    725 ms
ok 12        + float8                                    724 ms
ok 13        + bit                                       689 ms
ok 14        + numeric                                  1401 ms
ok 15        + txid                                      676 ms
ok 16        + uuid                                      531 ms
ok 17        + enum                                      661 ms
ok 18        + money                                     672 ms
ok 19        + rangetypes                               1265 ms
ok 20        + pg_lsn                                    678 ms
ok 21        + regproc                                   611 ms
# parallel group (20 tests):  lseg line md5 path macaddr circle numerology date strings macaddr8 interval point timestamp time box inet timetz timestamptz polygon multirangetypes
ok 22        + strings                                   734 ms
ok 23        + md5                                       591 ms
ok 24        + numerology                                645 ms
ok 25        + point                                     843 ms
ok 26        + lseg                                      441 ms
ok 27        + line                                      440 ms
ok 28        + box                                       927 ms
ok 29        + path                                      611 ms
ok 30        + polygon                                  1074 ms
ok 31        + circle                                    634 ms
ok 32        + date                                      719 ms
ok 33        + time                                      920 ms
ok 34        + timetz                                   1016 ms
ok 35        + timestamp                                 917 ms
ok 36        + timestamptz                              1033 ms
ok 37        + interval                                  824 ms
ok 38        + inet                                      913 ms
ok 39        + macaddr                                   597 ms
ok 40        + macaddr8                                  762 ms
ok 41        + multirangetypes                          1135 ms
# parallel group (12 tests):  type_sanity horology misc_sanity unicode geometry comments expressions mvcc regex xid tstypes opr_sanity
ok 42        + geometry                                  625 ms
ok 43        + horology                                  493 ms
ok 44        + tstypes                                   726 ms
ok 45        + regex                                     692 ms
ok 46        + type_sanity                               370 ms
ok 47        + opr_sanity                                900 ms
ok 48        + misc_sanity                               485 ms
ok 49        + comments                                  650 ms
ok 50        + expressions                               649 ms
ok 51        + unicode                                   611 ms
ok 52        + xid                                       688 ms
ok 53        + mvcc                                      662 ms
# parallel group (5 tests):  copydml copyselect copy insert_conflict insert
ok 54        + copy                                      400 ms
ok 55        + copyselect                                336 ms
ok 56        + copydml                                   334 ms
ok 57        + insert                                   2170 ms
ok 58        + insert_conflict                           513 ms
# parallel group (7 tests):  create_operator create_procedure create_schema create_function_c create_type create_misc create_table
ok 59        + create_function_c                         425 ms
ok 60        + create_misc                               462 ms
ok 61        + create_operator                           376 ms
ok 62        + create_procedure                          375 ms
ok 63        + create_table                             1029 ms
ok 64        + create_type                               419 ms
ok 65        + create_schema                             372 ms
# parallel group (5 tests):  index_including index_including_gist create_view create_index_spgist create_index
ok 66        + create_index                             2977 ms
ok 67        + create_index_spgist                      1197 ms
ok 68        + create_view                              1179 ms
ok 69        + index_including                          1095 ms
ok 70        + index_including_gist                     1134 ms
# parallel group (16 tests):  typed_table create_aggregate select drop_if_exists create_am create_function_sql create_cast infinite_recurse roleattributes errors constraints hash_func updatable_views vacuum inherit triggers
ok 71        + create_aggregate                         1053 ms
ok 72        + create_function_sql                      1749 ms
ok 73        + create_cast                              1747 ms
ok 74        + constraints                              2049 ms
ok 75        + triggers                                 3292 ms
ok 76        + select                                   1147 ms
ok 77        + inherit                                  3082 ms
ok 78        + typed_table                              1042 ms
ok 79        + vacuum                                   2580 ms
ok 80        + drop_if_exists                           1354 ms
ok 81        + updatable_views                          2539 ms
ok 82        + roleattributes                           2036 ms
ok 83        + create_am                                1732 ms
ok 84        + hash_func                                2223 ms
ok 85        + errors                                   2031 ms
ok 86        + infinite_recurse                         2006 ms
ok 87        - sanity_check                              438 ms
# parallel group (20 tests):  select_having select_implicit select_distinct_on case select_into delete transactions namespace portals subselect select_distinct union random arrays prepared_xacts join update hash_index aggregates btree_index
ok 88        + select_into                              1381 ms
ok 89        + select_distinct                          1791 ms
ok 90        + select_distinct_on                       1261 ms
ok 91        + select_implicit                          1259 ms
ok 92        + select_having                            1138 ms
ok 93        + subselect                                1718 ms
ok 94        + union                                    1808 ms
ok 95        + case                                     1298 ms
ok 96        + join                                     2284 ms
ok 97        + aggregates                               3357 ms
ok 98        + transactions                             1363 ms
ok 99        + random                                   1800 ms
ok 100       + portals                                  1520 ms
ok 101       + arrays                                   1797 ms
ok 102       + btree_index                              7270 ms
ok 103       + hash_index                               3051 ms
ok 104       + update                                   2367 ms
ok 105       + delete                                   1351 ms
ok 106       + namespace                                1437 ms
ok 107       + prepared_xacts                           1935 ms
# parallel group (20 tests):  tablesample drop_operator init_privs matview security_label lock generated replica_identity password collate groupingsets gin identity object_address rowsecurity spgist gist brin join_hash privileges
ok 108       + brin                                     7963 ms
ok 109       + gin                                      2770 ms
ok 110       + gist                                     3412 ms
ok 111       + spgist                                   3361 ms
ok 112       + privileges                               9348 ms
ok 113       + init_privs                               1811 ms
ok 114       + security_label                           2521 ms
ok 115       + collate                                  2653 ms
ok 116       + matview                                  2518 ms
ok 117       + lock                                     2520 ms
ok 118       + replica_identity                         2519 ms
ok 119       + rowsecurity                              3195 ms
ok 120       + object_address                           3090 ms
ok 121       + tablesample                              1080 ms
ok 122       + groupingsets                             2751 ms
ok 123       + drop_operator                            1796 ms
ok 124       + password                                 2598 ms
ok 125       + identity                                 2747 ms
ok 126       + generated                                2507 ms
ok 127       + join_hash                                7941 ms
# parallel group (2 tests):  brin_bloom brin_multi
ok 128       + brin_bloom                                463 ms
ok 129       + brin_multi                               1830 ms
# parallel group (18 tests):  collate.utf8 tid alter_operator create_role collate.icu.utf8 tidscan async alter_generic sysviews tidrangescan tsrf dbsize create_table_like misc misc_functions incremental_sort merge without_overlaps
ok 130       + create_table_like                        1260 ms
ok 131       + alter_generic                            1227 ms
ok 132       + alter_operator                           1075 ms
ok 133       + misc                                     1255 ms
ok 134       + async                                    1165 ms
ok 135       + dbsize                                   1241 ms
ok 136       + merge                                    1495 ms
ok 137       + misc_functions                           1287 ms
ok 138       + sysviews                                 1236 ms
ok 139       + tsrf                                     1235 ms
ok 140       + tid                                      1059 ms
ok 141       + tidscan                                  1154 ms
ok 142       + tidrangescan                             1230 ms
ok 143       + collate.utf8                              721 ms
ok 144       + collate.icu.utf8                         1056 ms
ok 145       + incremental_sort                         1309 ms
ok 146       + create_role                              1053 ms
ok 147       + without_overlaps                         1652 ms
# parallel group (7 tests):  psql_crosstab amutils collate.linux.utf8 collate.windows.win1252 psql rules stats_ext
ok 148       + rules                                    1597 ms
ok 149       + psql                                     1594 ms
ok 150       + psql_crosstab                            1140 ms
ok 151       + amutils                                  1348 ms
ok 152       + stats_ext                                3255 ms
ok 153       + collate.linux.utf8                       1497 ms
ok 154       + collate.windows.win1252                  1496 ms
ok 155       - select_parallel                          5639 ms
ok 156       - write_parallel                            812 ms
ok 157       - vacuum_parallel                          1729 ms
# parallel group (2 tests):  subscription publication
ok 158       + publication                               894 ms
ok 159       + subscription                              297 ms
# parallel group (17 tests):  guc dependency advisory_lock portals_p2 select_views equivclass tsdicts functional_deps cluster combocid tsearch xmlmap window bitmapops foreign_data indirect_toast foreign_key
ok 160       + select_views                             1736 ms
ok 161       + portals_p2                               1569 ms
ok 162       + foreign_key                              3062 ms
ok 163       + cluster                                  2311 ms
ok 164       + dependency                               1113 ms
ok 165       + guc                                       862 ms
ok 166       + bitmapops                                2584 ms
ok 167       + combocid                                 2306 ms
ok 168       + tsearch                                  2307 ms
ok 169       + tsdicts                                  2287 ms
ok 170       + foreign_data                             2578 ms
ok 171       + window                                   2331 ms
ok 172       + xmlmap                                   2329 ms
ok 173       + functional_deps                          2297 ms
ok 174       + advisory_lock                            1099 ms
ok 175       + indirect_toast                           2580 ms
ok 176       + equivclass                               1649 ms
# parallel group (9 tests):  json_encoding sqljson_jsontable jsonpath sqljson_queryfuncs sqljson jsonpath_encoding json jsonb_jsonpath jsonb
ok 177       + json                                      585 ms
ok 178       + jsonb                                    1034 ms
ok 179       + json_encoding                             447 ms
ok 180       + jsonpath                                  530 ms
ok 181       + jsonpath_encoding                         573 ms
ok 182       + jsonb_jsonpath                            582 ms
ok 183       + sqljson                                   554 ms
ok 184       + sqljson_queryfuncs                        524 ms
ok 185       + sqljson_jsontable                         497 ms
# parallel group (18 tests):  prepare largeobject truncate rowtypes with limit plancache sequence conversion returning xml copy2 rangefuncs polymorphism domain temp plpgsql alter_table
ok 186       + plancache                                1898 ms
ok 187       + limit                                    1896 ms
ok 188       + plpgsql                                  3593 ms
ok 189       + copy2                                    2222 ms
ok 190       + temp                                     2525 ms
ok 191       + domain                                   2488 ms
ok 192       + rangefuncs                               2436 ms
ok 193       + prepare                                  1000 ms
ok 194       + conversion                               1875 ms
ok 195       + truncate                                 1638 ms
not ok 196   + alter_table                              4884 ms
ok 197       + sequence                                 1870 ms
ok 198       + polymorphism                             2455 ms
ok 199       + rowtypes                                 1711 ms
ok 200       + returning                                1958 ms
ok 201       + largeobject                              1629 ms
ok 202       + with                                     1708 ms
ok 203       + xml                                      2025 ms
# parallel group (15 tests):  partition_info hash_part reloptions predicate partition_merge compression explain memoize partition_join indexing partition_split tuplesort stats partition_aggregate partition_prune
ok 204       + partition_merge                          2096 ms
ok 205       + partition_split                          2931 ms
ok 206       + partition_join                           2906 ms
ok 207       + partition_prune                          5167 ms
ok 208       + reloptions                               1647 ms
ok 209       + hash_part                                1646 ms
ok 210       + indexing                                 2899 ms
ok 211       + partition_aggregate                      3963 ms
ok 212       + partition_info                           1483 ms
ok 213       + tuplesort                                2957 ms
ok 214       + explain                                  2362 ms
ok 215       + compression                              2164 ms
ok 216       + memoize                                  2891 ms
ok 217       + stats                                    3544 ms
ok 218       + predicate                                1665 ms
# parallel group (2 tests):  oidjoins event_trigger
ok 219       + oidjoins                                  889 ms
ok 220       + event_trigger                             978 ms
ok 221       - event_trigger_login                       355 ms
ok 222       - fast_default                              529 ms
ok 223       - tablespace                               1070 ms
1..223
# 1 of 223 tests failed.
# The differences that caused some tests to fail can be viewed in the file "C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/regression.diffs".
# A copy of the test summary that you see above is saved in the file "C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/regression.out".
=== dumping C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/regression.diffs ===
diff -w -U3 C:/cirrus/src/test/regress/expected/alter_table.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/alter_table.out
--- C:/cirrus/src/test/regress/expected/alter_table.out	2024-04-27 13:44:43.257218900 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/alter_table.out	2024-04-27 13:48:04.120437500 +0000
@@ -3477,8 +3477,19 @@
 SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
 WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
  oid | mapped_oid | reltablespace | relfilenode | relname 
------+------------+---------------+-------------+---------
-(0 rows)
+-------+------------+---------------+-------------+----------------------
+ 36429 |            |             0 |       36429 | pktable_pkey
+ 36421 |            |             0 |       36421 | pktable
+ 36431 |            |             0 |       36431 | fktable
+ 37618 |            |             0 |       37618 | pg_toast_37576_index
+ 37616 |            |             0 |       37616 | pg_toast_37576
+ 37576 |            |             0 |       37594 | foo
+ 38167 |            |             0 |       38167 | old_oids
+ 38184 |            |             0 |       38184 | pg_toast_38181
+ 38185 |            |             0 |       38185 | pg_toast_38181_index
+ 38181 |            |             0 |       38181 | recur2
+ 38176 |            |             0 |       38176 | recur1
+(11 rows)
 
 -- Checks on creating and manipulation of user defined relations in
 -- pg_catalog.
=== EOF ===
[13:48:22.583](104.274s) not ok 5 - regression tests pass
[13:48:22.583](0.000s) #   Failed test 'regression tests pass'
#   at C:/cirrus/src/bin/pg_upgrade/t/002_pg_upgrade.pl line 260.
[13:48:22.583](0.001s) #          got: '256'
#     expected: '0'
# Checking port 51485
# Found port 51485
Name: new_node
Data directory: C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_new_node_data/pgdata
Backup directory: C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_new_node_data/backup
Archive directory: C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_new_node_data/archives
Connection string: port=51485 host=C:/Windows/TEMP/LZFgcOhnGj
Log file: C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\log/002_pg_upgrade_new_node.log
[13:48:22.619](0.035s) # initializing database system by running initdb
# Running: initdb -D C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_new_node_data/pgdata -A trust -N --wal-segsize 1 --allow-group-access --encoding SQL_ASCII --locale-provider libc
The files belonging to this database system will be owned by user "SYSTEM".
This user must also own the server process.

The database cluster will be initialized with locale "English_United States.1252".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... windows
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Atlantic/Reykjavik
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok

Sync to disk skipped.
The data directory might become corrupt if the operating system crashes.

Success. You can now start the database server using:

    pg_ctl -D ^"C^:^\cirrus^\build^/testrun^/pg^_upgrade^/002^_pg^_upgrade^\data^/t^_002^_pg^_upgrade^_new^_node^_data^/pgdata^" -l logfile start

# Running: C:\cirrus\build\src/test\regress\pg_regress.exe --config-auth C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_new_node_data/pgdata
# Running: pg_dumpall --no-sync -d port=51484 host=C:/Windows/TEMP/LZFgcOhnGj dbname='postgres' -f C:\cirrus\build\testrun\pg_upgrade\002_pg_upgrade\data\tmp_test_9QTe/dump1.sql
[13:48:30.017](7.399s) ok 6 - dump before running pg_upgrade
### Stopping node "old_node" using mode fast
# Running: pg_ctl -D C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_old_node_data/pgdata -m fast stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "old_node"
# Running: pg_upgrade --no-sync -d C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_old_node_data/pgdata -D C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_new_node_data/pgdata -b C:/cirrus/build/TMP_IN~1/usr/local/pgsql/bin/does/not/exist/ -B C:/cirrus/build/TMP_IN~1/usr/local/pgsql/bin -s C:/Windows/TEMP/LZFgcOhnGj -p 51484 -P 51485 --copy --check

check for "C:/cirrus/build/TMP_IN~1/usr/local/pgsql/bin/does/not/exist" failed: No such file or directory
Failure, exiting
[13:48:30.736](0.719s) ok 7 - run of pg_upgrade --check for new instance with incorrect binary path
[13:48:30.741](0.005s) ok 8 - pg_upgrade_output.d/ not removed after pg_upgrade failure
# Running: pg_upgrade --no-sync -d C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_old_node_data/pgdata -D C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_new_node_data/pgdata -b C:/cirrus/build/TMP_IN~1/usr/local/pgsql/bin -B C:/cirrus/build/TMP_IN~1/usr/local/pgsql/bin -s C:/Windows/TEMP/LZFgcOhnGj -p 51484 -P 51485 --copy --check
[13:48:34.307](3.566s) ok 9 - invalid database causes failure status (got 1 vs expected 1)
[13:48:34.308](0.001s) ok 10 - invalid database causes failure stdout /(?^:invalid)/
[13:48:34.309](0.000s) ok 11 - invalid database causes failure stderr /(?^:^$)/
### Starting node "old_node"
# Running: pg_ctl -w -D C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_old_node_data/pgdata -l C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\log/002_pg_upgrade_old_node.log -o --cluster-name=old_node start
waiting for server to start.... done
server started
# Postmaster PID for node "old_node" is 6484
### Stopping node "old_node" using mode fast
# Running: pg_ctl -D C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_old_node_data/pgdata -m fast stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "old_node"
# Running: pg_upgrade --no-sync -d C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_old_node_data/pgdata -D C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_new_node_data/pgdata -b C:/cirrus/build/TMP_IN~1/usr/local/pgsql/bin -B C:/cirrus/build/TMP_IN~1/usr/local/pgsql/bin -s C:/Windows/TEMP/LZFgcOhnGj -p 51484 -P 51485 --copy --check
Performing Consistency Checks
-----------------------------
Checking cluster versions                                     ok
Checking database user is the install user                    ok
Checking database connection settings                         ok
Checking for prepared transactions                            ok
Checking for contrib/isn with bigint-passing mismatch         ok
Checking for valid logical replication slots                  ok
Checking for subscription state                               ok
Checking for data type usage                                  ok
Checking for presence of required libraries                   ok
Checking database user is the install user                    ok
Checking for prepared transactions                            ok
Checking for new cluster tablespace directories               ok

*Clusters are compatible*
[13:48:41.585](7.276s) ok 12 - run of pg_upgrade --check for new instance
[13:48:41.586](0.001s) ok 13 - pg_upgrade_output.d/ removed after pg_upgrade --check success
# Running: pg_upgrade --no-sync -d C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_old_node_data/pgdata -D C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_new_node_data/pgdata -b C:/cirrus/build/TMP_IN~1/usr/local/pgsql/bin -B C:/cirrus/build/TMP_IN~1/usr/local/pgsql/bin -s C:/Windows/TEMP/LZFgcOhnGj -p 51484 -P 51485 --copy
Performing Consistency Checks
-----------------------------
Checking cluster versions                                     ok
Checking database user is the install user                    ok
Checking database connection settings                         ok
Checking for prepared transactions                            ok
Checking for contrib/isn with bigint-passing mismatch         ok
Checking for valid logical replication slots                  ok
Checking for subscription state                               ok
Checking for data type usage                                  ok
Creating dump of global objects                               ok
Creating dump of database schemas                             ok
Checking for presence of required libraries                   ok
Checking database user is the install user                    ok
Checking for prepared transactions                            ok
Checking for new cluster tablespace directories               ok

If pg_upgrade fails after this point, you must re-initdb the
new cluster before continuing.

Performing Upgrade
------------------
Setting locale and encoding for new cluster                   ok
Analyzing all rows in the new cluster                         ok
Freezing all rows in the new cluster                          ok
Deleting files from new pg_xact                               ok
Copying old pg_xact to new server                             ok
Setting oldest XID for new cluster                            ok
Setting next transaction ID and epoch for new cluster         ok
Deleting files from new pg_multixact/offsets                  ok
Copying old pg_multixact/offsets to new server                ok
Deleting files from new pg_multixact/members                  ok
Copying old pg_multixact/members to new server                ok
Setting next multixact ID and offset for new cluster          ok
Resetting WAL archives                                        ok
Setting frozenxid and minmxid counters in new cluster         ok
Restoring global objects in the new cluster                   ok
Restoring database schemas in the new cluster                 ok
Copying user relation files                                   ok
Setting next OID for new cluster                              ok
Creating script to delete old cluster                         ok
Checking for extension updates                                ok

Upgrade Complete
----------------
Optimizer statistics are not transferred by pg_upgrade.
Once you start the new server, consider running:
    C:/cirrus/build/TMP_IN~1/usr/local/pgsql/bin/vacuumdb --all --analyze-in-stages
Running this script will delete the old cluster's data files:
    delete_old_cluster.bat
[13:49:18.536](36.951s) ok 14 - run of pg_upgrade for new instance
[13:49:18.536](0.000s) ok 15 - pg_upgrade_output.d/ removed after pg_upgrade success
### Starting node "new_node"
# Running: pg_ctl -w -D C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_new_node_data/pgdata -l C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\log/002_pg_upgrade_new_node.log -o --cluster-name=new_node start
waiting for server to start.... done
server started
# Postmaster PID for node "new_node" is 4216
[13:49:19.725](1.188s) ok 16 - check that locales in new cluster match original cluster
# Running: pg_dumpall --no-sync -d port=51485 host=C:/Windows/TEMP/LZFgcOhnGj dbname='postgres' -f C:\cirrus\build\testrun\pg_upgrade\002_pg_upgrade\data\tmp_test_9QTe/dump2.sql
[13:49:24.039](4.314s) ok 17 - dump after running pg_upgrade
[13:49:24.325](0.286s) ok 18 - old and new dumps match after pg_upgrade
[13:49:24.327](0.001s) 1..18
### Stopping node "new_node" using mode immediate
# Running: pg_ctl -D C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_new_node_data/pgdata -m immediate stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "new_node"
[13:49:25.134](0.808s) # Looks like you failed 1 test of 18.