Why is parula failing?
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql-hackers@lists.postgresql.org
Cc: tharar@amazon.com
Date: 2024-03-19T19:58:38Z
Lists: pgsql-hackers
For the last few days, buildfarm member parula has been intermittently failing the partition_prune regression test, due to unexpected plan changes [1][2][3][4]. The symptoms can be reproduced exactly by inserting a "vacuum" of one or another of the partitions of table "ab", so we can presume that the underlying cause is an autovacuum run against one of those tables. But why is that happening? None of those tables receive any insertions during the test, so I don't understand why autovacuum would trigger on them. I suppose we could attach "autovacuum=off" settings to these tables, but it doesn't seem to me that that should be necessary. These test cases are several years old and haven't given trouble before. Moreover, if that's necessary then there are a lot of other regression tests that would presumably need the same treatment. I'm also baffled why this wasn't happening before. I scraped the buildfarm logs for 3 months back and confirmed my impression that this is a new failure mode. But one of these four runs is on REL_14_STABLE, eliminating the theory that the cause is a recent HEAD-only change. Any ideas? regards, tom lane [1] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=parula&dt=2024-03-19%2016%3A09%3A02 [2] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=parula&dt=2024-03-18%2011%3A13%3A02 [3] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=parula&dt=2024-03-14%2011%3A40%3A02 [4] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=parula&dt=2024-03-14%2019%3A00%3A02
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Revert "Temporarily install debugging in partition_prune test"
- ec1a405adc24 17.0 landed
-
Temporarily install debugging in partition_prune test
- 1db689715d44 17.0 landed
-
Review wording on tablespaces w.r.t. partitioned tables
- a0390f6ca6c7 17.0 cited