On 2019-Oct-07, Moreno Andreo wrote: > Unfortunately, it didn't work :( > > db0=# select * from failing_table where ctid='(3160,31)' for update; > ERROR: MultiXactId 12800 has not been created yet -- apparent wraparound
Oh well. It was a long shot anyway ... > Since the probability we are into corruption is very high, what if I \copy > all the table but the failing row(s) to an external file, drop and recreate > the table, and then \copy clean data back inside? Yes, that should work. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
