[SR-Users] Wrong Publish status

[Aleš Šturm]

Hello,

 

yes, if the priority is the same, records should be ordered by
received_time. Acting in this way, when "presentity" table has more than one
record of the same user with equal priority, to watcher would be send Notify
message with last received status.

 

SQL like:

select * from presentity where username=X and priority=Y order by
received_time desc;

 

 

Thanks,

 

Ales

 

 

 

From: Daniel-Constantin Mierla [mailto:miconda at gmail.com] 
Sent: Wednesday, June 01, 2016 9:15 AM
To: Kamailio (SER) - Users Mailing List
Cc: 'Ales Sturm'
Subject: Re: [SR-Users] Wrong Publish status

 

Hello,

skipping the other content to fit in size limits for mailing list ...

On 27/05/16 11:59, Aleš Šturm wrote:

I think that statuses with equal "priority" are retrieved by "id" and not by
"received_time"!?

Is the above the conclusion and the fix would be to order by received_time
if the priority is the same?

At this moment I expect there is no further ordering than the priority in
this case, mysql being the one returning the order within the priority as
the records are found in the db. Like, if you just do a select without order
by, there is no guarantee that the order of records is the one as the
records were added.

Cheers,
Daniel



-- 
Daniel-Constantin Mierla
http://www.asipto.com - http://www.kamailio.org
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20160601/b0594fc7/attachment.html>