IDS Forum

Re: ystem Error: Recvd erroneous event on select

Posted By: Art Kagel
Date: Friday, 25 September 2009, at 1:01 p.m.

In Response To: Re: ystem Error: Recvd erroneous event on select (DEEPAK JOSHI)

onstat -k will show you all of the locks held on the server. From that
output you can determine what user session is holding the large number of
locks (owner column). Run onstat -u and grep for the owner's address and
the 3rd column is the owner session's session id. Then onstat -g ses
<session id> will tell you the session's process id (pid) and host. Here's
a sample session:

$ onstat -k

IBM Informix Dynamic Server Version 11.50.FC3X6 -- On-Line -- Up 9 days
02:46:49 -- 976304 Kbytes

Locks
address wtlist owner lklist type
tblsnum rowid key#/bsiz
446e7a58 0 5fee04a8 0
HDR+S 100002 204 0
446e7ad8 0 5fedfc60 0
S 100002 204 0
446e7b58 0 5fee0cf0 0
S 100002 204 0
*44759fd8 0 5fee0cf0 447b5cd8
HDR+S 100002 205 0 *
4478c9d8 0 5fedfc60 446e7ad8
S 100002 202 0
447b5cd8 0 5fee0cf0 448538d8
HDR+S 100002 203 0
447c2dd8 0 5fedfc60 447d89d8
S 100002 205 0
447d89d8 0 5fedfc60 4478c9d8
S 100002 203 0
448538d8 0 5fee0cf0 446e7b58
HDR+S 100002 202 0
9 active, 20000 total, 16384 hash buckets, 0 lock table overflows

So let's say that the lock on tblspace 100002 rowid 205 is the one we're
looking for. So, we look up the owner address '5ee0cf0':

art@Galadriel-II:~/Desktop/firefox$ onstat -u |fgrep 5fee0cf0
5fee0cf0 ---P--- *23 * informix - 0 0
4 247097 356444

That's identified with session # 23, so:

$ onstat -g ses 23

IBM Informix Dynamic Server Version 11.50.FC3X6 -- On-Line -- Up 9 days
02:47:40 -- 976304 Kbytes

session effective #RSAM total
used dynamic
id user user tty pid hostname threads memory
memory explain
23 informix - - *123 * * galadriel* 1
1273856 590464 off

tid name rstcb flags curstk status
50 dbWorker 5fee0cf0 ---P--- 4576 sleeping forever-

Memory pools count 2
name class addr totalsize freesize #allocfrag
#freefrag
23 V 61194040 1269760 682584 959
299
23*O0 V 61450040 4096 808 1
1

name free used name free used

overhead 0 6576 mtmisc 0 192

resident 0 72 scb 0 456

opentable 0 66880 filetable 0 9552

ru 0 616 log 0 16536

temprec 0 130208 partn 0 72

keys 0 21264 ralloc 0 199752

gentcb 0 1752 ostcb 0 2976

sort 0 240 sqscb 0 103872

sql 0 144 rdahead 0 1120

hashfiletab 0 552 buft_buffer 0 2176

sqtcb 0 14328 fragman 0 9480

sapi 0 360 SAPI callback 0 712

sqlj 0 384

sqscb info
scb sqscb optofc pdqpriority sqlstats optcompind
directives
6122c028 6126f028 0 0 0 0
1

Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
Explain
23 sysadmin DR Wait 5 0 0 -
Off

$

You can see that session #23 is associated with pid 123 on host gladriel.
Once you know the session id you can kill the session with "onmode -z
<session id>" and since you also now know the pid you can kill the task
itself at the OS level with kill -9 <pid>

Art

Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.

On Fri, Sep 25, 2009 at 12:20 PM, DEEPAK JOSHI <djoshih@hotmail.com> wrote:

> If we bounce the engine, it will goes to offline and I don't want engine to
> be
> offline, because several users are connected.
>
> Please suggest is there any other way?
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--0015174736ac84fa5b047469e425

Messages In This Thread

• ystem Error: Recvd erroneous event on select
  DEEPAK JOSHI -- Friday, 25 September 2009, at 11:47 a.m.
  • Re: ystem Error: Recvd erroneous event on select
    MIKE MAGIE -- Friday, 25 September 2009, at 12:07 p.m.
    • Re: ystem Error: Recvd erroneous event on select
      DEEPAK JOSHI -- Friday, 25 September 2009, at 12:20 p.m.
      • Re: ystem Error: Recvd erroneous event on select
        Art Kagel -- Friday, 25 September 2009, at 1:01 p.m.
      • Re: ystem Error: Recvd erroneous event on select
        Jonathan Leffler -- Sunday, 27 September 2009, at 5:37 p.m.
  • Re: ystem Error: Recvd erroneous event on select
    MIKE MAGIE -- Friday, 25 September 2009, at 12:11 p.m.
  • Re: ystem Error: Recvd erroneous event on select
    MIKE MAGIE -- Friday, 25 September 2009, at 2:03 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.