<html><head><meta http-equiv="Content-Type" content="text/html charset=iso-8859-2"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">problem solved<div><br><div><div>Wiadomość napisana przez Sebastian Pawłowski <<a href="mailto:sebpaa@gmail.com">sebpaa@gmail.com</a>> w dniu 18 wrz 2012, o godz. 15:56:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">HI, <div><br></div><div>os: ubuntu</div><div>slony 2.1.2</div><div>postgres 9.0</div><div><br></div><div>i've problem with setting up replicaction, when i try to subscribe set from master to slave i get:</div><div><br></div><div><div>2012-09-18 14:49:13 CEST CONFIG remoteWorkerThread_2: Begin COPY of table "public"."auth_user"</div><div>NOTICE: truncate of "public"."auth_user" failed - doing delete</div><div>2012-09-18 14:54:42 CEST CONFIG remoteWorkerThread_2: 2745697400 bytes copied for table "public"."auth_user"</div><div>2012-09-18 15:26:52 CEST CONFIG remoteWorkerThread_2: 2259.200 seconds to copy table "public"."auth_user"</div><div>2012-09-18 15:26:52 CEST CONFIG remoteWorkerThread_2: copy table "public"."payments_grouppacket"</div><div>2012-09-18 15:26:52 CEST CONFIG remoteWorkerThread_2: Begin COPY of table "public"."payments_grouppacket"</div><div>2012-09-18 15:26:52 CEST ERROR remoteWorkerThread_2: "select "_getmedia".copyFields(2);" FATAL: terminating connection due to administrator command</div><div>server closed the connection unexpectedly</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>This probably means the server terminated abnormally</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>before or while processing the request.</div><div><br></div><div>2012-09-18 15:26:52 CEST WARN remoteWorkerThread_2: data copy for set 1 failed 1 times - sleep 15 seconds</div></div><div><br></div><div>table auth_user syncs, but next table payments_grouppacket fails to sync, every time the same: FATAL, and the process go back to copy auth_user</div><div>i've checked in logs, and there is not nothing else</div><div><br></div><div>postgres logs shows only these:</div><div><br></div><div><div><b>Sep 18 15:26:52 db01a postgres[11628]: [68-1] 2012-09-18 15:26:52.188 CEST slony@getmedia 11628 192.168.10.241(58888) LOG: duration: 1929804.203 ms statement: select "_getmedia".finishTableAfterCopy(1); analyze "public"."auth_user"; </b></div><div>Sep 18 15:26:52 db01a postgres[11629]: [4667-1] 2012-09-18 15:26:52.192 CEST slony@getmedia 11629 192.168.10.241(58891) LOG: duration: 0.082 ms statement: start transaction;set transaction isolation level serializable;lock table "_getmedia".sl_event_lock;select last_value from "_getmedia".sl_action_seq;</div><div>Sep 18 15:26:52 db01a postgres[11629]: [4668-1] 2012-09-18 15:26:52.192 CEST slony@getmedia 11629 192.168.10.241(58891) LOG: duration: 0.019 ms statement: rollback transaction;</div><div>Sep 18 15:26:52 db01a postgres[11619]: [3361-1] 2012-09-18 15:26:52.229 CEST slony@getmedia 11619 192.168.10.241(58887) LOG: duration: 0.034 ms statement: start transaction; set transaction isolation level serializable;</div><div>Sep 18 15:26:52 db01a postgres[11619]: [3362-1] 2012-09-18 15:26:52.229 CEST slony@getmedia 11619 192.168.10.241(58887) LOG: duration: 0.228 ms statement: select ev_seqno, ev_timestamp, 'dummy', 'dummy', 'dummy', ev_type, ev_data1, ev_data2, ev_data3, ev_data4, ev_data5, ev_data6, ev_data7, ev_data8 from "_getmedia".sl_event where ev_origin = '1' and ev_seqno > '5000000576' order by ev_seqno</div><div>Sep 18 15:26:52 db01a postgres[11619]: [3363-1] 2012-09-18 15:26:52.229 CEST slony@getmedia 11619 192.168.10.241(58887) LOG: duration: 0.022 ms statement: rollback transaction;</div><div><b>Sep 18 15:26:52 db01a postgres[11628]: [69-1] 2012-09-18 15:26:52.235 CEST slony@getmedia 11628 192.168.10.241(58888) LOG: duration: 46.190 ms statement: lock table "_getmedia".sl_config_lock;select "_getmedia".setAddTable_int(1, 2, '"public"."payments_grouppacket"', 'payments_grouppacket_pkey', 'Table public.payments_grouppacket with primary key'); </b></div></div><div><br></div><div><br></div><div>any ideas, could You help me?</div><div><br></div><div>best regards</div><div><br></div><div>Sebastian</div></div>_______________________________________________<br>Slony1-general mailing list<br><a href="mailto:Slony1-general@lists.slony.info">Slony1-general@lists.slony.info</a><br>http://lists.slony.info/mailman/listinfo/slony1-general<br></blockquote></div><br></div></body></html>