Skip site navigation (1) Skip section navigation (2)

Re: xlog lockup patch (was: BUG #2712: could not fsync

From: TANIDA Yutaka <tanida(at)sraoss(dot)co(dot)jp>
To: pgsql-bugs(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org
Subject: Re: xlog lockup patch (was: BUG #2712: could not fsync
Date: 2007-01-10 09:52:16
Message-ID: 20070110185216.4332b43c.tanida@sraoss.co.jp (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-patches
Hi.

On Mon, 20 Nov 2006 15:33:33 -0500 (EST)
Bruce Momjian <bruce(at)momjian(dot)us> wrote:

> Thomas H. wrote:
> > me wrote:
> > > i've loaded 1gb of data without any xlog-problems, whereas with the 8.2b2 
> > > executable it locked up after ~100mb. the xlog-files are cycling...
> > >
> > > if i need to test for some specific behaviour let me know.
> > 
> > what's the status on this patch for inclusion in future 8.2 builds? would be 
> > nice to see it in b4 or rc1...
> 
> This was fixed the day after we packaged beta3:
> 	
> 	revision 1.44
> 	date: 2006/11/08 20:12:05;  author: tgl;  state: Exp;  lines: +20 -48
> 	Change Windows rename and unlink substitutes so that they time out after
> 	30 seconds instead of retrying forever.  Also modify xlog.c so that if
> 	it fails to rename an old xlog segment up to a future slot, it will
> 	unlink the segment instead.  Per discussion of bug #2712, in which it
> 	became apparent that Windows can handle unlinking a file that's being
> 	held open, but not renaming it.
> 
> beta4 will have the fix.
 
Are there any plan to  backport this patch for 8.1/8.0 server ? 

My customer has same problem in 8.1.5 , but this bug doesn't seems to
be fixed in 8.1.6 . 

Backport patch for 8.1.6 attached. 

Sorry for replying old mail.
 
--
TANIDA Yutaka <tanida(at)sraoss(dot)co(dot)jp>

Attachment: 81_win_xlog_lockup_fix.patch
Description: application/octet-stream (4.8 KB)

In response to

Responses

pgsql-bugs by date

Next:From: Marco BehnkeDate: 2007-01-10 11:26:13
Subject: Bugreport
Previous:From: Dave PageDate: 2007-01-09 19:50:32
Subject: Re: BUG #2875: pgAdmin III docs installed even if app is not

pgsql-patches by date

Next:From: Teodor SigaevDate: 2007-01-10 10:47:22
Subject: Re: [HACKERS] [PATCHES] Bundle of patches
Previous:From: Heikki LinnakangasDate: 2007-01-10 09:31:49
Subject: Re: [HACKERS] [PATCHES] Last infomask bit

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group