pgsql: Try to harden insert-conflict-specconflict against autovacuum. - Mailing list pgsql-committers

From Andres Freund
Subject pgsql: Try to harden insert-conflict-specconflict against autovacuum.
Date
Msg-id E1j1kQP-0005c9-Ed@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Try to harden insert-conflict-specconflict against autovacuum.

Looks like guaibasaurus had a autovacuum running during the
controller_print_speculative_locks step (just added in
43e08419708). Which does indeed seem quite possible.

Avoid the problem by only looking for the backends participating in
the test.

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/997563dfcb2501a7a199589cd6f15f2bb8af3d04

Modified Files
--------------
.../isolation/expected/insert-conflict-specconflict.out   | 15 ++++++++++++---
.../isolation/specs/insert-conflict-specconflict.spec     |  5 ++++-
2 files changed, 16 insertions(+), 4 deletions(-)


pgsql-committers by date:

Previous
From: Andres Freund
Date:
Subject: Re: pgsql: Test additional speculative conflict scenarios.
Next
From: Fujii Masao
Date:
Subject: Re: pgsql: walreceiver uses a temporary replication slot by default