[Info-ingres] Re: RE: [Info-ingres] Unable to kill some sessions

#1

Hi AndrÃ©,

It seems not. This is the complete info from iimonitor

Session 000000010ABFC580:29757 (Os_user ) cs_state: CS_COMPUTABLE
cs_mask: CS_DEAD_MASK,CS_IRPENDING_MASK
DB Name: Db (Owned by: dbowner )
User: dbuser (Os_user )
User Name at Session Startup: dbuser
Terminal: batch
Group Id: mygroup
Role Id:
Application Code: 00000000 Current Facility: OPF (00000004)
Client user: Os_user
Client host: remote_machine
Client tty: remote_machine
Client pid: 18831
Client connection target: node::db
Client information:
user='os_user',host='remote_machine',tty='remote_m achine',pid=18831,conn='node::db'
Description: JSQL/18831/dbuser
Query: open ~Q cursor for INGSTMT0 for readonly using ~V , ~V , ~V , ~V , ~V , ~V

Carlos

Quote:

Is the state NOINT ?
Maybe it's rolling back. Sometimes that can take a while.
Andre
-----Original Message-----
From: <a
href="javascript:sendMsg('info-ingres-admin (AT) cariboulake (DOT) com');">info-ingres-admin (AT) cariboulake (DOT) com</a
a
href="javascript:sendMsg('[mailto:info-ingres-admin (AT) cariboulake (DOT) com]');">[mailto:info-ingres-admin (AT) cariboulake (DOT) com]</a

On Behalf Of <a href="javascript:sendMsg('izena (AT) mixmail (DOT) com');">izena (AT) mixmail (DOT) com</a>

Quote:

Sent: Thursday, September 22, 2005 11:42 AM
To: <a
href="javascript:sendMsg('info-ingres (AT) cariboulake (DOT) com');">info-ingres (AT) cariboulake (DOT) com</a
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
a href="javascript:sendMsg('Info-ingres (AT) cariboulake (DOT) com
http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres');">Info-ingres (AT) cariboulake (DOT) com
http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres</a

---------------------------------------------------------
Juega y llévate una PS2 two: http://juegos.ya.com/consolas_y_pc/2...curso-ps2.html
Ya.com ADSL 2MB + Llamadas 24 horas: desde 26,95 €/mes + IVA. Navega y habla de forma ilimitada. Sin compromiso de permanencia. http://acceso.ya.com/ADSLllamadas/2mb

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

[Info-ingres] Re: RE: [Info-ingres] Unable to kill some sessions

comp.databases.ingres comp.databases.ingres

[Info-ingres] Re: RE: [Info-ingres] Unable to kill some sessions - 09-22-2005 , 11:14 AM