[ckan-dev] SSL SYSCALL error: EOF detected

Mon May 21 12:25:04 UTC 2018

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 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

On Mon, May 21, 2018, at 1:23 PM, Rafa wrote:
> Hi everyone.
> 
> I have installed CKAN instance in 3 servers:
>  * Server 1 with Nginx acting as a proxy server.
>  * Server 2 with CKAN frontend and Apache.
>  * Server 3 (DMZ) with al database, Solr and Redis stuff.> All the system is still in a developing phase with no user, just me
> creating organizations, groups and some datasets via web interface.
> After a few minutes of use, I always get this error and CKAN returns
> an Error 500:> 
> [Mon May 21 13:20:26.992569 2018] [wsgi:error] [pid 8037] [remote
> 192.168.3.1:328] Error - <class 'sqlalchemy.exc.OperationalError'>:
> (OperationalError) SSL SYSCALL error: EOF detected> [Mon May 21 13:20:26.992630 2018] [wsgi:error] [pid 8037] [remote
> 192.168.3.1:328]  'SELECT system_info.id AS system_info_id,
> system_info.key AS system_info_key, system_info.value AS
> system_info_value, system_info.state AS system_info_state,
> system_info.revision_id AS system_info_revision_id \\nFROM system_info
> \\nWHERE system_info.key = %(key_1)s \\n LIMIT %(param_1)s'
> {'param_1': 1, 'key_1': 'ckan.config_update'}> 
> Any idea of what the problem may be or how to solve this error?
> 
> Thanks.
> Rafa.
> 
> -- 
> --------------------------------------------------
> Rafael Salas Robledo
> _________________________________________________
> 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/20180521/8791da8a/attachment-0002.html>