[OpenSIPS-Devel] [ opensips-Bugs-3406690 ] B2B logic module

[SourceForge.net]

Bugs item #3406690, was opened at 2011-09-09 08:59
Message generated for change (Tracker Item Submitted) made by nobody
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=3406690&group_id=232389

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: modules
Group: 1.6.x
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: B2B logic module

Initial Comment:
I asked on the mailing list about a problem I was having with B2B logic MYSQL duplicate entry errors.  In my logs I am seeing

Sep  9 09:57:27 /usr/local/sbin/opensips[2642]: CRITICAL:db_mysql:wrapper_single_mysql_real_query: driver error (1062): Duplicate entry '475.0' for key 2
Sep  9 09:57:27 /usr/local/sbin/opensips[2642]: ERROR:core:db_do_insert: error while submitting query
Sep  9 09:57:27 /usr/local/sbin/opensips[2642]: ERROR:b2b_logic:b2b_logic_dump: Sql insert failed

but the DB hasn't been restarted or crashed.  The reply to my mailing list message was

"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."

Regards

Lee

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=3406690&group_id=232389