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.