- Архив списков рассылки pgsql-admin
| От | Karl Hafner |
|---|---|
| Тема | |
| Дата | |
| Msg-id | CA+MJ4cS1bdt6eGbXuhLFXVQHfrn6pyyHMHp_P1vh71TPrVi+UA@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re:
Re: |
| Список | 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 по дате отправления: