Stabilize test_decoding touching with sequences
Tomas Vondra <tomas.vondra@postgresql.org>
Stabilize test_decoding touching with sequences Some of the test_decoding regression tests are unstable due to modifying a sequence. The first increment of a sequence after a checkpoint is always logged (and thus decoded), which makes the output unpredictable. The runs are usually much shorter than a checkpoint internal, so these failures are rare, but we've seen a couple of them on animals that are either slow or are running with valgrind/clobber cache/... Fixed by skipping sequence decoding in most tests, with the exception of the test aimed at testing decoding of sequences. Reported-by: Amita Kapila Discussion: https://postgr.es/m/d045f3c2-6cfb-06d3-5540-e63c320df8bc@enterprisedb.com
Files
| Path | Change | +/− |
|---|---|---|
| contrib/test_decoding/expected/ddl.out | modified | +13 −13 |
| contrib/test_decoding/expected/decoding_in_xact.out | modified | +1 −1 |
| contrib/test_decoding/expected/replorigin.out | modified | +4 −4 |
| contrib/test_decoding/expected/rewrite.out | modified | +1 −1 |
| contrib/test_decoding/expected/slot.out | modified | +3 −3 |
| contrib/test_decoding/sql/ddl.sql | modified | +13 −13 |
| contrib/test_decoding/sql/decoding_in_xact.sql | modified | +1 −1 |
| contrib/test_decoding/sql/replorigin.sql | modified | +4 −4 |
| contrib/test_decoding/sql/rewrite.sql | modified | +1 −1 |
| contrib/test_decoding/sql/slot.sql | modified | +3 −3 |
Discussion
- logical decoding and replication of sequences 129 messages · 2021-06-07 → 2022-08-29