Re: BUG #4879: bgwriter fails to fsync the file in recovery mode

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4879: bgwriter fails to fsync the file in recovery mode
Date: 2009-06-25 20:39:06
Message-ID: 1245962346.4038.214.camel@ebony.2ndQuadrant
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


On Thu, 2009-06-25 at 15:10 -0400, Tom Lane wrote:

> So to summarize the state of play, it seems
> we have these issues:
>
> * need to delete startup process's local pendingOpsTable once bgwriter
> is launched, so that requests go to bgwriter instead

Need to ensure that fsync requests are directed to the process that will
act on the fsync requests.

> * need to push end-of-recovery checkpoint into bgwriter

That's probably the easiest thing to do, but the issue is that we must
fsync all files mentioned in the pendingOpsTable in *any* process that
has been accumulating such requests.

> * need to do something about IsRecovery tests that will now be executed
> in bgwriter

Yes

> * need to fix mistaken code in FinishPreparedTransaction

Yes

--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2009-06-25 20:46:23 Re: BUG #4879: bgwriter fails to fsync the file in recovery mode
Previous Message Dave Page 2009-06-25 20:36:11 Re: BUG #4882: One-click installer crashes with certain service account passwords