<html><body><div style="color:#000; background-color:#fff; font-family:tahoma, new york, times, serif;font-size:10pt"><div dir="ltr"><span>Hello,</span></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: tahoma,new york,times,serif; background-color: transparent; font-style: normal;" dir="ltr"><span>Do you think it is a good idea to change the dialog_id filed to auto_increment or change to the none-primarykey field;</span></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: tahoma,new york,times,serif; background-color: transparent; font-style: normal;" dir="ltr"><span><span style="font-weight: bold;">dlg_id | bigint(10) unsigned | NO | PRI | NULL </span><br></span></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: tahoma,new york,times,serif; background-color: transparent; font-style: normal;"
dir="ltr"><span></span></div><div> </div><div>Regard<br>Sami</div><div><br></div> <div style="font-family: tahoma, new york, times, serif; font-size: 10pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> ----- Forwarded Message -----<br> <font face="Arial" size="2"> <b><span style="font-weight:bold;">From:</span></b> "sami@yahoo.com" <samiramhosseini@yahoo.com><br> <b><span style="font-weight: bold;">To:</span></b> Bogdan-Andrei Iancu <bogdan@opensips.org> <br> <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, 22 October 2013, 17:11:29<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [OpenSIPS-Users] Erro on dialog table of opensips mysql (dialog_update_db: could not add another dialog to db)<br> </font> </div> <div class="y_msg_container"><br><div id="yiv3110475820"><div><div style="color:#000;background-color:#fff;font-family:tahoma, new york, times,
serif;font-size:10pt;">Hello,<br clear="none">Sorry about that.<br clear="none">No, only one server with opensips (1.10 - I have upgraded) used the dialog table;<br clear="none"><div><span><br clear="none"></span></div><div> </div><div>Regard<br clear="none">Sami</div><div><br clear="none"></div> <div class="yiv3110475820yqt3696274573" id="yiv3110475820yqt44158"><div style="font-family:tahoma, new york, times, serif;font-size:10pt;"> <div style="font-family:times new roman, new york, times, serif;font-size:12pt;"> <div dir="ltr"> <hr size="1"> <font face="Arial" size="2"> <b><span style="font-weight:bold;">From:</span></b> Bogdan-Andrei Iancu <bogdan@opensips.org><br clear="none"> <b><span style="font-weight:bold;">To:</span></b> "sami@yahoo.com" <samiramhosseini@yahoo.com>; OpenSIPS users mailling list <users@lists.opensips.org> <br clear="none"> <b><span style="font-weight:bold;">Sent:</span></b> Tuesday, 22 October 2013,
16:46:03<br clear="none"> <b><span style="font-weight:bold;">Subject:</span></b> Re:
[OpenSIPS-Users] Erro on dialog table of opensips mysql (dialog_update_db: could not add another dialog to db)<br clear="none"> </font> </div> <div class="yiv3110475820y_msg_container"><br clear="none"><div id="yiv3110475820"><div>
<tt>Hello,<br clear="none">
<br clear="none">
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...<br clear="none">
<br clear="none">
Is your "dialog" table used by more than one opensips instance?<br clear="none">
<br clear="none">
Regards, <br clear="none">
</tt>
<pre class="yiv3110475820moz-signature">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a rel="nofollow" shape="rect" class="yiv3110475820moz-txt-link-freetext" target="_blank" href="http://www.opensips-solutions.com/">http://www.opensips-solutions.com</a></pre>
<br clear="none">
On 10/22/2013 04:05 PM, <a rel="nofollow" shape="rect" class="yiv3110475820moz-txt-link-abbreviated" ymailto="mailto:sami@yahoo.com" target="_blank" href="mailto:sami@yahoo.com">sami@yahoo.com</a> wrote:
<blockquote type="cite">
<div class="yiv3110475820yqt0762601206" id="yiv3110475820yqt56766"><div style="color:rgb(0, 0, 0);background-color:rgb(255, 255, 255);font-family:tahoma, new york, times, serif;font-size:10pt;">
<div><span></span></div>
<div dir="ltr"><span>Hello,</span></div>
<div dir="ltr" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:tahoma, new york, times, serif;background-color:transparent;font-style:normal;"><span><br clear="none">
</span></div>
<div dir="ltr" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:tahoma, new york, times, serif;background-color:transparent;font-style:normal;"><span>I got the
following error when sending 100call per second on opensips
:</span></div>
<div dir="ltr" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:tahoma, new york, times, serif;background-color:transparent;font-style:normal;"><span><br clear="none">
</span></div>
<div dir="ltr" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:tahoma, new york, times, serif;background-color:transparent;font-style:normal;"><span>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'<br clear="none">
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<br clear="none">
</span></div>
<div dir="ltr"><br clear="none">
opensips version:1.9<br clear="none">
mysql Ver 15.1 Distrib 5.5.32-MariaDB, for Linux (x86_64)
using readline 5.1<br clear="none">
Plz help;<br clear="none">
<br clear="none">
<br clear="none">
Thanks <br clear="none">
</div>
<div dir="ltr">Regard<br clear="none">
Sami</div>
</div></div>
<pre></pre><fieldset class="yiv3110475820mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list
<a rel="nofollow" shape="rect" class="yiv3110475820moz-txt-link-abbreviated" ymailto="mailto:Users@lists.opensips.org" target="_blank" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a rel="nofollow" shape="rect" class="yiv3110475820moz-txt-link-freetext" target="_blank" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</blockquote>
</div></div><br clear="none"><br clear="none"></div> </div> </div></div> </div></div></div><br><br></div> </div> </div> </div></body></html>