[Bucardo-general] Goat with Text Pkey Problem
Ben Allen
bsa at lanl.gov
Fri Oct 5 15:54:37 UTC 2007
When I make a sync that includes a goat that uses a text primary key
the following, what looks like an SQL error, occurs.
#Bucardo Log
(16738) [1191598116] CTL Re-adding sync to q table for db "test2"
(16738) [1191598117] CTL Creating kid to handle resurrected q row
(16738) [1191598117] CTL Created new kid 16749 for sync "test_sync"
(16749) [1191598117] KID New kid, syncs "test1" to "test2" for sync
"test_sync" alive=1 Parent=16738
(16749) [1191598117] KID Source delta count for public.name: 0
(16749) [1191598117] KID Target delta count for public.name: 0
(16749) [1191598117] KID Warning! Rows set to aborted in the q table
for this child: 1
(16749) [1191598117] KID Warning! Child for "test_sync" was killed at
line 3731: DBD::Pg::st execute failed: ERROR: syntax error at or
near "FROM"
LINE 4: FROM bucardo.bucardo_delta d
^
main error: none source error: 7 target error: none
(16749) [1191598117] KID Sent an email to nobody at example.com: Bucardo
kid for "test_sync" killed
#PostgreSQL Log
LOG: statement: DEALLOCATE dbdpg_1
LOG: execute dbdpg_2:
UPDATE bucardo.audit_pid
SET killdate=timeofday
()::timestamp, death=$1
WHERE type='KID'
AND sync=$2
AND ppid=$3
AND pid=$4
DETAIL: parameters: $1 = 'DBD::Pg::st execute failed: ERROR: syntax
error at or near "FROM"
LINE 4: FROM bucardo.bucardo_delta d
^
main error: none source error: 7 target error: none
', $2 = 'test_sync', $3 = '16883', $4 = '16907'
LOG: statement: commit
#SQL of the table created, and SQL used to add the goat.
CREATE TABLE group_def (
groupname text CONSTRAINT group_def PRIMARY KEY
);
INSERT INTO goat(db,tablename,pkey,pkeytype,standard_conflict) VALUES
('test1', 'group_def', 'groupname', 'text', 'source' );
My database setup is the same as the previous example I posted. I've
tested this both on the AMD64 and i386 platforms as well as a two
host and one host setup. I'm using the latest pull from git.
Any ideas?
Thanks,
Ben Allen
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20071005/ae42b2aa/attachment.html
More information about the Bucardo-general
mailing list