Re: ERROR: cannot freeze committed xmax

2021-07-16 Thread Sasha Aliashkevich
Hi Alvaro, glad to hear from you! This database is relatevely young, it was initdb'ed about a year ago or so and it was initially at 10.x. I don't know the exact minor version but the major version was 10 for sure. The problematic row is actually visible: SELECT COUNT(*) FROM pg_proc WHER

Re: ERROR: cannot freeze committed xmax

2021-07-15 Thread Alvaro Herrera
One thing I forgot is that these XIDs are fairly old, perhaps dating back to when this database was freshly initdb'd if there has been no XID wraparound. In that case you were probably running a version much older than 10.14 when they were written. Do you happen to know when did you initdb this,

Re: ERROR: cannot freeze committed xmax

2021-07-15 Thread Alvaro Herrera
Hi Sasha On 2021-Jul-14, Sasha Aliashkevich wrote: > lp | ctid | xmin| xmax | xmax_is_lock | xmax_committed | > xmax_rolled_back | xmax_multixact > +-+---+--+--++--+ > 19 | (75,21) | 571 | 572