[OpenSIPS-Users] Erro on dialog table of opensips mysql (dialog_update_db: could not add another dialog to db)

[Bogdan-Andrei Iancu]

Starting with the 1.9, the dlg_id was changed as how it is generated and
data type in SQL. Previously it was a simply auto-inc at DB level.
Starting with 1.9 it is generated and filled in by OpenSIPS.

So be sure to have the right table (according to version).

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com


On 10/22/2013 05:12 PM, sami at yahoo.com wrote:
> But I have the problem yesterday, Today I have upgraded. it seems the
> dialog_id is not generated identically !
>
>
>  
> Regard
> Sami
>
> ------------------------------------------------------------------------
> *From:* Bogdan-Andrei Iancu <bogdan at opensips.org>
> *To:* "sami at yahoo.com" <samiramhosseini at yahoo.com>;
> "users at lists.opensips.org" <users at lists.opensips.org>
> *Sent:* Tuesday, 22 October 2013, 17:29:48
> *Subject:* Re: [OpenSIPS-Users] Erro on dialog table of opensips mysql
> (dialog_update_db: could not add another dialog to db)
>
> Maybe you have some old dialogs from before the upgrade - the content
> may not be compatible between versions. So, before starting OpenSIPS,
> be sure and purge the content of the dialog table - this is needed
> just when doing the migration.
>
> Regards,
> Bogdan-Andrei Iancu
> OpenSIPS Founder and Developer
> http://www.opensips-solutions.com <http://www.opensips-solutions.com/>
>
> On 10/22/2013 04:41 PM, sami at yahoo.com <mailto:sami at yahoo.com> wrote:
>> Hello,
>> Sorry about that.
>> No, only one server with opensips (1.10 - I have upgraded) used the
>> dialog table;
>>
>>  
>> Regard
>> Sami
>>
>> ------------------------------------------------------------------------
>> *From:* Bogdan-Andrei Iancu <bogdan at opensips.org>
>> <mailto:bogdan at opensips.org>
>> *To:* "sami at yahoo.com" <mailto:sami at yahoo.com>
>> <samiramhosseini at yahoo.com> <mailto:samiramhosseini at yahoo.com>;
>> OpenSIPS users mailling list <users at lists.opensips.org>
>> <mailto:users at lists.opensips.org>
>> *Sent:* Tuesday, 22 October 2013, 16:46:03
>> *Subject:* Re: [OpenSIPS-Users] Erro on dialog table of opensips
>> mysql (dialog_update_db: could not add another dialog to db)
>>
>> Hello,
>>
>> First of all, please do not post on multiple mailing list if not
>> really needed - the topic you have is "user" related, has nothing to
>> do with development in OpenSIPS...
>>
>> Is your "dialog" table used by more than one opensips instance?
>>
>> Regards,
>> Bogdan-Andrei Iancu
>> OpenSIPS Founder and Developer
>> http://www.opensips-solutions.com <http://www.opensips-solutions.com/>
>>
>> On 10/22/2013 04:05 PM, sami at yahoo.com <mailto:sami at yahoo.com> wrote:
>>> Hello,
>>>
>>> I got the following error when sending 100call per second on opensips :
>>>
>>> Oct 22 16:06:01 osipsA
>>> /usr/local/opensips_proxy/sbin/opensips[8195]:
>>> CRITICAL:db_mysql:wrapper_single_mysql_stmt_execute: driver error
>>> (1062): Duplicate entry '16219786361317' for key 'PRIMARY'
>>> Oct 22 16:06:01 osipsA
>>> /usr/local/opensips_proxy/sbin/opensips[8195]:
>>> ERROR:dialog:dialog_update_db: could not add another dialog to db
>>>
>>> opensips version:1.9
>>> mysql  Ver 15.1 Distrib 5.5.32-MariaDB, for Linux (x86_64) using
>>> readline 5.1
>>> Plz help;
>>>
>>>
>>> Thanks 
>>> Regard
>>> Sami
>>>
>>> _______________________________________________ Users mailing list
>>> Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users 
>>
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20131022/7b3ada89/attachment.htm>