Hi all
Just to report back if it is of interest to anybody, I managed to solve
this.
Had nothing to do with Asterisk, rather with Percona 5.6 / MySQL which is
the database used via ODBC from Asterisk to store CELs and CDRs.
I added the following in the /etc/my.cnf file for the Percona instance
It might be worth pointing out that 1.8x was released 6 years ago,
went into security fix only over 2 years ago, and reached "end of
life/no further fixes" over a year ago.
11.x went into "security fix only" last month - 13 and 14 are the
current versions - can you try with them?
On 23 November
Hi all
I get this warning in the Asterisk CLI about once every ten minutes or so:
[Nov 23 14:47:36] WARNING[2544]: res_odbc.c:647
ast_odbc_prepare_and_execute: SQL Execute returned an error -1: HY000:
[MySQL][ODBC 5.1 Driver][mysqld-5.1.73]Deadlock found when trying to get
lock; try restarting