<html><body><div style="color:#000; background-color:#fff; font-family:tahoma, new york, times, serif;font-size:12pt"><br><div style="font-family: tahoma, new york, times, serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;">Hello,<div class="y_msg_container"><div id="yiv3526477217"><div><div style="color:#000;background-color:#fff;font-family:tahoma, new york, times, serif;font-size:12pt;"><div dir="ltr">On the previous scenario I use only one instance opensips, But Now</div><div dir="ltr"><span style="font-weight:bold;"><br clear="none"></span></div><div dir="ltr" style="color:rgb(0, 0, 0);font-size:16px;font-family:monospace;background-color:transparent;font-style:normal;"><span style="font-weight:bold;">My <tt>"dialog" table used by more
than one opensips instance, So</tt> I got the following error:</span></div><div dir="ltr" style="color:rgb(0, 0, 0);font-size:16px;font-family:monospace;background-color:transparent;font-style:normal;"><span style="font-weight:bold;">Do you know how can I solve the problem?<br clear="none"></span></div><div dir="ltr"><br clear="none"></div><div dir="ltr" style="color:rgb(0, 0, 0);font-size:16px;font-family:tahoma, new york, times, serif;background-color:transparent;font-style:normal;"></div><div dir="ltr" style="color:rgb(0, 0, 0);font-size:16px;font-family:tahoma, new york, times, serif;background-color:transparent;font-style:normal;">
<div class="yiv3526477217MsoNormal"><span style="">er error
(1062): Duplicate entry '7861307993824' for key 'PRIMARY'</span></div>
<div class="yiv3526477217MsoNormal"><span style="">Oct 27
13:59:24 osips /usr/local/opensips_proxy/sbin/opensips[15766]:
ERROR:dialog:dialog_update_db: could not add another dialog to db</span></div>
<div class="yiv3526477217MsoNormal"><span style="">Oct 27
14:00:24 osips /usr/local/opensips_proxy/sbin/opensips[15766]:
CRITICAL:db_mysql:wrapper_single_mysql_stmt_execute: driver error (1062):
Duplicate entry '7861307993824' for key 'PRIMARY'</span></div>
<div class="yiv3526477217MsoNormal" style="color:rgb(0, 0, 0);font-size:16px;"><span style="">Oct 27
14:00:24 osips /usr/local/opensips_proxy/sbin/opensips[15766]:
ERROR:dialog:dialog_update_db: could not add another dialog to db</span></div>
</div><div dir="ltr" style="color:rgb(0, 0, 0);font-size:16px;"><br clear="none"></div><div dir="ltr" style="color:rgb(0, 0, 0);font-size:16px;">Thanks a lot.<br clear="none"><span></span></div><div style="color:rgb(0, 0, 0);font-size:16px;font-family:tahoma, new york, times, serif;background-color:transparent;font-style:normal;"><span></span></div><div> </div><div>Regard<br clear="none">Sami</div><div><br clear="none"></div> <div class="yiv3526477217yqt9952917399" id="yiv3526477217yqt51317"><div style="font-family:tahoma, new york, times, serif;font-size:12pt;"> <div style="font-family:times new roman, new york, times, serif;font-size:12pt;"> <div dir="ltr"> ----- Forwarded Message -----<br clear="none"> <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>; "users@lists.opensips.org" <users@lists.opensips.org> <br clear="none"> <b><span style="font-weight:bold;">Sent:</span></b> Tuesday, 22 October 2013, 17:48:54<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="yiv3526477217y_msg_container"><br clear="none"><div id="yiv3526477217"><div>
<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 clear="none">
<br clear="none">
So be sure to have the right table (according to version).<br clear="none">
<br clear="none">
Regards,<br clear="none">
</tt>
<pre class="yiv3526477217moz-signature">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a rel="nofollow" shape="rect" class="yiv3526477217moz-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 05:12 PM, <a rel="nofollow" shape="rect" class="yiv3526477217moz-txt-link-abbreviated" ymailto="mailto:sami@yahoo.com" target="_blank" href="mailto:sami@yahoo.com">sami@yahoo.com</a> wrote:
<div class="yiv3526477217yqt7175051141" id="yiv3526477217yqt60656"><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;">But I have the problem yesterday, Today I have upgraded.
it seems the dialog_id is not generated identically !<br clear="none">
<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 face="Arial" size="2"> <b><span style="font-weight:bold;">From:</span></b>
Bogdan-Andrei Iancu <a rel="nofollow" shape="rect" class="yiv3526477217moz-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 rel="nofollow" shape="rect" class="yiv3526477217moz-txt-link-rfc2396E" ymailto="mailto:sami@yahoo.com" target="_blank" href="mailto:sami@yahoo.com">"sami@yahoo.com"</a> <a rel="nofollow" shape="rect" class="yiv3526477217moz-txt-link-rfc2396E" ymailto="mailto:samiramhosseini@yahoo.com" target="_blank" href="mailto:samiramhosseini@yahoo.com"><samiramhosseini@yahoo.com></a>;
<a rel="nofollow" shape="rect" class="yiv3526477217moz-txt-link-rfc2396E" 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="yiv3526477217moz-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, 17:29:48<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="yiv3526477217y_msg_container"><br clear="none">
<div id="yiv3526477217">
<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="yiv3526477217moz-signature">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a rel="nofollow" shape="rect" class="yiv3526477217moz-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 rel="nofollow" shape="rect" class="yiv3526477217moz-txt-link-abbreviated" ymailto="mailto:sami@yahoo.com" target="_blank" href="mailto:sami@yahoo.com">sami@yahoo.com</a>
wrote:
<div class="yiv3526477217yqt9977910931" id="yiv3526477217yqt65580">
<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 face="Arial" size="2">
<b><span style="font-weight:bold;">From:</span></b>
Bogdan-Andrei Iancu <a rel="nofollow" shape="rect" class="yiv3526477217moz-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 rel="nofollow" shape="rect" class="yiv3526477217moz-txt-link-rfc2396E" ymailto="mailto:sami@yahoo.com" target="_blank" href="mailto:sami@yahoo.com">"sami@yahoo.com"</a>
<a rel="nofollow" shape="rect" class="yiv3526477217moz-txt-link-rfc2396E" ymailto="mailto:samiramhosseini@yahoo.com" target="_blank" href="mailto:samiramhosseini@yahoo.com"><samiramhosseini@yahoo.com></a>;
OpenSIPS users mailling list <a rel="nofollow" shape="rect" class="yiv3526477217moz-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="yiv3526477217y_msg_container"><br clear="none">
<div id="yiv3526477217">
<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="yiv3526477217moz-signature">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a rel="nofollow" shape="rect" class="yiv3526477217moz-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="yiv3526477217moz-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="yiv3526477217yqt0762601206" id="yiv3526477217yqt56766">
<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="yiv3526477217mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list <a rel="nofollow" shape="rect" class="yiv3526477217moz-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="yiv3526477217moz-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 clear="none">
<br clear="none">
</div>
</div>
</div>
</div>
</blockquote></div>
</div></div><br clear="none"><br clear="none"></div> </div> </div></div> </div></div></div><br><br></div> </div> </div> </div></body></html>