|
Problem IT44934
|
Status: Closed |
VARIOUS ASSERTION FAILURES SEEN IN FUNCTION STCMPRI WHEN RUNNINGA STORED PROCEDURE MORE THAN ONCE
|
| product: |
INFORMIX SERVER / 5725A3900 / E10 - |
| Problem description: |
It's possible to see error 1206 and 874 being reported along
with the following stacks when an SPL is run more than once.
0x00007fa513bddb10 (Linux)
0x000000000170b5bd (oninit) stcmpri
0x000000000173c9ef (oninit) todate
0x0000000001718c42 (oninit) excmp
0x000000000083bb4e (oninit) op_adjust_fltrs
0x000000000084e1a7 (oninit) opinit.constprop.82
0x00000000008464d4 (oninit) op_opinit
0x000000000080b20e (oninit) sqoptim
0x0000000000850714 (oninit) opinit.constprop.82
0x00000000008464d4 (oninit) op_opinit
0x000000000080b20e (oninit) sqoptim
0x00000000006e442c (oninit) ip_evalsql
0x00000000006dd475 (oninit) runproc
0x00000000006f1359 (oninit) udrlm_spl_execute
0x0000000000b11210 (oninit) udrlm_exec_routine
0x000000000072de0d (oninit) udr_execute
0x00000000006e8feb (oninit) ip_fetch
0x000000000087569b (oninit) getrow
0x00000000008755de (oninit) fetchrow
0x0000000000608244 (oninit) exfetch
0x0000000000ab8a2d (oninit) sql_nfetch
0x0000000000ab8304 (oninit) sq_nfetch
0x0000000000b9701e (oninit) sqmain
If error trap 874 is set ...
0x0000000000efb0b8 (oninit) check_traperror
0x0000000000765301 (oninit) sqerr
0x000000000080a3cc (oninit) sqoptim
0x0000000000850714 (oninit) opinit.constprop.82
0x00000000008464d4 (oninit) op_opinit
0x000000000080b20e (oninit) sqoptim
0x00000000006e442c (oninit) ip_evalsql
0x00000000006dd475 (oninit) runproc
0x00000000006f1359 (oninit) udrlm_spl_execute
0x0000000000b11210 (oninit) udrlm_exec_routine
0x000000000072de0d (oninit) udr_execute
0x00000000006e8feb (oninit) ip_fetch
0x000000000087569b (oninit) getrow
0x00000000008755de (oninit) fetchrow
0x0000000000608244 (oninit) exfetch
0x0000000000ab8a2d (oninit) sql_nfetch
0x0000000000ab8304 (oninit) sq_nfetch
0x0000000000b9701e (oninit) sqmain
0x000000000170b5bd (oninit) stcmpri
0x000000000173a9cf (oninit) rvaldataDate
0x0000000000aed8cc (oninit) valstore
0x000000000086a436 (oninit) loadkey
0x00000000008699ee (oninit) loadidxkey
0x0000000000864dd7 (oninit) loadindex_bounds
0x00000000008658fa (oninit) readidx_init
0x0000000000866a29 (oninit) readidx_new
0x000000000085f84f (oninit) gettupl
0x000000000085a217 (oninit) scan_next
0x0000000000bd726e (oninit) join_next
0x0000000000bdf7c6 (oninit) next_row.part.7
0x0000000000bdd3c7 (oninit) get_first_row_from_producer
0x0000000000bd9a88 (oninit) group_open
0x000000000086cde5 (oninit) filltemp
0x0000000000859a08 (oninit) scan_open
0x000000000086ec35 (oninit) materialize_viewtmp
0x000000000086ed44 (oninit) materialize_viewtmp
0x000000000086ed44 (oninit) materialize_viewtmp
0x000000000086ed44 (oninit) materialize_viewtmp
0x000000000086ed44 (oninit) materialize_viewtmp
0x000000000086ed44 (oninit) materialize_viewtmp
0x000000000086ed44 (oninit) materialize_viewtmp
0x000000000086ed44 (oninit) materialize_viewtmp
0x0000000000874584 (oninit) prepselect
0x0000000000873629 (oninit) doselinto
0x000000000060595c (oninit) excommand
0x00000000006e4090 (oninit) ip_evalsql
0x00000000006dd475 (oninit) runproc
0x00000000006f1359 (oninit) udrlm_spl_execute
0x0000000000b11210 (oninit) udrlm_exec_routine
0x000000000072de0d (oninit) udr_execute
0x00000000006e8feb (oninit) ip_fetch
0x000000000087569b (oninit) getrow
0x00000000008755de (oninit) fetchrow
0x0000000000608244 (oninit) exfetch
0x0000000000ab8a2d (oninit) sql_nfetch
0x0000000000ab8304 (oninit) sq_nfetch
0x0000000000b9701e (oninit) sqmain
0x00000000014d86a2 (oninit) affail_interface
0x000000000152b402 (oninit) mem_asfail
0x00000000015214d8 (oninit) mt_shm_free_pool
0x0000000001539cac (oninit) destroy_session
0x0000000000b9c745 (oninit) sq_exit
0x0000000000b9701e (oninit) sqmain
0x0000000001611e39 (oninit) spawn_thread |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 14.10.xC11. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 14.10.xC11. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 14.10.xC11. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 14.10.xC11. *
**************************************************************** |
| Comment |
Fixed in Informix Server 14.10.xC11. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.11.2023
03.06.2024
03.06.2024 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
