- Mailing list pgsql-admin

From Karl Hafner
Subject
Date
Msg-id CA+MJ4cS1bdt6eGbXuhLFXVQHfrn6pyyHMHp_P1vh71TPrVi+UA@mail.gmail.com
Whole thread Raw
Responses Re:  (Karl Hafner <karl@scoreloop.com>)
Re:  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-admin
Dear mailing-list, 

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"

It seems that "autovacuum" is active on that table, but it seems to have restarted today in the morning:  

select query_start, query, state, pid from pg_stat_activity where query LIKE 'autovacuum%' ;

XXX=# select query_start, query, state, pid from pg_stat_activity where query LIKE 'autovacuum%' ;
         
query_start          |                                      query                                       | state  | pid  
-------------------------------+----------------------------------------------------------------------------------+--------+------
 2013-11-15 07:13:13.281202+00 | autovacuum: VACUUM ANALYZE public.gamer_device_sightings (to prevent wraparound) | active | 4360

pgsql-admin by date:

Previous
From: Petr Suk
Date:
Subject: Re: automatical grant - role membership
Next
From: Karl Hafner
Date:
Subject: Re: