|
Problem IT26655
|
Status: Geschlossen |
PREPARING LARGE STATEMENTS THAT CONSIST OF MANY SMALLER STATEMENTS CAN CAUSE SEGV IN STMT2CB WHILE PARSING
|
| Produkt: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problembeschreibung: |
Common stacks for the asserting threads include:
0x000000000141fa89 (oninit) afstack
0x0000000001423571 (oninit) mt_ex_throw_sig
0x000000000142e443 (oninit) afsig_handler
0x0000003ddfa0e4c0 (Linux)
0x000000000066be08 (oninit) stmt2cb
0x000000000066fa6e (oninit) p_sp2cb
0x0000000000a3072c (oninit) parsecmd
0x0000000000a30c42 (oninit) sqcmd
0x0000000000a3b9ca (oninit) sq_cmnd
0x0000000000a3bb24 (oninit) sq_prepare
0x0000000000b0af81 (oninit) sqmain
0x000000000154cb1b (oninit) spawn_thread
0x0000000001411550 (oninit) th_init_initgls
0x0000000001456e88 (oninit) startup
0x000000000141fa89 (oninit) afstack
0x0000000001423571 (oninit) mt_ex_throw_sig
0x000000000142e443 (oninit) afsig_handler
0x0000003ddfa0e4c0 (Linux)
0x000000000066be08 (oninit) stmt2cb
0x000000000066fa6e (oninit) p_sp2cb
0x000000000072533e (oninit) ssc_link
0x0000000000a3060e (oninit) parsecmd
0x0000000000a30c42 (oninit) sqcmd
0x0000000000a3b9ca (oninit) sq_cmnd
0x0000000000a3bb24 (oninit) sq_prepare
0x0000000000b0af81 (oninit) sqmain
0x000000000154cb1b (oninit) spawn_thread
0x0000000001411550 (oninit) th_init_initgls
0x0000000001456e88 (oninit) startup
The statement that the parser was parsing was about 300 lines of
update statements that looked like this:
UPDATE ResulAnaRede SET POTRESUL = 38.253 WHERE DATPDP =
'20181018' AND
CODEQUIP = 'CHPTU04T3' AND TIPEQUIP = 'TR' AND INTRESUL = 4
AND ((POTRESUL
IS NULL) OR (POTRESUL IS NOT NULL AND POTRESUL < 38.253));
UPDATE
ResulAnaRede SET POTRESUL = 37.761 WHERE DATPDP =
'20181018' AND CODEQUIP
= 'CHPTU04T2' AND TIPEQUIP = 'TR' AND INTRESUL = 4 AND
((POTRESUL IS NULL)
OR (POTRESUL IS NOT NULL AND POTRESUL < 37.761)); UPDATE
ResulAnaRede SET
POTRESUL = 38.728 WHERE DATPDP = '20181018' AND CODEQUIP =
'CHPTU04T4'
AND TIPEQUIP = 'TR' AND INTRESUL = 4 AND ((POTRESUL IS NULL)
OR
(POTRESUL IS NOT NULL AND POTRESUL < 38.728)); UPDATE
ResulAnaRede SET
POTRESUL = 27.53 WHERE DATPDP = '20181018' AND CODEQUIP =
'CHPTU-2MTT-'
AND TIPEQUIP = 'LN' AND INTRESUL = 4 AND ((POTRESUL IS NULL)
OR (POTRESUL
IS NOT NULL AND POTRESUL < 27.53));
... |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Users of IDS prior to 12.10.xC13. *
****************************************************************
* PROBLEM DESCRIPTION: *
* Preparing large statements that consist of many smaller *
* statements can cause segv in stmt2cb while parsing. *
****************************************************************
* RECOMMENDATION: *
**************************************************************** |
| Local-Fix: |
|
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 18.10.2018
26.09.2019
26.09.2019 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
12.10.xC13
|
| Problem behoben lt. FixList in der Version |
