Re: ERROR: found xmin 54230249 from before relfrozenxid 61349053

2018-08-02 Thread rihad
On 08/02/2018 05:34 PM, rihad wrote: On 08/02/2018 04:38 PM, rihad wrote: Hi all. We see such errors on one of our own (non-system) tables on Postgres 10.3. They stop both automatic vacuum & automatic analyze not only on that table, but on all tables & databases (manual vacuuming works though)

Re: ERROR: found xmin 54230249 from before relfrozenxid 61349053

2018-08-02 Thread rihad
On 08/02/2018 04:38 PM, rihad wrote: Hi all. We see such errors on one of our own (non-system) tables on Postgres 10.3. They stop both automatic vacuum & automatic analyze not only on that table, but on all tables & databases (manual vacuuming works though). Luckily it's a small (but important)

ERROR: found xmin 54230249 from before relfrozenxid 61349053

2018-08-02 Thread rihad
Hi all. We see such errors on one of our own (non-system) tables on Postgres 10.3. They stop both automatic vacuum & automatic analyze not only on that table, but on all tables & databases (manual vacuuming works though). Luckily it's a small (but important) table - less than 1000 rows. Any qui