[RADIATOR] Howto investigate a "dropped connection" problem with Radiator and Postgres on a local connection?

[Eike Lohmann]

Hi,

we have a problem between radiator 4.9 and postgresql 9.1 on many machines and 
have had this problem with Radiator 4.7, 4.8 and postgressql 8.3, 8.4.
The Problem occurs from 100k Session at a rate of less ~1% while an update or 
insert statement from Radiator, the connection is local!

Logfile Radiator with SSL:
"Wed Feb 22 09:43:45 2012: ERR: Execute failed for 'select 
d.DEVICELOGINPASSWORD, d.DEVICEIP from device d where d.DEVICELOGINNAME = 'xy' 
and d.DEVICEENABLED = 'Y'': SSL-Error: sslv3 alert bad record mac"

Logfile Postgres with SSL:
2012-02-22 09:37:09 CET LOG: 08P01: SSL-Fehler: decryption failed or bad record mac
2012-02-22 09:37:09 CET ORT: secure_read, be-secure.c:277
2012-02-22 09:37:09 CET LOG: 08006: konnte Daten vom Client nicht empfangen: Die 
Verbindung wurde vom Kommunikationspartner zurückgesetzt(no data from client, 
connection was reset)
2012-02-22 09:37:09 CET ORT: pq_recvbuf, pqcomm.c:769
2012-02-22 09:37:09 CET LOG: 08P01: unerwartetes EOF auf 
Client-Verbindung(unexpected EOF from client)
2012-02-22 09:37:09 CET ORT: SocketBackend, postgres.c:332


After debugging this problem we changed the connection method from IP to Socket 
without ssl and get the same problem but now without a ssl error message.
Logfile Radiator Soket:
"Wed Feb 22 11:24:46 2012: ERR:|server closed the connection unexpectedly This 
probably means the server terminated abnormally before orwhileprocessing the 
request.|"

Logfile Postgres Soket:
2012-02-22 11:24:46 CET LOG: 00000: Verbindung empfangen: Host=[local](incomming 
connection)
2012-02-22 11:24:46 CET ORT: BackendInitialize, postmaster.c:3279
2012-02-22 11:24:46 CET LOG: 00000: Verbindung authorisiert: Benutzer=radius 
Datenbank=radius (connection authorized)
2012-02-22 11:24:46 CET ORT: BackendInitialize, postmaster.c:3357
2012-02-22 11:24:46 CET LOG: 00000: Dauer: 2.930 ms (duration)

Sorry for the old and german logentries, but maybe you have some ideas how to 
investigate this problem with more details.

Thanks, Eike




-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.open.com.au/pipermail/radiator/attachments/20131018/edc3f423/attachment.html