[ckan-dev] SSL SYSCALL Error

Wed Sep 19 23:25:39 UTC 2018

It doesnt seem like postgres has any effect on ckan.

If i stop the service all together my site still runs.

On Wed, Sep 19, 2018 at 7:18 PM Biz Tweets <optweets at gmail.com> wrote:

> Im going to try for the pgbouncer solution once I figure out how to instal
> it.
>
> On Wed, Sep 19, 2018 at 7:17 PM Karen Turner <karen at catalyst.net.nz>
> wrote:
>
>> I don't know why that would not work for you then.
>> Once something in the middle has dropped the connection the only way is
>> to restart.
>>
>> I don't know of a solution. sorry.
>>
>> On 20/09/18 10:57, Biz Tweets wrote:
>> > Its a linux box, and I ended up trying the fix but its not working. The
>> > only way for me to  a connection is to run sudo apache2
>> > restart manually.
>> >
>> >
>> >
>> > On Wed, Sep 19, 2018 at 6:56 PM Karen Turner <karen at catalyst.net.nz
>> > <mailto:karen at catalyst.net.nz>> wrote:
>> >
>> >     Cool.
>> >
>> >     I did see comments on the postgres page about the keep alive. Is the
>> >     postgres box Linux or Windows based?
>> >
>> >
>> https://www.postgresql.org/docs/9.5/static/runtime-config-connection.html
>> >
>> >     I think the eventual solution would be at the CKAN end to make it
>> more
>> >     robust. I did look at this when the issue came up but I couldn't
>> see a
>> >     quick fix.
>> >
>> >
>> >
>> >     On 20/09/18 10:49, Biz Tweets wrote:
>> >     > Yep i found your old ckan post for reference:
>> >     >
>> >     > I tried it but it didnt work, ill do some further testing.
>> >     >
>> >     > https://lists.okfn.org/pipermail/ckan-dev/2017-May/022314.html
>> >     >
>> >     > Thanks!
>> >     _______________________________________________
>> >     ckan-dev mailing list
>> >     ckan-dev at lists.okfn.org <mailto:ckan-dev at lists.okfn.org>
>> >     https://lists.okfn.org/mailman/listinfo/ckan-dev
>> >     Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>> >
>> >
>> >
>> > _______________________________________________
>> > ckan-dev mailing list
>> > ckan-dev at lists.okfn.org
>> > https://lists.okfn.org/mailman/listinfo/ckan-dev
>> > Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>> >
>> _______________________________________________
>> ckan-dev mailing list
>> ckan-dev at lists.okfn.org
>> https://lists.okfn.org/mailman/listinfo/ckan-dev
>> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20180919/e6a73613/attachment-0002.html>