Informix - Problembeschreibung
Problem IC61250 | Status: Geschlossen |
ASSERTION FAILURE WHEN YOU RUN A STORED PROCEDURE THAT HAD UPDATE STATISTICS RUN ON IT WITH PDQ ENABLED | |
Produkt: | |
IBM IDS ENTRP E / 5724L2304 / B15 - IDS 11.50 | |
Problembeschreibung: | |
A stored procedure crashes a scan thread and the database serverif PDQ was enabled when 'update statistics for routine' was run. The stack trace in the assertion failure file will look similar to this: (oninit) afstack (oninit) mt_ex_throw_sig (oninit) afsig_handler (Linux) <signal frame> (oninit) gettupl (oninit) scan_next (oninit) producer_thread (oninit) startup | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users running stored procedures with implicitly casted * * lvarchar and PDQ . * **************************************************************** * PROBLEM DESCRIPTION: * * When SPL uses implicitly casted lvarchar and if PDQ was * * enabled when 'update statistics for routine' was run the * * server crashes in the scan thread. * **************************************************************** * RECOMMENDATION: * * Upgrade to IDS 11.50.xC5 or above. * **************************************************************** | |
Local-Fix: | |
Disable PDQ and then run update statistic for routine. | |
Lösung | |
Problem is fixed in IDS 11.50.xC5. | |
Workaround | |
Disable PDQ before running update statistics. | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 26.05.2009 19.01.2010 19.01.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
11.50.xC5 | |
Problem behoben lt. FixList in der Version | |
11.50.xC4.W1 | |
11.50.xC5 |