|
Problem IT17112
|
Status: Closed |
ASSERT FAIL AND CRASH POSSIBLE IN SEND_ROW_TO_CONSUMER OR PK_PUTFREE WHEN RUNNING QUERY WITH PDQ
|
| product: |
INFORMIX SERVER / 5725A3900 / B50 - IDS 11.50 |
| Problem description: |
Error Description
----------------------------------------------------------------
------------------
When running a query that involves a correlated sub-query with
PDQ enabled, it is possible for one or more of the threads to
raise an AF and crash with stacks similar to:
afstack
mt_ex_throw_sig
afsig_handler
send_row_to_consumer
producer_thread
startup
or
afstack
mt_ex_throw_sig
afsig_handler
pk_putfree
xchg_next
join_next
startup
SQL:
select m.name, count(*) from tab1 u, tab2 m, tab3 e where
u.ev_class_id = 25 and u.ev_id = e.ev_id and u.ev_id =
m.ev_id and not
exists (select * from tab4 c, tab5 b, tab2 m WHERE
c.ev_mkt_id =
m.ev_mkt_id and c.ev_oc_id = b.ev_oc_id and m.ev_id
= e.ev_id )
group by 1 order by 2 desc
This problem has the same characteristics as IC85782 which is
fixed in the earlier release 11.70.xC6. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All platforms *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 11.50.xC10 *
**************************************************************** |
| Local Fix: |
If the query is run without PDQ then no AF occurs. |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.09.2016
27.06.2017
27.06.2017 |
| Problem solved at the following versions (IBM BugInfos) |
11.50.xC10
|
| Problem solved according to the fixlist(s) of the following version(s) |
