pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Simon Riggs <simon@2ndquadrant.com>
To: Jeff Frost <jeff@frostconsultingllc.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: does wal archiving block the current client connection?
Date: Thu, 18 May 2006 10:01:17 +0100
Message-ID: <1147942877.2646.388.camel@localhost.localdomain> (raw)
In-Reply-To: <Pine.LNX.4.64.0605172243190.7012@discord.home.frostconsultingllc.com>
References: <Pine.LNX.4.64.0605150914360.9581@discord.dyndns.org>
	<1147728181.5074.73.camel@localhost.localdomain>
	<Pine.LNX.4.64.0605151424500.9581@discord.dyndns.org>
	<1147733193.5074.87.camel@localhost.localdomain>
	<Pine.LNX.4.64.0605151554000.9581@discord.dyndns.org>
	<1147781287.2646.32.camel@localhost.localdomain>
	<Pine.LNX.4.64.0605161119330.3380@glacier.frostconsultingllc.com>
	<15699.1147840569@sss.pgh.pa.us>
	<1147858398.2646.150.camel@localhost.localdomain>
	<19436.1147874478@sss.pgh.pa.us>
	<Pine.LNX.4.64.0605170909020.3380@glacier.frostconsultingllc.com>
	<7583.1147922685@sss.pgh.pa.us>
	<Pine.LNX.4.64.0605172134370.7012@discord.home.frostconsultingllc.com>
	<8269.1147927511@sss.pgh.pa.us>
	<Pine.LNX.4.64.0605172243190.7012@discord.home.frostconsultingllc.com>

On Wed, 2006-05-17 at 22:45 -0700, Jeff Frost wrote:
> On Thu, 18 May 2006, Tom Lane wrote:
> 
> > Jeff Frost <jeff@frostconsultingllc.com> writes:
> >> I seem to get alot of these:
> >
> >> May 17 21:34:04 discord postgres[20573]: [5-1] WARNING:  could not rename file
> >> "pg_xlog/archive_status/000000010000000000000001.ready" to
> >> May 17 21:34:04 discord postgres[20573]: [5-2]
> >> "pg_xlog/archive_status/000000010000000000000001.done": No such file or
> >> directory
> >
> > That seems odd ...
> 
> Further interesting items:
> 
> May 17 22:41:18 discord postgres[23817]: [3-1] LOG:  archive command 
> "/usr/local/pgsql-8.1.3/bin/archive_test.sh "pg_xlog/00000001000000000000000E" 
> "00000001000000000000000E""
> May 17 22:41:18 discord postgres[23817]: [3-2]  failed: return code 256
> And in the window where I started postgres via pg_ctl, I had this:
> 
> cat: pg_xlog/00000001000000000000000E: No such file or directory
> cat: pg_xlog/00000001000000000000000E: No such file or directory
> 
> Seems bad.

Seems so.

Can you post the full test, plus full execution log.

[You don't need to "cat" you could just do "ls" instead FWIW]

Are you doing *anything* with pg_xlog directory or below? I understand
your saying No to that question and pg_xlog has not been moved, its just
underneath data directory, which is on normal disk?

-- 
  Simon Riggs             
  EnterpriseDB   http://www.enterprisedb.com




view thread (55+ messages)  latest in thread

Message-ID: <1147942877.2646.388.camel@localhost.localdomain>
Permalink:  ../1147942877.2646.388.camel@localhost.localdomain/
Also on:    postgresql.org/message-id/1147942877.2646.388.camel@localhost.localdomain

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: simon@2ndquadrant.com, jeff@frostconsultingllc.com, tgl@sss.pgh.pa.us
  Subject: Re: does wal archiving block the current client connection?
  In-Reply-To: <1147942877.2646.388.camel@localhost.localdomain>
  References: <Pine.LNX.4.64.0605150914360.9581@discord.dyndns.org> <1147728181.5074.73.camel@localhost.localdomain> <Pine.LNX.4.64.0605151424500.9581@discord.dyndns.org> <1147733193.5074.87.camel@localhost.localdomain> <Pine.LNX.4.64.0605151554000.9581@discord.dyndns.org> <1147781287.2646.32.camel@localhost.localdomain> <Pine.LNX.4.64.0605161119330.3380@glacier.frostconsultingllc.com> <15699.1147840569@sss.pgh.pa.us> <1147858398.2646.150.camel@localhost.localdomain> <19436.1147874478@sss.pgh.pa.us> <Pine.LNX.4.64.0605170909020.3380@glacier.frostconsultingllc.com> <7583.1147922685@sss.pgh.pa.us> <Pine.LNX.4.64.0605172134370.7012@discord.home.frostconsultingllc.com> <8269.1147927511@sss.pgh.pa.us> <Pine.LNX.4.64.0605172243190.7012@discord.home.frostconsultingllc.com> <1147942877.2646.388.camel@localhost.localdomain>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox