<sr-users@lists.sip-router.org>
Objet : Re: [SR-Users] Lost of connection with MySQL?
On Wed, Mar 01, 2017 at 09:55:52AM +0100, Igor Potjevlesch wrote:
> Again this morning. It looks to be during the beginning of the peak. I don't
> have any idea where to search the issue. Any idea
On Wed, Mar 01, 2017 at 09:55:52AM +0100, Igor Potjevlesch wrote:
> Again this morning. It looks to be during the beginning of the peak. I don't
> have any idea where to search the issue. Any ideas?
The root cause has always been the mysqlserver in my case. I've seen the
following jobs causing
(SER) - Users Mailing List'
<sr-users@lists.sip-router.org>
Objet : RE: [SR-Users] Lost of connection with MySQL?
Hello,
Same issue this morning.
Feb 24 08:42:51 /usr/local/sbin/kamailio[25368]: ERROR: db_mysql
[km_dbase.c:126]: db_mysql_submit_query(): driver error on query: Can't c
[mailto:igor.potjevle...@gmail.com]
Envoyé : vendredi 17 février 2017 17:25
À : mico...@gmail.com; 'Kamailio (SER) - Users Mailing List'
<sr-users@lists.sip-router.org>
Objet : RE: [SR-Users] Lost of connection with MySQL?
Hello,
Thank you Daniel, and Daniel :) for your advises and analyse of this problem
Potjevlesch <igor.potjevle...@gmail.com>; 'Kamailio (SER) - Users
Mailing List' <sr-users@lists.sip-router.org>
Objet : Re: [SR-Users] Lost of connection with MySQL?
Hello,
as I said, if the execution if the query takes too long, then async mode
doesn't really solve the proble
gt; Regards,
>
>
>
> Igor.
>
>
>
> *De :*Daniel-Constantin Mierla [mailto:mico...@gmail.com]
> *Envoyé :* mercredi 15 février 2017 08:57
> *À :* Igor Potjevlesch <igor.potjevle...@gmail.com>; 'Kamailio (SER) -
> Users Mailing List' <sr-users@lists.sip-r
-Constantin Mierla [mailto:mico...@gmail.com]
Envoyé : mercredi 15 février 2017 08:57
À : Igor Potjevlesch <igor.potjevle...@gmail.com>; 'Kamailio (SER) - Users
Mailing List' <sr-users@lists.sip-router.org>
Objet : Re: [SR-Users] Lost of connection with MySQL?
Hello,
it doesn't hav
On 14/02/2017 14:36, Daniel Tryba wrote:
> On Tue, Feb 14, 2017 at 02:27:59PM +0100, Igor Potjevlesch wrote:
>> Looks to be a good idea.
>> I use MySQL and MyISAM, so I understand that async is supported.
> Async (db_insert_mode=2) is supported with any (acc)backend. With myisam you
> can use
On 14/02/2017 14:36, Daniel Tryba wrote:
> On Tue, Feb 14, 2017 at 02:27:59PM +0100, Igor Potjevlesch wrote:
>> Looks to be a good idea.
>> I use MySQL and MyISAM, so I understand that async is supported.
> Async (db_insert_mode=2) is supported with any (acc)backend.
To be accurate, not all
Constantin Mierla [mailto:mico...@gmail.com]
> *Envoyé :* mardi 14 février 2017 12:06
> *À :* Igor Potjevlesch <igor.potjevle...@gmail.com>; 'Kamailio (SER) -
> Users Mailing List' <sr-users@lists.sip-router.org>
> *Objet :* Re: [SR-Users] Lost of connection with MySQL?
>
>
On Tue, Feb 14, 2017 at 02:27:59PM +0100, Igor Potjevlesch wrote:
> Looks to be a good idea.
> I use MySQL and MyISAM, so I understand that async is supported.
Async (db_insert_mode=2) is supported with any (acc)backend. With myisam you
can use delayed inserts (db_insert_mode=1). But without even
sip-router.org>
Objet : Re: [SR-Users] Lost of connection with MySQL?
On Tue, Feb 14, 2017 at 09:54:42AM +0100, Igor Potjevlesch wrote:
[mysql query fails]
> These errors are repeated many times and cause Kamailio to hang and
> don't reply to SIP requests. A reboot of Kamailio solv
Mierla [mailto:mico...@gmail.com]
Envoyé : mardi 14 février 2017 12:06
À : Igor Potjevlesch <igor.potjevle...@gmail.com>; 'Kamailio (SER) - Users
Mailing List' <sr-users@lists.sip-router.org>
Objet : Re: [SR-Users] Lost of connection with MySQL?
Hello,
it is a lot if you have over 9 mil
On Tue, Feb 14, 2017 at 09:54:42AM +0100, Igor Potjevlesch wrote:
[mysql query fails]
> 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?
This is
ers Mailing List <sr-users@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 wro
Hello Daniel,
Actually 9 031 181.
Regards,
Igor.
De : sr-users [mailto:sr-users-boun...@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@lists.sip-router.org>
Objet : Re: [SR-Users
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]:
>
17 matches
Mail list logo