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 <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.
------------------------------------------------------------------------
Avast logo
<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>
------------------------------------------------------------------------
Avast logo
<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>