[ckan-dev] SSL SYSCALL Error

Tue Sep 18 14:44:06 UTC 2018

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

On Tue, Sep 18, 2018, at 3:22 PM, Biz Tweets wrote:
> Hey there,
> 
> We are hosting our ckan build on Azure. The Postgres DB Is running on
> Azure Database for PostgreSQL. Sometimes it seems that the connection
> breaks and once it does the following error will hang below in Apache2
> error logs and the site will not reconnect.> 
> Has anyone come accross this error and or have a known way for ckan to
> reconnect if this error arises due to a postgres break?> 
> Usually all i need to run to fix this error will be an apache2 restart> 
> OperationalError: (OperationalError) SSL SYSCALL error: EOF detected
> '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'}> _________________________________________________
> 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/20180918/20897188/attachment-0002.html>