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