[OpenSIPS-Users] Possible MYQL B2B problem?

[Ovidiu Sas]

No.  You need to upgrade to 1.7.0.

Regards,
Ovidiu Sas

On Tue, Sep 13, 2011 at 11:39 AM, Lee Archer <Lee.Archer at 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-bounces at lists.opensips.org [mailto:users-bounces at 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-bounces at lists.opensips.org [mailto:users-bounces at 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.Archer at 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-bounces at lists.opensips.org
>> [mailto:users-bounces at 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-bounces at lists.opensips.org
>> [mailto:users-bounces at 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.Archer at 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 at lists.opensips.org
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>
>>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>