Hello,
Indeed, I think there are some DB access external of kamailio.cfg.
If accounting process is implied in the freeze of SIP handling, and if aysnc accounting
can solve this, it's my priority. Even if accounting fails due to the timeout you
reminded.
Regards,
Igor.
De : Daniel-Constantin Mierla [mailto:miconda@gmail.com]
Envoyé : mercredi 15 février 2017 08:57
À : Igor Potjevlesch <igor.potjevlesch(a)gmail.com>om>; 'Kamailio (SER) - Users
Mailing List' <sr-users(a)lists.sip-router.org>
Objet : Re: [SR-Users] Lost of connection with MySQL?
Hello,
it doesn't have to be from kamailio.cfg, but any query from external tools, like cron
jobs, billing applications, etc ...
Can you measure how long it takes to do a query from the command line? Just try to select
the records by a call-id.
Also, there are some core parameters that will print log messages in case of slow
queries/actions, see the core cookbook.
Moreover, the db_mysql module has some parameters to tune the timeouts.
Cheers,
Daniel
On 14/02/2017 14:22, Igor Potjevlesch wrote:
Hello,
There is only queries on a replication server, so not the one reported in the errors, to
make some fraud detections. But, directly from Kamailio config file, there's no
queries.
The structure is: id as primary and callid is an index.
Regards,
Igor.
De : Daniel-Constantin Mierla [mailto:miconda@gmail.com]
Envoyé : mardi 14 février 2017 12:06
À : Igor Potjevlesch <mailto:igor.potjevlesch@gmail.com>
<igor.potjevlesch(a)gmail.com>om>; 'Kamailio (SER) - Users Mailing List'
<mailto:sr-users@lists.sip-router.org> <sr-users(a)lists.sip-router.org>
Objet : Re: [SR-Users] Lost of connection with MySQL?
Hello,
it is a lot if you have over 9 million records. Do you run other periodical queries over
acc, like generating full cdrs every N minutes?
Have you created other constraints (e.g., unique keys) over the table?
Cheers,
Daniel
On 14/02/2017 11:51, Igor Potjevlesch wrote:
Hello Daniel,
Actually 9 031 181.
Regards,
Igor.
De : sr-users [mailto:sr-users-bounces@lists.sip-router.org] De la part de
Daniel-Constantin Mierla
Envoyé : mardi 14 février 2017 10:57
À : Kamailio (SER) - Users Mailing List <mailto:sr-users@lists.sip-router.org>
<sr-users(a)lists.sip-router.org>
Objet : Re: [SR-Users] Lost of connection with MySQL?
Hello,
do you have a lot of records inside the acc table?
Cheers,
Daniel
On 14/02/2017 09:54, Igor Potjevlesch wrote:
Hello,
Two times in the last week, Kamailio reports MySQL errors like these:
/usr/local/sbin/kamailio[19225]: ERROR: db_mysql [km_dbase.c:126]:
db_mysql_submit_query(): driver error on query: Can't connect to MySQL server on
'192.168.2.6' (4) (2003)
/usr/local/sbin/kamailio[19225]: ERROR: <core> [db_query.c:235]: db_do_insert_cmd():
error while submitting query
/usr/local/sbin/kamailio[19225]: ERROR: acc [acc.c:504]: acc_db_request(): failed to
insert into database
These errors are repeated many times and cause Kamailio to hang and don't reply to SIP
requests. A reboot of Kamailio solves the issue.
Anyone has already had this issue and had solved it?
Regards,
Igor.
_____
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel
antivirus Avast.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org <mailto:sr-users@lists.sip-router.org>
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla
www.twitter.com/miconda <http://www.twitter.com/miconda> --
www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda>
Kamailio Advanced Training - Mar 6-8 (Europe) and Mar 20-22 (USA) -
www.asipto.com
<http://www.asipto.com>
Kamailio World Conference - May 8-10, 2017 -
www.kamailioworld.com
<http://www.kamailioworld.com>
_____
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel
antivirus Avast.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>
--
Daniel-Constantin Mierla
www.twitter.com/miconda <http://www.twitter.com/miconda> --
www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda>
Kamailio Advanced Training - Mar 6-8 (Europe) and Mar 20-22 (USA) -
www.asipto.com
<http://www.asipto.com>
Kamailio World Conference - May 8-10, 2017 -
www.kamailioworld.com
<http://www.kamailioworld.com>
_____
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel
antivirus Avast.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>
--
Daniel-Constantin Mierla
www.twitter.com/miconda <http://www.twitter.com/miconda> --
www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda>
Kamailio Advanced Training - Mar 6-8 (Europe) and Mar 20-22 (USA) -
www.asipto.com
<http://www.asipto.com>
Kamailio World Conference - May 8-10, 2017 -
www.kamailioworld.com
<http://www.kamailioworld.com>
---
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel
antivirus Avast.
https://www.avast.com/antivirus