Hiya, Daniel.

A search of Mers yielded some tidbits. You may care to follow em up:

http://www.mers.com/cgi-bin/srchcgi.exe/EXECSEARCH?
pageno=1&linktype=search&searchtext=page+in+use+during+flush&grouptext
=

And this from the IBPhoenix db corruption page:

"Synchronous writes are known as "careful writes", in that the
InterBase engine will flush modified pages to disk on a transaction
commit, and will write the pages back to the database in the correct
order (as far as the database server is concerned) and so minimise
any possible data loss. Careful write is present in all cases, though
without forced write, it's careful only up to the Operating System
file cache. Forced write has no effect on Windows 3.1, Windows 95 and
Windows 98. On Unix and NT, it causes the operating system to bypass
its file cache and send the page directly to disk."

What are the odds your corrupt db was set to forced-write off???

Below is a suggestion found from the Mers site. I'm off to bed.

Regards,
Andrew Ferguson
-- I can see your house from here.



Subject: Re: internal gds software consistency check (page in use
during flush
Author: Didzis Klavins <didzisk@...>
Date: Sat, 28 Nov 1998 14:43:25 +0200
Newsgroup: interbase.public.general


----------------------------------------------------------------------
----------
Hi!
Try backup without garbage collection (this message sounds like this
will
help)
Try "read-only" validation option.

Didzis

Stephen Davey wrote:

> Hi all,
>
> RE: internal gds software consistency check (page in use during

flush

> (210))
>
> Has any solved this error ?
>
> We have backed up the database and restored it when it will let us,

we

> are now unable to
> backup or perform any database repair, this error generated every

time

> we try.
>
> We are running NT 4.0 Service Pack 4
> Interbase WI-V5.5.0.742
> BDE 5.0
>
> The error was also present with interbase 5.0.
>
> The database has only ever been on Win NT.
>
> The above error was displayed after a reboot when we tried to do a
> database validation.
>
> We would greatful for any information that might help us discover

what

> is causing this error and how to fix it.
>
> Regards
> Stephen Davey



--- In ib-support@y..., Daniel Rail <daniel@a...> wrote:
> At 25/05/2002 12:11 PM, you wrote:
> >Have a look at the link below. Possibly it is the same cause as
your
> >client's problems. Basically it is when the DB reaches the OS
file-
> >size limit and starts overwriting pages from the beginning -- or
> >something. Sounded rather scary :-)
> >
> >http://www.elists.org/pipermail/delphi-db/2002-January/005261.html
>
> Thanks for the reply Andrew. But, I forgot to mention that the
database
> size is 87MB and Interbase is running on a Windows 2000 system with
> NTFS. The error that I reported (still mentioned below) is from
me, not my
> client. My client has another error and my boss didn't forward me
all the
> information that I asked for (including the client's
interbase.log). And,
> now, it seems that I'm only going to be able to do something
Monday,
> instead of this weekend, since I can't work with the file. I also
ran a
> sweep on the database with no effect.
>
> Any suggestions are appreciated. I know that it's not much to work
with,
> but I'm only looking for suggestions, for now.
>
> Daniel Rail
>
> >--- In ib-support@y..., Daniel Rail <daniel@a...> wrote:
> > > Hi,
> > >
> > > I'm getting the following error when trying to fix the database
of
> >one of
> > > my clients. I get this error when using gfix with validate or
> >mend. I
> > > don't know if the error occurs when performing normal
operations,
> >since I
> > > need to fix another problem that my client reported.
> > >
> > > "internal gds software consistency check (page in use during
flush
> >(210))"
> > >
> > > The reason why I'm trying to fix the database is because my
client
> >was
> > > getting a consistency check error, but not the same one.
> > >
> > > Can someone tell me what does this message means and what
could've
> >caused
> > > it? My guess is maybe the database was copied while a
transaction
> >was
> > > open. But, I want to be sure about this assumption.
> > >
> > > Thanks in advance.
> > >
> > >
> > > Daniel Rail
> > > Senior System Engineer
> > > ACCRA Group Inc. (www.accra.ca)
> > > ACCRA Med Software Inc. (www.accramed.ca)
> >
> >
> >
> >To unsubscribe from this group, send an email to:
> >ib-support-unsubscribe@e...
> >
> >
> >
> >Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/