installcheck fails when compute_query_id=on or pg_stat_statsement is loaded

From: Мельников Антон Андреевич <aamelnikov(at)inbox(dot)ru>
To: pgsql-hackers(at)postgresql(dot)org
Subject: installcheck fails when compute_query_id=on or pg_stat_statsement is loaded
Date: 2021-10-15 07:36:36
Message-ID: 1634283396.372373993@f75.i.mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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
 
 

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Bille 2021-10-15 07:44:39 Re: [Proposal] Global temporary tables
Previous Message Amit Langote 2021-10-15 07:13:19 Re: Partition Check not updated when insert into a partition