[asterisk-bugs] [JIRA] (ASTERISK-26633) SQL Execute returned "Deadlock found when trying to get lock; try restarting transaction"

[Rusty Newton (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-26633?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rusty Newton updated ASTERISK-26633:
------------------------------------

    Description: 
Hello,

If i settings my queues to "ringall" and receive many calls i start to had this message from mysql 
{noformat}
[2016-11-30 15:50:26] WARNING[12027][C-00001731] res_odbc.c: SQL Execute returned an error: HY000: [MySQL][ODBC 5.1 Driver][mysqld-5.5.52-0+deb8u1-log]Deadlock found when trying to get lock; try restarting transaction
[2016-11-30 15:50:26] WARNING[12027][C-00001731] res_odbc.c: SQL Execute error -1!
{noformat}
I attached a log where this only happens when a agent not answer a call and the app write in the queue_log RINGNOANSWER

Sorry my english

Thanks

  was:
Hello,

If i settings my queues to "ringall" and receive many calls i start to had this message from mysql 

[2016-11-30 15:50:26] WARNING[12027][C-00001731] res_odbc.c: SQL Execute returned an error: HY000: [MySQL][ODBC 5.1 Driver][mysqld-5.5.52-0+deb8u1-log]Deadlock found when trying to get lock; try restarting transaction
[2016-11-30 15:50:26] WARNING[12027][C-00001731] res_odbc.c: SQL Execute error -1!

I attached a log where this only happens when a agent not answer a call and the app write in the queue_log RINGNOANSWER

Sorry my english

Thanks


> SQL Execute returned "Deadlock found when trying to get lock; try restarting transaction"
> -----------------------------------------------------------------------------------------
>
>                 Key: ASTERISK-26633
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-26633
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Resources/res_odbc
>    Affects Versions: 13.13.0
>         Environment: Debian 8 64 bits + Mysql
>            Reporter: wushumasters
>         Attachments: sqlerror.log
>
>
> Hello,
> If i settings my queues to "ringall" and receive many calls i start to had this message from mysql 
> {noformat}
> [2016-11-30 15:50:26] WARNING[12027][C-00001731] res_odbc.c: SQL Execute returned an error: HY000: [MySQL][ODBC 5.1 Driver][mysqld-5.5.52-0+deb8u1-log]Deadlock found when trying to get lock; try restarting transaction
> [2016-11-30 15:50:26] WARNING[12027][C-00001731] res_odbc.c: SQL Execute error -1!
> {noformat}
> I attached a log where this only happens when a agent not answer a call and the app write in the queue_log RINGNOANSWER
> Sorry my english
> Thanks



--
This message was sent by Atlassian JIRA
(v6.2#6252)