A2Billing is a telecom switch and billing system capable of providing and billing a range of telecom products and services to customers such as calling card products, residential and wholesale VoIP termination, DID resale and callback services.
Some time my a2billing down, I detected that on this moment DB locked.
command full processlist and saw this query locked DB
Status: User sleep
info: SELECT username,useralias,UNIX_TIMESTAMP(creationdate) creationdate,vat,firstname,lastname FROM cc_card WHERE id = 1 OR SLEEP(5)
I runned this queary manually and DB also locked.
I didn't find this query in a2billing scripts. I dont understand why need SLEEP(5) in this query and where located file with this script.
Some time my a2billing down, I detected that on this moment DB locked. command full processlist and saw this query locked DB Status: User sleep info: SELECT username,useralias,UNIX_TIMESTAMP(creationdate) creationdate,vat,firstname,lastname FROM cc_card WHERE id = 1 OR SLEEP(5)
I runned this queary manually and DB also locked. I didn't find this query in a2billing scripts. I dont understand why need SLEEP(5) in this query and where located file with this script.
Please, can someone help me with my issue.