Gentle Greetings,

Has anyone noticed any situations where Admin sessions on the server get
hung and become "ghost" sessions that will not go away?  Cancelling has no
effect.  Opening a separate Admin session and cancelling from there has no
effect.  In some cases, subsequent sessions get hung and a reboot is
necessary.  And in other cases, there seems to be no adverse side effects.

In this case, I was doing some SQL queries on the database, and two user
Admin sessions hung and two Query Admin sessions hung.  (Fortunately,
everything else is continuing to run smoothly.)  Below is the output from
"show threads" related to these 4 sessions.

We are running 4.1.2 Server on an IBM M80 running AIX 4.3.3.

Thank you in advance for any help and/or suggestions.

Jennifer

----------------------------
Thread 68: SessionThread
Thread 68: SessionThread
tid=4437, ktid=34577, ptid=52, det=1, zomb=0, join=0, result=0, sess=31636
 Awaiting cond 5c355b04 (mutex 301a65b0) at 10009b38 (outGetNext)

Thread 101: SessionThread
 tid=653d, ktid=69811, ptid=52, det=1, zomb=0, join=0, result=0, sess=31768
  Awaiting cond 5c33a484 (mutex 301a65b0) at 10009b38 (outGetNext)

Thread 105: SessionThread
 tid=6963, ktid=72547, ptid=52, det=1, zomb=0, join=0, result=0, sess=30446
  Awaiting cond 5c286354 (mutex 301a65b0) at 10009b38 (outGetNext)

Thread 108: SessionThread
 tid=6acf, ktid=52079, ptid=52, det=1, zomb=0, join=0, result=0, sess=31704
  Awaiting cond 5c1c69d4 (mutex 301a65b0) at 10009b38 (outGetNext)