Re: PostGreSQL (7.3?) recovery, Mac OS X (10.3.8)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PostGreSQL (7.3?) recovery, Mac OS X (10.3.8)
Дата
Msg-id 2197.1113359786@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PostGreSQL (7.3?) recovery, Mac OS X (10.3.8)  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Список pgsql-general
Alvaro Herrera <alvherre@dcc.uchile.cl> writes:
> What version is this exactly?  IIRC there was a version of 7.3 that
> would refuse to start if the last XLog record fell at the edge of a
> segment.  I may be misremembering though (i.e. maybe it was one of the
> 7.4 series), plus I can't find the relevant entry in the release notes.

If I'm reading the CVS history correctly, the bug existed only in the
7.3.3 release; here's the CVS log entry for the fix:

2003-07-17 12:45  tgl

    * src/backend/access/transam/xlog.c (REL7_3_STABLE): Repair
    boundary-case bug introduced by patch of two months ago that fixed
    incorrect initial setting of StartUpID.  The logic in XLogWrite()
    expects that Write->curridx is advanced to the next page as soon as
    LogwrtResult points to the end of the current page, but
    StartupXLOG() failed to make that happen when the old WAL ended
    exactly on a page boundary.  Per trouble report from Hannu Krosing.

and this seems to be what Bruce boiled it down to in the 7.3.4 release
notes:

* Prevent rare possibility of server startup failure (Tom)

Personally I always look at the CVS history when searching for bug
histories.  cvs2cl.pl is a wonderful tool ...

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PostGreSQL (7.3?) recovery, Mac OS X (10.3.8)
Следующее
От: "Jinane Haddad"
Дата:
Сообщение: Re: What are the consequences of a bad database design (never seen