On Thu, Sep 18, 2014 at 6:20 PM, Dev Kumkar <devdas.kum...@gmail.com> wrote:
> On Thu, Sep 18, 2014 at 4:03 PM, Andres Freund <and...@2ndquadrant.com> > wrote: > >> I don't think that's relevant for you. >> >> Did you upgrade the database using pg_upgrade? >> > > That's correct! No, there is no upgrade here. > > >> Can you show pg_controldata output and the output of 'SELECT oid, >> datname, relfrozenxid, age(relfrozenxid), relminmxid FROM pg_database;'? >> > > Here are the details: > oid datname datfrozenxid age(datfrozenxid) datminmxid > 16384 myDB 1673 10872259 1 > > Additionally wanted to mention couple more points here: > When I try to run "vacuum full" on this machine then facing following > issue: > INFO: vacuuming "myDB.mytable" > ERROR: MultiXactId 3622035 has not been created yet -- apparent > wraparound > > No Select statements are working on this table, is the table corrupt? > Any inputs/hints/tips here?