Got could not truncate directory "pg_multixact/offsets": apparent wraparound

Поиск
Список
Период
Сортировка
От Gordon Shannon
Тема Got could not truncate directory "pg_multixact/offsets": apparent wraparound
Дата
Msg-id 25287801.post@talk.nabble.com
обсуждение исходный текст
Ответы Re: Got could not truncate directory "pg_multixact/offsets": apparent wraparound  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-general
Hello,  running 8.4 on Centos.  Been running production for 6 months.  Never
saw this message until tonight:

  LOG: could not truncate directory "pg_multixact/offsets": apparent
wraparound

In case it helps...

Output of pg_controldata:
Latest checkpoint's NextMultiXactId:  145725622
Latest checkpoint's NextMultiOffset:  394849408

Contents of pg_multixact/offsets:  08B0
Contents of pg_multixact/members: 178B

In conf file:
vacuum_freeze_min_age = 1000000000  # (1 billion)
autovacuum_freeze_max_age = 1500000000  # (1.5 billion)

Oldest txn in cluster (pg_database.datfrozenxid) : 648

Should I be concerned?

Thanks
Gordon


--
View this message in context:
http://www.nabble.com/Got-could-not-truncate-directory-%22pg_multixact-offsets%22%3A-apparent-wraparound-tp25287801p25287801.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


В списке pgsql-general по дате отправления:

Предыдущее
От: Gordon Shannon
Дата:
Сообщение: Re: Getting "insufficient data left in message" on copy with binary
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: New server disk setup?