On 09/12/2016 02:33 PM, Tory M Blue wrote: > > > Okay keepalives didn't work, but maybe I configured the slon.conf wrong, > there does not appear to be any real examples > > I used: > > tcp_keepalive_time = 5 > > tcp_keepalive_probes = 24 > > tcp_keepalive_intvl = 5
tcp_keepalive_idle=5 tcp_keepalive_count=24 tcp_keepalive_interval=5 http://www.slony.info/documentation/2.2/slon-config-connection.html > > While my kernel is set at, maybe I need to adjust the kernel as well? > > net.ipv4.tcp_keepalive_time = 7200 > > net.ipv4.tcp_keepalive_probes = 9 > > net.ipv4.tcp_keepalive_intvl = 75 > > > 2016-09-12 09:27:48 PDT CONFIG remoteWorkerThread_1: 1869.486 seconds to > copy table "torque"."impressions_daily" > > 2016-09-12 09:27:48 PDT CONFIG remoteWorkerThread_1: copy table > "torque"."impressions" > > 2016-09-12 09:27:48 PDT CONFIG remoteWorkerThread_1: Begin COPY of table > "torque"."impressions" > > NOTICE: truncate of "torque"."impressions" succeeded > > 2016-09-12 10:31:09 PDT CONFIG remoteWorkerThread_1: 77048102322 bytes > copied for table "torque"."adimpressions" > > 2016-09-12 11:02:56 PDT CONFIG remoteWorkerThread_1: 5708.515 seconds to > copy table "torque"."impressions" > > 2016-09-12 11:02:56 PDT CONFIG remoteWorkerThread_1: copy table > "torque"."impressions_archive" > > 2016-09-12 11:02:56 PDT CONFIG remoteWorkerThread_1: Begin COPY of table > "torque"."impressions_archive" > > 2016-09-12 11:02:56 PDT ERROR remoteWorkerThread_1: "select > "_cls".copyFields(237);" > > 2016-09-12 11:02:56 PDT WARN remoteWorkerThread_1: data copy for set 2 > failed 1 times - sleep 15 seconds > > There are no indexes, so I don't know what Slon is doing for the 31 > minutes between when the data is finished copied and it attempts to > start the next table. > > More suggestions? I know I'm being needy but I'm spinning my wheels it seems > > Thanks > Tory > > > > _______________________________________________ > Slony1-general mailing list > Slony1-general@lists.slony.info > http://lists.slony.info/mailman/listinfo/slony1-general > _______________________________________________ Slony1-general mailing list Slony1-general@lists.slony.info http://lists.slony.info/mailman/listinfo/slony1-general
