Subject: Re: BUG #17116: Assert failed in SerialSetActiveSerXmin() on commit
 of parallelized serializable transaction
To: Thomas Munro <thomas.munro@gmail.com>
Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
References: <17116-d6ca217acc180e30@postgresql.org>
 <CA+hUKGJCUnwUbydS8HSOdbjnrYKG+TtHe7wqyt58FGp71irnrw@mail.gmail.com>
 <CA+hUKGJmSjkA4qp1ywKvZXc8EA8vW_rPbObzmowuYTo0eF910A@mail.gmail.com>
 <66a6851c-e213-b31a-c8e6-789ab06e17f1@gmail.com>
 <CA+hUKGKNQc9q+bUMyYWVKAuKgtrS-aY-AW0V1vzYm6FkMnYFqQ@mail.gmail.com>
From: Alexander Lakhin <exclusion@gmail.com>
Message-ID: <d1ff80d3-4191-0b30-d9ce-aa11b95c2d00@gmail.com>
Date: Wed, 28 Jul 2021 00:00:00 +0300
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.7.1
MIME-Version: 1.0
In-Reply-To: 
 <CA+hUKGKNQc9q+bUMyYWVKAuKgtrS-aY-AW0V1vzYm6FkMnYFqQ@mail.gmail.com>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
Content-Language: en-US
Archived-At: 
 <https://www.postgresql.org/message-id/d1ff80d3-4191-0b30-d9ce-aa11b95c2d00%40gmail.com>
Precedence: bulk

Hello Thomas,
27.07.2021 14:17, Thomas Munro wrote:
> Reproduced here using a similar approach.  It doesn't fail with this
> new draft patch.  The main thing I have learned is that
> serializable-parallel-2.sql isn't really testing a very interesting
> code path.  I'll try to come up with a better test.
Thanks! With the new fix applied, my multiple installcheck test survives
100+ iterations. (Except for read-only-anomaly-3, that causes another
assertion fail but I believe that it's not related to the initial issue
and deserves another bug report.)

Best regards,
Alexander