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

[sami@yahoo.com]

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
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/20131022/90758662/attachment.htm>