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(at)postgresql(dot)org> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 17518
> Logged by: Bob Krier
> Email address: rkrier(at)cleo(dot)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.