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
