Re: SR fails to send existing WAL file after off-line copy - Mailing list pgsql-hackers

From Greg Smith
Subject Re: SR fails to send existing WAL file after off-line copy
Date
Msg-id 4CCF1CE7.7060300@2ndquadrant.com
Whole thread Raw
In response to Re: SR fails to send existing WAL file after off-line copy  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
Heikki Linnakangas wrote:
> Yes, indeed there is a corner-case bug when you try to stream the very 
> first WAL segment, with log==seg==0.

I confirmed that the bug exists in only this case by taking my problem 
install and doing this:

psql -d postgres -c "checkpoint; select pg_switch_xlog();"

To force it to the next xlog file.  With only that change, everything 
else then works.  So we'll just need to warn people about this issue and 
provide that workaround, as something that only trivial new installs 
without much data loaded into them are likely to run into, until 9.0.2 
ships with your fix in it.  I'll update the docs on the wiki 
accordingly, once I've recovered from this morning's flight out West.

I forgot to credit Robert Noles here for rediscovering this bug on one 
of our systems and bringing it to my attention.

-- 
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services and Support        www.2ndQuadrant.us




pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: Range Types, discrete and/or continuous
Next
From: Greg Stark
Date:
Subject: Re: SR fails to send existing WAL file after off-line copy