spurious pg_amcheck test failure

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Subject: spurious pg_amcheck test failure
Date: 2025-05-13 15:25:21
Message-ID: ds3jgki252q3lddgpu2pwhr5e32lgzlqwwcetjcgt4ae2wgmxw@pph7n6t4hqsu
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

In a rare CI failure I just noticed:

https://cirrus-ci.com/task/4901437240508416
https://api.cirrus-ci.com/v1/artifact/task/4901437240508416/testrun/build/testrun/pg_amcheck/002_nonesuch/log/regress_log_002_nonesuch

[11:38:06.031](0.000s) # Failed test 'schema exclusion pattern overrides all inclusion patterns stderr /(?^:pg_amcheck: warning: skipping database "template1": amcheck is not installed)/'
# at /Users/admin/pgsql/src/bin/pg_amcheck/t/002_nonesuch.pl line 400.
[11:38:06.031](0.000s) # 'pg_amcheck: warning: skipping database "another_db": amcheck is not installed
# '
# doesn't match '(?^:pg_amcheck: warning: skipping database "template1": amcheck is not installed)'
[11:38:06.031](0.000s) not ok 107 - schema exclusion pattern overrides all inclusion patterns stderr /(?^:pg_amcheck: error: no relations to check)/
[11:38:06.031](0.000s) # Failed test 'schema exclusion pattern overrides all inclusion patterns stderr /(?^:pg_amcheck: error: no relations to check)/'
# at /Users/admin/pgsql/src/bin/pg_amcheck/t/002_nonesuch.pl line 400.
[11:38:06.031](0.000s) # 'pg_amcheck: warning: skipping database "another_db": amcheck is not installed
# '
# doesn't match '(?^:pg_amcheck: error: no relations to check)'

I don't really understand how there can be an *occasional* reordering of the
database list - afaict the pg_amcheck query has an ORDER BY that should
prevent that?
") AS combined_records"
"\nORDER BY pattern_id NULLS LAST, datname");

Greetings,

Andres Freund

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2025-05-13 15:54:42 Re: fix: propagate M4 env variable to flex subprocess
Previous Message Andres Freund 2025-05-13 13:57:46 Re: Add partial :-variable expansion to psql \copy