Assert Failed: No Exception Handler
I recently found this message in my informix 7.31FD3W1
-------------------------------------------------------------
09:57:36 Assert Failed: No Exception Handler
09:57:36 Informix Dynamic Server Version 7.31.FD3W1
09:57:36 Who: Session(64147, gisp@a0648911, 284, 547084728)
Thread(89111, sqlexec, c000000042e71640, 3)
File: mtex.c Line: 454
09:57:36 Results: Exception Caught. Type: MT_EX_OS, Context: mem
09:57:36 Action: Please notify Informix Technical Support.
09:57:36 stack trace for pid 3390 written to /tmp/af.5fffd15e
09:57:44 See Also: /tmp/af.5fffd15e
09:57:44 mtex.c, line 454, thread 89111, proc id 3390, No Exception
Handler.
09:57:44 PANIC: Attempting to bring system down
-----------------------------------------------------------------
This is the onstat -g sql of /tmp/af.5fffd15e
-----------------------------------------------------------------
/opt/informix/bin/onstat -g ses 64147:
Informix Dynamic Server Version 7.31.FD3W1 -- On-Line -- Up 6 days
04:52:33 -- 761496 Kbytes
session #RSAM total used
id user tty pid hostname threads memory
memory
64147 gisp CPU1463 284 a0648911 1 81920 47224
tid name rstcb flags curstk status
89111 sqlexec c000000042e71640 ---P--- 34944 running
Memory pools count 1
name class addr totalsize freesize #allocfrag
#freefrag
Changing data structure forced command termination.
===========------------- - - - - - -
/opt/informix/bin/onstat -g sql 64147:
Informix Dynamic Server Version 7.31.FD3W1 -- On-Line -- Up 6 days
04:52:33 -- 761496 Kbytes
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
64147 - dbtecnica CR Not Wait 0 0 9.15
Last parsed SQL statement :
select fecha from status_avl where code = '46A1'
--------------------------------------------------------------------
why does the query caused this error???
is a simple query.
this is the table's schema :
create table "sistec".status_avl
(
code varchar(4) not null ,
fecha varchar(12),
origin varchar(20),
status varchar(2),
flags varchar(2),
gps_quality varchar(2),
gps_error varchar(2),
latitude float,
longitude float,
altitude float,
speed varchar(3),
direction varchar(2),
fisical_input varchar(5),
input_1 varchar(2),
input_2 varchar(2),
output varchar(4),
command varchar(2),
event_1 varchar(3),
event_2 varchar(254),
message varchar(20),
id_link varchar(2),
num_frame varchar(20),
analog_input_1 varchar(2),
analog_input_2 varchar(2),
lastalarm varchar(254),
pending varchar(2),
utmx varchar(20),
utmy varchar(20)
);
revoke all on "sistec".status_avl from "public";