Deadlocks in Freeradius MySQL Database

[Claudio Carvalho]

Hi,

 
I am testing freeradius version 3 with RedHat Enterprise Server 7.4 and MySQL 5.6.35, even in a newly fresh/initialized database I get these messages in radius.log, has anyone else been through this situation yet?

what would be the best choice of operating system, database and freeradius version that recommend as more stable?

 
###############################################################################

 
ERROR: (1526654) sqlippool: ERROR: rlm_sql_mysql: ERROR 1213 (Deadlock found when trying to get lock; try restarting transaction): 40001

 
[root at rad-a-01 radius]# cat radius.log | wc -l

197357

 
[root at rad-a-01 radius]#  cat radius.log | grep Deadlock | wc -l

2468

 
[root at rad-a-01 radius]# rpm -qa | grep freeradius

freeradius-3.0.13-8.el7_4.x86_64

freeradius-mysql-3.0.13-8.el7_4.x86_64

freeradius-utils-3.0.13-8.el7_4.x86_64

freeradius-ldap-3.0.13-8.el7_4.x86_64

 
[root at rad-a-01 radius]# uname -a

Linux rad-a-01 3.10.0-693.5.2.el7.x86_64 #1 SMP Fri Oct 13 10:46:25 EDT 2017 x86_64 x86_64 x86_64 GNU/Linux

 
###############################################################################

Thanks,

Claudio.