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

Re: [pgsql-patches] xlog lockup patch (was: BUG #2712:

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: TANIDA Yutaka <tanida(at)sraoss(dot)co(dot)jp>
Cc: pgsql-bugs(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org
Subject: Re: [pgsql-patches] xlog lockup patch (was: BUG #2712:
Date: 2007-01-10 16:38:20
Message-ID: 200701101638.l0AGcKT25777@momjian.us (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-patches
It was considered too risky to backpatch because we couldn't do
sufficient testing.

---------------------------------------------------------------------------

TANIDA Yutaka wrote:
> 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, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

-- 
  Bruce Momjian   bruce(at)momjian(dot)us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

pgsql-bugs by date

Next:From: kalyanDate: 2007-01-10 17:18:28
Subject: BUG #2878: does not install
Previous:From: Marvin SolomonDate: 2007-01-10 15:49:00
Subject: follow-up: problems with pg_ctl -w

pgsql-patches by date

Next:From: Bruce MomjianDate: 2007-01-10 16:45:17
Subject: Re: [HACKERS] [PATCHES] Building libpq/psql with Borland BCC5
Previous:From: Bruce MomjianDate: 2007-01-10 16:36:27
Subject: Re: [HACKERS] [PATCHES] SGML index build fix

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