No. You need to upgrade to 1.7.0. Regards, Ovidiu Sas
On Tue, Sep 13, 2011 at 11:39 AM, Lee Archer <lee.arc...@thebigword.com> wrote: > Hi all, is there any way I can avoid using the DB for B2B with 1.6.4? > > Regards > > Lee > > -----Original Message----- > From: users-boun...@lists.opensips.org > [mailto:users-boun...@lists.opensips.org] On Behalf Of Lee Archer > Sent: 09 September 2011 15:03 > To: OpenSIPS users mailling list > Subject: Re: [OpenSIPS-Users] Possible MYQL B2B problem? > > I'm using 1.6 and I don't think this works. > > Regards > > Lee > > -----Original Message----- > From: users-boun...@lists.opensips.org > [mailto:users-boun...@lists.opensips.org] On Behalf Of Ovidiu Sas > Sent: 09 September 2011 14:02 > To: OpenSIPS users mailling list > Subject: Re: [OpenSIPS-Users] Possible MYQL B2B problem? > > The db mode can be controlled via a module parameter: > http://www.opensips.org/html/docs/modules/1.7.x/b2b_entities.html#id250115 > http://www.opensips.org/html/docs/modules/1.7.x/b2b_logic.html#id250404 > > Regards, > Ovidiu Sas > > On Fri, Sep 9, 2011 at 12:36 AM, Lee Archer <lee.arc...@thebigword.com> wrote: >> Hi Ovidiu, could I not use a database for this and each server would do it >> locally? >> >> Regards >> >> Lee >> >> -----Original Message----- >> From: users-boun...@lists.opensips.org >> [mailto:users-boun...@lists.opensips.org] On Behalf Of Lee Archer >> Sent: 08 September 2011 17:22 >> To: OpenSIPS users mailling list >> Subject: Re: [OpenSIPS-Users] Possible MYQL B2B problem? >> >> Thanks for the explanation. So does this problem cause any calls to drop? >> I haven't restarted the server or made any changes to the b2b tables so >> don't quite understand how this could have happened. >> >> Regards >> >> Lee >> >> -----Original Message----- >> From: users-boun...@lists.opensips.org >> [mailto:users-boun...@lists.opensips.org] On Behalf Of Ovidiu Sas >> Sent: 08 September 2011 16:22 >> To: OpenSIPS users mailling list >> Subject: Re: [OpenSIPS-Users] Possible MYQL B2B problem? >> >> There is an issue with the b2b_logic module. >> If a b2b_logic context is saved in the db and the b2b_entities corresponding >> to the b2b_logic contexts are lost, the db is not properly cleaned up. >> When a new call comes in, a b2b_logic context is created and it may have the >> same key as the saved old b2b_logic context in the db. >> When a db operation is performed on that call (like inserting a new >> b2b_logic context with the same id as the one in the db) the operation fails >> and you see those errors. >> >> It might be possible that you arrived in this scenario after an opensips >> crash that left the db out of synch. >> When opensips was restarted, the b2b_logic context failed to load but it was >> not cleaned up in the db. >> >> In your case, you should see that you have in b2b_logic table a context with >> si_key='414.0'. >> You will need to manually delete that one from the db. >> >> When opensips starts, there are ERROR logs for this kind of situation: >> ERROR:b2b_entities:b2b_restore_logic_info: No dialog found for key >> [bk2bk.287.95] >> WARNING:b2b_logic:b2bl_add_tuple: Failed to restore logic info for >> tuple:entity [644.0][0] >> ERROR:b2b_entities:b2b_restore_logic_info: No dialog found for key >> [bk2bk.132.8088290] >> WARNING:b2b_logic:b2bl_add_tuple: Failed to restore logic info for >> tuple:entity [644.0][1] >> >> In this case, the b2b_logic context should be removed from the db because >> the restoration failed. >> >> >> Please open a bug report about this. >> >> >> Regards, >> Ovidiu Sas >> >> On Thu, Sep 8, 2011 at 4:03 AM, Lee Archer <lee.arc...@thebigword.com> wrote: >>> Hi all, I am using the b2b entities and logic modules and keep seeing >>> the following in the log: >>> >>> /usr/local/sbin/opensips[2642]: >>> CRITICAL:db_mysql:wrapper_single_mysql_real_query: driver error (1062): >>> Duplicate entry '414.0' for key 2 >>> /usr/local/sbin/opensips[2642]: ERROR:core:db_do_insert: error while >>> submitting query >>> /usr/local/sbin/opensips[2642]: ERROR:b2b_logic:b2b_logic_dump: Sql >>> insert failed >>> >>> Is it something to worry about and what problems could I encounter? >>> I've done some searching but haven't found much hence the question to the >>> group. >>> Is it correct to assume the call will be dropped? >>> >>> Thanks >>> >>> Lee >>> >>> _______________________________________________ >>> Users mailing list >>> Users@lists.opensips.org >>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>> >>> >> >> _______________________________________________ >> Users mailing list >> Users@lists.opensips.org >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> _______________________________________________ >> Users mailing list >> Users@lists.opensips.org >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> _______________________________________________ >> Users mailing list >> Users@lists.opensips.org >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> > > _______________________________________________ > Users mailing list > Users@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > _______________________________________________ > Users mailing list > Users@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > _______________________________________________ > Users mailing list > Users@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > _______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
