Re: Win32 Powerfail testing

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: dpage(at)vale-housing(dot)co(dot)uk
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Win32 Powerfail testing
Date: 2003-03-05 13:49:27
Message-ID: 20030305.224927.71087099.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > So far we found interesting facts. Our Win32 port passes his
> > test in most cases. However if power of the machine is turned
> > off right after (10 to 20 seconds) the Checkpoint has been
> > made, it does not passes his test. So we are thinking that
> > there is someting wrong with the checkpoint implementaion for
> > Win32 port, which is essentially same as Jan's
> > implementation. i.e. using _flushall() instead of sync(). We
> > were looking for a fix or an alternative implementaion of
> > sync() without success.
>
> Hi Tatsuo,
>
> Does this help:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;66052

Sorry, but it does not help. The page says we could use
FlushFileBuffers() to sync the kernel buffer to the
disk. Unfortunately, it requires a file descriptor to flush for its
argument. Thus it could not be a replacement of sync(). Actually I
have modified the buffer manager so that it remembers all file
descriptors those have not been synced yet to the disk at the
checkpoint time to sync them later. However I found this modification
does not help at all with some reason I don't know.
--
Tatsuo Ishii

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bob Calco 2003-03-05 14:09:50 Re: XML ouput for psql
Previous Message Greg Stark 2003-03-05 13:32:31 Re: Updateable views...