<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
<tt>No, that will be a terrible bad idea. do not change the table
structure!<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<br>
On 10/22/2013 04:48 PM, <a class="moz-txt-link-abbreviated" href="mailto:sami@yahoo.com">sami@yahoo.com</a> wrote:
<blockquote
cite="mid:1382449691.44527.YahooMailNeo@web171403.mail.ir2.yahoo.com"
type="cite">
<div style="color: rgb(0, 0, 0); background-color: rgb(255, 255,
255); 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 size="2" face="Arial"> <b><span style="font-weight:
bold;">From:</span></b> <a class="moz-txt-link-rfc2396E" href="mailto:sami@yahoo.com">"sami@yahoo.com"</a>
<a class="moz-txt-link-rfc2396E" href="mailto:samiramhosseini@yahoo.com"><samiramhosseini@yahoo.com></a><br>
<b><span style="font-weight: bold;">To:</span></b>
Bogdan-Andrei Iancu <a class="moz-txt-link-rfc2396E" href="mailto:bogdan@opensips.org"><bogdan@opensips.org></a> <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: rgb(0, 0, 0); background-color:
rgb(255, 255, 255); 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 size="2" face="Arial">
<b><span style="font-weight: bold;">From:</span></b>
Bogdan-Andrei Iancu
<a class="moz-txt-link-rfc2396E" href="mailto:bogdan@opensips.org"><bogdan@opensips.org></a><br
clear="none">
<b><span style="font-weight: bold;">To:</span></b>
<a class="moz-txt-link-rfc2396E" href="mailto:sami@yahoo.com">"sami@yahoo.com"</a>
<a class="moz-txt-link-rfc2396E" href="mailto:samiramhosseini@yahoo.com"><samiramhosseini@yahoo.com></a>;
OpenSIPS users mailling list
<a class="moz-txt-link-rfc2396E" href="mailto:users@lists.opensips.org"><users@lists.opensips.org></a> <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 moz-do-not-send="true" 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
moz-do-not-send="true" 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>
<fieldset
class="yiv3110475820mimeAttachmentHeader"></fieldset>
_______________________________________________
Users
mailing list
<a moz-do-not-send="true"
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 moz-do-not-send="true"
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>
</blockquote>
</body>
</html>