[OpenSIPS-Devel] [opensips] duplicate entry (#764)

Lead Developer notifications at github.com
Wed Feb 17 07:52:49 CET 2016


Hi, I can confirm getting identical errors in our v.1.11.1 

```
Feb 15 16:46:12 uk1 /usr/sbin/opensips[19041]: CRITICAL:db_mysql:wrapper_single_mysql_real_query: driver error (1062): Duplicate entry '599802--sip:599802 at 92.40.248.209:41468;transport=UDP;rinstance=1' for key 'account_contact_idx'
Feb 15 16:46:12 uk1 /usr/sbin/opensips[19041]: CRITICAL:db_mysql:wrapper_single_mysql_real_query: driver error (1062): Duplicate entry '599802--sip:599802 at 92.40.248.209:41468;transport=UDP;rinstance=1' for key 'account_contact_idx'
Feb 15 17:17:29 uk1 /usr/sbin/opensips[19041]: CRITICAL:db_mysql:wrapper_single_mysql_real_query: driver error (1062): Duplicate entry '590981--sip:590981 at 31.4.229.32:35276;transport=UDP;rinstance=b84' for key 'account_contact_idx'
Feb 15 17:17:29 uk1 /usr/sbin/opensips[19041]: CRITICAL:db_mysql:wrapper_single_mysql_real_query: driver error (1062): Duplicate entry '590981--sip:590981 at 31.4.229.32:35276;transport=UDP;rinstance=b84' for key 'account_contact_idx'
```
my impression is it started since we switched to db_virtual in FAILOVER mode with Primary and Backup. Unable to reproduce this consistently in our Dev environment, however seeing 20-50 above log entries every day.

Regards,
Chris

---
Reply to this email directly or view it on GitHub:
https://github.com/OpenSIPS/opensips/issues/764#issuecomment-185056680
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/devel/attachments/20160216/79b73a56/attachment.htm>


More information about the Devel mailing list