Re:

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux