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
_______________________________________________
radiator mailing list
radiator@open.com.au
http://www.open.com.au/mailman/listinfo/radiator
