Postgres Pro
Downloads
Home   >   mailing lists

Got could not truncate directory "pg_multixact/offsets": apparent wraparound - Mailing list pgsql-general

From Gordon Shannon
Subject Got could not truncate directory "pg_multixact/offsets": apparent wraparound
Date
Msg-id 25287801.post@talk.nabble.com
Whole thread Raw
Responses Re: Got could not truncate directory "pg_multixact/offsets": apparent wraparound
List pgsql-general
Tree view 
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 by date:

Previous
From: Gordon Shannon
Date:
Subject: Re: Getting "insufficient data left in message" on copy with binary
Next
From: Scott Marlowe
Date:
Subject: Re: New server disk setup?