<!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>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.<br>
<br>
So be sure to have the right table (according to version).<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 05:12 PM, <a class="moz-txt-link-abbreviated" href="mailto:sami@yahoo.com">sami@yahoo.com</a> wrote:
<blockquote
cite="mid:1382451176.74808.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;">But I have the problem yesterday, Today I have upgraded.
it seems the dialog_id is not generated identically !<br>
<br>
<div><span><br>
</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">
<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>
<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>;
<a class="moz-txt-link-rfc2396E" href="mailto:users@lists.opensips.org">"users@lists.opensips.org"</a>
<a class="moz-txt-link-rfc2396E" href="mailto:users@lists.opensips.org"><users@lists.opensips.org></a> <br>
<b><span style="font-weight: bold;">Sent:</span></b>
Tuesday, 22 October 2013, 17:29:48<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="yiv0484969324">
<div> <tt>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.<br
clear="none">
<br clear="none">
Regards,<br clear="none">
</tt>
<pre class="yiv0484969324moz-signature">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a moz-do-not-send="true" rel="nofollow" shape="rect" class="yiv0484969324moz-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:41 PM, <a moz-do-not-send="true"
rel="nofollow" shape="rect"
class="yiv0484969324moz-txt-link-abbreviated"
ymailto="mailto:sami@yahoo.com" target="_blank"
href="mailto:sami@yahoo.com">sami@yahoo.com</a>
wrote:
<div class="yiv0484969324yqt9977910931"
id="yiv0484969324yqt65580">
<blockquote 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;">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 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
moz-do-not-send="true" rel="nofollow"
shape="rect"
class="yiv0484969324moz-txt-link-rfc2396E"
ymailto="mailto:bogdan@opensips.org"
target="_blank"
href="mailto:bogdan@opensips.org"><bogdan@opensips.org></a><br
clear="none">
<b><span style="font-weight: bold;">To:</span></b>
<a moz-do-not-send="true" rel="nofollow"
shape="rect"
class="yiv0484969324moz-txt-link-rfc2396E"
ymailto="mailto:sami@yahoo.com"
target="_blank"
href="mailto:sami@yahoo.com">"sami@yahoo.com"</a>
<a moz-do-not-send="true" rel="nofollow"
shape="rect"
class="yiv0484969324moz-txt-link-rfc2396E"
ymailto="mailto:samiramhosseini@yahoo.com" target="_blank"
href="mailto:samiramhosseini@yahoo.com"><samiramhosseini@yahoo.com></a>;
OpenSIPS users mailling list <a
moz-do-not-send="true" rel="nofollow"
shape="rect"
class="yiv0484969324moz-txt-link-rfc2396E"
ymailto="mailto:users@lists.opensips.org" target="_blank"
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="yiv0484969324y_msg_container"><br
clear="none">
<div id="yiv0484969324">
<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="yiv0484969324moz-signature">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a moz-do-not-send="true" rel="nofollow" shape="rect" class="yiv0484969324moz-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="yiv0484969324moz-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="yiv0484969324yqt0762601206"
id="yiv0484969324yqt56766">
<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="yiv0484969324mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list <a
moz-do-not-send="true"
rel="nofollow" shape="rect"
class="yiv0484969324moz-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="yiv0484969324moz-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>
</blockquote>
</div>
</div>
</div>
<br>
<br>
</div>
</div>
</div>
</div>
</blockquote>
</body>
</html>