Is the state NOINT ?

Maybe it's rolling back. Sometimes that can take a while.

Andre

-----Original Message-----
From: info-ingres-admin (AT) cariboulake (DOT) com
[mailto:info-ingres-admin (AT) cariboulake (DOT) com] On Behalf Of izena (AT) mixmail (DOT) com
Sent: Thursday, September 22, 2005 11:42 AM
To: info-ingres (AT) cariboulake (DOT) com
Subject: [Info-ingres] Unable to kill some sessions


I am unable to kill two sessions that iimonitor marks them as:

cs_state: CS_COMPUTABLE cs_mask: CS_DEAD_MASK,CS_IRPENDING_MASK

I have tried:

- Kill them with ipm. After it, ipm informed that session was removed,
but it was not. Still appeared in the session list.

- Kill the process (in the remote machine) that created them. In this
case a JDBC server. No change.

- Kill them with iimonitor. No result. I also tried the
suspend,remove,resume trick with no results.

I suspect that they perhaps are comsuming quite CPU in a indefinite
loop or something as the system is quiet but CPU is unusually high.

(iimonitor shows that the query is "open ~Q cursor for INGSTMT0 for
readonly using ~V , ~V , ~V , ~V , ~V , ~V")

Any ideas?

Thanks in advance


Carlos

_______________________________________________
Info-ingres mailing list
Info-ingres (AT) cariboulake (DOT) com
http://mailman.cariboulake.com/mailm...py/info-ingres