| 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: | Whole Thread | Raw Message | 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 |