Subject | Re: [ib-support] Corrupted DB |
---|---|
Author | Jason Chapman (JAC2) |
Post date | 2002-06-19T12:12:51Z |
Michael,
problem.
What does it do?
as well.
possibles:
1) Establish it is happening when the sweep is occuring.
2) If yes to the above reduce the priority of the NTVDM when the sweep is
about to kick in.
3) Remove the NTVDM when the sweep is about to kick in.
> I have posted several messages earlier about my DB getting corrupted.And also you have said multiple machines on this site all have the same
> I use Firebird version 1.0
> It runs on a server running 2000 with all SP installed.
> I have gotten my hardware checked, and found no errors.
problem.
> On my server there runs a program called NTVDM.EXE which at timesHave you tried to downgrade the priority?
> takes up to 100 % of CPU time (and 90 % kernel time)
What does it do?
> Then after my DB gets corrupted, I have these values when runningWhat happens if you change the sweep interval (e.g. 0, 40000)?
> GStat:
>
> Oldest Transaction 4848
> Oldest Active 28304
> Oldest Snapshot 28304
> Next Transaction 28306
> To solve my problem I have to do a Backup - Restore.Are the errors all index and orphaned back versions or actually data pages
> Then it all works perfect.
as well.
> Now my new question:You never know, you have an unusual situation. You need to remove
>
> Could it be, that my DB doesn't get enough time (because of NTVDM)
> when the sweep function kick in ?
possibles:
1) Establish it is happening when the sweep is occuring.
2) If yes to the above reduce the priority of the NTVDM when the sweep is
about to kick in.
3) Remove the NTVDM when the sweep is about to kick in.
> Does sweep ALWAYS sweep when the difference i 20000 exactly or justDon't know.
> shortly after ?