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

[Bogdan-Andrei Iancu]

Hello Sami,

You should not use same dialog table for more OpenSIPS instances - makes
no sense.  What is your reason of doing that?

Regards,

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


On 10/28/2013 01:52 PM, sami at yahoo.com wrote:
> Hello,
> On the previous scenario I use only one instance opensips, But Now
>
> My "dialog" table used by more than one opensips instance, So I got
> the following error:
> Do you know how can I solve the problem?
>
> er error (1062): Duplicate entry '7861307993824' for key 'PRIMARY'
> Oct 27 13:59:24 osips /usr/local/opensips_proxy/sbin/opensips[15766]:
> ERROR:dialog:dialog_update_db: could not add another dialog to db
> Oct 27 14:00:24 osips /usr/local/opensips_proxy/sbin/opensips[15766]:
> CRITICAL:db_mysql:wrapper_single_mysql_stmt_execute: driver error
> (1062): Duplicate entry '7861307993824' for key 'PRIMARY'
> Oct 27 14:00:24 osips /usr/local/opensips_proxy/sbin/opensips[15766]:
> ERROR:dialog:dialog_update_db: could not add another dialog to db
>
> Thanks a lot.
>  
> Regard
> Sami
>
> ----- Forwarded Message -----
> *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:48:54
> *Subject:* Re: [OpenSIPS-Users] Erro on dialog table of opensips mysql
> (dialog_update_db: could not add another dialog to db)
>
> 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 <http://www.opensips-solutions.com/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20131030/b39527e4/attachment.htm>