🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.replication
Article #151

Records not being replicated

#151
From: Damien Turnbull
Date: Tue, 17 Jun 2003 02:33
26 lines
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-mail

Show 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