|
Problem IT28718
|
Status: Closed |
FAILURES POSSIBLE WHEN CALLING VARIOUS HASH JOIN FUNCTIONALITY FROM COLLSUBQ_OPEN
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
The problem was originally reported running a 12.10.FC7W1 server
on linux x86_64. The repro
I developed shows the problem also reproduces in the latest
12.10 server (FC12W1).
The following are examples of stacks reported for this issue:
mt_aio_reset
fstmp_io
hash_writeout_buffer
hash_write_buffer_to_temp
ha_write_out_full_page
ha_insrt_hashtab_or_ovrfl_page
hjoin_open
sort_open
prepselect
collsubq_open
ifx_coll_open_with_options
mi_collection_open_with_options
collectionoutput_internal
udrlm_clang_execute_internal
udrlm_clang_execute
udrlm_exec_routine
udr_execute
exroutine
geval
geval
fnreplace
geval
fnreplace
geval
fnreplace
geval
fnreplace
geval
fnreplace
geval
ev_geval
new_eval
sort_open
prepselect
excommand
sq_exselect
sqmain
spawn_thread
th_init_initgls
startup
Other stacks vary in the topmost functions with startup through
collsubq_open() being consistent
but variations above comparable to these below:
afstack
afhandler afcrash_interface
mt_clear_mutex
mt_aio_free
fstmp_drop
drop_hash_temp_partn
hjcleanup
hjoin_close
sort_open
prepselect
collsubq_open
afstack
afhandler
affail_interface
mt_ex_throw_sig
afsig_handler
mt_aio_reset
fstmp_io
hash_writeout_buffer
hash_write_buffer_to_temp
ha_write_out_rem_part_pages
setup_new_environment
hjoin_next
sort_open
prepselect
collsubq_open
afstack
afhandler
affail_interface
mt_ex_throw_sig
afsig_handler
hash_read_buffer
hash_read_tuple
hash_read_tuple_from_temp
hjoin_next
sort_open
prepselect
collsubq_open |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of IDS prior to 12.10.xC13. *
****************************************************************
* PROBLEM DESCRIPTION: *
* Failures possible when calling various hash join *
* functionality from collsubq_open. *
****************************************************************
* RECOMMENDATION: *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.04.2019
24.09.2019
24.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) |
