Amir Tal wrote:
Adding unique key to the database results in the following being returned from rlm_sql,
What happen to accounting data when a duplicate entry is encountered?
It SHOULD run the normal query, followed by the "alt" query.
In addition, currently there is no scheduled clearing of the data in radacct table, wont this increase in occurrence?
Yes. Accounting is about storing data. If you want to delete data, it's one line of SQL.
[sql] Couldn't insert SQL accounting STOP record - Duplicate entry 'c6d3d253355b3dcf' for key 2 rlm_sql_mysql: MYSQL check_error: 1062 received rlm_sql_mysql: Cannot store result rlm_sql_mysql: MySQL error 'Duplicate entry 'c6d3d253355b3dcf' for key 2'
OK... it SHOULD run the "alt" query here, to UPDATE the record.
WARNING: Child is hung for request 5763411 in component <core> module <queue>. WARNING: Child is hung for request 5763412 in component <core> module <queue>.
And that's a problem. Your SQL database is slow. Fix it. Alan DeKok.