Thank you Alan, I was running a test with 100K users and I did not realize the occurrence, only after the end of the test during the deep analysis of the logs, yes, I am using postgresql queries, next night I will run a new test and in this test the debug will be active . freeradius-3.0.13-8.el7_4.x86_64 freeradius-postgresql-3.0.13-8.el7_4.x86_64 Regards, Claudio -----Mensagem original----- De: Freeradius-Users [mailto:freeradius-users-bounces+claudio=nextdigitalservices.com.br@lists.freeradius.org] Em nome de Alan DeKok Enviada em: segunda-feira, 6 de novembro de 2017 15:01 Para: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Assunto: Re: RES: Deadlocks in Freeradius MySQL Database On Nov 6, 2017, at 11:54 AM, Claudio Carvalho <claudio@nextdigitalservices.com.br> wrote:
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
I haven't seen that before. Are you sure you're using the postgresql queries? And... as always, run it in debug mode to see what's going on. That should be your FIRST step. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html