spurious pg_amcheck test failure - Mailing list pgsql-hackers

From Andres Freund
Subject spurious pg_amcheck test failure
Date
Msg-id ds3jgki252q3lddgpu2pwhr5e32lgzlqwwcetjcgt4ae2wgmxw@pph7n6t4hqsu
Whole thread Raw
List 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



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Add partial :-variable expansion to psql \copy
Next
From: Andres Freund
Date:
Subject: Re: fix: propagate M4 env variable to flex subprocess