| From: | Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)2ndquadrant(dot)com> |
| 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] pg_multixact issues |
| Date: | 2014-09-18 12:50:59 |
| Message-ID: | CALSLE1Mngj=vyA-hdKaB-HWQ=gU_A3vDRE4ddyKwViTRFXmLFg@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 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?
Regards...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G Johnston | 2014-09-18 13:18:15 | Re: Why isn't Java support part of Postgresql core? |
| Previous Message | ludwig@kni-online.de | 2014-09-18 11:12:48 | Re: strange problem with not existing roles |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Bartunov | 2014-09-18 13:12:52 | Re: Collations and Replication; Next Steps |
| Previous Message | Pavel Stehule | 2014-09-18 12:37:26 | Re: Anonymous code block with parameters |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dev Kumkar | 2014-09-18 17:22:57 | Re: [GENERAL] [SQL] pg_multixact issues |
| Previous Message | Andres Freund | 2014-09-18 10:33:38 | Re: [SQL] pg_multixact issues |