Re: BUG #8397: pg_basebackup -x from new standby server sometimes causes Segmentation fault

From: TAKATSUKA Haruka <harukat(at)sraoss(dot)co(dot)jp>
To: pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #8397: pg_basebackup -x from new standby server sometimes causes Segmentation fault
Date: 2013-08-25 07:05:49
Message-ID: 20130825160549.8cbe1bfd.harukat@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Thanks for the response.

On Sat, 24 Aug 2013 17:04:21 +0200
Magnus Hagander <magnus(at)hagander(dot)net> wrote:

> > (1) create new standby server dir by pg_basebackup without -x
> > (2) start new standby server
> > (3) pg_basebackup from new standby server with -x
> > (!) when new standby has no WAL files in pg_xlog,
> > new standby's wal sender crash
(snip)
> > Though pg_basebackup does not have to work in this rare case,
> > we should insert something like "if (nWalFiles <= 0) ereport(...);".
>
> Yes, we definitely need better error checking there - a crash is never
> the right answer.
>
> Does this happen only when you take a backup "really quickly" after
> setting up the new standby,

It's just this first case.
Therefore, we recognize that it is the problem of how to use.

regards,

> or is there some scenario further in it's
> lifetime when it can happen? In the first case, throwing a hard error
> seems quite reasonable, but if it's repeatable, perhaps there is
> something better we can do?
>
> Also, while we definitely need a sanity check at this point, might it
> be worth it to put a second check earlier in the process as well -
> since AFAICT this error gets thrown only after all the data has been
> sent arlready.
>
> --
> Magnus Hagander
> Me: http://www.hagander.net/
> Work: http://www.redpill-linpro.com/

______________________________________________________
harukat(at)sraoss(dot)co(dot)jp (SRA OSS, Inc. http://www.sraoss.co.jp)

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2013-08-25 16:22:47 Re: BUG #8396: Window function results differ when selecting from table and view, with where clause
Previous Message Magnus Hagander 2013-08-24 15:04:21 Re: BUG #8397: pg_basebackup -x from new standby server sometimes causes Segmentation fault