[asterisk-bugs] [JIRA] (ASTERISK-28858) Realtime linear queues losing the order of agents

[Leandro Dardini (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-28858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=250587#comment-250587 ] 

Leandro Dardini commented on ASTERISK-28858:
--------------------------------------------

You are right. My assumption was wrong. The ordering in the queue is not done over the "membername" (maybe it was this way in some old asterisk version?) but it is made over the "uniqueid". That field is a Primary Key, so the result from any MySQL command is returned ordered by that field.

Thank you to all

> Realtime linear queues losing the order of agents
> -------------------------------------------------
>
>                 Key: ASTERISK-28858
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-28858
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Applications/app_queue
>    Affects Versions: 16.9.0
>         Environment: Asterisk 16.9.0 on CentOS 7 64bit, realtime configuration on MySQL 5.7
>            Reporter: Leandro Dardini
>            Severity: Minor
>
> I have a system with several queues in a realtime configuration, using MySQL 5.7 as backend database. After restarting asterisk, for a limited amount of time, the ordering of the agents is perfect. As far as I know, the ordering of agents is made based on the device name, so agents are named as following, starting from AG-000 to AG-021
> {quote}
> asterisk -rx 'queue show 3641'
> 3641 has 0 calls (max unlimited) in 'linear' strategy (0s holdtime, 0s talktime), W:0, C:0, A:0, SL:0.0%, SL2:0.0% within 30s
>    Members:
>       236 (Local/AG-000-NFR-16324 at fromotherpbx/n from Custom:236-14687) (ringinuse enabled) (realtime) (Not in use) has taken no calls yet
>       232 (Local/AG-001-NFR-16348 at fromotherpbx/n from Custom:232-14687) (ringinuse enabled) (realtime) (Not in use) has taken no calls yet
>       226 (Local/AG-002-NFR-17993 at fromotherpbx/n from Custom:226-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       234 (Local/AG-003-NFR-16340 at fromotherpbx/n from Custom:234-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       206 (Local/AG-004-NFR-16332 at fromotherpbx/n from Custom:206-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       210 (Local/AG-005-NFR-16300 at fromotherpbx/n from Custom:210-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       211 (Local/AG-006-NFR-16356 at fromotherpbx/n from Custom:211-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       213 (Local/AG-007-NFR-16412 at fromotherpbx/n from Custom:213-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       215 (Local/AG-008-NFR-16372 at fromotherpbx/n from Custom:215-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       217 (Local/AG-009-NFR-16380 at fromotherpbx/n from Custom:217-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       218 (Local/AG-010-NFR-16404 at fromotherpbx/n from Custom:218-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       219 (Local/AG-011-NFR-16388 at fromotherpbx/n from Custom:219-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       220 (Local/AG-012-NFR-16396 at fromotherpbx/n from Custom:220-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       224 (Local/AG-013-NFR-16428 at fromotherpbx/n from Custom:224-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       230 (Local/AG-014-NFR-16308 at fromotherpbx/n from Custom:230-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       231 (Local/AG-015-NFR-16364 at fromotherpbx/n from Custom:231-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       238 (Local/AG-016-NFR-16444 at fromotherpbx/n from Custom:238-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       240 (Local/AG-017-NFR-16316 at fromotherpbx/n from Custom:240-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       241 (Local/AG-018-NFR-16420 at fromotherpbx/n from Custom:241-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       243 (Local/AG-019-NFR-16460 at fromotherpbx/n from Custom:243-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       246 (Local/AG-020-NFR-16292 at fromotherpbx/n from Custom:246-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       205 (Local/AG-021-NFR-16452 at fromotherpbx/n from Custom:205-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>    No Callers
> {quote}
> After a few hours, even if there was no call processed in the queue, the ordering is lost. The only activity in the queue is a "queue show" command run every minute.
> {quote}
> asterisk -rx 'queue show 3641'
> 3641 has 0 calls (max unlimited) in 'linear' strategy (0s holdtime, 0s talktime), W:0, C:0, A:0, SL:0.0%, SL2:0.0% within 30s
>    Members: 
>       232 (Local/AG-001-NFR-16348 at fromotherpbx/n from Custom:232-14687) (ringinuse enabled) (realtime) (Not in use) has taken no calls yet
>       234 (Local/AG-003-NFR-16340 at fromotherpbx/n from Custom:234-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       206 (Local/AG-004-NFR-16332 at fromotherpbx/n from Custom:206-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       210 (Local/AG-005-NFR-16300 at fromotherpbx/n from Custom:210-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       211 (Local/AG-006-NFR-16356 at fromotherpbx/n from Custom:211-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       213 (Local/AG-007-NFR-16412 at fromotherpbx/n from Custom:213-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       215 (Local/AG-008-NFR-16372 at fromotherpbx/n from Custom:215-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       217 (Local/AG-009-NFR-16380 at fromotherpbx/n from Custom:217-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       218 (Local/AG-010-NFR-16404 at fromotherpbx/n from Custom:218-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       219 (Local/AG-011-NFR-16388 at fromotherpbx/n from Custom:219-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       220 (Local/AG-012-NFR-16396 at fromotherpbx/n from Custom:220-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       224 (Local/AG-013-NFR-16428 at fromotherpbx/n from Custom:224-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       230 (Local/AG-014-NFR-16308 at fromotherpbx/n from Custom:230-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       231 (Local/AG-015-NFR-16364 at fromotherpbx/n from Custom:231-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       238 (Local/AG-016-NFR-16444 at fromotherpbx/n from Custom:238-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       240 (Local/AG-017-NFR-16316 at fromotherpbx/n from Custom:240-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       241 (Local/AG-018-NFR-16420 at fromotherpbx/n from Custom:241-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (In use) has taken no calls yet
>       243 (Local/AG-019-NFR-16460 at fromotherpbx/n from Custom:243-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       246 (Local/AG-020-NFR-16292 at fromotherpbx/n from Custom:246-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       205 (Local/AG-021-NFR-16452 at fromotherpbx/n from Custom:205-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>       226 (Local/AG-000-NFR-17993 at fromotherpbx/n from Custom:226-14687) (ringinuse enabled) (realtime) (Not in use) has taken no calls yet
>       236 (Local/AG-002-NFR-16324 at fromotherpbx/n from Custom:236-14687) (ringinuse enabled) (realtime) (paused was 0 secs ago) (Not in use) has taken no calls yet
>    No Callers
> {quote}



--
This message was sent by Atlassian JIRA
(v6.2#6252)