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 at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
>