Hi,<div><br></div><div>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</div><div>
<br></div><div><br></div><div>2010-06-03 12:51:41 PDTDEBUG2 remoteListenThread_1: queue event 1,5000007435 SYNC</div><div>2010-06-03 12:51:42 PDTDEBUG2 remoteListenThread_1: queue event 1,5000007436 SYNC</div><div>2010-06-03 12:51:43 PDTDEBUG2 remoteListenThread_1: queue event 1,5000007437 SYNC</div>
<div>2010-06-03 12:51:44 PDTDEBUG2 remoteListenThread_1: queue event 1,5000007438 SYNC</div><div>2010-06-03 12:51:45 PDTDEBUG2 remoteListenThread_1: queue event 1,5000007439 SYNC</div><div>2010-06-03 12:51:45 PDTDEBUG2 remoteWorkerThread_1: SYNC 5000004861 processing</div>
<div>2010-06-03 12:51:45 PDTDEBUG1 about to monitor_subscriber_query - pulling big actionid list for 1</div><div>2010-06-03 12:51:45 PDTINFO   remoteWorkerThread_1: syncing set 1 with 36 table(s) from provider 1</div><div>
2010-06-03 12:51:45 PDTDEBUG2  ssy_action_list length: 0</div><div>2010-06-03 12:51:45 PDTDEBUG2 remoteWorkerThread_1: current local log_status is 0</div><div>2010-06-03 12:51:45 PDTDEBUG2 remoteWorkerThread_1_1: current remote log_status = 2</div>
<div>2010-06-03 12:51:46 PDTDEBUG1 remoteHelperThread_1_1: 0.272 seconds delay for first row</div><div>2010-06-03 12:51:46 PDTDEBUG1 remoteHelperThread_1_1: 0.291 seconds until close cursor</div><div>2010-06-03 12:51:46 PDTDEBUG1 remoteHelperThread_1_1: inserts=226 updates=173 deletes=0</div>
<div>2010-06-03 12:51:46 PDTDEBUG1 remoteWorkerThread_1: sync_helper timing:  pqexec (s/count)- provider 0.274/4 - subscriber 0.001/4</div><div>2010-06-03 12:51:46 PDTDEBUG1 remoteWorkerThread_1: sync_helper timing:  large tuples 0.003/1</div>
<div>2010-06-03 12:51:46 PDTERROR  remoteWorkerThread_1: &quot;update only &quot;public&quot;.&quot;jobs&quot; set &quot;folder_path&quot;=&#39;/download/es/ws_2B_PROCESSED_PREVIEW2WEB/=pressfourt_14249-B0154127094-001-5k-4.4.0.0-16PT-BCMATT-2X35-MIA&#39; where &quot;job_id&quot;=&#39;2022703&#39;;</div>
<div>insert into &quot;public&quot;.&quot;job_status&quot; (&quot;job_status_id&quot;,&quot;job_id&quot;,&quot;status_code&quot;,&quot;take&quot;,&quot;date_set&quot;,&quot;user_id&quot;,&quot;email_needed&quot;,&quot;email_sent&quot;,&quot;folder_path&quot;,&quot;folder_user&quot;,&quot;batch_number&quot;,&quot;job_alias&quot;,&quot;ship_tracker&quot;) values (&#39;37700155&#39;,&#39;2022703&#39;,&#39;100&#39;,&#39;1&#39;,&#39;2010-06-03 12:05:21&#39;,&#39;0&#39;,&#39;f&#39;,&#39;f&#39;,&#39;/download/es/ws_2B_PROCESSED_PREVIEW2WEB/=pressfourt_14249-B0154127094-001-5k-4.4.0.0-16PT-BCMATT-2X35-MIA&#39;,&#39;&#39;,&#39;&#39;,&#39;&#39;,&#39;&#39;);</div>
<div>update only &quot;public&quot;.&quot;jobs&quot; set &quot;job_id&quot;=&#39;2022703&#39; where &quot;job_id&quot;=&#39;2022703&#39;;</div><div>insert into &quot;public&quot;.&quot;job_tasks&quot; (&quot;job_task_id&quot;,&quot;job_id&quot;,&quot;completed&quot;,&quot;task&quot;,&quot;notes&quot;,&quot;date_added&quot;,&quot;failed&quot;,&quot;attempt&quot;,&quot;date_completed&quot;,&quot;task_id&quot;) values (&#39;2022249.S&#39;,&#39;2022249&#39;,&#39;f&#39;,&#39;send2prod|++=@@theprintin_14181-B0154116748-001-1k-4.4.0.0-14PT-RCBCMATT-2X35-MIA-RC|2B_PROCESSED_4SITE@GLN|5&#39;,NULL,&#39;2010-06-03 12:05:20.767821&#39;,&#39;f&#39;,&#39;0&#39;,NULL,&#39;3044361&#39;);</div>
<div>update only &quot;public&quot;.&quot;job_tasks&quot; set &quot;completed&quot;=&#39;t&#39;,&quot;notes&quot;=&#39;&#39;,&quot;date_completed&quot;=&#39;2010-06-03 12:05:20.688241&#39; where &quot;task_id&quot;=&#39;3044349&#39;;</div>
<div>insert into &quot;public&quot;.&quot;notes&quot; (&quot;note_id&quot;,&quot;cust_id&quot;,&quot;anything_id&quot;,&quot;id_type&quot;,&quot;date_added&quot;,&quot;user_id&quot;,&quot;text&quot;,&quot;from_dept_id&quot;,&quot;to_dept_id&quot;,&quot;auto_note_id&quot;,&quot;read_by&quot;,&quot;read_date&quot;) values (&#39;2031235&#39;,&#39;52069&#39;,&#39;2022695&#39;,&#39;&#39;,&#39;2010-06-03 12:05:21&#39;,&#39;0&#39;,&#39;HTML Preview: <a href="http://tools.4over.com/previews/,B0154/B0154127082-001_Ss4BcFlHqYVG2OS0TBdMWHxN.d">http://tools.4over.com/previews/,B0154/B0154127082-001_Ss4BcFlHqYVG2OS0TBdMWHxN.d</a>&#39;,&#39;&#39;,&#39;&#39;,&#39;&#39;,NULL,NULL);</div>
<div>insert into &quot;public&quot;.&quot;orders&quot; (&quot;order_id&quot;,&quot;source&quot;,&quot;source_order_id&quot;,&quot;date_ordered&quot;,&quot;date_added&quot;,&quot;cust_id&quot;,&quot;cust_company&quot;,&quot;cust_firstname&quot;,&quot;cust_lastname&quot;,&quot;cust_phone&quot;,&quot;cust_email&quot;,&quot;cust_bill_addr1&quot;,&quot;cust_bill_addr2&quot;,&quot;cust_bill_city&quot;,&quot;cust_bill_state&quot;,&quot;cust_bill_zip&quot;,&quot;cust_bill_country&quot;,&quot;pay_method&quot;,&quot;pay_grossprice&quot;,&quot;pay_netprice&quot;,&quot;pay_cclast4&quot;,&quot;pay_approval_code&quot;,&quot;pay_trans_id&quot;,&quot;discount_type&quot;,&quot;discount_id&quot;,&quot;discount_adjustment&quot;,&quot;discount_value&quot;,&quot;prod_status&quot;,&quot;instructions&quot;,&quot;xml_file&quot;) values (&#39;1283441&#39;,&#39;trade&#39;,&#39;B0154127118&#39;,&#39;2010-06-03 12:06:54&#39;,&#39;2010-06-03 12:06:41&#39;,&#39;3228&#39;,&#39;Calabasas Printing&#39;,&#39;Darrin&#39;,&#39;Cockerill&#39;,&#39;8185912935&#39;,&#39;<a href="mailto:paul@calabasasprinting.com">paul@calabasasprinting.com</a>&#39;,&#39;23875 Ventura Blvd., Suite 105&#39;,&#39;&#39;,&#39;Calabasas&#39;,&#39;CA&#39;,&#39;91302&#39;,&#39;US&#39;,&#39;cc&#39;,&#39;42000&#39;,&#39;42000&#39;,&#39;5718&#39;,&#39;413050&#39;,&#39;3020152307&#39;,&#39;&#39;,&#39;&#39;,&#39;&#39;,&#39;&#39;,&#39;0&#39;,NULL,NULL);</div>
<div>update only &quot;public&quot;.&quot;orders&quot; set &quot; ERROR:  syntax error at end of input</div><div>LINE 8: update only &quot;public&quot;.&quot;orders&quot; set </div><div>                                          ^</div>
<div> - qualification was: </div><div>2010-06-03 12:51:46 PDTDEBUG2 remoteWorkerThread_1: cleanup</div><div>2010-06-03 12:51:46 PDTERROR  remoteWorkerThread_1: SYNC aborted</div><div>2010-06-03 12:51:46 PDTDEBUG2 remoteListenThread_1: queue event 1,5000007440 SYNC</div>
<div>2010-06-03 12:51:47 PDTDEBUG2 remoteListenThread_1: queue event 1,5000007441 SYNC</div><div>2010-06-03 12:51:48 PDTDEBUG2 remoteListenThread_1: queue event 1,5000007442 SYNC</div><div>2010-06-03 12:51:49 PDTDEBUG2 remoteListenThread_1: queue event 1,5000007443 SYNC</div>
<div>2010-06-03 12:51:50 PDTDEBUG2 remoteListenThread_1: queue event 1,5000007444 SYNC</div><div><br></div><div><br></div><div>Could you please suggest, how to rid out of above errors.</div><div><br></div><div>Slony version: 2.0.1</div>
<div><br></div><div>Structure of the table for Master and slave is fine.</div><div><br></div><div> <br clear="all"><br>-- <br>Thanks &amp; Regards<br>Raghu Ram<br>System Engineer<br>EnterpriseDB Corporation<br>The Enterprise Postgres Company<br>
Phone: 732-331-1300 Ext- 2022<br>            020-30589493<br>           +91-9604766989<br>Website: <a href="http://www.enterprisedb.com">www.enterprisedb.com</a><br>EnterpriseDB Blog: <a href="http://blogs.enterprisedb.com/">http://blogs.enterprisedb.com/</a><br>
Follow us on Twitter: <a href="http://www.twitter.com/enterprisedb">http://www.twitter.com/enterprisedb</a><br><br>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. <br>
<br>
</div>