No subject

Sun Mar 31 09:34:23 UTC 2013

network issue, which I initially suspected but I am unable to find
anything, or an issue around the postgres connection being terminated
without closing the connection properly from the client, in this case ckan.
I have only seen this when working on the datastore.

Have anyone else experienced errors in connections to postgres from ckan?

-- 
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.

--e89a8f3b9db1f24e8104de28c138
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi all,<div><br></div><div>I currently have a CKAN 2.0 fro=
m package install up and running with the datastore working. Everything is =
working fine except one odd error.</div><div><br></div><div>When I make cha=
nges to datasets and datastore resources via the API it affects the postgre=
s - ckan connection. I am getting these errors from time to time:</div>
<div><br></div><div><div>2013-06-02 11:25:06 CEST LOG: =A0could not receive=
 data from client: Connection reset by peer</div><div>2013-06-02 11:25:06 C=
EST LOG: =A0unexpected EOF on client connection</div><div><br></div><div st=
yle>
I have a two-proxy setup due to university firewall and the VB server. The=
=A0outer apache log shows a timeout to the inner apache/CKAN server. The er=
ror is only logged in the postgres=A0logs at the &#39;inner&#39; server.</d=
iv>
<div style><br></div><div style>From investigating (google) the error on po=
stgres, it can either be a network issue, which I initially suspected but I=
 am unable to find anything, or an issue around the postgres connection bei=
ng terminated without closing the connection properly from the client, in t=
his case ckan. I have only seen this when working on the datastore.=A0</div=
>
<div style><br></div><div style>Have anyone else experienced errors in conn=
ections to postgres from ckan?</div><div><br></div>-- <br><div dir=3D"ltr">=
<div>Med venlig hilsen -=A0Best regards,</div><div><br></div><b>Henrik Kors=
gaard</b><div>
<div><div><font color=3D"#666666">Phone: +45 22377114</font></div><div><fon=
t color=3D"#666666">Office: CAVI 114b, Aarhus University</font></div></div>=
</div><div><font color=3D"#444444"><br></font></div><div><font color=3D"#44=
4444">NB. I am slowly migrating my=A0university=A0related=A0correspondence =
to my official AU mail: <a href=3D"mailto:korsgaard at cavi.au.dk" target=3D"_=
blank">korsgaard at cavi.au.dk</a> - feel free to contact me at that address i=
f relevant.</font></div>
</div>
</div></div>

--e89a8f3b9db1f24e8104de28c138--