Re: 9.0beta2 - server crash when using HS + SR

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Greg Smith <greg(at)2ndquadrant(dot)com>
Cc: Rafael Martinez <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>, Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: 9.0beta2 - server crash when using HS + SR
Date: 2010-06-14 06:21:49
Message-ID: AANLkTin8tuhrOML5d4gxZbYOkONQyG2GsTE1QPt9C26_@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Jun 14, 2010 at 9:16 AM, Greg Smith <greg(at)2ndquadrant(dot)com> wrote:
> I wouldn't be adverse to improving the error messages emitted when this
> happens by the server to make it more obvious what's gone wrong in 9.1.
>  That's the only genuine improvement I'd see value in here, to cut down on
> other people running into what you did and being as confused by it.

What about the attached patch? When we encounter that problem, we get
the following hint message:

FATAL: directory "/path_to/ts" does not exist
HINT: create "/path_to/ts" directory for tablespace before
restarting the server
CONTEXT: xlog redo create ts: 16384 "/path_to/ts"

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

Attachment Content-Type Size
recovery_ts_hint_v1.patch application/octet-stream 752 bytes

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jehan-Guillaume (ioguix) de Rorthais 2010-06-14 07:48:44 Typo in plperl doc ?
Previous Message Heikki Linnakangas 2010-06-14 06:16:10 Re: warning message in standby