[sr-dev] [kamailio] event on table location Duplicate entry for key 'ruid_idx' (#30)

[Daniel-Constantin Mierla]

I took the time to revise the old reported issue and I am having difficulty to understand what is left unfixed. There were some issue in matching the old records in database for db_update_ucontact_addr() in various mach modes, which should be fixed with the commit e8a795a6a413ae453f619e3deaf36c26b85b0077.

For db_mode_ruid=1, the matching is done on ruid column, thus db_update_ucontact_ruid() should result in one affected row if the same ruid value is found. I expect that at least expires and last_modifield fields will have different values.

Devel version has the option to set CLIENT_FOUND_ROWS to mysql connection to return matched rows instead of changed rows when doing UPDATE:
  * http://kamailio.org/docs/modules/devel/modules/db_mysql.html#db_mysql.p.update_affected_found

Maybe that can be made default.

Otherwise, I am not sure what else needs to be fixed. If you still think there is an issue, add new details here, explaining the case again. From the old issue on sip-router.org tracker is nothing I found to be fixed anymore.

---
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/issues/30#issuecomment-88455530
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20150401/ae8f2774/attachment.html>