Hi,
I had following problem. I have a java servlet (webserver application
with multiple connections & connection pooling), which connects via jdbc.
Sometimes one connection hangs (I have 3 entries in DOMAIN.LOCKS for one
session). Other connections trie also to lock (if I access that tables)
and hangs forever. I don't set a lock myself. I use default transaction
processing. If i stop all clients (shutdown webserver), the connections
(and the locks) are still existing (log appended). If I kill the first
blocking process, all remaining tasks are freed. In knldiag I have
entries like this
-------------------------------------------------------------------------
2002-05-27 15:09:17 25952 11509 COMMUNIC Connection broken by appl
state 10 T29
2002-05-27 15:09:17 25952 WNG 11824 COMMUNIC Releasing T29 connection
aborted
2002-05-27 15:09:17 25952 11007 COMMUNIC wait for connection T29
-------------------------------------------------------------------------
Why is the connection existent if the client is killed? How can I avoid
that problem?
thanks
Thomas
OS is Linux (2.4.10-64GB-SMP), 2xCel466 @768MB
log from dbmcli
-------------------------------------------------------------------------
server1:~ # /opt/sapdb/depend/bin/dbmcli -d PSAP -u dba,dba show active
OK
SERVERDB: PSAP
ID UKT UNIX TASK APPL Current Timeout Region Wait
Dispatch
tid type pid state priority cnt try time count
T29 6 25952 User 0* Vwait 0 0 -1 1559
94854(s)
T30 6 25952 User 0* Vwait 0 0 -1 1156
94854(s)
T31 6 25952 User 0* Vwait 0 0 -1 953
94854(s)
T32 6 25952 User 0* Vwait 0 0 -1 2172
94854(s)
T33 6 25952 User 0* Vwait 0 0 -1 584
94854(s)
T34 6 25952 User 0* Vwait 0 0 -1 1916
94854(s)
T36 6 25952 User 0* Vwait 0 0 -1 2011
94854(s)
T41 6 25952 User 0* Vwait 0 0 -1 499
94854(s)
server1:~ # /opt/sapdb/depend/bin/dbmcli -d PSAP -u dba,dba db_cons kill T29
OK
--
Thomas Markus
Tel: 030 29 36 399 - 18
mailto:[EMAIL PROTECTED]
Proventis GmbH
Torellstr. 1
10243 Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
