[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