INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

You may encounter an assertion like

afstack
mt_ex_throw_sig
afsig_handler

mt_slock
slc_lookup_cache
ssc_identity
ssc_sqmksdb
sq_cmnd
sq_prepare
sqmain
spawn_thread
th_init_initgls
startup

with an error reported

  959: The current transaction has been rolled back due to an
internal error.

  172: ISAM error:  Unexpected internal error

when statement cache is enabled and a very large statement is
run. In the reported case the statement was a big UNION ALL with
about 49141000 characters. The exact nature of the statement is
irrelevant to the occurrence. The trigger for the AF is the mere
size of the statement and the attempt to look it up in the
statement cache.

Disabling the statement cache would be the option for a
temporary relief (with the associated performance penalty it
might have, unfortunately).

****************************************************************
* USERS AFFECTED:                                              *
* Users of IDS prior to 12.10.xC12.                            *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* Assert Failure possible in mt_slock() called by              *
* slc_lookup_cache() when very large statement is run with     *
* statement cache enabled.                                     *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

26.12.2018
04.10.2019
04.10.2019

12.10.xC12