From: | Michael Paquier <michael(at)paquier(dot)xyz> |
---|---|
To: | Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> |
Cc: | Stepan Neretin <sndcppg(at)gmail(dot)com>, Nathan Bossart <nathandbossart(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Assertion failure when autovacuum drops orphan temp indexes. |
Date: | 2024-10-28 00:50:36 |
Message-ID: | Zx7f3GAAAbZBIyGu@paquier.xyz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Sun, Oct 27, 2024 at 05:19:45PM -0700, Masahiko Sawada wrote:
> my $psql1 = $node->interactive_psql('postgres');
> $psql1->query("create temp table test (a int primary key);");
> sleep(3);
>
> $node->stop('immediate');
> $node->start();
> $node->safe_psql('postgres', 'select 1');
>
> sleep(5);
> $node->safe_psql('postgres', 'select 1');
>
> ok(1);
> done_testing();
The assertion failure happens in an autovacuum worker. So if you are
looking for a test that can be integrated in the tree, you could get
some inspiration from 006_signal_autovacuum.pl and rely on an
injection point wait with the existing autovacuum-worker-start. My
2c, as it looks easy enough to avoid the hardcoded waits.
--
Michael
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2024-10-28 00:52:56 | Re: Add isolation test template in injection_points for wait/wakeup/detach |
Previous Message | Masahiko Sawada | 2024-10-28 00:19:45 | Re: Assertion failure when autovacuum drops orphan temp indexes. |