problem solved

Wiadomość napisana przez Sebastian Pawłowski <sebpaa at gmail.com> 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20120918/8a985935/attachment.htm