|
Problem IT37096
|
Status: Closed |
USING BTS INDEX IN TRANSACTION RUN IN PARALLEL CAN LEAD TO AFS
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
Using BTS indexes in transactions which are run in parallel will
after some time throw afs when using more than one BTS VP.
The exact stack is dependent on the setting of STACKSIZE, for
smaller
stacksizes it will show a stack like this:
base: 0x00000000496d6000
len: 102400
pc: 0x00000000014807de
tos: 0x00000000496e8870
state: running
vp: 15
0x00000000014807de (oninit) mt_call_size
0x00000000005ced7d (oninit) mi_call_size
0x00007f4139cd29cd
(/data/informix/IBM/12.10.FC10/extend/bts.3.11/bts.bld)
bts_am_getnext
0x0000000000ae0d22 (oninit) udrlm_clang_execute_internal
0x0000000000ae1ccf (oninit) udrlm_clang_execute
0x0000000000a86b9e (oninit) udrlm_exec_routine
0x00000000006fe079 (oninit) udr_execute
0x00000000006ff9aa (oninit) udr_execute_vti_vii_file
0x000000000164851e (oninit) vti_vii_udr_execute
0x0000000001645626 (oninit) vii_getnext
0x000000000150dc30 (oninit) fmread
0x000000000080e1f9 (oninit) getsinglerow
0x0000000000819d4d (oninit) readidx_new
0x000000000081e734 (oninit) gettupl
0x00000000008213b4 (oninit) scan_next
0x0000000000b81dc5 (oninit) join_next
0x0000000000b82da0 (oninit) next_row
0x0000000000b83741 (oninit) get_first_row_from_producer
0x0000000000b85e56 (oninit) hash_process_all_groups
0x0000000000b87836 (oninit) group_open
0x0000000000848131 (oninit) sort_open
0x000000000081083d (oninit) filltemp
0x000000000081848f (oninit) scan_open
0x000000000080603b (oninit) materialize_viewtmp
0x00000000008060d1 (oninit) materialize_viewtmp
0x0000000000825084 (oninit) prepselect
0x0000000000a4582e (oninit) open_cursor
0x00000000006ba95b (oninit) ip_scurstart
0x00000000006beb55 (oninit) ip_opencur
0x00000000006c1875 (oninit) runproc
0x00000000006c2e81 (oninit) udrlm_spl_execute
0x0000000000a86b9e (oninit) udrlm_exec_routine
0x00000000006fe079 (oninit) udr_execute
0x00000000006c3b8c (oninit) ip_curnext
0x00000000006c44b7 (oninit) ip_fetchcur
0x00000000006c1892 (oninit) runproc
0x00000000006c2e81 (oninit) udrlm_spl_execute
0x0000000000a86b9e (oninit) udrlm_exec_routine
0x00000000006fe079 (oninit) udr_execute
0x00000000006c3b8c (oninit) ip_curnext |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC7. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 12.10.xC15 or 14.10.xC7 (when *
* available). *
****************************************************************
This fix reverses the change fixed by IT06304 to prevent
asserting threads. |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC7. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 12.10.xC15 or 14.10.xC7 (when *
* available). *
****************************************************************
This fix reverses the change fixed by IT06304 to prevent
asserting threads. |
| Comment |
Fixed in Informix Server 12.10.xC15 and 14.10.xC7. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.06.2021
25.08.2021
25.08.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
