This is a multi-part message in MIME format.
--------------010109010907070509040001
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Adding more logs doesn't give any more clue:<br>
(...)<br>
<br>
LOG: sentencia: EXECUTE <unnamed> [PREPARE:
COMMIT]<br>
LOG: sentencia: <BIND> <br>
LOG: sentencia: EXECUTE <unnamed> [PREPARE:
BEGIN]<br>
LOG: sentencia: <BIND> <br>
LOG: sentencia: EXECUTE <unnamed> [PREPARE: SELECT
* FROM
loctest.posicion, loctest.datosensor WHERE id_activo = $1 AND
posicion.idposicion = datosensor.idposicion AND idsensor = 2 ORDER BY
time DESC LIMIT 1]<br>
LOG: sentencia: <BIND> <br>
LOG: sentencia: EXECUTE <unnamed> [PREPARE: SELECT
* FROM
loctest.posicion, loctest.datosensor WHERE id_activo = $1 AND
posicion.idposicion = datosensor.idposicion AND idsensor = 2 ORDER BY
time DESC LIMIT 1]<br>
LOG: sentencia: <BIND> <br>
LOG: sentencia: EXECUTE <unnamed> [PREPARE: SELECT
* FROM
loctest.pois]<br>
LOG: sentencia: <BIND> <br>
LOG: sentencia: EXECUTE <unnamed> [PREPARE: SELECT
* FROM
loctest.pois]<br>
LOG: sentencia: <BIND> <br>
LOG: sentencia: EXECUTE <unnamed> [PREPARE: SELECT
current
FROM loctest.id_pos_seq_view]<br>
LOG: sentencia: <BIND> <br>
LOG: sentencia: EXECUTE <unnamed> [PREPARE: SELECT
current
FROM loctest.id_pos_seq_view]<br>
LOG: sentencia: <BIND> <br>
ERROR: message format invalid<br>
FATAL: message type of frontend 0 is not valid<br>
<br>
<br>
Besides this <unnamed> that appears on the sentences not much
more info is shown on the logs.<br>
Sometimes the number associated whith the fronted changes Sometimes
it's 0 sometimes it's 255..<br>
<br>
Regards<br>
<br>
Sergi Vera escribió:
<blockquote cite="mid:48030B0A.1070404@[EMAIL PROTECTED]
" type="cite"><br>
Thanks Craig,
<br>
<br>
Browsing the pgsql logs I've found the following error messages
(roughly translated to english):
<br>
<br>
(autovacuums)
<br>
....
<br>
(autovacuums)
<br>
ERROR: remaining data on the message is not sufficient
<br>
FATAL: message type from the frontend 0 is not valid
<br>
<br>
I just don't understand why sometimes it fails and sometimes not.
<br>
<br>
I will try the other suggestion you made as soon as possible
<br>
<br>
Craig Ringer escribió:
<br>
<blockquote type="cite">Sergi Vera wrote:
<br>
<br>
<blockquote type="cite">Everything is working ok and fast, but at
some moment (sometimes sooner,
<br>
sometimes later) the server starts to fail with the following messages
<br>
<br>
org.postgresql.util.PSQLException: invalid message format (for the
first
<br>
failure)
<br>
org.postgresql.util.PSQLException: A I/O error has happened while
<br>
sending to backend (at every following jdbc call)
<br>
</blockquote>
<br>
I suggest having a look in the server logs to see if there is any error
<br>
being re****ted by the backend.
<br>
<br>
You might also find it helpful to enable log_statement and
<br>
log_connection in postgresql.conf while you're trying to track the
issue
<br>
down. Your logs might get quite big if your load is high, though.
<br>
<br>
--
<br>
Craig Ringer
<br>
<br>
</blockquote>
<br>
<br>
</blockquote>
<br>
<br>
<div class="moz-signature">-- <br>
<meta http-equiv="CONTENT-TYPE" content="text/html; ">
<title></title>
<meta name="GENERATOR" content="OpenOffice.org 2.3 (Linux)">
<style type="text/css">
<!--
@[EMAIL PROTECTED]
{ size: 21cm 29.7cm; margin: 2cm }
P { margin-bottom: 0.21cm }
-->
</style><a
href="http://www.emovilia.com/">
<img src="cid:part1.00080804.01070300@[EMAIL PROTECTED]
" border="0"></a>
<p style="margin-bottom: 0cm;">Sergio Vera<br>
Rosellón, 34, 5 Planta<br>
08029 Barcelona<br>
tel. 902101870<br>
<a class="moz-txt-link-abbreviated"
href="http://www.emovilia.com">www.emovilia.com</a><br>
<br>
</p>
<p style="margin-bottom: 0cm;" lang="ca-ES"><font
style="font-size: 10pt;" face="Consolas, monospace" size="2">IMPRIME
ESTE EMAIL Y SUS ARCHIVOS SI REALMENTE LOS NECESITAS.<br>
GRACIAS **** RESPETAR EL MEDIO AMBIENTE.</font></p>
<p style="margin-bottom: 0cm;" lang="ca-ES"><font
face="Consolas, monospace"><font style="font-size: 10pt;" size="2">NOTA:
La información contenida en este email, y sus do***entos
adjuntos, es confidencial y para uso exclusivo de la persona o
personas a las que va dirigido. No está permitido el acceso a
este mensaje a otra persona distinta a los indicados. Si no es uno de
los destinatarios o ha recibido este mensaje **** error, cualquier
duplicación, reproducción, distribución, así
como cualquier uso de la información contenida o cualquiera
otra acción tomada en relación con el mismo, está
prohibida y puede ser ilegal.</font></font></p>
<p style="margin-bottom: 0cm;" lang="ca-ES"> </p>
<p style="margin-bottom: 0cm;" lang="ca-ES"> </p>
<p style="margin-bottom: 0cm;" lang="ca-ES"><font
face="Consolas, monospace"><font style="font-size: 10pt;"
size="2">ADVICE:
The information in this email as in the attachments is confidential
and private for exclusive use of the target user group. Access to
this message is disallowed to any other than the addressee. If you
are not the addressee or you have been included by mistake, any
duplication, reproduction, distribution as any other action relative
to this email is strictly forbidden and might be
illegal.</font></font></p>
</div>
</body>
</html>
--------------010109010907070509040001
Content-Type: image/png;
name="emovilia.png"
Content-Transfer-Encoding: base64
Content-ID: <part1.00080804.01070300@[EMAIL PROTECTED]
>
Content-Disposition: inline;
filename="emovilia.png"
iVBORw0KGgoAAAANSUhEUgAAAMgAAAAgCAYAAABXTzdxAAAAAXNSR0IArs4c6QAAAAZiS0dE
AAAAAAAA+UO7fwAAAAlwSFlzAAALEwAACxMBAJqcGAAAAAd0SU1FB9cMDgg3B+aweCoAAAAZ
dEVYdENvbW1lbnQAQ3JlYXRlZCB3aXRoIEdJTVBXgQ4XAAANbUlEQVR42u1cb2hbVRv/LV62
63Y12ZquESu92koiLSTSQCsTWlDsdIMVHGZusIpjlnbK1LHhOjI/hLWgc7Aisqopbq5av8wF
JrTghwSqtLjJApmm0rkEO5douty5TO/KtX0/3ZDcnHPuvVnrO983z7fce+695zzn+T1/fuec
rFhcXFxERSpiUMbHx3Hx4kXiPY/Hg46OjqJr0WgUY2NjxPa1tbXYsWNHyfULFy7g66+/Jj7j
crmwZcuWf2y83FK9SFEUJJNJxGIxJJNJSJKERCIBAHA4HHA4HGhpaUFLS0vFyv7FEolEEA6H
ifceeOCBkmvhcBihUIjYftOmTdRv0J659957/9Hx3hFAZFnGhQsXMD4+jvPnz0OSJGK7eDwO
ABgdHYXdbkd3dzc6OjrAcVzF4v5lojo9ktTV1ZVcSyaT1PaPPvoo8frMzIypb9yVAIlEIjh5
8mTe+I1KJpPBkSNHcOnSJfT29kIQhIrV/Q8AhOM4PPjggyXXU6mUKWPP5XLIZDLUZ0RRvLsB
kslkMDg4SM0RjcrZs2chyzL6+voqkeRfIqxosG7dOlRVVZWk3TRA8TwPh8NRcv3GjRvUTOSu
jCCyLCMajSKVSiGZTGJycpIZZs3I2NgYmpubqbloRe4uqampwfDwMPHeypUrYbVaDQPKZrPB
ZrOVXK+qqsLg4CDzubsKIIlEAm+88YbhF/I8D0EQkMvlIMuybvtgMIgNGzb84wMnkQxzc3PI
ZrP5a/fddx8xbVAdRzqdxl9//QUAsFgscDgcuP/++8uu5+bm5nDz5s2i69XV1bBarXdFlOV5
Hi6Xy3B7Vi1ht9tLAFXON7Q6nJ6eRjKZxLVr1wAADz30EJxOJ+rr64vSuNu3b5c8v2rVqpKU
n1tK5XV2dmLLli0QBAGSJOGLL77AuXPnmM+lUilEIpFlo+7UWokke/fuRWNjY541mZmZKQrv
giDA4/Fg7969eaDIsoxQKIRQKIRUKpV3AipAnnvuOezcudOwQUej0Tx1mslkkMvlSgzJ4XCg
ra0NGzduLEljVFH7RPO6x44dM60fURRx+PDh/O8PP/wQk5OTxLY+n6+E4mVFEFotcfLkSUQi
EeK9trY2dHV1Ee999tlnGBsbI4KS53m0t7fjlVdegcPhwODgIHEcHR0d2LNnjzmAiKKIV199
Fe+//z49DHEcBgYGiijcqqoq9PX1IZfLUWnBwsldLoDE43EikWCxWDA/P48DBw5QJz2Xy2Fi
YgIzMzM4deoU0uk0/H4/McVcWFjAr7/+io8//hiZTAYHDhzQzeePHz9O/XZhzZfJZBCLxTAy
MgK/34+WlhZYLJaidg6Hg0mYKIpSAlpFUTA0NEQcD8dx2LVrV9H4vv32W/z0009UB2mG8Sr0
6IUyNTVFHUdnZ2fJNUmScPjwYZw/f54ZWcbGxjA5OYlAIIB4PE4kAkiEkcVIZKAtDKnS3t5O
Xd/o6uoiKk9rxKzCbDkKS47jcOTIEV0DVaNcf38/XnvtNUP119mzZzE9PU29PzU1hZ6eHkPf
1hrDwYMHMTU1RXRkrDSVpIdIJEIdj3ZO9YpnbURQFAWzs7PU9qQCXQ9U2gJdlmVdcGj15/f7
qf0iRTVdgFy9elUXILQiW5IkyLJsqL5gGdRy0JLz8/P47bffDL8nHA6bAjFNZ+Pj49i/f3/Z
DmF+fh6BQKCkvqupqWFSoFqj+PPPP/Hpp59SneKuXbuKIs7c3ByuX79u2Hiz2SyzPamvLBAK
ggC73V4EwP7+fsPg0NokKaMgLXTqplixWKwkL9Z6YjUvVhmvaDSKeDyORCLB5MG1UWQ5VtmX
inFbisiVTCbx3nvvQVEUpuHwPM9MlyRJQigUgs/nK7ru8XiowNQa3jfffEMton0+X4nBX716
ldpvkrFns1nTdC1rrmw2W1FRH41GdVN39Tkjzshms2Ht2rX6ABkaGoIkSZienoYkSboGznEc
RkZGMD09fUfGeOvWrSU3Ur2oxHEcnn76abjdbnz33XcIh8NYWFigthcEAZs3b0ZdXR2++uor
xGIxU57/3XffpTobURSxb98+NDc3AwAuX76M/fv3U/UfiURKAOJ2uw3r4ssvvySOVRTFkveW
U3BfuXKFqksaS6XHehXWCMFgkApYQRCwb98+tLW1ged5yLKM0dFRfPLJJ5ifnyc+s27dOmMA
oTEarAJofHzctPHabDZ4PB44nU54PB5q0aYagxEvUFdXB4/HYzh6dHd35zfLPfvss0ilUvjh
hx+oacfbb7+NDRs2AAC8Xi92795N7ZfWQ0ajUap353kegUCgSAf19fXYtGkTgsEgtXjP5XJF
RsMCSCHQWH3p6uoipsRmt5iYbW8GhOl0mtp/QRAQCASKshGe57Fz5848E0eS2tpaIvPIkRoK
ggBRFFFXV4epqSndGkRP1PzR5XKhpaUFLpfL8IqooigIBoNM76LK66+/XgQQlsJdLheef/75
/O+VK1di/fr1VIC0t7fnwaHm/Ha7nQoQbRFK89gqO0NyEE8++SQVILIs4/bt20UA4XmemmZl
Mpm8x6W90+v1llC1Rrw7KYKUQ/GyvuF0OnXrO1WXpFTdYrFg27ZtGB4eJkYeWp9KADI8PFyk
9FQqVRZACqNDQ0MDqqqqdNkskuixJyzPxPJira2tRf3RY13a2tpM9UurcBZjpX13IQhY7OKq
VatKrrvdbuJ8SZKEGzduIJFIEO/zPI/u7u6yajmzEYRkjGb2YLFSZxrA1TGKokgEYk1NjTGA
aLlgIwyU6rncbnceGCQwyLKMmzdvIpvNIpvNIp1O48cff0Q6nUZTUxNefvnlkmd+//13puIK
+1DotdV1CSMeqRzWhdUvjuOKjCaZTFKN3W63o7a21rRHtdlsRN7e4/EQ02RJkpDNZqm5+9at
W9HY2EhNfWj5vt1uR3V1dUnUN7up8datW0wyqFCfLMfBStXVSGqmLjK0UGhE+vv7qRFCkiT0
9fVBkiT88ccfkCSpJN0gHZzRC9VagykEs1kPb5Z1MZNCsCZUEASsWbPGNMlAm1B1PUQ7FkVR
8P333xOjh81mIxbm5bBLerqhsUUs/dP2bdGiLs0O1XNKZuoiTmvImUwGly9fRjweRzKZNLSd
XZZlnDlzBtu3byeyN0ePHmWmaV6vN8/ekDxLIf/NMsrCiWLx9loPXw7rwjKahoYGwymkoihE
75xOp8tKy9T1EJK+T5w4QczNe3p6qFtY9MZKKm712CjSt2gr9GactErokNKshYUFfP7559R6
kQYqLpPJ4NSpU4jFYnmAsHh6mpw+fRo1NTV46qmnigB39OhRJl/NcRw1egDAM888QzWGQrnn
nnuKfpvl7ZfyIJCZCVV3SWvTm2AwSE0HRFFkMla0Qp0UyZqamorm7E7YpTvRzZUrVwzrn1XL
BoNBNDU1laRxoVCIevSXtqoPANz169dx5syZIu9ZyDo5nU78/fffzL1YKhj8fj9GRkbgdDrz
K/B6YHvppZeYC4SCIJR1qIo1SSQPz1rvuVNAqTUZyUAVRYHf78fAwECeFWNt8lT3SLE2Q7LA
o31XT08PVq9eTW2zsLCAn3/++b9K8T722GMl4xsdHSW2nZ2dxe7du+Hz+SCKIubm5jA5OYmJ
iYmy6hZu7dq1EEUR69evz7NOtbW1RayToig4d+6coYVA2uZAGpOk8tNLLWZZFLNez2wR2tnZ
SZ3UVCqFnp4eQ8cEOjs7dSOqUYC0t7frtl3qPVi0CGIGVB6Ph+pwVGc9NDRk2FYefvhhOkCq
q6tx+vRpXU9z6NChO9pDpH2fz+dDd3f3sp1zMHuumQZqksGzimfSyToA2L59O8LhMDVSybLM
BIbFYoHX60Vvb6+uzljrIYWFb29vr64e9fZg3SkbqI6dphftHiwAsFqt2Lp1q67dGhVWBLEY
fUljYyMCgUBZaxlaBQ0MDGDPnj3LegiI5ZG0nLdZ1sUsq6MWp4cOHSpbf9u2bWMyhWajiM/n
Y+be5dZy5ezBYumflmK/8MILpmo9Wlue54nzpUvzKoqCdDqN2dlZxOPx/AZEI6cEScah/mdS
4Wr0colZ3p5l8CTWhVWvPPLIIyVnNVRpbm7GRx99hOPHjxuqzziOg9frxY4dO6gsH6tQZx2E
YtG6WjbNjNFdu3bN9B4sVkpOO3lot9tx7NgxvPnmm8z5W716NTZv3ozHH38cBw8eJDo0FoXM
FQIimUzi4sWLmJ6eRjweRyqVYi7esEK8WuC3traivr7eEFW7VMLzPPUAFknhVquV2p40qQ6H
g9q+tbVVN5y/8847uHTpEiYmJhCNRiHLMhKJRH6l12azwe12w+v1wul0lhVpnU4nfD4f0aFt
3LjRcCRi6aZwW0+hwZnRpd4zTU1N1L45HA588MEHRSc8C22gtbUVL774IhobG/HLL7/grbfe
Io6PBZAVJ06cWDQSHdRcUBRFOJ1OiKIIl8sFq9VaFCJtNht12b4iFVlOSafTkCQJPM8v2b+f
rHjiiScWaeGzEAhaZqsiFfl/EM7lckFRFDQ0NMDpdOZTowoQKlIRYIUkSYtr1qyp/HlbRSpC
Akjl390rUhG6WCoqqEhF6PIfdzv7pNF9zv0AAAAASUVORK5CYII=
--------------010109010907070509040001--
|
