Skip site navigation (1) Skip section navigation (2)

Re: BUG #4566: pg_stop_backup() reports incorrect STOP WAL LOCATION

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc: Randy Isbell <jisbell(at)cisco(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4566: pg_stop_backup() reports incorrect STOP WAL LOCATION
Date: 2009-01-15 01:50:31
Message-ID: 200901150150.n0F1oV113850@momjian.us (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-docspgsql-hackers
Would someone please tell me if this should be applied?

---------------------------------------------------------------------------

Fujii Masao wrote:
> On Fri, Dec 5, 2008 at 11:41 PM, Randy Isbell <jisbell(at)cisco(dot)com> wrote:
> >
> > The following bug has been logged online:
> >
> > Bug reference:      4566
> > Logged by:          Randy Isbell
> > Email address:      jisbell(at)cisco(dot)com
> > PostgreSQL version: 8.3.4
> > Operating system:   FreeBSD 6.2
> > Description:        pg_stop_backup() reports incorrect STOP WAL LOCATION
> > Details:
> >
> > An inconsistency exists between the segment name reported by
> > pg_stop_backup() and the actual WAL file name.
> >
> >
> > SELECT pg_start_backup('filename');
> >         pg_start_backup
> >        -----------------
> >         10/FE1E2BAC
> >        (1 row)
> >
> > Later:
> > SELECT pg_stop_backup();
> >         pg_stop_backup
> >        ----------------
> >         10/FF000000
> >        (1 row)
> >
> > The resulting *.backup file:
> >
> > START WAL LOCATION: 10/FE1E2BAC (file 0000000200000010000000FE)
> > STOP WAL LOCATION: 10/FF000000 (file 0000000200000010000000FF)
> > CHECKPOINT LOCATION: 10/FE1E2BAC
> > START TIME: 2008-11-09 01:15:06 CST
> > LABEL: /bck/db/sn200811090115.tar.gz
> > STOP TIME: 2008-11-09 01:15:48 CST
> >
> > In my 8.3.4 instance, WAL file naming occurs as:
> >
> > ...
> > 0000000100000003000000FD
> > 0000000100000003000000FE
> > 000000010000000400000000
> > 000000010000000400000001
> > ...
> >
> > WAL files never end in 'FF'.  This causes a problem when trying to collect
> > the ending WAL file for backup.
> 
> It's a bug of pg_stop_backup(), which has been talked before.
> http://archives.postgresql.org/pgsql-hackers/2008-12/msg00108.php
> 
> Attached is a patch against HEAD. I think that we should
> also backport.
> 
> Regards,
> 
> -- 
> Fujii Masao
> NIPPON TELEGRAPH AND TELEPHONE CORPORATION
> NTT Open Source Software Center

[ Attachment, skipping... ]

> 
> -- 
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

Responses

pgsql-docs by date

Next:From: Heikki LinnakangasDate: 2009-01-15 12:09:57
Subject: Re: BUG #4566: pg_stop_backup() reports incorrect STOP WAL LOCATION
Previous:From: Peter EisentrautDate: 2009-01-12 15:09:10
Subject: Re: Current docs are too comlicated for new Postgre users; thoughts on improvement

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2009-01-15 01:51:23
Subject: Re: Re: [COMMITTERS] pgsql: Make 'find' syntaxconsistent; add .git exclusion to make_ctags.
Previous:From: Bruce MomjianDate: 2009-01-15 01:48:35
Subject: Re: visibility maps

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2009-01-15 01:51:54
Subject: Re: Fall back to alternative tsearch dictionary directory
Previous:From: Bruce MomjianDate: 2009-01-15 01:38:31
Subject: Re: BUG #4562: ts_headline() adds space when parsing url

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group