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
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 |