Informix - Problem description
Problem IT36973 | Status: Closed |
-208 ERROR IN RIS FILE FOR TRANSACTIONS > 65535 ROWS REPLICATINGTO SPL DUE TO CDR DATA SYNC THREAD EXHAUSTING SQL STATEMENT IDS | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
When using the replicate to spl routine, when a transaction has more than max smallint rows (so 65535), the cdr data sync thread exhausts all possible statement ids, and then rejects further rows (or the whole transaction at that point) with -208 errors reported in the RIS file. Example RIS file output: TXH Source ID:101 / Name:g_mqtt / CommitTime:21-05-12 13:58:53 TXH Target ID:101 / Name:g_mqtt / ReceiveTime:21-05-12 13:59:12 ---------- RRH Row:65532 / Replicate Id: 6619137 / Table: mydb@informix.extents / DbOp:Insert RRH CDR:0 / SQL:-208 / ISAM:0 ... RRH Row:70000 / Replicate Id: 6619137 / Table: mydb@informix.extents / DbOp:Insert RRH CDR:0 / SQL:-208 / ISAM:0 ========== TXH Transaction committed TXH Total number of rows in transaction:70000 replicate defined as follows: cdr define repl rep_extent -C always -S row -M g_mqtt -A -R --serial --jsonsplname=async_trigger_call "mydb@g_mqtt:informix.extent" "select * from extent" "mydb@g_loopback:informix.extent" "select * from extent" | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC7. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC7. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC7. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC7. * **************************************************************** | |
Comment | |
Fixed in Informix Server 14.10.xC7. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 20.05.2021 01.11.2021 01.11.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |