[OpenSIPS-Users] dialog_update_db: could not add another dialog to db

[sami@yahoo.com]

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
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
>On 10/22/2013 04:41 PM, 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>
>>To: "sami at yahoo.com" <samiramhosseini at yahoo.com>; OpenSIPS users mailling list <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
>>On 10/22/2013 04:05 PM, 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 http://lists.opensips.org/cgi-bin/mailman/listinfo/users 
>>
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20131028/2348bf70/attachment.htm>