[ckan-dev] Initial server error on query - fixed on refresh

[Dominik Moritz]

Hi,

Thanks for reporting the issue and providing the logs. I created an issue at https://github.com/okfn/ckan/issues/907 and will look into it soon.

I have heard of this problem before but could not reproduce it and didn't have any logs. So again, thank you. 

Best wishes,
Dominik

On 17 May 2013, at 10:23, Henrik Korsgaard <henrikkorsgaard at gmail.com> wrote:

> Hi all,
> 
> I have an annoying server error when making a query to
> 
> http://ckan.projects.cavi.dk/api/3/action/datastore_search?resource_id=_table_metadata
> 
> The initial query returns a server error, but a few refreshes will make the
> server respond with a correct return.
> 
> Logs: http://pastebin.com/796AhAPd
> 
> I suspect it is something with the database connection timing out or being
> closed. Have anyone else experienced this?
> 
> Where should I force the system to keep the database connection alive? In
> CKAN, sqlalchemy or in postgresql conf?
> 
> -- 
> Med venlig hilsen - Best regards,
> 
> *Henrik Korsgaard*
> Phone: +45 22377114
> Office: CAVI 114b, Aarhus University
> 
> NB. I am slowly migrating my university related correspondence to my
> official AU mail: korsgaard at cavi.au.dk - feel free to contact me at that
> address if relevant.
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: http://lists.okfn.org/mailman/options/ckan-dev

Dominik Moritz
CKAN developer  |  skype: d.moritz  |  @doobly_doo
The Open Knowledge Foundation
Empowering through Open Knowledge
http://okfn.org/  |  @okfn  |  http://ckan.org  |  @CKANproject