[CKAN-support] Qld Gov CKAN site issue

[Nigel Babu]

It looks like their db server was unreachable for all the times that they
had downtimes.

Nigel Babu

Developer  |  @nigelbabu <https://twitter.com/nigelbabu>

The Open Knowledge Foundation <http://okfn.org/>

Empowering through Open Knowledge

http://okfn.org/  |  @okfn <http://twitter.com/OKFN>  |  OKF on
Facebook<https://www.facebook.com/OKFNetwork> |
Blog <http://blog.okfn.org/>  |  Newsletter<http://okfn.org/about/newsletter>

 CKAN | http://ckan.org/ | @CKANproject
<http://twitter.com/CKANproject> |the world’s leading open-source data
portal platform


On 28 May 2013 10:17, Gavin Chait <gavin.chait at okfn.org> wrote:

>  Hi, anyone able to review the error today?
>  ------------------------------
> From: Lawrence Howson <lawrence at xvt.com.au>
> Sent: ‎28/‎05/‎2013 03:03
> To: 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.
>
> _______________________________________________
> CKAN-support mailing list
> CKAN-support at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/ckan-support
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.okfn.org/mailman/private/ckan-support/attachments/20130528/5bb19341/attachment-0003.html>