Re: BUG #15231: After Upgrade from 9.3.23 to 9.6.9 getting ERROR:found xmin 598 from before relfrozenxid 68569164 - Mailing list pgsql-bugs

From pinker
Subject Re: BUG #15231: After Upgrade from 9.3.23 to 9.6.9 getting ERROR:found xmin 598 from before relfrozenxid 68569164
Date
Msg-id 1541268103049-0.post@n3.nabble.com
Whole thread Raw
In response to Re: BUG #15231: After Upgrade from 9.3.23 to 9.6.9 getting ERROR: found xmin 598 from before relfrozenxid 68569164  (Sergei Kornilov <sk@zsrv.org>)
List pgsql-bugs
I have the same problem after upgrading to 10.4.9:

2018-11-03 00:06:14 CET [41253]: [1-1] user=, db=, app=, client= ERROR: 
found xmin 2502024502 from before relfrozenxid 150137048
2018-11-03 00:06:14 CET [41253]: [2-1] user=, db=, app=, client= CONTEXT: 
automatic vacuum of table "postgres.pg_catalog.pg_tablespace"
2018-11-03 00:06:29 CET [41305]: [1-1] user=, db=, app=, client= ERROR: 
found xmin 2502024502 from before relfrozenxid 150137048
2018-11-03 00:06:29 CET [41305]: [2-1] user=, db=, app=, client= CONTEXT: 
automatic vacuum of table "postgres.pg_catalog.pg_tablespace"
2018-11-03 00:06:44 CET [41625]: [1-1] user=, db=, app=, client= ERROR: 
found xmin 2502024502 from before relfrozenxid 150137048
2018-11-03 00:06:44 CET [41625]: [2-1] user=, db=, app=, client= CONTEXT: 
automatic vacuum of table "postgres.pg_catalog.pg_tablespace"
2018-11-03 00:06:59 CET [41676]: [1-1] user=, db=, app=, client= ERROR: 
found xmin 2502024502 from before relfrozenxid 150137048
2018-11-03 00:06:59 CET [41676]: [2-1] user=, db=, app=, client= CONTEXT: 
automatic vacuum of table "postgres.pg_catalog.pg_tablespace"

your workaround helped, thank you




--
Sent from: http://www.postgresql-archive.org/PostgreSQL-bugs-f2117394.html


pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #15476: Problem on show_trgm with 4 byte UTF-8 characters
Next
From: Andres Freund
Date:
Subject: Re: Wrong aggregate result when sorting by a NULL value