Thu Jun 3 13:46:56 PDT 2010
- Previous message: [Slony1-general] Known issues with Slony-I 2.0.3
- Next message: [Slony1-general] Replication issue
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Known issues with Slony-I 2.0.3
- Next message: [Slony1-general] Replication issue
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list