[CKAN-support] Qld Gov CKAN site issue

[Gavin Chait]

Hi, anyone able to review the error today?

-----Original Message-----
From: "Lawrence Howson" <lawrence at xvt.com.au>
Sent: ‎28/‎05/‎2013 03:03
To: "support at ckan.org" <support at ckan.org>
Cc: "Gavin Chait" <gavin.chait at okfn.org>; "George Sattler" <George.sattler at xvt.com.au>
Subject: Qld Gov CKAN site issue

Hi, 


Just received this issue logged by Qld Gov (SSQ). Could you advise?


Thanks,


Lawrence


Our monitoring of the applications showed that they became unavailable 5 times yesterday (Monday 27/05/2013). 
We have the following times recorded for these outages: 
07:36 - 07:39 
14:54 - 14:56 
20:45 - 20:50 
22:29 - 22:32 
22:38 - 22:41
We suspect that there was network issues with the database server as: 
* the uptime on database server is 187 days 
* the log file (/var/log/apache2/ssq/epub.error.log) shows the following error 
==================== 
[Sun May 26 16:35:41 2013] [error] [client 127.0.0.1] Error - <class 'sqlalchemy.exc.OperationalError'>: (OperationalError) could no 
t connect to server: No route to host 
[Sun May 26 16:35:41 2013] [error] [client 127.0.0.1] \tIs the server running on host "dbserver" (10.181.10.23) and accepting 
[Sun May 26 16:35:41 2013] [error] [client 127.0.0.1] \tTCP/IP connections on port 5432? 
[Sun May 26 16:35:41 2013] [error] [client 127.0.0.1] None None 
[Sun May 26 16:35:44 2013] [error] [client 127.0.0.1] mod_wsgi (pid=22332): Exception occurred processing WSGI script '/var/lib/ckan 
/epub/wsgi.py'. 
.... 
====================
Can you please investigate



This email and any files transmitted with it is confidential and intended solely for the use of the addressee. The unauthorised use, dissemination, forwarding, printing or copying of this communication is strictly prohibited. If you have received this communication in error please notify us immediately by reply email and destroy this communication. Any views and opinions presented in this email are solely those of the author and do not necessarily represent the views of XVT Solutions. The recipient should check this email and any attachments for viruses. XVT Solutions accepts no liability for the content of this email, and any damage caused by any viruses that could potentially be transmitted through this email.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.okfn.org/mailman/private/ckan-support/attachments/20130528/c553b105/attachment-0001.html>