[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Help-gnu-radius] mysql accounting entries sent out-of-order
From: |
Sergey Poznyakoff |
Subject: |
Re: [Help-gnu-radius] mysql accounting entries sent out-of-order |
Date: |
Thu, 17 Jan 2002 18:47:49 +0200 |
> 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