duplicated query insert doing accounting
Hi guys , Im trying to tune my accounting server. Everything is working good so far. On strange thing is the following line when debuging. rlm_sql_mysql: MYSQL check_error: 1062 received rlm_sql (sql): Duplicate entry '915bec9642b89feb789b9566b7ec6e9b' for key 'acctuniqueid' rlm_sql_mysql: MYSQL check_error: 1062 received rlm_sql_mysql: Cannot store result rlm_sql_mysql: MySQL error 'Duplicate entry '915bec9642b89feb789b9566b7ec6e9b' for key 'acctuniqueid'' Why is there a second attempt to insert a register ? On the client side I did: radclient -f accounting_packet 172.20.4.208 acct xxxxxxx and checked that there is only one accounting request going to the server. Regards, Leandro
On Apr 28, 2017, at 5:09 PM, Leandro <ingrogger@gmail.com> wrote:
Hi guys , Im trying to tune my accounting server. Everything is working good so far. On strange thing is the following line when debuging.
rlm_sql_mysql: MYSQL check_error: 1062 received rlm_sql (sql): Duplicate entry '915bec9642b89feb789b9566b7ec6e9b' for key 'acctuniqueid' rlm_sql_mysql: MYSQL check_error: 1062 received rlm_sql_mysql: Cannot store result rlm_sql_mysql: MySQL error 'Duplicate entry '915bec9642b89feb789b9566b7ec6e9b' for key 'acctuniqueid''
Why is there a second attempt to insert a register ?
Because there may already be a row for that accounting session. The server tries to INSERT, and then if that fails, UPDATE. This is all documented in the SQL config files. See raddb/mods-config/sql/mysql/queries.conf Alan DeKok.
participants (2)
-
Alan DeKok -
Leandro