Hi,

Replication is setup performed between master to slave node, while syncing
operation going b/w the master to slave, we have observed the below errors
in slony log files and sync is aborted


2010-06-03 12:51:41 PDTDEBUG2 remoteListenThread_1: queue event 1,5000007435
SYNC
2010-06-03 12:51:42 PDTDEBUG2 remoteListenThread_1: queue event 1,5000007436
SYNC
2010-06-03 12:51:43 PDTDEBUG2 remoteListenThread_1: queue event 1,5000007437
SYNC
2010-06-03 12:51:44 PDTDEBUG2 remoteListenThread_1: queue event 1,5000007438
SYNC
2010-06-03 12:51:45 PDTDEBUG2 remoteListenThread_1: queue event 1,5000007439
SYNC
2010-06-03 12:51:45 PDTDEBUG2 remoteWorkerThread_1: SYNC 5000004861
processing
2010-06-03 12:51:45 PDTDEBUG1 about to monitor_subscriber_query - pulling
big actionid list for 1
2010-06-03 12:51:45 PDTINFO   remoteWorkerThread_1: syncing set 1 with 36
table(s) from provider 1
2010-06-03 12:51:45 PDTDEBUG2  ssy_action_list length: 0
2010-06-03 12:51:45 PDTDEBUG2 remoteWorkerThread_1: current local log_status
is 0
2010-06-03 12:51:45 PDTDEBUG2 remoteWorkerThread_1_1: current remote
log_status = 2
2010-06-03 12:51:46 PDTDEBUG1 remoteHelperThread_1_1: 0.272 seconds delay
for first row
2010-06-03 12:51:46 PDTDEBUG1 remoteHelperThread_1_1: 0.291 seconds until
close cursor
2010-06-03 12:51:46 PDTDEBUG1 remoteHelperThread_1_1: inserts=226
updates=173 deletes=0
2010-06-03 12:51:46 PDTDEBUG1 remoteWorkerThread_1: sync_helper timing:
 pqexec (s/count)- provider 0.274/4 - subscriber 0.001/4
2010-06-03 12:51:46 PDTDEBUG1 remoteWorkerThread_1: sync_helper timing:
 large tuples 0.003/1
2010-06-03 12:51:46 PDTERROR  remoteWorkerThread_1: "update only
"public"."jobs" set
"folder_path"='/download/es/ws_2B_PROCESSED_PREVIEW2WEB/=pressfourt_14249-B0154127094-001-5k-4.4.0.0-16PT-BCMATT-2X35-MIA'
where "job_id"='2022703';
insert into "public"."job_status"
("job_status_id","job_id","status_code","take","date_set","user_id","email_needed","email_sent","folder_path","folder_user","batch_number","job_alias","ship_tracker")
values ('37700155','2022703','100','1','2010-06-03
12:05:21','0','f','f','/download/es/ws_2B_PROCESSED_PREVIEW2WEB/=pressfourt_14249-B0154127094-001-5k-4.4.0.0-16PT-BCMATT-2X35-MIA','','','','');
update only "public"."jobs" set "job_id"='2022703' where "job_id"='2022703';
insert into "public"."job_tasks"
("job_task_id","job_id","completed","task","notes","date_added","failed","attempt","date_completed","task_id")
values
('2022249.S','2022249','f','send2prod|++=@@theprintin_14181-B0154116748-001-1k-4.4.0.0-14PT-RCBCMATT-2X35-MIA-RC|2B_PROCESSED_4SITE at GLN|5',NULL,'2010-06-03
12:05:20.767821','f','0',NULL,'3044361');
update only "public"."job_tasks" set
"completed"='t',"notes"='',"date_completed"='2010-06-03 12:05:20.688241'
where "task_id"='3044349';
insert into "public"."notes"
("note_id","cust_id","anything_id","id_type","date_added","user_id","text","from_dept_id","to_dept_id","auto_note_id","read_by","read_date")
values ('2031235','52069','2022695','','2010-06-03 12:05:21','0','HTML
Preview:
http://tools.4over.com/previews/,B0154/B0154127082-001_Ss4BcFlHqYVG2OS0TBdMWHxN.d
','','','',NULL,NULL);
insert into "public"."orders"
("order_id","source","source_order_id","date_ordered","date_added","cust_id","cust_company","cust_firstname","cust_lastname","cust_phone","cust_email","cust_bill_addr1","cust_bill_addr2","cust_bill_city","cust_bill_state","cust_bill_zip","cust_bill_country","pay_method","pay_grossprice","pay_netprice","pay_cclast4","pay_approval_code","pay_trans_id","discount_type","discount_id","discount_adjustment","discount_value","prod_status","instructions","xml_file")
values ('1283441','trade','B0154127118','2010-06-03 12:06:54','2010-06-03
12:06:41','3228','Calabasas Printing','Darrin','Cockerill','8185912935','
paul at calabasasprinting.com','23875 Ventura Blvd., Suite
105','','Calabasas','CA','91302','US','cc','42000','42000','5718','413050','3020152307','','','','','0',NULL,NULL);
update only "public"."orders" set " ERROR:  syntax error at end of input
LINE 8: update only "public"."orders" set
                                          ^
 - qualification was:
2010-06-03 12:51:46 PDTDEBUG2 remoteWorkerThread_1: cleanup
2010-06-03 12:51:46 PDTERROR  remoteWorkerThread_1: SYNC aborted
2010-06-03 12:51:46 PDTDEBUG2 remoteListenThread_1: queue event 1,5000007440
SYNC
2010-06-03 12:51:47 PDTDEBUG2 remoteListenThread_1: queue event 1,5000007441
SYNC
2010-06-03 12:51:48 PDTDEBUG2 remoteListenThread_1: queue event 1,5000007442
SYNC
2010-06-03 12:51:49 PDTDEBUG2 remoteListenThread_1: queue event 1,5000007443
SYNC
2010-06-03 12:51:50 PDTDEBUG2 remoteListenThread_1: queue event 1,5000007444
SYNC


Could you please suggest, how to rid out of above errors.

Slony version: 2.0.1

Structure of the table for Master and slave is fine.



-- 
Thanks & Regards
Raghu Ram
System Engineer
EnterpriseDB Corporation
The Enterprise Postgres Company
Phone: 732-331-1300 Ext- 2022
           020-30589493
          +91-9604766989
Website: www.enterprisedb.com
EnterpriseDB Blog: http://blogs.enterprisedb.com/
Follow us on Twitter: http://www.twitter.com/enterprisedb

This e-mail message (and any attachment) is intended for the use of the
individual or entity to whom it is addressed. This message contains
information from EnterpriseDB Corporation that may be privileged,
confidential, or exempt from disclosure under applicable law. If you are not
the intended recipient or authorized to receive this for the intended
recipient, any use, dissemination, distribution, retention, archiving, or
copying of this communication is strictly prohibited. If you have received
this e-mail in error, please notify the sender immediately by reply e-mail
and delete this message.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20100604/96050283/attachment.htm