[asterisk-bugs] [JIRA] (ASTERISK-28858) Realtime linear queues losing the order of agents
Kevin Harwell (JIRA)
noreply at issues.asterisk.org
Tue Apr 28 16:25:25 CDT 2020
[ https://issues.asterisk.org/jira/browse/ASTERISK-28858?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kevin Harwell closed ASTERISK-28858.
------------------------------------
Resolution: Not A Bug
Closing as this is not really a bug, but how the database values are retrieved. Any change that would want to sort records Asterisk side would be an improvement/new feature.
> 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)
More information about the asterisk-bugs
mailing list