We see a similar problem occasionally, but can't reproduce it on demand.
A long-running SQL query will run fine one day, hang the next.
I think it MAY be related to having another long-running process (such as
reclamation) in flight while the query is running. (But this could be
coincidence.)
You can cancel any active processes, and you can cancel the session that
started the long-running query, but that session never goes away, and never
times out. Then any additional SQL queries also hang. Eventually ALL
queries hang, although backups continue to run just fine. You can leave the
situation there for days and it will never clear up on its on. Eventually
you have to kill the server and restart it to clear the condition.
We are TSM 3.7.2 on AIX 4.3.3, 20 GB data base.
Doesn't happen on our other TSM 3.7.2 server, which is exactly the same
config, but only as a 3 GB data base.
************************************************************************
Wanda Prather
The Johns Hopkins Applied Physics Lab
443-778-8769
[EMAIL PROTECTED]
"Intelligence has much less practical application than you'd think" -
Scott Adams/Dilbert
************************************************************************
-----Original Message-----
From: George Lesho [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 26, 2001 11:55 AM
To: [EMAIL PROTECTED]
Subject: Re: Hung Admin Sessions
Jennifer, The same type problem occurs in threads on my version of TSM
3.7.3.6
for drives waiting on instructions to dismount tapes... you would probably
do us
a favor by bringing this issue to TSM for resolution... Don't the sessions
eventually "time out" and disappear?
George Lesho
Storage/System Admin
AFC Enterprises
"Jennifer I. Moore" <[EMAIL PROTECTED]> on 02/23/2001 06:32:14 PM
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc: (bcc: George Lesho/Partners/AFC)
Fax to:
Subject: Hung Admin Sessions
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)
