broken master regress tests - Mailing list pgsql-hackers

From Pavel Stehule
Subject broken master regress tests
Date
Msg-id CAFj8pRB=XVWC0orWu0FbjrmyOpAMLqJiau80YyQOYQPfMj8Xxw@mail.gmail.com
Whole thread Raw
Responses Re: broken master regress tests
Re: broken master regress tests
List pgsql-hackers
Hi

today build is broken on my Fedora 39

Regards

Pavel

make[2]: Opouští se adresář „/home/pavel/src/postgresql.master/src/bin/initdb“
make -C pg_amcheck check
make[2]: Vstupuje se do adresáře „/home/pavel/src/postgresql.master/src/bin/pg_amcheck“
echo "# +++ tap check in src/bin/pg_amcheck +++" && rm -rf '/home/pavel/src/postgresql.master/src/bin/pg_amcheck'/tmp_check && /usr/bin/mkdir -p '/home/pavel/src/postgresql.master/src/bin/pg_amcheck'/tmp_check && cd . && TESTLOGDIR='/home/pavel/src/postgresql.master/src/bin/pg_amcheck/tmp_check/log' TESTDATADIR='/home/pavel/src/postgresql.master/src/bin/pg_amcheck/tmp_check' PATH="/home/pavel/src/postgresql.master/tmp_install/usr/local/pgsql/master/bin:/home/pavel/src/postgresql.master/src/bin/pg_amcheck:$PATH" LD_LIBRARY_PATH="/home/pavel/src/postgresql.master/tmp_install/usr/local/pgsql/master/lib" INITDB_TEMPLATE='/home/pavel/src/postgresql.master'/tmp_install/initdb-template  PGPORT='65432' top_builddir='/home/pavel/src/postgresql.master/src/bin/pg_amcheck/../../..' PG_REGRESS='/home/pavel/src/postgresql.master/src/bin/pg_amcheck/../../../src/test/regress/pg_regress' /usr/bin/prove -I ../../../src/test/perl/ -I .  t/*.pl
# +++ tap check in src/bin/pg_amcheck +++
t/001_basic.pl ........... ok  
t/002_nonesuch.pl ........ ok    
t/003_check.pl ........... 1/?
#   Failed test 'pg_amcheck all schemas, tables and indexes in database db1 stdout /(?^:could not open file ".*": No such file or directory)/'
#   at t/003_check.pl line 345.
#                   'btree index "db1.s1.t1_btree":
#     ERROR:  index "t1_btree" lacks a main relation fork
# btree index "db1.s1.t2_btree":
#     ERROR:  could not open file "base/16384/16477.1" (target block 2862699856): previous segment is only 2 blocks
# btree index "db1.s3.t1_btree":
#     ERROR:  index "t1_btree" lacks a main relation fork
# btree index "db1.s3.t2_btree":
#     ERROR:  could not open file "base/16384/16601.1" (target block 2862699856): previous segment is only 2 blocks
# heap table "db1.s2.t1":
#     ERROR:  could not open file "base/16384/16491": Adresář nebo soubor neexistuje
# heap table "db1.s2.t2", block 0, offset 3:
#     line pointer redirection to item at offset 21840 exceeds maximum offset 4
# heap table "db1.s2.t2", block 0, offset 4:
#     line pointer to page offset 21840 with length 21840 ends beyond maximum page offset 8192
# heap table "db1.s3.t1":
#     ERROR:  could not open file "base/16384/16553": Adresář nebo soubor neexistuje
# heap table "db1.s3.t2", block 0, offset 3:
#     line pointer redirection to item at offset 21840 exceeds maximum offset 4
# heap table "db1.s3.t2", block 0, offset 4:
#     line pointer to page offset 21840 with length 21840 ends beyond maximum page offset 8192
# heap table "db1.s4.t2":
#     ERROR:  could not open file "base/16384/16623": Adresář nebo soubor neexistuje
# heap table "db1.s3.t1_mv":
#     ERROR:  could not open file "base/16384/16570": Adresář nebo soubor neexistuje
# heap table "db1.s3.t2_mv", block 0, offset 3:
#     line pointer redirection to item at offset 21840 exceeds maximum offset 4
# heap table "db1.s3.t2_mv", block 0, offset 4:
#     line pointer to page offset 21840 with length 21840 ends beyond maximum page offset 8192
# heap table "db1.s3.p1_1":
#     ERROR:  could not open file "base/16384/16588": Adresář nebo soubor neexistuje
# heap table "db1.pg_toast.pg_toast_16620":
#     ERROR:  could not open file "base/16384/16623": Adresář nebo soubor neexistuje
# '
#     doesn't match '(?^:could not open file ".*": No such file or directory)'
t/003_check.pl ........... 9/?
#   Failed test 'pg_amcheck all schemas, tables and indexes in databases db1, db2, and db3 stdout /(?^:could not open file ".*": No such file or directory)/'
#   at t/003_check.pl line 355.
#                   'btree index "db1.s1.t1_btree":
#     ERROR:  index "t1_btree" lacks a main relation fork
# btree index "db1.s1.t2_btree":
#     ERROR:  could not open file "base/16384/16477.1" (target block 2862699856): previous segment is only 2 blocks
# btree index "db1.s3.t1_btree":
#     ERROR:  index "t1_btree" lacks a main relation fork
# btree index "db1.s3.t2_btree":
#     ERROR:  could not open file "base/16384/16601.1" (target block 2862699856): previous segment is only 2 blocks
# heap table "db1.s2.t1":
#     ERROR:  could not open file "base/16384/16491": Adresář nebo soubor neexistuje
# heap table "db1.s2.t2", block 0, offset 3:
#     line pointer redirection to item at offset 21840 exceeds maximum offset 4
# heap table "db1.s2.t2", block 0, offset 4:
#     line pointer to page offset 21840 with length 21840 ends beyond maximum page offset 8192
# heap table "db1.s3.t1":
#     ERROR:  could not open file "base/16384/16553": Adresář nebo soubor neexistuje
# heap table "db1.s3.t2", block 0, offset 3:
#     line pointer redirection to item at offset 21840 exceeds maximum offset 4
# heap table "db1.s3.t2", block 0, offset 4:
#     line pointer to page offset 21840 with length 21840 ends beyond maximum page offset 8192
# heap table "db1.s4.t2":
#     ERROR:  could not open file "base/16384/16623": Adresář nebo soubor neexistuje
# heap table "db1.s3.t1_mv":
#     ERROR:  could not open file "base/16384/16570": Adresář nebo soubor neexistuje
# heap table "db1.s3.t2_mv", block 0, offset 3:
#     line pointer redirection to item at offset 21840 exceeds maximum offset 4
# heap table "db1.s3.t2_mv", block 0, offset 4:
#     line pointer to page offset 21840 with length 21840 ends beyond maximum page offset 8192
# heap table "db1.s3.p1_1":
#     ERROR:  could not open file "base/16384/16588": Adresář nebo soubor neexistuje
# heap table "db1.pg_toast.pg_toast_16620":
#     ERROR:  could not open file "base/16384/16623": Adresář nebo soubor neexistuje
# btree index "db2.s1.t1_btree":
#     ERROR:  index "t1_btree" lacks a main relation fork
# heap table "db2.s1.t1":
#     ERROR:  could not open file "base/16736/16781": Adresář nebo soubor neexistuje
# '
#     doesn't match '(?^:could not open file ".*": No such file or directory)'

#   Failed test 'pg_amcheck of db2.s1 excluding indexes stdout /(?^:could not open file ".*": No such file or directory)/'
#   at t/003_check.pl line 402.
#                   'heap table "db2.s1.t1":
#     ERROR:  could not open file "base/16736/16781": Adresář nebo soubor neexistuje
# '
#     doesn't match '(?^:could not open file ".*": No such file or directory)'

#   Failed test 'pg_amcheck schema s3 reports table and index errors stdout /(?^:could not open file ".*": No such file or directory)/'
#   at t/003_check.pl line 410.
#                   'btree index "db1.s3.t1_btree":
#     ERROR:  index "t1_btree" lacks a main relation fork
# btree index "db1.s3.t2_btree":
#     ERROR:  could not open file "base/16384/16601.1" (target block 2862699856): previous segment is only 2 blocks
# heap table "db1.s3.t1":
#     ERROR:  could not open file "base/16384/16553": Adresář nebo soubor neexistuje
# heap table "db1.s3.t2", block 0, offset 3:
#     line pointer redirection to item at offset 21840 exceeds maximum offset 4
# heap table "db1.s3.t2", block 0, offset 4:
#     line pointer to page offset 21840 with length 21840 ends beyond maximum page offset 8192
# heap table "db1.s3.t1_mv":
#     ERROR:  could not open file "base/16384/16570": Adresář nebo soubor neexistuje
# heap table "db1.s3.t2_mv", block 0, offset 3:
#     line pointer redirection to item at offset 21840 exceeds maximum offset 4
# heap table "db1.s3.t2_mv", block 0, offset 4:
#     line pointer to page offset 21840 with length 21840 ends beyond maximum page offset 8192
# heap table "db1.s3.p1_1":
#     ERROR:  could not open file "base/16384/16588": Adresář nebo soubor neexistuje
# '
#     doesn't match '(?^:could not open file ".*": No such file or directory)'

#   Failed test 'pg_amcheck in schema s4 reports toast corruption stdout /(?^:could not open file ".*": No such file or directory)/'
#   at t/003_check.pl line 423.
#                   'heap table "db1.s4.t2":
#     ERROR:  could not open file "base/16384/16623": Adresář nebo soubor neexistuje
# heap table "db1.pg_toast.pg_toast_16620":
#     ERROR:  could not open file "base/16384/16623": Adresář nebo soubor neexistuje
# '
#     doesn't match '(?^:could not open file ".*": No such file or directory)'
t/003_check.pl ........... 40/? # Looks like you failed 5 tests of 63.
t/003_check.pl ........... Dubious, test returned 5 (wstat 1280, 0x500)
Failed 5/63 subtests
t/004_verify_heapam.pl ... ok    
t/005_opclass_damage.pl .. ok  

Test Summary Report
-------------------
t/003_check.pl         (Wstat: 1280 (exited 5) Tests: 63 Failed: 5)
  Failed tests:  7, 12, 24, 29, 32
  Non-zero exit status: 5
Files=5, Tests=214,  9 wallclock secs ( 0.09 usr  0.01 sys +  1.65 cusr  1.59 csys =  3.34 CPU)
Result: FAIL
make[2]: *** [Makefile:48: check] Chyba 1
make[2]: Opouští se adresář „/home/pavel/src/postgresql.master/src/bin/pg_amcheck“
make[1]: *** [Makefile:43: check-pg_amcheck-recurse] Chyba 2
make[1]: Opouští se adresář „/home/pavel/src/postgresql.master/src/bin“
make: *** [GNUmakefile:71: check-world-src/bin-recurse] Chyba 2


pgsql-hackers by date:

Previous
From: Peter Smith
Date:
Subject: Re: [PoC] pg_upgrade: allow to upgrade publisher node
Next
From: Amit Kapila
Date:
Subject: Re: subscription/015_stream sometimes breaks