Assertion messages in MSGPATH:
14:46:22 IBM Informix Dynamic Server Version 12.10.FC4W1
14:46:22 Who: Session(28, user@machine, 6292360,
70000002048ce88)
Thread(55, sqlexec, 70000002044c188, 1)
File: mtex.c Line: 420
14:46:22 Action: Please notify IBM Informix Techical Support.
14:46:22 stack trace for pid 5178194 written to
/dumpdir/af.41f7e0e
14:46:22 See Also: /dumpdir/af.41f7e0e, shmem.41f7e0e.0
14:46:27 Exception Caught. Type: MT_EX_OS, Context: mem
14:46:27 (-9791): ERROR: Routine execution trap --
procname=<testspl> procid=533
reason: mem
Stack trace for failing thread:
afstack
afhandler
affail_interface
mt_ex_throw_sig@AF11_4
afsig_handler
rvaldataChar
chkralloc
valstore_deepcopy
IPRA.$ip_evalexpr
runproc
udrlm_spl_execute
udrlm_exec_routine
udr_execute
udr_spl_curnext
ip_curnext
ip_fetch
getrow
fetchrow
exfetch
sql_nfetch
sq_nfetch
sqmain
listen_verify
spawn_thread
th_init_initgls
startup
onstat -g ses output
Sess SQL Current Iso Lock SQL
ISAM F.E.
Id Stmt type Database Lvl Mode ERR
ERR Vers Explain
32 t1 CR Not Wait 0
0 9.24 Off
Stored procedure stack :
context proc-counter opcode name
----------------------------------------------------------------
--
0x07000000219dd058 0x70000002192f780+0x0010 EXPR t1:jr1
Current SQL statement (1172) in procedure t1:jr1
proc-counter 0x70000002192f780 opcode EXPR
(|| p_arti.sum_fam[4], p_arti.sum_fam[8])
The let statement in the SPL code that generates the failure:
create procedure testspl()
returning char(2);
define global p_arti row_arti default null;
define v_sector_seccion char(2);
let v_sector_seccion = (NULL::CHAR);
LET v_sector_seccion = p_arti.sum_fam[4]||p_arti.sum_fam[8];
return v_sector_seccion;
end procedure; |
