[asterisk-users] ODBC locks warning in CLI - Asterisk 188.8.131.52
viljoens at verishare.co.za
Thu Dec 1 02:39:05 CST 2016
Just to report back if it is of interest to anybody, I managed to solve
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 I am
and restarted the Percona instance.
This appears to have definitively removed the below warning from my Asterisk
Using READ-COMMITTED (instead of the default REPEATABLE-READ) transaction
isolation level apparently has optimised InnoDB table row locking (at least
in my use case, Percona / MySQL version and load) to such a degree that I no
longer see the warning below come up.
Everything is still reliably logging as far as I can determine, and all my
MySQL stored procedures which process my CDRs and CELs into useful form for
my dialing back-end are still working fine.
Just in case somebody can be helped by this.
>I get this warning in the Asterisk CLI about once every ten minutes or so:
>[Nov 23 14:47:36] WARNING: 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 transaction (105) [Nov >23 14:47:36] WARNING:
res_odbc.c:659 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying
connection to cdr [asterisk-cdr]...
>[Nov 23 14:47:36] WARNING: res_odbc.c:763 ast_odbc_sanity_check:
Connection is down attempting to reconnect...
>[Nov 23 14:47:36] NOTICE: res_odbc.c:1541 odbc_obj_connect:
Connecting cdr [Nov 23 14:47:36] NOTICE: res_odbc.c:1573
odbc_obj_connect: res_odbc: Connected to cdr [asterisk-cdr]
>Does this imply that I'm missing the ODBC CELs and / or CDRs that were
trying to write to MySQL over ODBC when the above occurred?
>Or will the ODBC module in Asterisk (or ODBC itself?) recover gracefully
and re-emit the CEL or CDR insert that hit the lock and were therefore NOT
written to MySQL?
More information about the asterisk-users