Informix - Problem description
Problem IT34254 | Status: Closed |
QUERIES AGAINST SYSMASTER TABLES SYSCMSMTAB AND SYSCMSMUNIT CAN ASSERT WITH STACK IN PRCMSMUNIT | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
The following was reported and later reproduced running 12.10.FC11 on linux x86-64 but this is probably not a platform specific problem. The connection manager will run queries like:⠨⠨SELECT cm.name, cluster.flag, upper(cluster.foc) FROM syscmsmtab as cm, syscmsmunit as cluster WHERE cm.sid = cluster.sid AND BITAND(cluster.flag, 256) = 0 ORDER BY cm.sid; When the connection manager or a regular user is running such a query it is possible for the IDS server to assert fail with a stack like below when the syscmsmtab and syscmsmunit tables are modified via operations like reloading the cm config files. 02:55:30 Stack for thread: 5124 sqlexec base: 0x000000004f5ce000 len: 69632 pc: 0x000000000141d4b9 tos: 0x0000000045ac3310 state: running vp: 14 0x000000000141d4b9 (oninit) afstack 0x0000000001420fa1 (oninit) mt_ex_throw_sig 0x000000000142be13 (oninit) afsig_handler 0x0000003ddfa0e4c0 (Linux) 0x00000000015d61f5 (oninit) stchar 0x000000000157eefb (oninit) prcmsmunit 0x0000000000e604c3 (oninit) pstread 0x0000000000d2ab90 (oninit) pst_rsread 0x0000000000d2d68c (oninit) rsread 0x00000000014fcfc7 (oninit) fmread 0x0000000000819e4e (oninit) readseq_single 0x000000000081b28e (oninit) gettupl 0x000000000081e484 (oninit) scan_next 0x000000000084e38c (oninit) hjoin_open 0x0000000000844f91 (oninit) sort_open 0x0000000000822209 (oninit) prepselect 0x0000000000a3f75e (oninit) open_cursor 0x0000000000a475d9 (oninit) sql_open 0x0000000000a477c6 (oninit) sq_open 0x0000000000b0a161 (oninit) sqmain 0x000000000154a03b (oninit) spawn_thread 0x000000000140efd0 (oninit) th_init_initgls 0x00000000014547f8 (oninit) startup | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC6. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC6 (when available). * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC6. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC6 (when available). * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC15 and 14.10.xC6. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 17.09.2020 12.05.2021 12.05.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |