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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #17518: Getting Error "new multixact has more than one updating member" when trying to delete records.
Дата
Msg-id CAKFQuwaUdUhcaJWON_B6yVTjdyrqTGx3DiRM_J6xSW9qg7_pOQ@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #17518: Getting Error "new multixact has more than one updating member" when trying to delete records.  (PG Bug reporting form <noreply@postgresql.org>)
Ответы RE: BUG #17518: Getting Error "new multixact has more than one updating member" when trying to delete records.  ("Krier, Bob" <rkrier@cleo.com>)
Список pgsql-bugs
Дерево обсуждения
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.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: BUG #17518: Getting Error "new multixact has more than one updating member" when trying to delete records.
Следующее
От: "Krier, Bob"
Дата:
Сообщение: RE: BUG #17518: Getting Error "new multixact has more than one updating member" when trying to delete records.