Re: [GENERAL] [SQL] pg_multixact issues

From: Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com>
To: Andres Freund <andres(at)2ndquadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, pgsql-sql(at)postgresql(dot)org
Subject: Re: [GENERAL] [SQL] pg_multixact issues
Date: 2014-09-18 17:22:57
Message-ID: CALSLE1OmAcaj6BmHu07LWNkRgd=xvoHyqsasTTVquHxXcni-mg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-sql

On Thu, Sep 18, 2014 at 6:20 PM, Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com> wrote:

> On Thu, Sep 18, 2014 at 4:03 PM, Andres Freund <andres(at)2ndquadrant(dot)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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2014-09-18 17:30:33 Re: Why isn't Java support part of Postgresql core?
Previous Message Szymon Guz 2014-09-18 17:17:17 Re: Why isn't Java support part of Postgresql core?

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2014-09-18 18:27:44 Re: jsonb format is pessimal for toast compression
Previous Message Josh Berkus 2014-09-18 16:53:53 Re: jsonb format is pessimal for toast compression

Browse pgsql-sql by date

  From Date Subject
Next Message Adrian Klaver 2014-09-18 21:47:04 Re: [GENERAL] [SQL] pg_multixact issues
Previous Message Dev Kumkar 2014-09-18 12:50:59 Re: [GENERAL] pg_multixact issues