Don't laugh, but I am still using IngresII 2.5 on Reliant UNIX.
Every 6 months or so our weekly iidbdb online "ckpdb" batch job hangs,
locking the entire installation. Last time the final part of the log
file was "CPP: Preparing stall of database, active xact cnt: 2".
Suspecting that we had active sessions (at 6 am when the checkpoint
job runs!) I added a "-timeout" flag to the "ckpdb" command and a "-v"
flag to get details of the sessions.
So far, so logical. We've had no recurrences of the problem yet and
no instances of "xact cnt" > 0 during iidbdb checkpoints. However I
have noticed that values of "xact cnt" greater than zero don't seem to
cause problems during online checkpoints of other databases in the
same installation.
Is the "ckpdb iidbdb" process uniquely vulnerable to active sessions,
or is the cause of our problems more likely to be something else?
Thanks.
L Jackson.
