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.