Informix - Problem description
Problem IT18740 | Status: Closed |
PARALLEL SHARD QUERY WHEN RUN FROM SECONDARY SERVER FAILS WITH ERROR CODE CLIXNOTACTIVE WHEN CONNECTING TO THE LOCAL SERVER | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
A parallel shard query when run from a Secondary server fails with error code clixnotactive when connecting to the local server. DBSERVERNAME serv_1 SHARD_ID 1 DBSERVERNAME serv_2 SHARD_ID 1 DBSERVERNAME serv_3 SHARD_ID 3 DBSERVERNAME serv_4 SHARD_ID 3 clust_a_grp group - - i=1 serv_1 onsoctcp vmwood177 12161 g=clust_a_grp serv_2 onsoctcp vmwood177 12162 g=clust_a_grp clust_b_grp group - - i=2 serv_3 onsoctcp vmwood177 12163 g=clust_b_grp serv_4 onsoctcp vmwood177 12164 g=clust_b_grp And there is an error message in the online.log: 09:26:19 Error code on connect -9 09:26:19 Error code on connect -9 09:26:19 Error code on connect -9 ############ Secondary ############ onstat -g shard IBM Informix Dynamic Server Version 12.10.FC8 -- Read-Only (Sec) -- Up 00:25:45 -- 156276 Kbytes andy shard_nl:informix.lightning key:country EXPRESSION:DELETE SHARD OPTIMIZATION:ENABLED Matching for delete:observed clust_a_grp (65540) country IN (1,2,3,4,5) clust_b_grp (65541) country IN (6,7,8,9) echo "set environment USE_SHARDING 'on'; select * from lightning" | dbaccess shard_nl Database selected. Environment set. 26972: Sharding Internal Error. Error in line 1 Near character position 58 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All platforms * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC9 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 10.01.2017 11.07.2017 11.07.2017 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC9 | |
Problem solved according to the fixlist(s) of the following version(s) |