I'm getting this issue when I try to connect to a specific db. Does it matters what table I specify ? Should I just choose a random table from the problematic db? If I'll dump the db and restore it it can help ?
On 1/24/19 3:14 PM, Mariel Cherkassky wrote: > I'm checking the full version. > As you said I saw that in 9.6.9 there was a fix for the next bug : > > Avoid spuriously marking pages as all-visible (Dan Wood, Pavan Deolasee, > Álvaro Herrera) > > This could happen if some tuples were locked (but not deleted). While > queries would still function correctly, vacuum would normally ignore > such pages, with the long-term effect that the tuples were never frozen. > In recent releases this would eventually result in errors such as "found > multixact nnnnn from before relminmxid nnnnn". > > So basically, he just need to upgrade in order to fix it ? Or there is > something else that need to be done? > >
Hello,
The fix prevent this error occur, but it doesn't fix tuples impacted by this bug.
Did you try this : psql -o /dev/null -c "select * from table for update" database