while inserting a record into the table, we are getting with the
below error -874 along with Assert failure.
This happens when tab1 has an insert trigger which is calling a
SP which is inserting into another table which has an insert
trigger too.
INSERT INTO tab1(dossnr, adr_andr_from)
VALUES(50008086,'2001-06-19');
874: General exception error has occurred in the optimizer.
Error in line 1
Near character position 1
08:56:20 IBM Informix Dynamic Server Version 14.10.FC10
08:56:20 Assert Failed: Exception Caught. Type: MT_EX_OS,
Context: mem
08:56:20 Who: Session(10869, informix@darkwood, 3824,
0x4e2773d0)
Thread(11359, sqlexec, 454905b0, 1)
File: mtex.c Line: 481
08:56:20 Action: Please notify IBM Informix Technical Support.
08:56:20 SHM Globals and Master Pool/Master Block Adresses:
0x00000000014ddefd (oninit) afstack
0x00000000014db969 (oninit) afhandler
0x00000000014d86a2 (oninit) affail_interface
0x00000000014e0e52 (oninit) mt_ex_throw_sig
0x00000000014e2828 (oninit) afsig_handler
0x00007ff1701cfb10 (Linux)
0x00000000006ba1c9 (oninit) col2expr
0x00000000006b90bf (oninit) dotted2expr
0x00000000006b54c8 (oninit) expr2expr
0x00000000006c4d84 (oninit) elist2arg
0x0000000000736693 (oninit) common_routine2expr
0x00000000006b57d9 (oninit) expr2expr
0x000000000092893e (oninit) bldtabtrigs
0x000000000092784d (oninit) bldtrigs
0x00000000008849c0 (oninit) itcallbldquery
0x000000000087cca1 (oninit) itbldroot
0x000000000080e0ce (oninit) sqoptim
0x00000000006e4ccf (oninit) ip_sqloptim
0x00000000006e3c84 (oninit) ip_evalsql
0x00000000006dd475 (oninit) runproc
0x00000000006f1359 (oninit) udrlm_spl_execute
0x0000000000b11210 (oninit) udrlm_exec_routine
0x000000000072de0d (oninit) udr_execute
0x0000000000739dc6 (oninit) exroutine
0x00000000008fa341 (oninit) geval
0x00000000016cfc4e (oninit) ev_geval
0x00000000016c692f (oninit) new_eval
0x00000000006dff0a (oninit) ip_evalexpr
0x00000000006dd2b0 (oninit) runproc
0x00000000006f1359 (oninit) udrlm_spl_execute
0x0000000000b11210 (oninit) udrlm_exec_routine
0x000000000072de0d (oninit) udr_execute
0x0000000000739dc6 (oninit) exroutine
0x00000000006097ac (oninit) execproc
0x00000000007212de (oninit) aud_execproc
0x0000000000606aee (oninit) excommand
0x000000000092bba0 (oninit) dotrstmts
0x000000000092b4bb (oninit) dotrigs
0x000000000092a81d (oninit) ferafttrig
0x00000000008b0835 (oninit) addone
0x00000000008ac961 (oninit) ins1row
0x00000000008af19b (oninit) insone_next
0x0000000000919400 (oninit) doinsert
0x0000000000723a75 (oninit) aud_doinsert
0x00000000006076f5 (oninit) excommand
0x0000000000ab211c (oninit) sq_execute_workhorse
0x0000000000ab286d (oninit) sq_execute
0x0000000000b9701e (oninit) sqmain
0x0000000001611e39 (oninit) spawn_thread
0x00000000014cafd3 (oninit) th_init_initgls
0x0000000001513bff (oninit) startup |
