Re: [Help-gnu-radius] mysql accounting entries sent out-of-order

[Sergey Poznyakoff]

> The account detail file in /var/log/radacct/*/detail also shows the Start 
> entry then the corresponding Stop entry.
> 
> But, the sql log /var/log/radacct/sql.log shows the SQL statement for the 
> STOP coming first:

Yes, it is possible when both start and stop requests are received
simultaneously. Each request is served by a separate process which
feeds it to SQL server. If the SQL server handles UPDATE request
faster than INSERT, it may finish the former before the latter.

If you use MySQL >= 3.23.36, you can work around this problem, by
replacing UPDATE statements with REPLACE in your raddb/sqlserver.

> I guess this would count as a bug?

Rather as a race condition.

Regards,
Sergey