Disconnected User still has an entry in promon lock table

[danishgambit]

Morning,

OpenEdge 10.2A on redhat.

we've got a user who was disconnected via promon, but who still has an entry appearing in the promon record locking screen, but the transaction doesn't appear in the active transactions screen.

Trying to figure out how to go about freeing the record, without resorting to stopping & restarting the database broker.

Thanks in Advance,

'Gambit.

 

[cj_brandt]

Does the user have an entry in the _Connect table ?
Is the user's pid still active ?
Does the db log show they logged out ?

You are saying that the user has a record locked - Option 4 in promon
But doesn't appear in the active transactions ? - Option R&D -> 1 -> 4 -> 3 in promon ??

 

[danishgambit]

Afternoon cj_brandt,

the answer to your last question is yes.

(Un)fortunately, we've now bounced the database (some other issues occurred as well) so I can't check these. Got to admit I didn't bother checking for the logout message in the db logfile. As for the _connect table, I was only looking in promon, without access to an editor, so didn't check this table (unless one of the screens is referencing this table).

I was a bit worried that when we bounced the database we might have an issue with shared memory but that wasn't the case, but thanks for the questions anyway, I'll bear them in mind for the next time we get such a problem.

Cheers,

DG.