This problem was reported in 12.10.FC5W1 on linux x86_64. I was
able to put together a stress test that
reproduces the problem when the only session running is the
session running the SQL below. Note that
the file $INFORMIXDIR/etc/sysadmin/stop is present and the
scheduler is not running.
$ cat loadmap.sql
set lock mode to wait 30;
set isolation to committed read last committed;
set constraints for devicenumplanmapendusermap disabled;
SET INDEXES FOR devicenumplanmapendusermap DISABLED;
INSERT INTO devicenumplanmapendusermap select * from
devicenumplanmapendusermap2;
SET INDEXES FOR devicenumplanmapendusermap ENABLED;
set constraints for devicenumplanmapendusermap enabled;
delete from devicenumplanmapendusermap;
$ while true; do
> dbaccess cisco loadmap.sql
> done
If you are trapping for -242 error via onmode -I 242, you will
get an assertion like below and trap a session on the
SET INDEXES FOR ... ENABLED:
IBM Informix Dynamic Server Version 12.10.UC5W1 -- On-Line -- Up
00:12:28 -- 125768 Kbytes
Sess SQL Current Iso Lock SQL
ISAM F.E.
Id Stmt type Database Lvl Mode ERR
ERR Vers Explain
11760 SET OBJMODE cisco LC Wait 30 -242
-106 9.24 Off
Current SQL statement (7) :
SET INDEXES FOR devicenumplanmapendusermap ENABLED
14:50:54 Assert Failed: found errno 242 in session 11760
14:50:54 IBM Informix Dynamic Server Version 12.10.UC5W1
14:50:54 Who: Session(11760, informix@server, 23179,
0x449a20cc)
Thread(233327, sqlexec, 4497218c, 8)
File: rsdebug.c Line: 3398
14:50:54 Action: Use onmode -I to stop verbose error
trapping.
14:50:54 stack trace for pid 15417 written to
/opt/informix/tmp/af.9357511e
14:50:54 See Also: /opt/informix/tmp/af.9357511e,
shmem.9357511e.0
14:50:55 found errno 242 in session 11760
(oninit)afstack
(oninit)afhandler
(oninit)affail_interface
(oninit)check_traperror
(oninit)sqerr
(oninit)sqerr1
(oninit)sqnameerr
(oninit)setobjmode
(oninit)aud_setobjmode
(oninit)excommand
(oninit)sq_execute
(oninit)sqmain
(oninit)spawn_thread
(oninit)th_init_initgls
(oninit)startup |
