diff -U3 /tmp/cirrus-ci-build/contrib/pg_walinspect/expected/pg_walinspect.out /tmp/cirrus-ci-build/build/testrun/pg_walinspect/regress/results/pg_walinspect.out --- /tmp/cirrus-ci-build/contrib/pg_walinspect/expected/pg_walinspect.out 2024-03-20 02:04:32.403444225 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_walinspect/regress/results/pg_walinspect.out 2024-03-20 02:10:58.663098514 +0000 @@ -39,235 +39,7 @@ ERROR: WAL input LSN must be less than current LSN -- Success with end LSNs. SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_records_info(:'wal_lsn1', 'FFFFFFFF/FFFFFFFF'); - ok ----- - t -(1 row) - -SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_stats(:'wal_lsn1', 'FFFFFFFF/FFFFFFFF'); - ok ----- - t -(1 row) - -SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_block_info(:'wal_lsn1', 'FFFFFFFF/FFFFFFFF'); - ok ----- - t -(1 row) - --- Failures with start LSNs. -SELECT * FROM pg_get_wal_records_info('FFFFFFFF/FFFFFFFE', 'FFFFFFFF/FFFFFFFF'); -ERROR: WAL start LSN must be less than current LSN -SELECT * FROM pg_get_wal_stats('FFFFFFFF/FFFFFFFE', 'FFFFFFFF/FFFFFFFF'); -ERROR: WAL start LSN must be less than current LSN -SELECT * FROM pg_get_wal_block_info('FFFFFFFF/FFFFFFFE', 'FFFFFFFF/FFFFFFFF'); -ERROR: WAL start LSN must be less than current LSN --- =================================================================== --- Tests for all function executions --- =================================================================== -SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_record_info(:'wal_lsn1'); - ok ----- - t -(1 row) - -SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_records_info(:'wal_lsn1', :'wal_lsn2'); - ok ----- - t -(1 row) - -SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_stats(:'wal_lsn1', :'wal_lsn2'); - ok ----- - t -(1 row) - -SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_block_info(:'wal_lsn1', :'wal_lsn2'); - ok ----- - t -(1 row) - --- =================================================================== --- Test for filtering out WAL records of a particular table --- =================================================================== -SELECT oid AS sample_tbl_oid FROM pg_class WHERE relname = 'sample_tbl' \gset -SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_records_info(:'wal_lsn1', :'wal_lsn2') - WHERE block_ref LIKE concat('%', :'sample_tbl_oid', '%') AND resource_manager = 'Heap'; - ok ----- - t -(1 row) - --- =================================================================== --- Test for filtering out WAL records based on resource_manager and --- record_type --- =================================================================== -SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_records_info(:'wal_lsn1', :'wal_lsn2') - WHERE resource_manager = 'Heap' AND record_type = 'INSERT'; - ok ----- - t -(1 row) - --- =================================================================== --- Tests to get block information from WAL record --- =================================================================== --- Update table to generate some block data. -SELECT pg_current_wal_lsn() AS wal_lsn3 \gset -UPDATE sample_tbl SET col1 = col1 + 1 WHERE col1 = 1; -SELECT pg_current_wal_lsn() AS wal_lsn4 \gset --- Check if we get block data from WAL record. -SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_block_info(:'wal_lsn3', :'wal_lsn4') - WHERE relfilenode = :'sample_tbl_oid' AND block_data IS NOT NULL; - ok ----- - t -(1 row) - --- Force a checkpoint so that the next update will log a full-page image. -SELECT pg_current_wal_lsn() AS wal_lsn5 \gset -CHECKPOINT; --- Verify that an XLOG_CHECKPOINT_REDO record begins at precisely the redo LSN --- of the checkpoint we just performed. -SELECT redo_lsn FROM pg_control_checkpoint() \gset -SELECT start_lsn = :'redo_lsn'::pg_lsn AS same_lsn, resource_manager, - record_type FROM pg_get_wal_record_info(:'redo_lsn'); - same_lsn | resource_manager | record_type -----------+------------------+----------------- - t | XLOG | CHECKPOINT_REDO -(1 row) - --- This update should produce a full-page image because of the checkpoint. -UPDATE sample_tbl SET col1 = col1 + 1 WHERE col1 = 2; -SELECT pg_current_wal_lsn() AS wal_lsn6 \gset --- Check if we get FPI from WAL record. -SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_block_info(:'wal_lsn5', :'wal_lsn6') - WHERE relfilenode = :'sample_tbl_oid' AND block_fpi_data IS NOT NULL; - ok ----- - t -(1 row) - --- =================================================================== --- Tests for permissions --- =================================================================== -CREATE ROLE regress_pg_walinspect; -SELECT has_function_privilege('regress_pg_walinspect', - 'pg_get_wal_record_info(pg_lsn)', 'EXECUTE'); -- no - has_function_privilege ------------------------- - f -(1 row) - -SELECT has_function_privilege('regress_pg_walinspect', - 'pg_get_wal_records_info(pg_lsn, pg_lsn) ', 'EXECUTE'); -- no - has_function_privilege ------------------------- - f -(1 row) - -SELECT has_function_privilege('regress_pg_walinspect', - 'pg_get_wal_stats(pg_lsn, pg_lsn, boolean) ', 'EXECUTE'); -- no - has_function_privilege ------------------------- - f -(1 row) - -SELECT has_function_privilege('regress_pg_walinspect', - 'pg_get_wal_block_info(pg_lsn, pg_lsn, boolean) ', 'EXECUTE'); -- no - has_function_privilege ------------------------- - f -(1 row) - --- Functions accessible by users with role pg_read_server_files. -GRANT pg_read_server_files TO regress_pg_walinspect; -SELECT has_function_privilege('regress_pg_walinspect', - 'pg_get_wal_record_info(pg_lsn)', 'EXECUTE'); -- yes - has_function_privilege ------------------------- - t -(1 row) - -SELECT has_function_privilege('regress_pg_walinspect', - 'pg_get_wal_records_info(pg_lsn, pg_lsn) ', 'EXECUTE'); -- yes - has_function_privilege ------------------------- - t -(1 row) - -SELECT has_function_privilege('regress_pg_walinspect', - 'pg_get_wal_stats(pg_lsn, pg_lsn, boolean) ', 'EXECUTE'); -- yes - has_function_privilege ------------------------- - t -(1 row) - -SELECT has_function_privilege('regress_pg_walinspect', - 'pg_get_wal_block_info(pg_lsn, pg_lsn, boolean) ', 'EXECUTE'); -- yes - has_function_privilege ------------------------- - t -(1 row) - -REVOKE pg_read_server_files FROM regress_pg_walinspect; --- Superuser can grant execute to other users. -GRANT EXECUTE ON FUNCTION pg_get_wal_record_info(pg_lsn) - TO regress_pg_walinspect; -GRANT EXECUTE ON FUNCTION pg_get_wal_records_info(pg_lsn, pg_lsn) - TO regress_pg_walinspect; -GRANT EXECUTE ON FUNCTION pg_get_wal_stats(pg_lsn, pg_lsn, boolean) - TO regress_pg_walinspect; -GRANT EXECUTE ON FUNCTION pg_get_wal_block_info(pg_lsn, pg_lsn, boolean) - TO regress_pg_walinspect; -SELECT has_function_privilege('regress_pg_walinspect', - 'pg_get_wal_record_info(pg_lsn)', 'EXECUTE'); -- yes - has_function_privilege ------------------------- - t -(1 row) - -SELECT has_function_privilege('regress_pg_walinspect', - 'pg_get_wal_records_info(pg_lsn, pg_lsn) ', 'EXECUTE'); -- yes - has_function_privilege ------------------------- - t -(1 row) - -SELECT has_function_privilege('regress_pg_walinspect', - 'pg_get_wal_stats(pg_lsn, pg_lsn, boolean) ', 'EXECUTE'); -- yes - has_function_privilege ------------------------- - t -(1 row) - -SELECT has_function_privilege('regress_pg_walinspect', - 'pg_get_wal_block_info(pg_lsn, pg_lsn, boolean) ', 'EXECUTE'); -- yes - has_function_privilege ------------------------- - t -(1 row) - -REVOKE EXECUTE ON FUNCTION pg_get_wal_record_info(pg_lsn) - FROM regress_pg_walinspect; -REVOKE EXECUTE ON FUNCTION pg_get_wal_records_info(pg_lsn, pg_lsn) - FROM regress_pg_walinspect; -REVOKE EXECUTE ON FUNCTION pg_get_wal_stats(pg_lsn, pg_lsn, boolean) - FROM regress_pg_walinspect; -REVOKE EXECUTE ON FUNCTION pg_get_wal_block_info(pg_lsn, pg_lsn, boolean) - FROM regress_pg_walinspect; --- =================================================================== --- Clean up --- =================================================================== -DROP ROLE regress_pg_walinspect; -SELECT pg_drop_replication_slot('regress_pg_walinspect_slot'); - pg_drop_replication_slot --------------------------- - -(1 row) - -DROP TABLE sample_tbl; -DROP EXTENSION pg_walinspect; +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/pg_walinspect/expected/oldextversions.out /tmp/cirrus-ci-build/build/testrun/pg_walinspect/regress/results/oldextversions.out --- /tmp/cirrus-ci-build/contrib/pg_walinspect/expected/oldextversions.out 2024-03-20 02:04:32.403444225 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_walinspect/regress/results/oldextversions.out 2024-03-20 02:10:58.679098500 +0000 @@ -1,5 +1,6 @@ -- Test old extension version entry points. CREATE EXTENSION pg_walinspect WITH VERSION '1.0'; +ERROR: extension "pg_walinspect" already exists -- Mask DETAIL messages as these could refer to current LSN positions. \set VERBOSITY terse -- List what version 1.0 contains, using a locale-independent sorting. @@ -9,45 +10,34 @@ refobjid = (SELECT oid FROM pg_extension WHERE extname = 'pg_walinspect') AND deptype = 'e' ORDER BY pg_describe_object(classid, objid, 0) COLLATE "C"; - obj ------------------------------------------------------------ + obj +------------------------------------------------------- + function pg_get_wal_block_info(pg_lsn,pg_lsn,boolean) function pg_get_wal_record_info(pg_lsn) function pg_get_wal_records_info(pg_lsn,pg_lsn) - function pg_get_wal_records_info_till_end_of_wal(pg_lsn) function pg_get_wal_stats(pg_lsn,pg_lsn,boolean) - function pg_get_wal_stats_till_end_of_wal(pg_lsn,boolean) -(5 rows) +(4 rows) -- Make sure checkpoints don't interfere with the test. SELECT 'init' FROM pg_create_physical_replication_slot('regress_pg_walinspect_slot', true, false); - ?column? ----------- - init -(1 row) - +ERROR: replication slot "regress_pg_walinspect_slot" already exists CREATE TABLE sample_tbl(col1 int, col2 int); +ERROR: relation "sample_tbl" already exists SELECT pg_current_wal_lsn() AS wal_lsn1 \gset INSERT INTO sample_tbl SELECT * FROM generate_series(1, 2); -- Tests for the past functions. SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_records_info_till_end_of_wal(:'wal_lsn1'); - ok ----- - t -(1 row) - +ERROR: function pg_get_wal_records_info_till_end_of_wal(unknown) does not exist at character 33 SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_stats_till_end_of_wal(:'wal_lsn1'); - ok ----- - t -(1 row) - +ERROR: function pg_get_wal_stats_till_end_of_wal(unknown) does not exist at character 33 -- Failures with start LSNs. SELECT * FROM pg_get_wal_records_info_till_end_of_wal('FFFFFFFF/FFFFFFFF'); -ERROR: WAL start LSN must be less than current LSN +ERROR: function pg_get_wal_records_info_till_end_of_wal(unknown) does not exist at character 15 SELECT * FROM pg_get_wal_stats_till_end_of_wal('FFFFFFFF/FFFFFFFF'); -ERROR: WAL start LSN must be less than current LSN +ERROR: function pg_get_wal_stats_till_end_of_wal(unknown) does not exist at character 15 -- Move to new version 1.1. ALTER EXTENSION pg_walinspect UPDATE TO '1.1'; +NOTICE: version "1.1" of extension "pg_walinspect" is already installed -- List what version 1.1 contains. \dx+ pg_walinspect Objects in extension "pg_walinspect"