ystem Error: Recvd erroneous event on select

How to kill the process, No idea which process is? Informix continues writing this to our database log files and it is causing file system full to 100%. Any clue, how to stop Database for doing this without stopping. 10:28:09 System Error: Recvd erroneous event on select 10:28:09 System Error: Recvd erroneous event on select 10:28:09 System Error: Recvd erroneous event on select 10:28:09 System Error: Recvd erroneous event on select 10:28:09 System Error: Recvd erroneous event on select 10:28:09 System Error: Recvd erroneous event on select 10:28:09 System Error: Recvd erroneous event on select 10:28:09 System Error: Recvd erroneous event on select 10:28:09 System Error: Recvd erroneous event on select 10:28:09 System Error: Recvd erroneous event on select

Bounce the engine.

Also man - if this is that 7.13 system you really need to upgrade. You will get very little "love" on the forum with that version installed, and zero support from IBM, other than MAYBE down systems help.

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?

onstat -k will show you all of the locks held on the server. From thatoutput 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

Likely one of the net vps or another oninit process is writing the message to your log. Almost certainly a bug in the product you have installed. Re-initializing the instance is your work around here.

On Fri, Sep 25, 2009 at 09:20, 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? > No, there probably isn't any other way of dealing with it. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/ "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." NB: Please do not use this email for correspondence. I don't necessarily read it every week, even. Marie von Ebner-Eschenbach<http://www.brainyquote.com/quotes/authors/m/marie_von_ebneresch enbac.html> - "Even a stopped clock is right twice a day." --000feae9aa8b711b04047495fc99