duplicated query insert doing accounting

[Alan DeKok]

On Apr 28, 2017, at 5:09 PM, Leandro <ingrogger at 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.