| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Karl Hafner <karl(at)scoreloop(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org, Strahinja Kustudić <strahinjak(at)nordeus(dot)com> |
| Subject: | Re: |
| Date: | 2013-11-22 15:18:20 |
| Message-ID: | 20131122151820.GM6041@eldon.alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi,
Karl Hafner wrote:
> I am currently worried about an error that shows up in our log files since
> a few weeks:
>
> 2013-11-15 07:13:13 UTC [22668]: [2-1] ERROR: MultiXactId 2683601542 does
> no longer exist -- apparent wraparound
> 2013-11-15 07:13:13 UTC [22668]: [3-1] CONTEXT: automatic vacuum of table
> "scoreloop.public.gamer_device_sightings"
So you're running 9.3.
Can you please share the output of pg_controldata and a directory
listing of pg_multixact/offsets?
> Since the autovacuum process is failing each time because of: "ERROR:
> MultiXactId 2683601542 does no longer exist -- apparent wraparound", I
> have expected the manual vacuum also to fail because of the same error.
> I've tried it anyway. Well ... manual vacuum also fails unfortunately.
Yeah, it's unlikely a manual vacuum (of either kind) would succeed.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Armand du Plessis | 2013-11-22 15:55:44 | Partial Index Creation |
| Previous Message | Glyn Astill | 2013-11-22 13:40:16 | Re: Intel DC S3700/S3500 question |