Re: BUG #15231: After Upgrade from 9.3.23 to 9.6.9 getting ERROR: found xmin 598 from before relfrozenxid 68569164

From: pinker <pinker(at)onet(dot)eu>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #15231: After Upgrade from 9.3.23 to 9.6.9 getting ERROR: found xmin 598 from before relfrozenxid 68569164
Date: 2018-11-03 18:01:43
Message-ID: 1541268103049-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2018-11-03 21:50:09 Re: Wrong aggregate result when sorting by a NULL value
Previous Message Tom Lane 2018-11-03 17:03:20 Re: BUG #15476: Problem on show_trgm with 4 byte UTF-8 characters