Yes and its getting rather annoying ...

 but we noticed this when we went to ECA015 on our 3466
 that's 3.7.2 from 3.1.2.20 ...

joe.f.

Joseph A Faracchio,  Systems Programmer, UC Berkeley


On Fri, 23 Feb 2001, Jennifer I. Moore wrote:

> 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
> 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)
>