[ckan-dev] Apache2 Dropping Session to Postgresql (Internal Service Error)

Thu Nov 6 16:44:34 UTC 2014

Hi,

The logs posted into a pastebin.com <http://pastebin.com/> would be very useful.  

[Random question]
Is the Postgres server on a different box to the Apache server? In the past I’ve had trouble with that setup when there’s a router of some description in between them .. the DB connections don’t stay alive.  Using pgbouncer helps in that case.

Ross

> On 6 Nov 2014, at 16:41, H. Michael LaFrance <hmlafrance at gmail.com> wrote:
> 
> Hello,
> 
> This is my first post so hopefully I am doing this right. I am new to Apache and Postgresql and I am trying to figure out why our CKAN site randomly drops connection to Postgresql DB server causing CKAN to return "Internal Service Error". I will post a log entries if needed, thanks.
> 
> Server OS: Ubuntu v12.04.5 LTS Web Server & v14.04.1 LTS Database Server
> Apache2: v2.2.22
> Postgresql: v9.3
> CKAN: v2.2
> _______________________________________________
> 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/20141106/d92e399f/attachment-0003.html>