Jennifer,
Yes, I get these too... They appear to happen whenever I have a session
doing anything that takes a long time (moving data w/ wait=yes, big sql
query, etc.).
The 'ghost' sessions don't appear to harm anything, although I have
noticed that eventually the server will start acting generally strange
until a halt and restart are done.
I've also noticed that the longer a dsmadmc program is running (even if
the session times out w/ the server) the slower the client responds. No
real apparent reason for this, either.
I too am running 4.1.2 on AIX 4.3.3
+-----------------------------------------------------------------------+
| Brian T. Huntley Systems Administrator |
| Campus Information Services, Clarkson University |
| Ph/FAX: 315.268-6723/6570 |
| [EMAIL PROTECTED] www.clarkson.edu/cis |
+-----------------------------------------------------------------------+
UNIX *is* user friendly. It's just selective about who its friends are.
PGP Public Key available. finger [EMAIL PROTECTED]
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)
//
//
