Informix - Problem description
Problem IT41587 | Status: Closed |
COMMAND "CDR LIST CATALOG -R" SHOULD INCLUDE OPTION "--ERKEY" IFTHE REPLICATE WAS CREATED WITH THAT OPTION | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
If a replicate is created with the --erkey for example : cdr define replicate --conflict=ignore --ats --ris rep_mytab --erkey \' "testdb@g_serv1:informix.mytab" "select t.col1, t.col2, t.col3, t.col4, t.new_col2, t.new_col3, t.new_col4, t.col5 from mytab t" \' "testdb@g_serv2:informix.mytab" "select t.col1, t.col2, t.col3, t.col4, t.new_col2, t.new_col3, t.new_col4, t.col5 from mytab t" and the above replicate 'rep_mytab' is deleted and rebuild with the output of 'cdr list catalog -r', for example : $ cdr list catalog -r # # cdr define replicate commands. # cdr define replicate --conflict=ignore --ats --ris rep_mytab \' "testdb@g_serv1:informix.mytab" "select t.ifx_erkey_1, t.ifx_erkey_2, t.ifx_erkey_3, t.col1, t.col2, t.col3, t.col4, t.new_col2, t.new_col3, t.new_col4, t.col5 from mytab t" \' "testdb@g_serv2:informix.mytab" "select t.ifx_erkey_1, t.ifx_erkey_2, t.ifx_erkey_3, t.col1, t.col2, t.col3, t.col4, t.new_col2, t.new_col3, t.new_col4, t.col5 from mytab t" it fails with following error : Interpreting this replicate as a master replicate.Table 'testdb@g_serv1.adj_detail' does not contain primary key. it happens because 'cdr list catalog -r' does not include the option "--erkey" but only the ifx_erkey shadow columns. If --erkey is added to the output of 'cdr list catalog -r' for example : cdr define replicate --conflict=ignore --ats --ris rep_mytab --erkey \' "testdb@g_serv1:informix.mytab" "select t.ifx_erkey_1, t.ifx_erkey_2, t.ifx_erkey_3, t.col1, t.col2, t.col3, t.col4, t.new_col2, t.new_col3, t.new_col4, t.col5 from mytab t" \' "testdb@g_serv2:informix.mytab" "select t.ifx_erkey_1, t.ifx_erkey_2, t.ifx_erkey_3, t.col1, t.col2, t.col3, t.col4, t.new_col2, t.new_col3, t.new_col4, t.col5 from mytab t" the above commands works successfully and the replicate is created. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC16 and 14.10.xC9. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC16 or 14.10.xC9. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC16 and 14.10.xC9. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC16 or 14.10.xC9. * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC16 and 14.10.xC9. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 21.07.2022 05.10.2022 13.06.2023 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |