Re: apparent wraparound - Mailing list pgsql-general

From Tom Lane
Subject Re: apparent wraparound
Date
Msg-id 8274.1163208101@sss.pgh.pa.us
Whole thread Raw
In response to Re: apparent wraparound  ("George Pavlov" <gpavlov@mynewplace.com>)
List pgsql-general
"George Pavlov" <gpavlov@mynewplace.com> writes:
>> "George Pavlov" <gpavlov@mynewplace.com> writes:
>>>>> 2006-11-08 12:38:34 PST [3739]: [3-1] LOG:  could not truncate directory
>>>>> "pg_multixact/members": apparent wraparound
>>>> During crash recovery?
>>> no crashes, just normal DB operation...
>>
>> Hmm ... what is in pg_multixact/members/ again?

> Now there is only a file named 0010 the date on which changes about
> every 4-5 minutes or so.

AFAICS this must indicate that TruncateMultiXact() computed a bogus
oldestOffset, but it's hard to see how that would happen in the middle
of an unexceptional run.  Alvaro, any ideas?  Could there be a race
condition involved in filling in the "members" entries?

            regards, tom lane

pgsql-general by date:

Previous
From: "George Pavlov"
Date:
Subject: Re: apparent wraparound
Next
From: Shane Ambler
Date:
Subject: Re: Request for replication advice