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 <[email protected]>
To: "[email protected]" <[email protected]>; "[email protected]"
<[email protected]>
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, [email protected] 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 <[email protected]>
>To: "[email protected]" <[email protected]>; "[email protected]"
><[email protected]>
>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, [email protected] 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 <[email protected]>
>>To: "[email protected]" <[email protected]>; OpenSIPS users mailling
>>list <[email protected]>
>>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, [email protected] 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
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>
>_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
