[OpenSIPS-Users] Possible MYQL B2B problem?

[Ovidiu Sas]

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
>