RES: Deadlocks in Freeradius MySQL Database

[Claudio Carvalho]

Thank you Alan for your tips,

in my tests I received a large number of this message, has anyone had this occurrence in your freeradius + Postgresql?

Sun Nov  5 19:05:26 2017 : Error: rlm_sql_postgresql: 22P02: INVALID TEXT REPRESENTATION

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


freeradius-3.0.13-8
Red Hat Enterprise 7.4
postgresql10-server-10.0-1PGDG

Claudio Carvalho

-----Mensagem original-----
De: Freeradius-Users [mailto:freeradius-users-bounces+claudio=nextdigitalservices.com.br at lists.freeradius.org] Em nome de Alan Buxey
Enviada em: segunda-feira, 6 de novembro de 2017 14:20
Para: FreeRadius users mailing list <freeradius-users at lists.freeradius.org>
Assunto: Re: Deadlocks in Freeradius MySQL Database

I may have some time to look into sqlippool performance...but in the meantime you may need to tweak your postgres configs to make the server more optimal.  there are several free tools that you can run against your PGSQL to see what can be tweaked (after the DB has been running for some hours and slammed by queries...get better results that way) eg pgtune
(http://pgfoundry.org/projects/pgtune/)
this will tweak your buffers, memory usage, cpu usage etc

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