[ckan-dev] SSL SYSCALL Error

[Karen Turner]

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
> 
> 
> 
> 
> 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 <http://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 <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
>