Freeradius - DeadLock

[Fajar A. Nugraha]

On Thu, Sep 26, 2013 at 4:14 AM, Alisson <alissongoncalves at bsd.com.br>wrote:

> So this error its caused by my application?
>
>
Whatever it is that creates queries to mysql.

In the default schema, radacct will continue to grow. If you're running it
on a production system with significant amount of user on a commodity
hardware, you need to find some way to maintain the table in a reasonable
size. For example, 10 million rows of radacct on a single-disk PC clearly
spells trouble.

The quickest way to "fix" that is by:
- create a new table with same structure: CREATE TABLE ... LIKE ... , see
mysql reference guide for details
- rename radacct to something else, and rename the new table to radacct

That way you'd get an empty radacct, but with old data still available to
examine. For example, you might want to copy current month's acct data (for
billing purposes) back.

After that, get a qualified DBA to help you manage your database
performance.

-- 
Fajar



>
> 2013/9/25 Arran Cudbard-Bell <a.cudbardb at freeradius.org>
>
>>
>> On 25 Sep 2013, at 20:54, Alisson <alissongoncalves at bsd.com.br> wrote:
>>
>> > This messages are from radius.log
>>
>> Those errors were generated by the MySQL client library or the MySQL
>> server, just because they're included in the radius.log file does not mean
>> they originated from within the FreeRADIUS code base.
>>
>> > I've doesn't changed anything in db... and I haven't custom queries...
>>
>> Here is a post describing possible causes.  I've never seen this with the
>> stock queries and schema.
>>
>>
>> http://stackoverflow.com/questions/2332768/how-to-avoid-mysql-deadlock-found-when-trying-to-get-lock-try-restarting-trans
>>
>> Arran Cudbard-Bell <a.cudbardb at freeradius.org>
>> FreeRADIUS Development Team
>>
>> -
>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>>
>
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20130926/50ab0d87/attachment.html>