Printing ER replication errors in online log file
User experienced excessive Enterprise Replication (ER) errors logged in IDS 11.50 FC8 online log file and asked if there was a control option to suppress these errors for specific troubled tables. Madison provided a solution: use the "cdr modify repl" command with the flags "-R n -A n" to control error logging behavior.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Folks, IDS11.50 FC8, Redhat Linux For some BAD reasons.., we have large number of ER replication errors printed in online log message file ( see below ) We knew the troubled tables that contributed most of the annoy info there. The question is, Can have a simple control option to ask IDS ER NOT producing these errors for some particular troubled tables? Thanks, Frank 19:44:14 CDR CDRD_10479: failed transaction spooled to file /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10479.111114_19:44:14.26 19:44:14 CDR CDRD_10477: failed rows spooled to file /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10477.111114_19:44:14.25 19:44:14 CDR CDRD_10477: failed transaction spooled to file /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10477.111114_19:44:14.26 19:44:14 CDR CDRD_10423: transaction aborted (One or more rows in a transaction defined with tx scope were rejected) with sql error 0 isam error 0. 19:44:14 CDR CDRD_10423: failed rows spooled to file /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10423.111114_19:44:14.323 19:44:14 CDR CDRD_10454: transaction aborted (One or more rows in a transaction defined with tx scope were rejected) with sql error 0 isam error 0. 19:44:14 CDR CDRD_10423: failed transaction spooled to file /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10423.111114_19:44:14.324 19:44:14 CDR CDRD_10454: failed rows spooled to file /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10454.111114_19:44:14.113 19:44:14 CDR CDRD_10454: failed transaction spooled to file /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10454.111114_19:44:14.114 19:44:27 CDR CDRD_10468: transaction aborted (One or more rows in a transaction defined with tx scope were rejected) with sql error 0 isam error 0. 19:44:27 CDR CDRD_10468: failed rows spooled to file /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10468.111114_19:44:27.39 19:44:27 CDR CDRD_10358: transaction aborted (One or more rows in a transaction defined with tx scope were rejected) with sql error 0 isam error 0. 19:44:27 CDR CDRD_10468: failed transaction spooled to file /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10468.111114_19:44:27.40 19:44:27 CDR CDRD_10358: failed rows spooled to file /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10358.111114_19:44:27.671 19:44:27 CDR CDRD_10358: failed transaction spooled to file /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10358.111114_19:44:27.672 [informix@walter RepErr]$ more /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10358.111114_19:44:27.672 TXH RIS file:/dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10358.111114_19:44:27.671 has also been created for this transaction ========== TXH Source ID:22 / Name:g_ncdcops / CommitTime:11-11-14 19:22:03 TXH Target ID:23 / Name:g_ngdcops / ReceiveTime:11-11-14 19:44:27 TXH Number of rows processed when transaction was aborted:1 TXH One or more rows in a transaction defined with tx scope were rejected TXH CDR:7 (Error: Delete aborted, row does not exist in target table) / SQL:0 / ISAM:0 ---------- RRH Row:1 / Replicate Id: 1376334 / Table: noaa@informix.rmt_path_update / DbOp:Delete RRD 491941603|file_change_notice|395290753|500|NCDC|OSDPD|NEWPATH [informix@walter RepErr]$ more /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10468.111114_19:44:27.40 TXH RIS file:/dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10468.111114_19:44:27.39 has also been created for this transaction ========== TXH Source ID:22 / Name:g_ncdcops / CommitTime:11-11-14 19:22:03 TXH Target ID:23 / Name:g_ngdcops / ReceiveTime:11-11-14 19:44:27 TXH Number of rows processed when transaction was aborted:1 TXH One or more rows in a transaction defined with tx scope were rejected TXH CDR:6 (Error: Update aborted, row does not exist in target table) / SQL:0 / ISAM:0 ---------- RRH Row:1 / Replicate Id: 1376299 / Table: noaa@informix.file_change_notice/ DbOp:Update RRD 395290753|OSDPD|mary-dat|NCDC|/class_dirs/local_cacheNP/008/GIMGO_npp_d20111114_ t0148370_e0150012_b00237_c20111114182810628948_noaa_ops.h5|32 4487368|b6f405436a5fb82681bd48c13377a8c6|VIIRSIMGEO|2011-11-14 01:48:37.038||READY|REPLICATE|500|2011-11-14 19:22:03|NCDC|STARTED|0|495699803|ARC H_SEND|0 --001517588cfa0871be04b1b7423b
cdr modify repl .... -R n -A n M.P. From: "FRANK" <yunyaoqu@gmail.com> To: ids@iiug.org Date: 11/14/2011 01:57 PM Subject: Printing ER replication errors in online log file [25423] Sent by: ids-bounces@iiug.org Folks, IDS11.50 FC8, Redhat Linux For some BAD reasons.., we have large number of ER replication errors printed in online log message file ( see below ) We knew the troubled tables that contributed most of the annoy info there. The question is, Can have a simple control option to ask IDS ER NOT producing these errors for some particular troubled tables? Thanks, Frank 19:44:14 CDR CDRD_10479: failed transaction spooled to file /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10479.111114_19:44:14.26 19:44:14 CDR CDRD_10477: failed rows spooled to file /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10477.111114_19:44:14.25 19:44:14 CDR CDRD_10477: failed transaction spooled to file /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10477.111114_19:44:14.26 19:44:14 CDR CDRD_10423: transaction aborted (One or more rows in a transaction defined with tx scope were rejected) with sql error 0 isam error 0. 19:44:14 CDR CDRD_10423: failed rows spooled to file /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10423.111114_19:44:14.323 19:44:14 CDR CDRD_10454: transaction aborted (One or more rows in a transaction defined with tx scope were rejected) with sql error 0 isam error 0. 19:44:14 CDR CDRD_10423: failed transaction spooled to file /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10423.111114_19:44:14.324 19:44:14 CDR CDRD_10454: failed rows spooled to file /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10454.111114_19:44:14.113 19:44:14 CDR CDRD_10454: failed transaction spooled to file /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10454.111114_19:44:14.114 19:44:27 CDR CDRD_10468: transaction aborted (One or more rows in a transaction defined with tx scope were rejected) with sql error 0 isam error 0. 19:44:27 CDR CDRD_10468: failed rows spooled to file /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10468.111114_19:44:27.39 19:44:27 CDR CDRD_10358: transaction aborted (One or more rows in a transaction defined with tx scope were rejected) with sql error 0 isam error 0. 19:44:27 CDR CDRD_10468: failed transaction spooled to file /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10468.111114_19:44:27.40 19:44:27 CDR CDRD_10358: failed rows spooled to file /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10358.111114_19:44:27.671 19:44:27 CDR CDRD_10358: failed transaction spooled to file /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10358.111114_19:44:27.672 [informix@walter RepErr]$ more /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10358.111114_19:44:27.672 TXH RIS file:/dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10358.111114_19:44:27.671 has also been created for this transaction ========== TXH Source ID:22 / Name:g_ncdcops / CommitTime:11-11-14 19:22:03 TXH Target ID:23 / Name:g_ngdcops / ReceiveTime:11-11-14 19:44:27 TXH Number of rows processed when transaction was aborted:1 TXH One or more rows in a transaction defined with tx scope were rejected TXH CDR:7 (Error: Delete aborted, row does not exist in target table) / SQL:0 / ISAM:0 ---------- RRH Row:1 / Replicate Id: 1376334 / Table: noaa@informix.rmt_path_update / DbOp:Delete RRD 491941603|file_change_notice|395290753|500|NCDC|OSDPD|NEWPATH [informix@walter RepErr]$ more /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10468.111114_19:44:27.40 TXH RIS file:/dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10468.111114_19:44:27.39 has also been created for this transaction ========== TXH Source ID:22 / Name:g_ncdcops / CommitTime:11-11-14 19:22:03 TXH Target ID:23 / Name:g_ngdcops / ReceiveTime:11-11-14 19:44:27 TXH Number of rows processed when transaction was aborted:1 TXH One or more rows in a transaction defined with tx scope were rejected TXH CDR:6 (Error: Update aborted, row does not exist in target table) / SQL:0 / ISAM:0 ---------- RRH Row:1 / Replicate Id: 1376299 / Table: noaa@informix.file_change_notice/ DbOp:Update RRD 395290753|OSDPD|mary-dat| NCDC|/class_dirs/local_cacheNP/008/GIMGO_npp_d20111114_t0148370_e0150012_b00237_ c20111114182810628948_noaa_ops.h5| 32 4487368|b6f405436a5fb82681bd48c13377a8c6|VIIRSIMGEO|2011-11-14 01:48:37.038||READY|REPLICATE|500|2011-11-14 19:22:03|NCDC|STARTED|0|495699803|ARC H_SEND|0 --001517588cfa0871be04b1b7423b ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Thanks , Madison!! Will have a look on. Frank On Mon, Nov 14, 2011 at 3:03 PM, Madison Pruet <mpruet@us.ibm.com> wrote: > cdr modify repl .... -R n -A n > > M.P. > > From: "FRANK" <yunyaoqu@gmail.com> > > To: ids@iiug.org > > Date: 11/14/2011 01:57 PM > > Subject: Printing ER replication errors in online log file [25423] > > Sent by: ids-bounces@iiug.org > > Folks, > > IDS11.50 FC8, Redhat Linux > > For some BAD reasons.., we have large number of ER replication errors > printed in online log message file ( see below ) > > We knew the troubled tables that contributed most of the annoy info > there. > > The question is, > Can have a simple control option to ask IDS ER NOT producing these > errors for some particular troubled tables? > > Thanks, > Frank > > 19:44:14 CDR CDRD_10479: failed transaction spooled to file > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10479.111114_19:44:14.26 > 19:44:14 CDR CDRD_10477: failed rows spooled to file > /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10477.111114_19:44:14.25 > 19:44:14 CDR CDRD_10477: failed transaction spooled to file > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10477.111114_19:44:14.26 > 19:44:14 CDR CDRD_10423: transaction aborted (One or more rows in a > transaction defined with tx scope were rejected) with sql error 0 isam > error 0. > 19:44:14 CDR CDRD_10423: failed rows spooled to file > /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10423.111114_19:44:14.323 > 19:44:14 CDR CDRD_10454: transaction aborted (One or more rows in a > transaction defined with tx scope were rejected) with sql error 0 isam > error 0. > 19:44:14 CDR CDRD_10423: failed transaction spooled to file > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10423.111114_19:44:14.324 > 19:44:14 CDR CDRD_10454: failed rows spooled to file > /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10454.111114_19:44:14.113 > 19:44:14 CDR CDRD_10454: failed transaction spooled to file > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10454.111114_19:44:14.114 > 19:44:27 CDR CDRD_10468: transaction aborted (One or more rows in a > transaction defined with tx scope were rejected) with sql error 0 isam > error 0. > 19:44:27 CDR CDRD_10468: failed rows spooled to file > /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10468.111114_19:44:27.39 > 19:44:27 CDR CDRD_10358: transaction aborted (One or more rows in a > transaction defined with tx scope were rejected) with sql error 0 isam > error 0. > 19:44:27 CDR CDRD_10468: failed transaction spooled to file > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10468.111114_19:44:27.40 > 19:44:27 CDR CDRD_10358: failed rows spooled to file > /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10358.111114_19:44:27.671 > 19:44:27 CDR CDRD_10358: failed transaction spooled to file > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10358.111114_19:44:27.672 > > [informix@walter RepErr]$ more > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10358.111114_19:44:27.672 > TXH RIS > file:/dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10358.111114_19:44:27.671 > has also been created for this transaction > ========== > TXH Source ID:22 / Name:g_ncdcops / CommitTime:11-11-14 19:22:03 > TXH Target ID:23 / Name:g_ngdcops / ReceiveTime:11-11-14 19:44:27 > TXH Number of rows processed when transaction was aborted:1 > TXH One or more rows in a transaction defined with tx scope were rejected > TXH CDR:7 (Error: Delete aborted, row does not exist in target table) / > SQL:0 / ISAM:0 > ---------- > RRH Row:1 / Replicate Id: 1376334 / Table: noaa@informix.rmt_path_update / > DbOp:Delete > RRD 491941603|file_change_notice|395290753|500|NCDC|OSDPD|NEWPATH > > [informix@walter RepErr]$ more > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10468.111114_19:44:27.40 > TXH RIS > file:/dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10468.111114_19:44:27.39 > has also been created for this transaction > ========== > TXH Source ID:22 / Name:g_ncdcops / CommitTime:11-11-14 19:22:03 > TXH Target ID:23 / Name:g_ngdcops / ReceiveTime:11-11-14 19:44:27 > TXH Number of rows processed when transaction was aborted:1 > TXH One or more rows in a transaction defined with tx scope were rejected > TXH CDR:6 (Error: Update aborted, row does not exist in target table) / > SQL:0 / ISAM:0 > ---------- > RRH Row:1 / Replicate Id: 1376299 / Table: > noaa@informix.file_change_notice/ DbOp:Update > RRD > > 395290753|OSDPD|mary-dat| > > > NCDC|/class_dirs/local_cacheNP/008/GIMGO_npp_d20111114_t0148370_e0150012_b00237_ c20111114182810628948_noaa_ops.h5| > 32 > 4487368|b6f405436a5fb82681bd48c13377a8c6|VIIRSIMGEO|2011-11-14 > 01:48:37.038||READY|REPLICATE|500|2011-11-14 > 19:22:03|NCDC|STARTED|0|495699803|ARC > H_SEND|0 > > --001517588cfa0871be04b1b7423b > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0015175907fe6fac2804b1b7822a
Madison, The command , cdr modify repl -A n -R n , can eliminate/stop the spooling data to the defined location. But the IDS online log message file still show that errors occurred . Can we also prevent(eliminate) this error message from the IDS online_log file? Thanks, Frank The following shows the difference in the online log file before and after running the command. After we modified the replicate, online log file does not show the Spooling info. But it still has a line ( "transaction aborted") for the transaction error. Can we get rid of that error line from the online log file also? Before running the command: 21:33:47 CDR CDRD_4: transaction aborted (One or more rows in a transaction defined with tx scope were rejected) with sql error 0 isam error 0. 21:33:47 CDR CDRD_4: failed rows spooled to file /dbbackup/RepErr/ris.g_ncdcint.g_nsofint.D_4.111114_21:33:46.1 21:33:47 CDR CDRD_4: failed transaction spooled to file /dbbackup/RepErr/ats.g_ncdcint.g_nsofint.D_4.111114_21:33:46.2 21:33:49 CDR CDRD_5: transaction aborted (One or more rows in a transaction defined with tx scope were rejected) with sql error 0 isam error 0. 21:33:49 CDR CDRD_5: failed rows spooled to file /dbbackup/RepErr/ris.g_ncdcint.g_nsofint.D_5.111114_21:33:48.3 21:33:49 CDR CDRD_5: failed transaction spooled to file /dbbackup/RepErr/ats.g_ncdcint.g_nsofint.D_5.111114_21:33:48.4 After running the command: 21:34:10 CDR CDRDS: transaction aborted (One or more rows in a transaction defined with tx scope were rejected) with sql error 0 isam error 0. 21:34:13 CDR CDRDS: transaction aborted (One or more rows in a transaction defined with tx scope were rejected) with sql error 0 isam error 0. On Mon, Nov 14, 2011 at 3:03 PM, Madison Pruet <mpruet@us.ibm.com> wrote: > cdr modify repl .... -R n -A n > > M.P. > > From: "FRANK" <yunyaoqu@gmail.com> > > To: ids@iiug.org > > Date: 11/14/2011 01:57 PM > > Subject: Printing ER replication errors in online log file [25423] > > Sent by: ids-bounces@iiug.org > > Folks, > > IDS11.50 FC8, Redhat Linux > > For some BAD reasons.., we have large number of ER replication errors > printed in online log message file ( see below ) > > We knew the troubled tables that contributed most of the annoy info > there. > > The question is, > Can have a simple control option to ask IDS ER NOT producing these > errors for some particular troubled tables? > > Thanks, > Frank > > 19:44:14 CDR CDRD_10479: failed transaction spooled to file > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10479.111114_19:44:14.26 > 19:44:14 CDR CDRD_10477: failed rows spooled to file > /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10477.111114_19:44:14.25 > 19:44:14 CDR CDRD_10477: failed transaction spooled to file > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10477.111114_19:44:14.26 > 19:44:14 CDR CDRD_10423: transaction aborted (One or more rows in a > transaction defined with tx scope were rejected) with sql error 0 isam > error 0. > 19:44:14 CDR CDRD_10423: failed rows spooled to file > /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10423.111114_19:44:14.323 > 19:44:14 CDR CDRD_10454: transaction aborted (One or more rows in a > transaction defined with tx scope were rejected) with sql error 0 isam > error 0. > 19:44:14 CDR CDRD_10423: failed transaction spooled to file > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10423.111114_19:44:14.324 > 19:44:14 CDR CDRD_10454: failed rows spooled to file > /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10454.111114_19:44:14.113 > 19:44:14 CDR CDRD_10454: failed transaction spooled to file > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10454.111114_19:44:14.114 > 19:44:27 CDR CDRD_10468: transaction aborted (One or more rows in a > transaction defined with tx scope were rejected) with sql error 0 isam > error 0. > 19:44:27 CDR CDRD_10468: failed rows spooled to file > /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10468.111114_19:44:27.39 > 19:44:27 CDR CDRD_10358: transaction aborted (One or more rows in a > transaction defined with tx scope were rejected) with sql error 0 isam > error 0. > 19:44:27 CDR CDRD_10468: failed transaction spooled to file > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10468.111114_19:44:27.40 > 19:44:27 CDR CDRD_10358: failed rows spooled to file > /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10358.111114_19:44:27.671 > 19:44:27 CDR CDRD_10358: failed transaction spooled to file > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10358.111114_19:44:27.672 > > [informix@walter RepErr]$ more > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10358.111114_19:44:27.672 > TXH RIS > file:/dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10358.111114_19:44:27.671 > has also been created for this transaction > ========== > TXH Source ID:22 / Name:g_ncdcops / CommitTime:11-11-14 19:22:03 > TXH Target ID:23 / Name:g_ngdcops / ReceiveTime:11-11-14 19:44:27 > TXH Number of rows processed when transaction was aborted:1 > TXH One or more rows in a transaction defined with tx scope were rejected > TXH CDR:7 (Error: Delete aborted, row does not exist in target table) / > SQL:0 / ISAM:0 > ---------- > RRH Row:1 / Replicate Id: 1376334 / Table: noaa@informix.rmt_path_update / > DbOp:Delete > RRD 491941603|file_change_notice|395290753|500|NCDC|OSDPD|NEWPATH > > [informix@walter RepErr]$ more > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10468.111114_19:44:27.40 > TXH RIS > file:/dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10468.111114_19:44:27.39 > has also been created for this transaction > ========== > TXH Source ID:22 / Name:g_ncdcops / CommitTime:11-11-14 19:22:03 > TXH Target ID:23 / Name:g_ngdcops / ReceiveTime:11-11-14 19:44:27 > TXH Number of rows processed when transaction was aborted:1 > TXH One or more rows in a transaction defined with tx scope were rejected > TXH CDR:6 (Error: Update aborted, row does not exist in target table) / > SQL:0 / ISAM:0 > ---------- > RRH Row:1 / Replicate Id: 1376299 / Table: > noaa@informix.file_change_notice/ DbOp:Update > RRD > > 395290753|OSDPD|mary-dat| > > > NCDC|/class_dirs/local_cacheNP/008/GIMGO_npp_d20111114_t0148370_e0150012_b00237_ c20111114182810628948_noaa_ops.h5| > 32 > 4487368|b6f405436a5fb82681bd48c13377a8c6|VIIRSIMGEO|2011-11-14 > 01:48:37.038||READY|REPLICATE|500|2011-11-14 > 19:22:03|NCDC|STARTED|0|495699803|ARC > H_SEND|0 > > --001517588cfa0871be04b1b7423b > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001517588cfaeb0c1904b1b8e0da
not really. From: "FRANK" <yunyaoqu@gmail.com> To: ids@iiug.org Date: 11/14/2011 03:53 PM Subject: Re: Printing ER replication errors in online l.... [25426] Sent by: ids-bounces@iiug.org Madison, The command , cdr modify repl -A n -R n , can eliminate/stop the spooling data to the defined location. But the IDS online log message file still show that errors occurred . Can we also prevent(eliminate) this error message from the IDS online_log file? Thanks, Frank The following shows the difference in the online log file before and after running the command. After we modified the replicate, online log file does not show the Spooling info. But it still has a line ( "transaction aborted") for the transaction error. Can we get rid of that error line from the online log file also? Before running the command: 21:33:47 CDR CDRD_4: transaction aborted (One or more rows in a transaction defined with tx scope were rejected) with sql error 0 isam error 0. 21:33:47 CDR CDRD_4: failed rows spooled to file /dbbackup/RepErr/ris.g_ncdcint.g_nsofint.D_4.111114_21:33:46.1 21:33:47 CDR CDRD_4: failed transaction spooled to file /dbbackup/RepErr/ats.g_ncdcint.g_nsofint.D_4.111114_21:33:46.2 21:33:49 CDR CDRD_5: transaction aborted (One or more rows in a transaction defined with tx scope were rejected) with sql error 0 isam error 0. 21:33:49 CDR CDRD_5: failed rows spooled to file /dbbackup/RepErr/ris.g_ncdcint.g_nsofint.D_5.111114_21:33:48.3 21:33:49 CDR CDRD_5: failed transaction spooled to file /dbbackup/RepErr/ats.g_ncdcint.g_nsofint.D_5.111114_21:33:48.4 After running the command: 21:34:10 CDR CDRDS: transaction aborted (One or more rows in a transaction defined with tx scope were rejected) with sql error 0 isam error 0. 21:34:13 CDR CDRDS: transaction aborted (One or more rows in a transaction defined with tx scope were rejected) with sql error 0 isam error 0. On Mon, Nov 14, 2011 at 3:03 PM, Madison Pruet <mpruet@us.ibm.com> wrote: > cdr modify repl .... -R n -A n > > M.P. > > From: "FRANK" <yunyaoqu@gmail.com> > > To: ids@iiug.org > > Date: 11/14/2011 01:57 PM > > Subject: Printing ER replication errors in online log file [25423] > > Sent by: ids-bounces@iiug.org > > Folks, > > IDS11.50 FC8, Redhat Linux > > For some BAD reasons.., we have large number of ER replication errors > printed in online log message file ( see below ) > > We knew the troubled tables that contributed most of the annoy info > there. > > The question is, > Can have a simple control option to ask IDS ER NOT producing these > errors for some particular troubled tables? > > Thanks, > Frank > > 19:44:14 CDR CDRD_10479: failed transaction spooled to file > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10479.111114_19:44:14.26 > 19:44:14 CDR CDRD_10477: failed rows spooled to file > /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10477.111114_19:44:14.25 > 19:44:14 CDR CDRD_10477: failed transaction spooled to file > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10477.111114_19:44:14.26 > 19:44:14 CDR CDRD_10423: transaction aborted (One or more rows in a > transaction defined with tx scope were rejected) with sql error 0 isam > error 0. > 19:44:14 CDR CDRD_10423: failed rows spooled to file > /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10423.111114_19:44:14.323 > 19:44:14 CDR CDRD_10454: transaction aborted (One or more rows in a > transaction defined with tx scope were rejected) with sql error 0 isam > error 0. > 19:44:14 CDR CDRD_10423: failed transaction spooled to file > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10423.111114_19:44:14.324 > 19:44:14 CDR CDRD_10454: failed rows spooled to file > /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10454.111114_19:44:14.113 > 19:44:14 CDR CDRD_10454: failed transaction spooled to file > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10454.111114_19:44:14.114 > 19:44:27 CDR CDRD_10468: transaction aborted (One or more rows in a > transaction defined with tx scope were rejected) with sql error 0 isam > error 0. > 19:44:27 CDR CDRD_10468: failed rows spooled to file > /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10468.111114_19:44:27.39 > 19:44:27 CDR CDRD_10358: transaction aborted (One or more rows in a > transaction defined with tx scope were rejected) with sql error 0 isam > error 0. > 19:44:27 CDR CDRD_10468: failed transaction spooled to file > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10468.111114_19:44:27.40 > 19:44:27 CDR CDRD_10358: failed rows spooled to file > /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10358.111114_19:44:27.671 > 19:44:27 CDR CDRD_10358: failed transaction spooled to file > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10358.111114_19:44:27.672 > > [informix@walter RepErr]$ more > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10358.111114_19:44:27.672 > TXH RIS > file:/dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10358.111114_19:44:27.671 > has also been created for this transaction > ========== > TXH Source ID:22 / Name:g_ncdcops / CommitTime:11-11-14 19:22:03 > TXH Target ID:23 / Name:g_ngdcops / ReceiveTime:11-11-14 19:44:27 > TXH Number of rows processed when transaction was aborted:1 > TXH One or more rows in a transaction defined with tx scope were rejected > TXH CDR:7 (Error: Delete aborted, row does not exist in target table) / > SQL:0 / ISAM:0 > ---------- > RRH Row:1 / Replicate Id: 1376334 / Table: noaa@informix.rmt_path_update / > DbOp:Delete > RRD 491941603|file_change_notice|395290753|500|NCDC|OSDPD|NEWPATH > > [informix@walter RepErr]$ more > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10468.111114_19:44:27.40 > TXH RIS > file:/dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10468.111114_19:44:27.39 > has also been created for this transaction > ========== > TXH Source ID:22 / Name:g_ncdcops / CommitTime:11-11-14 19:22:03 > TXH Target ID:23 / Name:g_ngdcops / ReceiveTime:11-11-14 19:44:27 > TXH Number of rows processed when transaction was aborted:1 > TXH One or more rows in a transaction defined with tx scope were rejected > TXH CDR:6 (Error: Update aborted, row does not exist in target table) / > SQL:0 / ISAM:0 > ---------- > RRH Row:1 / Replicate Id: 1376299 / Table: > noaa@informix.file_change_notice/ DbOp:Update > RRD > > 395290753|OSDPD|mary-dat| > > > NCDC|/class_dirs/local_cacheNP/008/GIMGO_npp_d20111114_t0148370_e0150012_b00237_ c20111114182810628948_noaa_ops.h5| > 32 > 4487368|b6f405436a5fb82681bd48c13377a8c6|VIIRSIMGEO|2011-11-14 > 01:48:37.038||READY|REPLICATE|500|2011-11-14 > 19:22:03|NCDC|STARTED|0|495699803|ARC > H_SEND|0 > > --001517588cfa0871be04b1b7423b > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001517588cfaeb0c1904b1b8e0da ********
Perhaps we need a Feature Request for controlling the ER transaction error info generated in the online log file. Because, such excessive amount of low level of regular transaction error messages really decrease the usefulness of online-log output ( people could easily miss more important info log , force people to look for a needle in the haystack ....) Thanks, Frank On Mon, Nov 14, 2011 at 5:02 PM, Madison Pruet <mpruet@us.ibm.com> wrote: > not really. > > From: "FRANK" <yunyaoqu@gmail.com> > > To: ids@iiug.org > > Date: 11/14/2011 03:53 PM > > Subject: Re: Printing ER replication errors in online l.... [25426] > > Sent by: ids-bounces@iiug.org > > Madison, > > The command , cdr modify repl -A n -R n , can eliminate/stop the > spooling data to the defined location. > But the IDS online log message file still show that errors occurred . Can > we also prevent(eliminate) this error message from the IDS > online_log file? > > Thanks, > Frank > > The following shows the difference in the online log file before and > after running the command. > After we modified the replicate, online log file does not show the > Spooling info. But it still has a line ( "transaction aborted") for the > transaction error. > Can we get rid of that error line from the online log file also? > > Before running the command: > > 21:33:47 CDR CDRD_4: transaction aborted (One or more rows in a > transaction defined with tx scope were rejected) with sql error 0 isam > error 0. > 21:33:47 CDR CDRD_4: failed rows spooled to file > /dbbackup/RepErr/ris.g_ncdcint.g_nsofint.D_4.111114_21:33:46.1 > 21:33:47 CDR CDRD_4: failed transaction spooled to file > /dbbackup/RepErr/ats.g_ncdcint.g_nsofint.D_4.111114_21:33:46.2 > 21:33:49 CDR CDRD_5: transaction aborted (One or more rows in a > transaction defined with tx scope were rejected) with sql error 0 isam > error 0. > 21:33:49 CDR CDRD_5: failed rows spooled to file > /dbbackup/RepErr/ris.g_ncdcint.g_nsofint.D_5.111114_21:33:48.3 > 21:33:49 CDR CDRD_5: failed transaction spooled to file > /dbbackup/RepErr/ats.g_ncdcint.g_nsofint.D_5.111114_21:33:48.4 > > After running the command: > > 21:34:10 CDR CDRDS: transaction aborted (One or more rows in a transaction > defined with tx scope were rejected) with sql error 0 isam error 0. > 21:34:13 CDR CDRDS: transaction aborted (One or more rows in a transaction > defined with tx scope were rejected) with sql error 0 isam error 0. > > On Mon, Nov 14, 2011 at 3:03 PM, Madison Pruet <mpruet@us.ibm.com> wrote: > > > cdr modify repl .... -R n -A n > > > > M.P. > > > > From: "FRANK" <yunyaoqu@gmail.com> > > > > To: ids@iiug.org > > > > Date: 11/14/2011 01:57 PM > > > > Subject: Printing ER replication errors in online log file [25423] > > > > Sent by: ids-bounces@iiug.org > > > > Folks, > > > > IDS11.50 FC8, Redhat Linux > > > > For some BAD reasons.., we have large number of ER replication errors > > printed in online log message file ( see below ) > > > > We knew the troubled tables that contributed most of the annoy info > > there. > > > > The question is, > > Can have a simple control option to ask IDS ER NOT producing these > > errors for some particular troubled tables? > > > > Thanks, > > Frank > > > > 19:44:14 CDR CDRD_10479: failed transaction spooled to file > > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10479.111114_19:44:14.26 > > 19:44:14 CDR CDRD_10477: failed rows spooled to file > > /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10477.111114_19:44:14.25 > > 19:44:14 CDR CDRD_10477: failed transaction spooled to file > > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10477.111114_19:44:14.26 > > 19:44:14 CDR CDRD_10423: transaction aborted (One or more rows in a > > transaction defined with tx scope were rejected) with sql error 0 isam > > error 0. > > 19:44:14 CDR CDRD_10423: failed rows spooled to file > > /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10423.111114_19:44:14.323 > > 19:44:14 CDR CDRD_10454: transaction aborted (One or more rows in a > > transaction defined with tx scope were rejected) with sql error 0 isam > > error 0. > > 19:44:14 CDR CDRD_10423: failed transaction spooled to file > > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10423.111114_19:44:14.324 > > 19:44:14 CDR CDRD_10454: failed rows spooled to file > > /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10454.111114_19:44:14.113 > > 19:44:14 CDR CDRD_10454: failed transaction spooled to file > > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10454.111114_19:44:14.114 > > 19:44:27 CDR CDRD_10468: transaction aborted (One or more rows in a > > transaction defined with tx scope were rejected) with sql error 0 isam > > error 0. > > 19:44:27 CDR CDRD_10468: failed rows spooled to file > > /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10468.111114_19:44:27.39 > > 19:44:27 CDR CDRD_10358: transaction aborted (One or more rows in a > > transaction defined with tx scope were rejected) with sql error 0 isam > > error 0. > > 19:44:27 CDR CDRD_10468: failed transaction spooled to file > > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10468.111114_19:44:27.40 > > 19:44:27 CDR CDRD_10358: failed rows spooled to file > > /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10358.111114_19:44:27.671 > > 19:44:27 CDR CDRD_10358: failed transaction spooled to file > > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10358.111114_19:44:27.672 > > > > [informix@walter RepErr]$ more > > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10358.111114_19:44:27.672 > > TXH RIS > > file:/dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10358.111114_19:44:27.671 > > > has also been created for this transaction > > ========== > > TXH Source ID:22 / Name:g_ncdcops / CommitTime:11-11-14 19:22:03 > > TXH Target ID:23 / Name:g_ngdcops / ReceiveTime:11-11-14 19:44:27 > > TXH Number of rows processed when transaction was aborted:1 > > TXH One or more rows in a transaction defined with tx scope were rejected > > > TXH CDR:7 (Error: Delete aborted, row does not exist in target table) / > > SQL:0 / ISAM:0 > > ---------- > > RRH Row:1 / Replicate Id: 1376334 / Table: > noaa@informix.rmt_path_update / > > DbOp:Delete > > RRD 491941603|file_change_notice|395290753|500|NCDC|OSDPD|NEWPATH > > > > [informix@walter RepErr]$ more > > /dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_10468.111114_19:44:27.40 > > TXH RIS > > file:/dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_10468.111114_19:44:27.39 > > has also been created for this transaction > > ========== > > TXH Source ID:22 / Name:g_ncdcops / CommitTime:11-11-14 19:22:03 > > TXH Target ID:23 / Name:g_ngdcops / ReceiveTime:11-11-14 19:44:27 > > TXH Number of rows processed when transaction was aborted:1 > > TXH One or more rows in a transaction defined with tx scope were rejected > > > TXH CDR:6 (Error: Update aborted, row does not exist in target table) / > > SQL:0 / ISAM:0 > > ---------- > > RRH Row:1 / Replicate Id: 1376299 / Table: > > noaa@informix.file_change_notice/ DbOp:Update > > RRD > > > > 395290753|OSDPD|mary-dat| > > > > > > > > > NCDC|/class_dirs