|
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) |
