Article View: borland.public.interbase.replication
Article #151Records not being replicated
From: Damien Turnbull
Date: Tue, 17 Jun 2003 02:33
Date: Tue, 17 Jun 2003 02:33
26 lines
1721 bytes
1721 bytes
I am attempting to set up replication using IB 7.0 and it's supplied replication tool. For some reason, it doesn't seem to be replicating the records from the tables that have a DOUBLE PRECISION field within the source table's primary key. When replicating, the following error is displyed: Insert 2.000000000000000 SELECT INTNUM,DBLNUM FROM DBL WHERE DBLNUM = ? INSERT INTO DBL ( INTNUM , DBLNUM ) VALUES (? , ? ) UPDATE DBL SET INTNUM = ? WHERE DBLNUM = ? DELETE FROM DBL WHERE DBLNUM = ? PLAN (DBL INDEX (RDB$PRIMARY306)) Tue Jun 17 10:12:50 2003 WARNING- Record not found - possibly already deleted or Key values modified The record's reference record is deleted from the REPL_LOG table and then seems to just disappear. The statistics displayed do not show any Inserts, Updates or Deletions. All other tables replicate through fine. Any ideas what is going on? Thanks, Damien
Technical Details
Message-ID:
<8ba35949.0306161833.7c625e83@posting.google.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: f89d7,70abd1219bf0cdaf,start X-Google-Attributes: gidf89d7,public X-Google-ArrivalTime: 2003-06-16 19:33:05 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail From: damtur@drs.com.au (Damien Turnbull) Newsgroups: borland.public.interbase.replication Subject: Records not being replicated Date: 16 Jun 2003 19:33:04 -0700 Organization: http://groups.google.com/ Lines: 26 Message-ID: <8ba35949.0306161833.7c625e83@posting.google.com> NNTP-Posting-Host: 192.169.41.42 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1055817185 16483 127.0.0.1 (17 Jun 2003 02:33:05 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 17 Jun 2003 02:33:05 GMT