RES: Deadlocks in Freeradius MySQL Database

[Claudio Carvalho]

Hi AemNet,

I'm using InnoDB in MySQL. 

Even using postgresql occurred some deadlocks in my test (100K accounts loading and 6hs of accounting(600s interval)), In 296031 radius.log lines, again happened 37 occurrences, the value was small and it seems to me that it administered by freeradius himself and the ip allocation was not lost.

Sun Nov  5 12:08:21 2017 : ERROR: (4666465) sqlippool: ERROR: rlm_sql_postgresql: ERROR:  deadlock detected
Sun Nov  5 12:08:21 2017 : ERROR: (4666465) sqlippool: ERROR: rlm_sql_postgresql: DETAIL:  Process 5083 waits for ShareLock on transaction 15919788; blocked by process 5054.
Sun Nov  5 12:08:21 2017 : ERROR: (4666465) sqlippool: ERROR: rlm_sql_postgresql: Process 5054 waits for ShareLock on transaction 15919790; blocked by process 5083.
Sun Nov  5 12:08:21 2017 : ERROR: (4666465) sqlippool: ERROR: rlm_sql_postgresql: HINT:  See server log for query details.
Sun Nov  5 12:08:21 2017 : ERROR: (4666465) sqlippool: ERROR: rlm_sql_postgresql: CONTEXT:  while locking tuple (3309,126) in relation "radippool"

Best regards,

Claudio Carvalho

-----Mensagem original-----
De: Freeradius-Users [mailto:freeradius-users-bounces+claudio=nextdigitalservices.com.br at lists.freeradius.org] Em nome de AemNet
Enviada em: segunda-feira, 6 de novembro de 2017 05:46
Para: freeradius-users at lists.freeradius.org
Assunto: Re: Deadlocks in Freeradius MySQL Database

What engine are you using? InnoDB or MyISAM? You should use the first one.
As Alan said try also PostgreSQL. If I'm not wrong also MySQL with InnoDB should have row-level locks.

GB
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html