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

Fujii Masao <masao.fujii@gmail.com>

View thread

From: Fujii Masao <masao.fujii@gmail.com>

To: Greg Smith <greg@2ndquadrant.com>

Cc: Rafael Martinez <r.m.guerrero@usit.uio.no>, Robert Haas <robertmhaas@gmail.com>, pgsql-hackers@postgresql.org

Date: 2010-06-14T06:21:49Z

Lists: pgsql-hackers

Attachments

recovery_ts_hint_v1.patch (application/octet-stream) patch v1

On Mon, Jun 14, 2010 at 9:16 AM, Greg Smith <greg@2ndquadrant.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