Jeremy Finzel wrote: > Getting some concerning errors in one of our databases that is on 9.5.11, > on autovacuum from template0 database pg_authid and pg_auth_members. I > only saw some notes on the list about this error related to materialized > views. FWIW, we did use pg_upgrade to upgrade this database from 9.4 to > 9.5. Here is an example: > > 2018-03-19 12:08:33.946 CDT,,,14892,,5aafee91.3a2c,1,,2018-03-19 12:08:33 > CDT,59/340951,0,ERROR,XX001,"found xmin 2906288382 from before relfrozenxid > 740087784",,,,,"automatic vacuum of table > ""template0.pg_catalog.pg_authid""",,,,"" Can you please supply output of pg_controldata? -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
