[OpenSIPS-Devel] [opensips] dbtext module (when interacting with dispatcher) load order of rows does not match dbtext file (#479)

[jockmckechnie]

Greetings;

On OpenSIPS v1.8.5 (presumed still present in 1.8.7):

Given a dbtext dispatcher database of the following:
-----
id(int,auto) setid(int) destination(string) socket(string,null) flags(int) weight(int) attrs(string) description(string)
0:1:sip\:192.168.55.9\:5060::0:1:'':'handler01'
1:1:sip\:192.168.55.8\:5060::0:1:'':'handler02'
-----

When the database is loaded into dispatcher the order unexpectedly gets sorted by the 'destination' field. No amount of changing the 'id' value will get the order altered from an apparent alpha sort of the 'destination' field, ala:

----
SET_NO:: 1
SET:: 1
         URI:: sip:192.168.55.8
         URI:: sip:192.168.55.9
----

Using dispatcher in a 'fail over' mode requires the data to be loaded from disk in a specific order and this is not possible with this fault present, unfortunately. If it could remain sorted by the 'id' field, or the on-disk order (I'm not sure which is easiest to implement), then it can be reliably configured in the correct order to solve the issue.

Thank you!

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