Re: BUG #17518: Getting Error "new multixact has more than one updating member" when trying to delete records.

On Tue, Jun 14, 2022 at 9:03 AM PG Bug reporting form <
noreply@postgresql.org> wrote:

> The following bug has been logged on the website:
>
> Bug reference:      17518
> Logged by:          Bob Krier
> Email address:      rkrier@cleo.com
> PostgreSQL version: 12.10
> Operating system:   AWS RDS
> Description:
>
> We are getting an error executing a delete statement from JDBC like
> follows:
>
> DELETE FROM "EBI"."LOG_OF_CONNECTION" WHERE "DATE" < {some java date in
> milliseconds}.  The error is as follows:
> --->   "SQLException: ERROR: new multixact has more than one updating
> member"
>

If you try this via psql you don't see the error though?

Do you get the same error if you delete a single row using a PK instead of
a bunch of rows via a date inequality?

Does it seem to matter which rows are being deleted in general, or how
many?  How about columns?

Can you construct a self-contained minimal reproducer?

Does it manifest on standalone community PostgreSQL or just RDS?

David J.