some mysql errors

[Arran Cudbard-Bell]

On 20 Aug 2012, at 16:33, Tony Peña <emperor.cu at gmail.com> wrote:

> Hi...
> 
> i'm getting some many errors like this...
> 
> 
> Mon Aug 20 11:27:26 2012 : Error: [sql] Couldn't update SQL accounting STOP record - Lock wait timeout exceeded; try restarting transaction
> Mon Aug 20 11:27:26 2012 : Error: rlm_sql_mysql: Cannot store result
> Mon Aug 20 11:27:26 2012 : Error: rlm_sql_mysql: MySQL error 'Lock wait timeout exceeded; try restarting transaction'
> 
> and other lines with Logins OK... but have more errors sql than logins ok...
> 
> i guess missing some tunning parameters... 
> i have, 15 NAS vs 2 freeradius-servers ..... this do AA vs 2 LDAP balanced and A vs cluster-mysql
> can help me more less to up or down some numbers to tune efficient the requests about some experience ?

Are the queries wrapped in the transaction taking a long time to complete? Have you enabled the slow query log? Is there a firewall in between the RADIUS servers and the cluster that could be ungracefuly terminating your TCP connections?

-Arran