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

[Bogdan-Andrei Iancu]

No, that will be a terrible bad idea. do not change the table structure!

Regards,

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


On 10/22/2013 04:48 PM, sami at yahoo.com wrote:
> Hello,
> Do you think it is a good idea to change the dialog_id filed to
> auto_increment or change to the none-primarykey field;
> dlg_id           | bigint(10) unsigned | NO   | PRI | NULL
>  
> Regard
> Sami
>
> ----- Forwarded Message -----
> *From:* "sami at yahoo.com" <samiramhosseini at yahoo.com>
> *To:* Bogdan-Andrei Iancu <bogdan at opensips.org>
> *Sent:* Tuesday, 22 October 2013, 17:11:29
> *Subject:* Re: [OpenSIPS-Users] Erro on dialog table of opensips mysql
> (dialog_update_db: could not add another dialog to db)
>
> 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 <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/96d4f430/attachment-0001.htm>