Unix Technical Forum

Re: [BUGS] xlog lockup patch (was: BUG #2712:

This is a discussion on Re: [BUGS] xlog lockup patch (was: BUG #2712: within the Pgsql Patches forums, part of the PostgreSQL category; --> It was considered too risky to backpatch because we couldn't do sufficient testing. --------------------------------------------------------------------------- TANIDA Yutaka wrote: > Hi. ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > Pgsql Patches

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-18-2008, 09:17 AM
Bruce Momjian
 
Posts: n/a
Default Re: [BUGS] xlog lockup patch (was: BUG #2712:


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@momjian.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@sraoss.co.jp>


[ Attachment, skipping... ]

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


--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com

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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 01:38 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com