A stored procedure which creates 2 timeseries using the Clip()
function and then uses them as arguments in the Apply() function
can either fail with this error:
9791: User Defined Routine (deepcopy) execution failed.
or return incorrect (NULL) values:
(expression) origin(2011-01-02 00:30:00.00000),
calendar(cal30min), container(
), threshold(0), regular, [(NULL), (NULL), (NULL),
(NULL), (NULL)
, (NULL), (NULL), (NULL), (NULL), (NULL), (NULL),
(NULL), (NULL),
(NULL), (NULL), (NULL), (NULL), (NULL), (NULL),
(NULL), (NULL),
(NULL), (NULL), (NULL), (NULL), (NULL), (NULL),
(NULL), (NULL), (
NULL), (NULL), (NULL), (NULL), (NULL), (NULL),
(NULL), (NULL), (N
ULL), (NULL), (NULL), (NULL), (NULL), (NULL),
(NULL), (NULL), (NU
LL), (NULL), (NULL)]
1 row(s) retrieved.
The error -9791 is accompanied with following assertion failure
in the online.log:
13:51:58 Assert Failed: Exception Caught. Type: MT_EX_OS,
Context: mem
13:51:58 IBM Informix Dynamic Server Version 12.10.FC1
13:51:58 Who: Session(33, informix@host, 26388, 112ff6fa8)
Thread(181, sqlexec, 112fb83f8, 1)
File: mtex.c Line: 425
13:51:58 Action: Please notify IBM Informix Technical Support.
13:51:58 stack trace for pid 26300 written to /tmp/af.49dc1de
13:51:58 See Also: /tmp/af.49dc1de, shmem.49dc1de.0
13:52:08 Exception Caught. Type: MT_EX_OS, Context: mem
13:52:08 (-9791): ERROR: Routine execution trap --
procname=<deepcopy> procid=1006
reason: mem
The stack trace of the failing thread looks like this:
TimeSeries.bld :: ts_deep_copy
oninit :: udrlm_clang_execute_internal
oninit :: udrlm_clang_execute
oninit :: udrlm_exec_routine
oninit :: udr_execute
oninit :: deepcopyval
oninit :: ip_evalassg2
oninit :: runproc
oninit :: udrlm_spl_execute
oninit :: udrlm_exec_routine
oninit :: udr_execute
oninit :: udr_spl_curnext
oninit :: ip_curnext
oninit :: ip_fetch
oninit :: getrow
oninit :: fetchrow
oninit :: exfetch
oninit :: sql_nfetch
oninit :: sq_nfetch
oninit :: sqmain
oninit :: listen_verify
oninit :: spawn_thread
oninit :: startup |
