[ckan-dev] SSL SYSCALL Error

Wed Sep 19 22:49:03 UTC 2018

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!

On Wed, Sep 19, 2018 at 6:48 PM Karen Turner <karen at catalyst.net.nz> wrote:

> No sorry for the confusion. We the keep alive in the postgres
> configuration on the database server.
>
> On 20/09/18 10:46, Biz Tweets wrote:
> > Got it, so you set a keepalive on the firewall end not postgres end
> correct?
> >
> > On Wed, Sep 19, 2018 at 6:45 PM Karen Turner <karen at catalyst.net.nz
> > <mailto:karen at catalyst.net.nz>> wrote:
> >
> >     We  used similar values.  But we hosted the database ourselves on a
> >     ubuntu box.
> >
> >     I've not done it on Azure.
> >
> >     It did fix the issue for us.  The stackoverflow question matched our
> >     issue with it being a statefull firewall that causing the issue.
> >
> >     So doing the keepalive meant that the firewall did not drop the
> >     connection.  The firewall would drop the connection with out
> notifying
> >     either end that the socket was closing.
> >
> >     Cheers
> >       Karen
> >
> >     On 20/09/18 06:50, Biz Tweets wrote:
> >     > So i set the following values in my postgresql.conf file and it
> didnt
> >     > work when i forced a disconnect. I was still getting the SSL
> SysCall
> >     > error after 5 minutes.
> >     >
> >     > tcp_keepalives_idle=300
> >     > tcp_keepalives_interval=30
> >     > tcp_keepalives_count=60
> >     >
> >     > My postgres server is hosted on Azure.
> >     >
> >     >
> >     > On Wed, Sep 19, 2018 at 9:44 AM Biz Tweets <optweets at gmail.com
> >     <mailto:optweets at gmail.com>
> >     > <mailto:optweets at gmail.com <mailto:optweets at gmail.com>>> wrote:
> >     >
> >     >     Where and what settings did you set for postgres keep alive?
> >     >
> >     >     I found this reference but I want to just confirm since you
> got it
> >     >     working.
> >     >
> >     >
> >
> https://stackoverflow.com/questions/6592137/sqlalchemy-fails-to-connect-to-db-after-server-is-idle-for-a-few-hours
> >     >
> >     >     On Tue, Sep 18, 2018 at 4:51 PM Karen Turner
> >     <karen at catalyst.net.nz <mailto:karen at catalyst.net.nz>
> >     >     <mailto:karen at catalyst.net.nz <mailto:karen at catalyst.net.nz>>>
> >     wrote:
> >     >
> >     >         Hi
> >     >
> >     >         I've had this issue when the firewall between ckan and
> >     Postgres
> >     >         would
> >     >         drop inactive connections.  Looks like the way SQL Alchemy
> >     is used
> >     >         doesn't retry.
> >     >
> >     >         The work around I used was to change the Postgres
> >     configuration
> >     >         to use
> >     >         keep alives.
> >     >
> >     >         Karen
> >     >
> >     >         On 19/09/18 02:44, Ross Jones wrote:
> >     >         > I think it's
> >     probably https://github.com/ckan/ckan/issues/3415
> >     >         >
> >     >         > If you search the mailing list I think this has come up
> >     >         before. I work
> >     >         > around it with pgbouncer but I think there was a thread
> >     with an
> >     >         > alternative solution.
> >     >         >
> >     >         > Ross
> >     >         >
> >     >         >
> >     >         >
> >     >         >
> >     _______________________________________________
> >     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/15bbfb46/attachment-0002.html>