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

[Eike Lohmann]

Hi Heikki,

we use <AuthBy SQL> one for authentication and another <AuthBy SQL> for 
accounting, a never used <AuthBy File> and some <AuthBy Group>'s.
Is this our Problem?

Do you know the default value of "InactiveDestroy" we don't set it in our 
postgres config files.

Never seen a retry from Radiator and we have missing START, ALIVE and STOP 
Accounting Records in ~1% from 100.000.

Thanks for your help.




Am 21.10.2013 21:11, schrieb Heikki Vatiainen:
> On 10/18/2013 04:15 PM, Eike Lohmann wrote:
>
>> 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!
> Hello Eike,
>
> I'd think this is not a SSL problem since you see it with non-SSL
> connections too. Also, since you are using a local connection, the
> networking problems should not be the cause.
>
> Do you use fork? Please see this link to Pg module documentation which
> mentions the error message you see:
> http://search.cpan.org/~turnstep/DBD-Pg/Pg.pm#InactiveDestroy_%28boolean%29
>
> Do you for example, fork for some slow AuthBys?
>
> The postgresql log entry you have quoted below might be from the retry
> Radiator does. If execute fails, it will retry and the PostgreSQL log
> entry might be from the retry, not from the failed initial execute.
>
> Retrying execute should also mean that even if you do get the error, the
> query will succeed with the retry.
>
> Thanks,
> Heikki
>
>> 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 at open.com.au
>> http://www.open.com.au/mailman/listinfo/radiator
>>
>