|
Problem IT28484
|
Status: Closed |
CREATE INDEX EXECUTED IN A SP CAN ABORT IN IDX2CB WHEN UPDATE STATS IS RUNNING IN PARALLEL
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
When a SP includes a create temp table with an subsequent create
index on this
temp table and accidently an update statistics or update
statistics for procedure is
running in parallel , the server may report an af file with the
following stack
0x00000000013e7ba9 (/opt/informix_gcdbap/12.10.FC9X8/bin/oninit)
afstack
0x00000000013eae27 (/opt/informix_gcdbap/12.10.FC9X8/bin/oninit)
afhandler
0x00000000013eb2a2 (/opt/informix_gcdbap/12.10.FC9X8/bin/oninit)
affail_interface
0x00000000013eb831 (/opt/informix_gcdbap/12.10.FC9X8/bin/oninit)
mt_ex_throw_sig
0x00000000013fc2c3 (/opt/informix_gcdbap/12.10.FC9X8/bin/oninit)
afsig_handler
0x00007fbeb59b3370 (Linux)
0x00000000006327c8 (/opt/informix_gcdbap/12.10.FC9X8/bin/oninit)
idx2cb
0x0000000000640a04 (/opt/informix_gcdbap/12.10.FC9X8/bin/oninit)
stmt2cb
0x000000000064454e (/opt/informix_gcdbap/12.10.FC9X8/bin/oninit)
p_sp2cb
0x000000000067fd55 (/opt/informix_gcdbap/12.10.FC9X8/bin/oninit)
ip_sqlparse
0x000000000068a1f1 (/opt/informix_gcdbap/12.10.FC9X8/bin/oninit)
ip_evalsql
0x000000000069678d (/opt/informix_gcdbap/12.10.FC9X8/bin/oninit)
runproc
0x0000000000697710 (/opt/informix_gcdbap/12.10.FC9X8/bin/oninit)
udrlm_spl_execute
0x0000000000a5345e (/opt/informix_gcdbap/12.10.FC9X8/bin/oninit)
udrlm_exec_routine
0x00000000006d229c (/opt/informix_gcdbap/12.10.FC9X8/bin/oninit)
udr_execute
0x000000000069841f (/opt/informix_gcdbap/12.10.FC9X8/bin/oninit)
ip_curnext
0x00000000006994c1 (/opt/informix_gcdbap/12.10.FC9X8/bin/oninit)
ip_fetch
0x00000000007f9548 (/opt/informix_gcdbap/12.10.FC9X8/bin/oninit)
getrow
0x00000000007f9dd8 (/opt/informix_gcdbap/12.10.FC9X8/bin/oninit)
fetchrow
0x00000000005cd898 (/opt/informix_gcdbap/12.10.FC9X8/bin/oninit)
exfetch
0x0000000000a1338c (/opt/informix_gcdbap/12.10.FC9X8/bin/oninit)
sql_nfetch
0x0000000000a1397b (/opt/informix_gcdbap/12.10.FC9X8/bin/oninit)
sq_nfetch
0x0000000000adcbf3 (/opt/informix_gcdbap/12.10.FC9X8/bin/oninit)
sqmain
0x0000000001513286 (/opt/informix_gcdbap/12.10.FC9X8/bin/oninit)
spawn_thread
0x00000000013d9840 (/opt/informix_gcdbap/12.10.FC9X8/bin/oninit)
th_init_initgls
0x0000000001442398 (/opt/informix_gcdbap/12.10.FC9X8/bin/oninit)
startup |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of IDS prior to 12.10.xC13. *
****************************************************************
* PROBLEM DESCRIPTION: *
* Create index executed in a Stored Procedure can abort in *
* idx2cb when Update Statistics is running in parallel. *
****************************************************************
* RECOMMENDATION: *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.03.2019
26.09.2019
26.09.2019 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC13
|
| Problem solved according to the fixlist(s) of the following version(s) |
