[OpenSIPS-Devel] [ opensips-Bugs-3488471 ] usrloc:db_insert_ucontact: inserting contact in db failed

[SourceForge.net]

Bugs item #3488471, was opened at 2012-02-16 23:32
Message generated for change (Tracker Item Submitted) made by nobody
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=3488471&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.7.x
Status: Open
Resolution: None
Priority: 5
Private: Yes
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: usrloc:db_insert_ucontact: inserting contact in db failed

Initial Comment:
Usrloc strange stuck on this record:
mysql> select * from location order by expires asc;
+-------+----------+--------+---------------------------------+----------+------+---------------------+-------+---------------------------------------------------+-------+---------------------+-------+--------+---------------------------------------+------------------------+---------+
| id    | username | domain | contact                         | received | path | expires             | q     | callid                                            | cseq  | last_modified       | flags | cflags | user_agent                            | socket                 | methods |
+-------+----------+--------+---------------------------------+----------+------+---------------------+-------+---------------------------------------------------+-------+---------------------+-------+--------+---------------------------------------+------------------------+---------+
| 16638 |          |        | sip:81.211.5.210:5060           | NULL     | NULL | 2012-02-16 18:48:53 | -1.00 | abf2344f-ff1c-ff04-8000-0002a4055cd0 at 81.211.5.210 | 26963 | 2012-02-16 18:38:53 |     0 |      0 | AddPac SIP Gateway                    | udp:87.249.26.210:5061 |    NULL |

Logs:
Feb 17 11:07:12 SimpleOffice-1 /usr/local/sbin/opensips[79108]: ERROR:usrloc:db_insert_ucontact: inserting contact in db failed
Feb 17 11:07:12 SimpleOffice-1 /usr/local/sbin/opensips[79108]: ERROR:usrloc:wb_timer: inserting contact into database failed
Feb 17 11:07:42 SimpleOffice-1 /usr/local/sbin/opensips[79108]: CRITICAL:db_mysql:wrapper_single_mysql_stmt_execute: driver error (1062): Duplicate entry 'sip:81.211.5.210:5060' for key 'account_contact_idx'
Feb 17 11:07:42 SimpleOffice-1 /usr/local/sbin/opensips[79108]: ERROR:usrloc:db_insert_ucontact: inserting contact in db failed
Feb 17 11:07:42 SimpleOffice-1 /usr/local/sbin/opensips[79108]: ERROR:usrloc:wb_timer: inserting contact into database failed
Feb 17 11:08:13 SimpleOffice-1 /usr/local/sbin/opensips[79108]: CRITICAL:db_mysql:wrapper_single_mysql_stmt_execute: driver error (1062): Duplicate entry 'sip:81.211.5.210:5060' for key 'account_contact_idx'
... 
Fixed by removing this record from database.
FreeBSD 7.1-RC2 i386
OpenSIPS v1.7.1
Mysql 5.1.58

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

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