sql returns fail for some stop requests

Alan DeKok aland at deployingradius.com
Sun Jul 22 21:27:45 CEST 2012

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.

More information about the Freeradius-Users mailing list