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.
So be sure to have the right table (according to version). Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 10/22/2013 05:12 PM, [email protected] wrote: > But I have the problem yesterday, Today I have upgraded. it seems the > dialog_id is not generated identically ! > > > > Regard > Sami > > ------------------------------------------------------------------------ > *From:* Bogdan-Andrei Iancu <[email protected]> > *To:* "[email protected]" <[email protected]>; > "[email protected]" <[email protected]> > *Sent:* Tuesday, 22 October 2013, 17:29:48 > *Subject:* Re: [OpenSIPS-Users] Erro on dialog table of opensips mysql > (dialog_update_db: could not add another dialog to db) > > 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. > > Regards, > Bogdan-Andrei Iancu > OpenSIPS Founder and Developer > http://www.opensips-solutions.com <http://www.opensips-solutions.com/> > > On 10/22/2013 04:41 PM, [email protected] <mailto:[email protected]> wrote: >> 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 <[email protected]> >> <mailto:[email protected]> >> *To:* "[email protected]" <mailto:[email protected]> >> <[email protected]> <mailto:[email protected]>; >> OpenSIPS users mailling list <[email protected]> >> <mailto:[email protected]> >> *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 <http://www.opensips-solutions.com/> >> >> On 10/22/2013 04:05 PM, [email protected] <mailto:[email protected]> 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 >>> [email protected] <mailto:[email protected]> >>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> > >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
