No, that will be a terrible bad idea. do not change the table structure! Regards,
Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 10/22/2013 04:48 PM, [email protected] wrote: > Hello, > Do you think it is a good idea to change the dialog_id filed to > auto_increment or change to the none-primarykey field; > dlg_id | bigint(10) unsigned | NO | PRI | NULL > > Regard > Sami > > ----- Forwarded Message ----- > *From:* "[email protected]" <[email protected]> > *To:* Bogdan-Andrei Iancu <[email protected]> > *Sent:* Tuesday, 22 October 2013, 17:11:29 > *Subject:* Re: [OpenSIPS-Users] Erro on dialog table of opensips mysql > (dialog_update_db: could not add another dialog to db) > > 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]> > *To:* "[email protected]" <[email protected]>; OpenSIPS users > mailling list <[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
