APAR status
Closed as duplicate of another APAR.
Error description
This problem can be observed in 11.70.FC8W1 and 12.10.FC13 Consider a file file that contains around 17000 inserts into a table that has an insert trigger. If you load this file into a buffer in an esql/c program and then execute immediate that buffer, you can see long running threads with stacks like: I've seen the thread not yield for minutes with stacks like these first two: #0 0x00000000008f2d40 in foldviews () #1 0x00000000006cbc23 in qd_expandviews () #2 0x0000000000a316d7 in bldstructs () #3 0x0000000000a35ea5 in sqcmd () #4 0x0000000000a40c2a in sq_cmnd () #5 0x0000000000a40d84 in sq_prepare () #6 0x0000000000b0b641 in sqmain () #7 0x000000000155d1ab in spawn_thread () #8 0x0000000001420130 in th_init_initgls () #9 0x0000000001465c48 in startup () #10 0x0000000000000000 in ?? () #0 0x00000000009728cc in oplooksubq () #1 0x00000000006cbc05 in qd_expandviews () #2 0x0000000000a316d7 in bldstructs () #3 0x0000000000a35ea5 in sqcmd () #4 0x0000000000a40c2a in sq_cmnd () #5 0x0000000000a40d84 in sq_prepare () #6 0x0000000000b0b641 in sqmain () #7 0x000000000155d1ab in spawn_thread () #8 0x0000000001420130 in th_init_initgls () #9 0x0000000001465c48 in startup () #10 0x0000000000000000 in ?? () Generally, this next stack can be seen for a few seconds once the thread reaches the sq_execute phase #0 0x00000000008f2db5 in foldviews () #1 0x00000000006cbc23 in qd_expandviews () #2 0x0000000000a316d7 in bldstructs () #3 0x00000000008c7ad1 in dotrstmts () #4 0x00000000008c8c12 in dotrigs () #5 0x00000000008c91e0 in ferafttrig () #6 0x000000000085512e in addone () #7 0x0000000000859464 in insone_next () #8 0x00000000008c1851 in doinsert () #9 0x00000000006eaadd in aud_doinsert () #10 0x00000000005fb7d8 in excommand () #11 0x0000000000a4d06c in sq_execute () #12 0x0000000000b0b641 in sqmain () #13 0x000000000155d1ab in spawn_thread () #14 0x0000000001420130 in th_init_initgls () #15 0x0000000001465c48 in startup () #16 0x0000000000000000 in ?? () If you interrupt the client, you can also see stacks like this for a minute or so without yielding: #0 0x00000000005f3fc2 in close_cb_subtree_r () #1 0x00000000005f4a37 in close_cb_subtree () #2 0x00000000005f5191 in closesdb () #3 0x00000000005f5466 in doreleasesdb () #4 0x0000000000990fe5 in sq_release () #5 0x00000000009b3401 in flushmsg () #6 0x00000000009b3c18 in flushpipe () #7 0x00000000009b8eb6 in puterr () #8 0x00000000009b017b in sq_execute () #9 0x0000000000a6e78b in sqmain () #10 0x00000000013e5639 in spawn_thread () #11 0x000000000131e360 in th_init_initgls () #12 0x00000000012eaaa8 in startup () #13 0x0000000000000000 in ?? ()
Local fix
Problem summary
Problem conclusion
Temporary fix
Comments
This APAR is a duplicate of IT29507
APAR Information
APAR number
IT29508
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
C10
Status
CLOSED DUB
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-06-20
Closed date
2022-07-26
Last modified date
2022-09-08
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Line of Business":[{"code":"LOB10","label":"Data and AI"}]}]
Document Information
Modified date:
08 September 2022