From: | "Krier, Bob" <rkrier(at)cleo(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | RE: BUG #17518: Getting Error "new multixact has more than one updating member" when trying to delete records. |
Date: | 2022-06-27 16:36:03 |
Message-ID: | BYAPR17MB27753908B9A073453EDFD3E8A5B99@BYAPR17MB2775.namprd17.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi David,
Thanks for the response.
* I haven’t tried via psql. I only have a snapshot of the customer’s database that I can restore in RDS. It is very time consuming to set this up. I’ve corrected the problem by running VACUUM (FULL, FREEZE, VERBOSE, ANALYZE, INDEX_CLEANUP, TRUNCATE) on the table and the problem is resolved.
* Deleting by date where it only matches to 1 row seems to work. If I match on more than one, it seems to fail. I’m not sure what conditions make it happen. I have not tried to delete by PK. I’m not sure what you mean by “How about columns?”. You don’t specify columns on a delete statement.
* Can I construct a self-contained minimal reproducer?: No unfortunately exporting the table and importing it to another Postgres instance does not reproduce the issue. Again the vacuum above corrects the issue.
* Does it manifiest standalone…? Again I only have the snapshot to restore on RDS and can reproduce it that way.
Again, the issue is resolved. Thanks for your attention to this!
Bob
Bob
Krier
Cleo |
Principal Software Engineer II
Tel: 815-986-6759
Email: rkrier(at)cleo(dot)com
|
Web: www.cleo.com
Request a Demo |
Take a tour of CIC Cockpit with RADAR
From: David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
Sent: Saturday, June 25, 2022 4:52 PM
To: Krier, Bob <rkrier(at)cleo(dot)com>; PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: 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<mailto: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<mailto: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.
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2022-06-27 17:11:21 | Re: BUG #17518: Getting Error "new multixact has more than one updating member" when trying to delete records. |
Previous Message | David G. Johnston | 2022-06-25 23:51:59 | Re: BUG #17518: Getting Error "new multixact has more than one updating member" when trying to delete records. |