Informix - Problembeschreibung
Problem IT18740 | Status: Geschlossen |
PARALLEL SHARD QUERY WHEN RUN FROM SECONDARY SERVER FAILS WITH ERROR CODE CLIXNOTACTIVE WHEN CONNECTING TO THE LOCAL SERVER | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All platforms * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC9 * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 10.01.2017 11.07.2017 11.07.2017 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC9 | |
Problem behoben lt. FixList in der Version |