ERROR: uncommitted xmin 347341220 from before xid cutoff 967029200 needs to be frozen

Hi All,

We recently started seeing an error “ERROR: uncommitted xmin 347341220
from before xid cutoff 967029200 needs to be frozen” on our user tables.
I’m unable to do ‘vacuum’, ‘vacuum freeze’ or ‘vacuum full’ on the
affected tables.

From what I read, this was a bug couple of years ago on System tables and
it was fixed long back.
However, we are seeing these errors on two of our User tables now.

After some Google search, I found the fix but, they seem to be temporary.

These are the solutions I found :
1. Truncate the table and restore the dump

2. remove ‘pg_internal.init’ from global directory

I’m not yet sure about removing the file ‘pg_internal.init’. So, I would
go ahead with table rebuilt for now.

Anyways, I would like to know if there is any permanent solution for this
issue as I did not find a proper solution.

We are running Postgresql 9.6.10 on SUSE 12.4 OS.
We are already in process of upgrading to the latest minor version of 9.6
and our Application supports only Postgres 9.6.x

I request you to please take a look at it and let me know the fix.