Re: Rogue user session


Hi Nog,

The sessions 32885750, 32908171 and 32902685 are all waiting for
transaction 539f5f5c and session 32885158 is waiting for condition
52ccd890 so post the output from

onstat -x|egrep -i
"539f5f5c|4ef13618|4ef1d618|512f3318|512f3318"
onstat -
onstat -g con |grep -i 512f3318
onstat -g ses 32885158

to have a bit more information regarding what's going on. Also check
the online.log for Long Transactions.

RoB


Nog wrote:
Hi,

Informix Dynamic Server Version 7.31.UD7, solaris 8

I've got a rogue user session connected to my instance that I need to
remove, if possible without bouncing the engine.

snippet frm onstat -u

4ef13618 T--P--- 32885750 userxyz console 539f5f5c 0 0 0
0
4ef1d618 T--P--- 32908171 userxyz console 539f5f5c 0 0 0
0
512f3318 T--P--- 32902685 userxyz console 539f5f5c 0 0 0
0
539c9818 Y--P--- 32885158 userxyz 29 52ccd890 0 3 202
129

basically, the user was running an SQL script to setup a database, the
script hung, so he killed (-9?) the process, this left the session
32885158, an onmode -z generated the session 32885750, trying it again
just created another session and an onmode -Z created another.

What can I do, short of bouncing the engine, to clear these sessions.

thanks

.