diff -U3 /tmp/cirrus-ci-build/contrib/pageinspect/expected/brin.out /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/brin.out --- /tmp/cirrus-ci-build/contrib/pageinspect/expected/brin.out 2024-10-19 12:29:43.065842429 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/brin.out 2024-10-19 12:34:35.016769300 +0000 @@ -161,50 +161,7 @@ SELECT * FROM brin_page_items(get_raw_page('brin_test_parallel_idx', 2), 'brin_test_parallel_idx') EXCEPT SELECT * FROM brin_page_items(get_raw_page('brin_test_serial_idx', 2), 'brin_test_serial_idx'); - itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty | value -------------+--------+--------+----------+----------+-------------+-------+------- -(0 rows) - -SELECT * FROM brin_page_items(get_raw_page('brin_test_serial_idx', 2), 'brin_test_serial_idx') -EXCEPT -SELECT * FROM brin_page_items(get_raw_page('brin_test_parallel_idx', 2), 'brin_test_parallel_idx'); - itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty | value -------------+--------+--------+----------+----------+-------------+-------+------- -(0 rows) - -DROP INDEX brin_test_parallel_idx; --- force parallel build, but don't allow starting parallel workers to force --- fallback to serial build, and repeat the checks -SET max_parallel_workers = 0; -CREATE INDEX brin_test_parallel_idx ON brin_parallel_test - USING brin (a int4_minmax_ops, a int4_bloom_ops, b, c int8_minmax_multi_ops) - WITH (pages_per_range=7) - WHERE NOT (a BETWEEN 1000 and 1500); -SELECT relname, relpages - FROM pg_class - WHERE relname IN ('brin_test_serial_idx', 'brin_test_parallel_idx') - ORDER BY relname; - relname | relpages -------------------------+---------- - brin_test_parallel_idx | 4 - brin_test_serial_idx | 4 -(2 rows) - -SELECT * FROM brin_page_items(get_raw_page('brin_test_parallel_idx', 2), 'brin_test_parallel_idx') -EXCEPT -SELECT * FROM brin_page_items(get_raw_page('brin_test_serial_idx', 2), 'brin_test_serial_idx'); - itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty | value -------------+--------+--------+----------+----------+-------------+-------+------- -(0 rows) - -SELECT * FROM brin_page_items(get_raw_page('brin_test_serial_idx', 2), 'brin_test_serial_idx') -EXCEPT -SELECT * FROM brin_page_items(get_raw_page('brin_test_parallel_idx', 2), 'brin_test_parallel_idx'); - itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty | value -------------+--------+--------+----------+----------+-------------+-------+------- -(0 rows) - -DROP TABLE brin_parallel_test; -RESET min_parallel_table_scan_size; -RESET max_parallel_maintenance_workers; -RESET maintenance_work_mem; +server closed the connection unexpectedly + This probably means the server terminated abnormally + before or while processing the request. +connection to server was lost diff -U3 /tmp/cirrus-ci-build/contrib/pageinspect/expected/checksum.out /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/checksum.out --- /tmp/cirrus-ci-build/contrib/pageinspect/expected/checksum.out 2024-10-19 12:29:43.065842429 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/checksum.out 2024-10-19 12:34:35.692768808 +0000 @@ -1,40 +1 @@ --- --- Verify correct calculation of checksums --- --- Postgres' checksum algorithm produces different answers on little-endian --- and big-endian machines. The results of this test also vary depending --- on the configured block size. This test has several different expected --- results files to handle the following possibilities: --- --- BLCKSZ end file --- 8K LE checksum.out --- 8K BE checksum_1.out --- --- In future we might provide additional expected-results files for other --- block sizes, but there seems little point as long as so many other --- test scripts also show false failures for non-default block sizes. --- --- This is to label the results files with blocksize: -SHOW block_size; - block_size ------------- - 8192 -(1 row) - -SHOW block_size \gset --- Apply page_checksum() to some different data patterns and block numbers -SELECT blkno, - page_checksum(decode(repeat('01', :block_size), 'hex'), blkno) AS checksum_01, - page_checksum(decode(repeat('04', :block_size), 'hex'), blkno) AS checksum_04, - page_checksum(decode(repeat('ff', :block_size), 'hex'), blkno) AS checksum_ff, - page_checksum(decode(repeat('abcd', :block_size / 2), 'hex'), blkno) AS checksum_abcd, - page_checksum(decode(repeat('e6d6', :block_size / 2), 'hex'), blkno) AS checksum_e6d6, - page_checksum(decode(repeat('4a5e', :block_size / 2), 'hex'), blkno) AS checksum_4a5e - FROM generate_series(0, 100, 50) AS a (blkno); - blkno | checksum_01 | checksum_04 | checksum_ff | checksum_abcd | checksum_e6d6 | checksum_4a5e --------+-------------+-------------+-------------+---------------+---------------+--------------- - 0 | 1175 | 28338 | 3612 | -30781 | -16269 | -27377 - 50 | 1225 | 28352 | 3598 | -30795 | -16251 | -27391 - 100 | 1139 | 28438 | 3648 | -30881 | -16305 | -27349 -(3 rows) - +psql: error: connection to server on socket "/tmp/pg_regress-Yr2etr/.s.PGSQL.40028" failed: FATAL: the database system is in recovery mode diff -U3 /tmp/cirrus-ci-build/contrib/pageinspect/expected/oldextversions.out /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/oldextversions.out --- /tmp/cirrus-ci-build/contrib/pageinspect/expected/oldextversions.out 2024-10-19 12:29:43.065842429 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/oldextversions.out 2024-10-19 12:34:35.812768721 +0000 @@ -1,56 +1,2 @@ --- test old extension version entry points -DROP EXTENSION pageinspect; -CREATE EXTENSION pageinspect VERSION '1.8'; -CREATE TABLE test1 (a int8, b text); -INSERT INTO test1 VALUES (72057594037927937, 'text'); -CREATE INDEX test1_a_idx ON test1 USING btree (a); --- from page.sql -SELECT octet_length(get_raw_page('test1', 0)) AS main_0; - main_0 --------- - 8192 -(1 row) - -SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0; - main_0 --------- - 8192 -(1 row) - -SELECT page_checksum(get_raw_page('test1', 0), 0) IS NOT NULL AS silly_checksum_test; - silly_checksum_test ---------------------- - t -(1 row) - --- from btree.sql -SELECT * FROM bt_page_stats('test1_a_idx', 1); - blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags --------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------ - 1 | l | 1 | 0 | 16 | 8192 | 8128 | 0 | 0 | 0 | 3 -(1 row) - -SELECT * FROM bt_page_items('test1_a_idx', 1); - itemoffset | ctid | itemlen | nulls | vars | data | dead | htid | tids -------------+-------+---------+-------+------+-------------------------+------+-------+------ - 1 | (0,1) | 16 | f | f | 01 00 00 00 00 00 00 01 | f | (0,1) | -(1 row) - --- page_header() uses int instead of smallint for lower, upper, special and --- pagesize in pageinspect >= 1.10. -ALTER EXTENSION pageinspect UPDATE TO '1.9'; -\df page_header - List of functions - Schema | Name | Result data type | Argument data types | Type ---------+-------------+------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------ - public | page_header | record | page bytea, OUT lsn pg_lsn, OUT checksum smallint, OUT flags smallint, OUT lower smallint, OUT upper smallint, OUT special smallint, OUT pagesize smallint, OUT version smallint, OUT prune_xid xid | func -(1 row) - -SELECT pagesize, version FROM page_header(get_raw_page('test1', 0)); - pagesize | version -----------+--------- - 8192 | 4 -(1 row) - -DROP TABLE test1; -DROP EXTENSION pageinspect; +psql: error: connection to server on socket "/tmp/pg_regress-Yr2etr/.s.PGSQL.40028" failed: FATAL: the database system is not yet accepting connections +DETAIL: Consistent recovery state has not been yet reached.