Informix - Problem description
Problem IT17068 | Status: Closed |
ASSERT FAILURE IN HASH_PROCESS_ALL_GROUPS POSSIBLE FOR QUERY WITH AGGREGATE FUNCTION AND GROUP BY CLAUSE | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
A query with an aggregate function and group by clause may encounter an assert failure with a stack like: afstack mt_ex_throw_sig afsig_handler hash_process_all_groups group_open sort_open prepselect open_cursor sql_open sq_open sqmain spawn_thread th_init_initgls | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of 12.10.xC7W1 and 12.10.xC7W2 * **************************************************************** * PROBLEM DESCRIPTION: * * An assertion failure may occur for a query under the * * following conditions: * * - query has a group by clause * * - at least one of the group by columns is of type varchar * * or lvarchar, or an expression that results in a character * * type * * - there are many groups produced and the hash table used * * for processing grouping operation overflowed to disk * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC8 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 15.09.2016 09.12.2016 09.12.2016 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC8 | |
Problem solved according to the fixlist(s) of the following version(s) |