INN-STABLE-20040216 and INN-STABLE-20040217 might have an ovdb_init bug

[Heath Kehoe]

Are there a large number of database log.* files?  That can happen if
the ovdb_monitor checkpoint process died and checkpoints weren't
happening.  When ovdb_init starts, it does a recovery, which scans
the logs starting at the most recent checkpoint, and makes sure
any committed transactions are actually committed, and uncommitted
transactions are undone.  If there are a large number of transactions
since the most recent checkpoint, this can take a really long time.

You might be able to check on the progress of ovdb_init using lsof
to see which log.* files it has open.

If there are a really large number of log.* files for it to wade
through, it may actually be faster to rebuild your overview database
from scratch using makehistory.  Shut down all news processes,
delete all files (other than DB_CONFIG, if you have it) from your
overview directory, run (as news user) ovdb_init followed by
makehistory -FOx

-heath

On Feb 17, 2004, at 6:11, The Doctor wrote:

> For the last 2 days,  ovdb_init is either hanging or taking a long
> time to start.
>
> How can one debug this issue?
>
>
> -- 
> Member - Liberal International	On 11 Sept 2001 the WORLD was violated.
> This is doctor at nl2k.ab.ca	Ici doctor at nl2k.ab.ca
> Society MUST be saved! Extremists must dissolve.
> Time to see the eternal relegation of Man U, Liverpool, Everton and 
> Millwall
>
>