found xmin x from before relfrozenxid y

2018-10-21 Thread Johannes Graën
Hi, after upgrading to version 11, I see the error pattern "found xmin x from before relfrozenxid y" in different databases on different hosts. From https://www.postgresql.org/docs/10/static/release-10-3.html, I learned that this was an error caused by pg_upgrade, which apparently had

Re: found xmin x from before relfrozenxid y

2018-10-21 Thread Tom Lane
=?UTF-8?Q?Johannes_Gra=c3=abn?= writes: > after upgrading to version 11, I see the error pattern "found xmin x > from before relfrozenxid y" in different databases on different hosts. > From https://www.postgresql.org/docs/10/static/release-10-3.html, I > learned that this

Re: found xmin x from before relfrozenxid y

2018-10-21 Thread Johannes Graën
Thanks for your answer. On 21/10/2018 16.24, Tom Lane wrote: > In the meantime, the only answer I can think of offhand is to manually > do VACUUM FREEZE on each of your MVs, and then refresh anything that > shows up with an error. Since I have so many of them, I decided to go for a quick-and-dirt

Re: found xmin x from before relfrozenxid y

2018-10-21 Thread Andres Freund
Hi, On 2018-10-21 10:24:16 -0400, Tom Lane wrote: > =?UTF-8?Q?Johannes_Gra=c3=abn?= writes: > > after upgrading to version 11, I see the error pattern "found xmin x > > from before relfrozenxid y" in different databases on different hosts. > > From https://ww