12 Mar
2020
12 Mar
'20
12:53 p.m.
On 12.03.20 09:09, Juha Heinanen wrote:
Daniel-Constantin Mierla writes:
Accounting records are
inserted without problems from other calls to the
same accounting table where the timer process tries to insert its
record but hangs.
Try to install debugging symbols for libmariadb and maybe there will be
more hints in the backtace of what it does internally, which can improve
troubleshooting by searching on the web for similar cases.
And, as I said in previous email, try to investigate the status of mysql
server with specific commands and tools, if you can find any out there.
DB access
works fine from K worker processes during the time when
insert is stuck in timer process.
Are new records inserted in acc table? I think
there are some
tools/commands for mysql to inspect the state a database table, check
acc table and missed_calls, if you also use this one. From mysql client API, we set the query timeout
options.
Otherwise, I haven't encountered such a situation yet to have any other
hint to share specific for it.
Maybe you can try to use IP sockets for connecting to mysql server, if
the connection is done over unixsocket file. In some older versions, it
was mentioned that timeout options may not work if not on an IP connection.
What you can also try, is to change the database table type. What do you
have now, MyISAM, InnoDB or something else?
To know better the ecosystem, what is the operation system and
mysq/mariadb versions?
Cheers,
Daniel
--
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio World Conference - April 27-29, 2020, in Berlin -- www.kamailioworld.com