[Home]

Summary:ASTERISK-19514: Queue realtime does not remove members after removed from database: Queue fraud has no realtime members defined. No need for update
Reporter:gicc (gicc)Labels:
Date Opened:2012-03-10 14:31:29.000-0600Date Closed:2012-04-02 15:25:49
Priority:CriticalRegression?
Status:Closed/CompleteComponents:Applications/app_queue PBX/pbx_realtime
Versions:1.8.10.0 Frequency of
Occurrence		Constant
Related
Issues:
is related toASTERISK-19793 Only last realtime member of a queue is not actually removed from queue when removed from database
Environment:Attachments:
Description:Hi,
I've recently upgraded to 1.8.10.0 and I've noticed that last of realtime agents are not logged out from queue, while they are removed from database. In 1.8.7.1 behaviour is correct


Steps to reproduce

********************************************************
0. empty queue

F0P147-IVR-1*CLI> queue show test
test has 0 calls (max 100) in 'leastrecent' strategy (0s holdtime, 0s talktime), W:0, C:0, A:0, SL:0.0% within 0s
  No Members
  No Callers

[Mar 10 21:25:26] DEBUG[7101]: res_config_mysql.c:1626 mysql_reconnect: MySQL RealTime: Connection okay.
[Mar 10 21:25:26] DEBUG[7101]: res_config_mysql.c:504 realtime_multi_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM queue_member_table WHERE interface LIKE '%' AND queue_name = 'test' ORDER BY interface
[Mar 10 21:25:26] DEBUG[7101]: app_queue.c:2401 update_realtime_members: Queue test has no realtime members defined. No need for update




********************************************************
1. adding Local/124053@QueueIncommingConnection/n to realtime members table




********************************************************
2. refresh queue status

F0P147-IVR-1*CLI> queue show test
test has 0 calls (max 100) in 'leastrecent' strategy (0s holdtime, 0s talktime), W:0, C:0, A:0, SL:0.0% within 0s
  Members:
     sss (Local/124053@QueueIncommingConnection/n) (realtime) (Not in use) has taken no calls yet
  No Callers

[Mar 10 21:16:43] DEBUG[6053]: res_config_mysql.c:1626 mysql_reconnect: MySQL RealTime: Connection okay.
[Mar 10 21:16:43] DEBUG[6053]: res_config_mysql.c:504 realtime_multi_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM queue_member_table WHERE interface LIKE '%' AND queue_name = 'test' ORDER BY interface
[Mar 10 21:16:43] DEBUG[6053]: devicestate.c:340 _ast_device_state: No provider found, checking channel drivers for Local - 124053@QueueIncommingConnection/n
[Mar 10 21:16:43] DEBUG[6053]: chan_local.c:300 local_devicestate: Checking if extension 124053@QueueIncommingConnection exists (devicestate)




********************************************************
3. remove Local/124053@QueueIncommingConnection/n from database




********************************************************
4. refresh queue status. "Queue test has no realtime members defined. No need for update"


F0P147-IVR-1*CLI> queue show test
test has 0 calls (max 100) in 'leastrecent' strategy (0s holdtime, 0s talktime), W:0, C:0, A:0, SL:0.0% within 0s
  Members:
     sss (Local/124053@QueueIncommingConnection/n) (realtime) (Not in use) has taken no calls yet
  No Callers

[Mar 10 21:16:51] DEBUG[6053]: res_config_mysql.c:1626 mysql_reconnect: MySQL RealTime: Connection okay.
[Mar 10 21:16:51] DEBUG[6053]: res_config_mysql.c:504 realtime_multi_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM queue_member_table WHERE interface LIKE '%' AND queue_name = 'test' ORDER BY interface
[Mar 10 21:16:51] DEBUG[6053]: app_queue.c:2401 update_realtime_members: Queue test has no realtime members defined. No need for update




********************************************************
5. add Local/124054@QueueIncommingConnection/n to database as member. 124053 get's removed, 124054 get's logged in

F0P147-IVR-1*CLI> queue show test
test has 0 calls (max 100) in 'leastrecent' strategy (0s holdtime, 0s talktime), W:0, C:0, A:0, SL:0.0% within 0s
  Members:
     xxx (Local/124054@QueueIncommingConnection/n) (realtime) (Not in use) has taken no calls yet
  No Callers

[Mar 10 21:19:34] DEBUG[6062]: res_config_mysql.c:1626 mysql_reconnect: MySQL RealTime: Connection okay.
[Mar 10 21:19:34] DEBUG[6062]: res_config_mysql.c:504 realtime_multi_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM queue_member_table WHERE interface LIKE '%' AND queue_name = 'test' ORDER BY interface
[Mar 10 21:19:34] DEBUG[6062]: devicestate.c:340 _ast_device_state: No provider found, checking channel drivers for Local - 124054@QueueIncommingConnection/n
[Mar 10 21:19:34] DEBUG[6062]: chan_local.c:300 local_devicestate: Checking if extension 124054@QueueIncommingConnection exists (devicestate)




********************************************************
6. remove Local/124054@QueueIncommingConnection/n from database


F0P147-IVR-1*CLI> queue show test
test has 0 calls (max 100) in 'leastrecent' strategy (0s holdtime, 0s talktime), W:0, C:0, A:0, SL:0.0% within 0s
  Members:
     xxx (Local/124054@QueueIncommingConnection/n) (realtime) (Not in use) has taken no calls yet
  No Callers

[Mar 10 21:19:50] DEBUG[6066]: res_config_mysql.c:1626 mysql_reconnect: MySQL RealTime: Connection okay.
[Mar 10 21:19:50] DEBUG[6066]: res_config_mysql.c:504 realtime_multi_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM queue_member_table WHERE interface LIKE '%' AND queue_name = 'test' ORDER BY interface
[Mar 10 21:19:50] DEBUG[6066]: app_queue.c:2401 update_realtime_members: Queue test has no realtime members defined. No need for update




********************************************************
This happens always with last queue member, does not matter if member is Local or SIP channel.



test queue settings:
[test]
musicclass = default
joinempty = yes
strategy = leastrecent
;retry = 10
maxlen = 100
announce-holdtime = no
wrapuptime=5
memberdelay = 0
eventwhencalled = yes
eventmemberstatus = yes



extconfig.conf
[settings]
queue_members => mysql,asterisk,queue_member_table
Comments:By: Matt Jordan (mjordan) 2012-03-13 10:36:57.631-0500

We require a complete debug log to help triage the issue. This document will provide instructions on how to collect debugging logs from an Asterisk machine for the purpose of helping bug marshals troubleshoot an issue: https://wiki.asterisk.org/wiki/display/AST/Collecting+Debug+Information


By: Matt Jordan (mjordan) 2012-04-02 15:25:40.282-0500

Suspended due to lack of activity. Please request a bug marshal in #asterisk-bugs on the IRC network irc.freenode.net to reopen the issue should you have the additional information requested.  Further information can be found at http://www.asterisk.org/developers/bug-guidelines