[OpenSIPS-Devel] [opensips] dlg_id as primary key and single dialog table shared by multiple opensips instances (#306)

miko95 notifications at github.com
Tue Aug 19 13:16:58 CEST 2014


Hi,

After the dialog table schema has been changed to replace the hash_entry and hash_id columns by the new dlg_id column, the dlg_id column is now the primary key of the table (while only an index - non UNIQUE - was defined before for the (hash_entry,hash_id) columns).

With a configuration where multiple opensips instances share the same dialog table, I can imagine a case where multiple instances create dialogs with the same (hash_entry,hash_id) pair. The problem is that if one instance inserts a dialog with the coordinates (6,2) and that some time after another instance inserts a new dialog with the coordinates (6,2), the database will reject the INSERT statement since the dlg_id will be the same for both dialogs.

Regards,
Mickael

---
Reply to this email directly or view it on GitHub:
https://github.com/OpenSIPS/opensips/issues/306
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/devel/attachments/20140819/4fcd0b4a/attachment.htm>


More information about the Devel mailing list