RES: RES: Deadlocks in Freeradius MySQL Database

[Claudio Carvalho]

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 at 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 at lists.freeradius.org>
Assunto: Re: RES: Deadlocks in Freeradius MySQL Database

On Nov 6, 2017, at 11:54 AM, Claudio Carvalho <claudio at 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