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

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

From
Gordon Shannon
Date:
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.


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

From
Alvaro Herrera
Date:
Gordon Shannon escribió:
>
> 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

My caffeing level is too low yet to know for sure, but I think this is
innocuous (particularly so if there's a single file in that directory,
because then there's nothing to truncate anyway).

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.