From: Karl Hafner <karl(at)scoreloop(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject:
Date: 2013-11-15 09:16:54
Message-ID: CA+MJ4cS1bdt6eGbXuhLFXVQHfrn6pyyHMHp_P1vh71TPrVi+UA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

  • Re: at 2013-11-15 09:33:21 from Karl Hafner

Browse pgsql-admin by date

  From Date Subject
Next Message Karl Hafner 2013-11-15 09:33:21 Re:
Previous Message Petr Suk 2013-11-14 09:17:16 Re: automatical grant - role membership