Re: Fix for visibility check on 14.5 fails on tpcc with high concurrency

Dimos Stamatakis <dimos.stamatakis@servicenow.com>

From: Dimos Stamatakis <dimos.stamatakis@servicenow.com>

To: Alvaro Herrera <alvherre@alvh.no-ip.org>

Cc: Peter Geoghegan <pg@bowt.ie>, "simon.riggs@enterprisedb.com" <simon.riggs@enterprisedb.com>, "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>

Date: 2022-11-29T18:21:54Z

Lists: pgsql-hackers

[External Email]

On 2022-Nov-25, Dimos Stamatakis wrote:

> So does this mean there is no race condition in this case and that
> this error is redundant?

No, it means I believe a bug exists but that I haven't spent enough time
on it to understand what it is.

Great! Please keep me posted and let me know if you need any more evidence to debug. 😊

Thanks,
Dimos

Commits

Make multixact error message more explicit
- f63f29733e2f 15.2 landed
- de95928ea071 12.14 landed
- b20e38142208 11.19 landed
- 8e7c86785a11 14.7 landed
- 5a185246f9a7 13.10 landed
- 2cf41cd30997 16.0 landed
Fix visibility check when XID is committed in CLOG but not in procarray.
- e24615a0057a 14.5 cited