Re: [ADMIN] does wal archiving block the current client connection? - Mailing list pgsql-hackers

From Jeff Frost
Subject Re: [ADMIN] does wal archiving block the current client connection?
Date
Msg-id Pine.LNX.4.64.0605222055360.7012@discord.home.frostconsultingllc.com
Whole thread Raw
In response to Re: [ADMIN] does wal archiving block the current client connection?  (Jeff Frost <jeff@frostconsultingllc.com>)
Responses Re: [ADMIN] does wal archiving block the current client connection?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Sun, 21 May 2006, Jeff Frost wrote:

>> So the chances of the original problem being archiver related are
>> receding...
>
> This is possible, but I guess I should try and reproduce the actual problem
> with the same archive_command script and a CIFS mount just to see what
> happens.  Perhaps the real root of the problem is elsewhere, it just seems
> strange since the archive_command is the only postgres related process that
> accesses the CIFS share.  More later.

I tried both pulling the plug on the CIFS server and unsharing the CIFS share,
but pgbench continued completely unconcerned.  I guess the failure mode of the
NAS device in the customer colo must be something different that I don't yet
know how to simulate.  I suspect I'll have to wait till it happens again and
try to gather some more data before restarting the NAS device.  Thanks for all
your suggestions guys!

--
Jeff Frost, Owner     <jeff@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954

pgsql-hackers by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: group by points
Next
From: Tom Lane
Date:
Subject: Re: [ADMIN] does wal archiving block the current client connection?