[ckan-dev] (OperationalError) could not send data to server: Connection timed out

[Nigel Babu]

Hi,

What made you conclude that it was a Postgresql feature? As far as I can see
you need pgbouncer or some such configured to do this. How about making sure
the server doesn't drop idle connections? I'm sure there'd be a way to do that.

On Thu, Jun 12, 2014 at 04:56:49PM +0200, Gianluca Pindinelli wrote:
> Hi all!
> I have a problem with an installation of CKAN 2.2a: my scenario
> involves two VM, one for CKAN and one for PostgreSql DBMS.
> Sometimes (when the portal is not used for a long time) CKAN print
> the error "(OperationalError) could not send data to server:
> Connection timed out" with blank page into browser. Restarting
> apache the problem disappears.
> I did an investigation and the problem seems correlated to
> PostgreSql 9.1 that closes the connection not used after some time.
> I tried to set parameters for "sqlalchemy" connection pool, adding
> these setting into my production.ini:
>
> sqlalchemy.pool_recycle=3600
> sqlalchemy.pool_size=5
> sqlalchemy.max_overflow=10
> sqlalchemy.pool_timeout=30
>
> but the problem persists.
> The question is: are these setting used by sqlalchemy? There are
> other ways for passing these parameters?
> And most in particular: can this issue resolve my problem?
>
> Thank's in advance!
>
> --
> This email was Virus checked by Astaro Security Gateway. http://www.sophos.com
> _______________________________________________
> 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

--
Nigel Babu
Developer, Open Knowledge