[ckan-dev] SSL SYSCALL error: EOF detected

Mon May 21 20:26:21 UTC 2018

Hi

I had a similar problem. It was the firewall dropping the connection between the webserver and the database server. Because of the way that the connection was dropped the database server didn’t get the network disconnect.
In my case we were using postgresql and we were able to set the keep alive in the postgresql config.

I don’t know SQL alchemy itself well enough to know if there is a parameter that should be passed to make it retry a session if it goes away. Or whether this is something that would be done at the CKAN level.

Cheers
  Karen

----
Karen Turner
Catalyst IT
w: http://catalyst.net.nz <http://catalyst.net.nz/>
p: +64 4  803 2375

> On 22/05/2018, at 12:25 AM, Ross Jones <ross at mailbolt.com> wrote:
> 
> Hi,
> 
> The last time I had this problem, it was because the connection through the DMZ was being killed after a short period of inactivity.  As getting the DMZ connection changed was apparently not feasible, I ended up using pgbouncer ( https://pgbouncer.github.io/ ) to <https://pgbouncer.github.io/> handle the reconnections for me.  It worked pretty well.
> 
> For Redis, I'd recommend looking at your redis.conf to ensure there is a timeout on connections, otherwise redis will keep those disconnected client's sockets around forever, or at least until you run out of file-descriptors.  This happened to my project this morning with some connections from 70 days ago still recorded in redis even though the clients had been rebooted many times.
> 
> Solr I'm not so sure about, as far as I know a connection isn't kept permanently open, but I could be wrong - hopefully somebody else will know.
> 
> Regards
> 
> 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 <https://lists.okfn.org/mailman/listinfo/ckan-dev>
> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev <https://lists.okfn.org/mailman/options/ckan-dev>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20180522/715b29f0/attachment-0002.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 269 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20180522/715b29f0/attachment-0002.sig>