From: Мельников Антон Андреевич <aamelnikov@inbox.ru>
To: pgsql-hackers@postgresql.org
Subject: installcheck fails when compute_query_id=on or pg_stat_statsement is loaded
Date: Fri, 15 Oct 2021 10:36:36 +0300
Message-ID: <1634283396.372373993@f75.i.mail.ru> (raw)
Hello!
When extension pg_stat_statsement is loaded into memory or compute_query_id=on in postgesql.conf
many of installcheck tests give errors.
The thing is that in *.out files appear lines "queryid = xxxxx" where xxxxx - some numeric value.
So 24 of 209 installcheck tests will fail.
It seems to be a normal behaviour as queryid calculation was moved into core in
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=5fd9dfa5f5
but tests say that something wrong.
Create test variants is not the way, as queryid value varies randomly
from test to test at the same enviroment.
I think this is a problem because these fake errors can mask a real errors in relevant tests.
What’s your opinion?
Best regards,
Anton Melnikov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: aamelnikov@inbox.ru
Subject: Re: installcheck fails when compute_query_id=on or pg_stat_statsement is loaded
In-Reply-To: <1634283396.372373993@f75.i.mail.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox