#414 B2B logic module

1.6.x
open
nobody
modules (454)
5
2011-09-09
2011-09-09
Anonymous
No

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

Discussion


Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks