(RADIATOR) Problems with SessionDatabase SQL

[Francisco Rodrigo Cortinas Maseda]

Hi everybody,
 
i have one question to the list, not very simple:
 
investigating a performance problem on the SQL database that is running
the session database for radiator, we have seen the following sql
statements:
 
080318 16:08:47       2 Query       delete from RADONLINE where
NASIDENTIFIER='XX.XX.XX.XX' and ACCTSESSIONID=''
 
this query is repeating hundres per hour. We have confirmed that all the
packets have the Acct-Session-ID on the request.
 
I have Radiator 3.8 on Linux, with Perl 5.8.3. My config for the SQL
session database is:
 
<SessionDatabase SQL>
        AddQuery                insert into RADONLINE (USERNAME,
NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIMESTAMP, FRAMEDIPADDRESS,
PORTLIMIT, REALM) values ('%n', '%N', '%{NAS-Port}',
'%{Acct-Session-Id}', %{Timestamp}, '%{Framed-IP-Address}',
'%{Port-Limit}', '%R')
        ClearNasQuery           delete from RADONLINE where
NASIDENTIFIER='%N'
        CountQuery              select NASIDENTIFIER, NASPORT,
ACCTSESSIONID from RADONLINE where USERNAME='%n'
        DeleteQuery            delete from RADONLINE where
NASIDENTIFIER='%N' and ACCTSESSIONID='%{Acct-Session-Id}'
        DBSource                dbi:mysql:auth:192.168.116.102:3306
        DBSource                dbi:mysql:auth:192.168.116.105:3306
        DBUsername              auth
        DBAuth                  auth2134
        FailureBackoffTime      10
        Timeout                 30
        Identifier              SDB1
</SessionDatabase>
 
Anybody knows why is it happening?
 
Thanks all.

Antes de imprimir este e-mail piense bien si es necesario hacerlo.

*********
Este mensaje es privado y CONFIDENCIAL y se dirige exclusivamente a su destinatario. Si usted ha recibido este mensaje por error, no debe revelar, copiar, distribuir o usarlo en ningun sentido. Le rogamos lo comunique al remitente y borre dicho mensaje y cualquier documento adjunto que pudiera contener. El correo electronico via Internet no permite asegurar la confidencialidad de los mensajes que se transmiten ni su integridad o correcta recepcion. JAZZTEL no asume responsabilidad por estas circunstancias. Si el destinatario de este mensaje no consintiera la utilizacion del correo electronico via Internet y la grabacion de los mensajes, rogamos lo ponga en nuestro conocimiento de forma inmediata.Cualquier opinion expresada en este mensaje pertenece unicamente al autor remitente, y no representa necesariamente la opinion de JAZZTEL, a no ser que expresamente se diga y el remitente este autorizado para hacerlo.
*********
This message is private and CONFIDENTIAL and it is intended exclusively for its addressee. If you receive this message in error, you should not disclose, copy, distribute this e-mail or use it in any other way. Please inform the sender and delete the message and attachments from your system.Internet e-mail neither guarantees the confidentiality nor the integrity or proper receipt of the messages sent. JAZZTEL does not assume any liability for those circumstances. If the addressee of this message does not consent to the use of Internet e-mail and message recording, please notify us immediately.Any views or opinions contained in this message are solely those of the author, and do not necessarily represent those of JAZZTEL, unless otherwise specifically stated and the sender is authorised to do so. 
*********

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20080318/3f0faa59/attachment.html>