Instability in test/regress/sql/portals.sql - Mailing list pgsql-hackers

From Matthias van de Meent
Subject Instability in test/regress/sql/portals.sql
Date
Msg-id CAEze2Wi0hg46bcvLQrjid6Kvbb+NSR1N5OKbDNfHy2J=JutJ=Q@mail.gmail.com
Whole thread
Responses Re: Instability in test/regress/sql/portals.sql
List pgsql-hackers
Hi,

Internally at Databricks we've seen rare regression failures in the
portals.sql test, where the regression diff looks something like the
one attached in data_attachments_ed2b37649a9393b5.diffs.

It seems like this was caused by synchronized seqscans, which caused
the foo25ns cursor to start its seqscan not at the start of the table,
but instead with an offset into the table. This changed the output,
because that relied on the seqscan starting at the first page of the
table.

To stabilize this test, let's add SET synchronize_seqscans = off, as attached.

Kind regards,

Matthias van de Meent
Databricks (https://www.databricks.com)

Attachment

pgsql-hackers by date:

Previous
From: shihao zhong
Date:
Subject: Re: Add missing stats_reset column to pg_stat_database_conflicts view
Next
From: Alexander Korotkov
Date:
Subject: Re: Exit walsender before confirming remote flush in logical replication