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