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.
|
| Список | 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 по дате отправления: