Calls fails when we see this error “SQL Execute returned an error”

VitalPBX Community Support Reporting an Issue Calls fails when we see this error “SQL Execute returned an error”

  • Post
    yazarlwin
    Participant
    We are having call drop issue when we see  this error in log. It’s happening the whole day.

    73:Apr 23 10:17:01 vpbx1 asterisk: [Apr 23 10:17:01] #033[1;31mWARNING#033[0m[84912]: #033[1;37mres_odbc.c#033[0m:#033[1;37m538#033[0m #033[1;37mast_odbc_print_errors#033[0m: SQL Execute returned an error: HY000: [ma-3.0.7][10.4.13-MariaDB-log]Lock wait timeout exceeded; try restarting transaction

    Our call center is running with high load the whole day. Over 200 concurrent session in SIPGW and more than 100 waiting user in PBX the whole day.

    During this error time, we found below in in Mysql.

    Every 5.0s: mysql -e ‘show open tables where in_use>0;’ Fri Apr 23 10:34:28 2021

    Database Table In_use Name_locked
    ombutel ombu_cdr_query_results 1 0
    asterisk cdr 2 0

    Can you please help us how to solve or avoid it?

    As of now we increased innodb lock wait timeout from 50 to 100 to mitigate the issue.

     

     

     

    Attachments:
    You must be logged in to view attached files.
    0
Viewing 5 replies - 1 through 5 (of 5 total)
  • Replies
    Up
    0
    Down
    What are your hardware specifications?
    0
    yazarlwin
    Participant
    Up
    0
    Down
    It’s VM on XCP-NG with Super MicroBlade Server.

    Intel(R) Xeon(R) CPU E5-2650L v4 @ 1.70GHz

    24 Cores

    16 GB RAM

     

    0
    yazarlwin
    Participant
    Up
    0
    Down
    We found this process in MySQL. Please have a look at the attached picture.

     

    Attachments:
    You must be logged in to view attached files.
    0
    Up
    0
    Down
    Due to you are running a call center, I recommend you update your current CPU to one with a better base frequency and multi-thread. “Intel® Core™ i7-4790K Processor 8M Cache, up to 4.40 GHz” as an illustration.

    This is because applications like “Asterisk” and  “MariaDB(MySQL)” are no multi-processors, are multi-thread. Moreover, increasing the CPU speed (base frequency) will allow the execution of the task rapidly.

    Regards,

    0
    yazarlwin
    Participant
    Up
    0
    Down
    Thanks for your suggestion. I will plan to upgrade the CPU.
    0
Viewing 5 replies - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.