problem solved Wiadomość napisana przez Sebastian Pawłowski <[email protected]> w dniu 18 wrz 2012, o godz. 15:56:
> HI, > > os: ubuntu > slony 2.1.2 > postgres 9.0 > > i've problem with setting up replicaction, when i try to subscribe set from > master to slave i get: > > 2012-09-18 14:49:13 CEST CONFIG remoteWorkerThread_2: Begin COPY of table > "public"."auth_user" > NOTICE: truncate of "public"."auth_user" failed - doing delete > 2012-09-18 14:54:42 CEST CONFIG remoteWorkerThread_2: 2745697400 bytes copied > for table "public"."auth_user" > 2012-09-18 15:26:52 CEST CONFIG remoteWorkerThread_2: 2259.200 seconds to > copy table "public"."auth_user" > 2012-09-18 15:26:52 CEST CONFIG remoteWorkerThread_2: copy table > "public"."payments_grouppacket" > 2012-09-18 15:26:52 CEST CONFIG remoteWorkerThread_2: Begin COPY of table > "public"."payments_grouppacket" > 2012-09-18 15:26:52 CEST ERROR remoteWorkerThread_2: "select > "_getmedia".copyFields(2);" FATAL: terminating connection due to > administrator command > server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > > 2012-09-18 15:26:52 CEST WARN remoteWorkerThread_2: data copy for set 1 > failed 1 times - sleep 15 seconds > > 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 > i've checked in logs, and there is not nothing else > > postgres logs shows only these: > > 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"; > 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; > 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; > 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; > 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 > 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; > 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'); > > > any ideas, could You help me? > > best regards > > Sebastian > _______________________________________________ > Slony1-general mailing list > [email protected] > http://lists.slony.info/mailman/listinfo/slony1-general
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
