Article View: borland.public.interbase.replication
Article #727Re: deciphering replication log
From: Vince Duggan
Date: Fri, 19 Oct 2001 14:18
Date: Fri, 19 Oct 2001 14:18
26 lines
1763 bytes
1763 bytes
The first error, means that the row was not found in the source database, while the second means the row was not found on the target database Vince "T.D. Brown" wrote: > > Below are a few lines from our replication log. There are two consecutive > updates to the same table. You'll notice the first update generates a > warning that it couldn't find the record to update. So, what did it do with > the record? Why wasn't it converted into a insert statement as in the > second update? > > Update 0*383*39*WA > Tue Jun 12 14:29:06 2001 > WARNING- Record not found - possibly already deleted or Key values modified > Update 0*380*39*WA > Tue Jun 12 14:29:06 2001 > Could not find row to update - Converted to INSERT STATEMENT > > -- > Thank you, > Tom Brown > Tracker Business Systems, Inc. > tom.brown@tbs-inc.net
Technical Details
Message-ID:
<3BD03645.C3E5760A@replication.co.za>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newshub2.rdc1.sfba.home.com!news.home.com!newsfeed.mesh.ad.jp!osa.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnewsReferences:
<3bc33d53$1_2@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: f89d7,edc02467cd2d36ce X-Google-Attributes: gidf89d7,public X-Google-ArrivalTime: 2001-10-19 07:29:58 PST Message-ID: <3BD03645.C3E5760A@replication.co.za> Date: Fri, 19 Oct 2001 16:18:45 +0200 From: Vince Duggan <vince@replication.co.za> X-Mailer: Mozilla 4.74 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 Newsgroups: borland.public.interbase.replication Subject: Re: deciphering replication log References: <3bc33d53$1_2@dnews> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 196.38.219.242 X-Trace: dnews 1003501186 196.38.219.242 (19 Oct 2001 07:19:46 -0700) Lines: 26 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newshub2.rdc1.sfba.home.com!news.home.com!newsfeed.mesh.ad.jp!osa.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews