[asterisk-bugs] [JIRA] Commented: (ASTERISK-19170) realtime queues fail to load queue information when there arent valid queue_members in the queue_members table

[Ronny Becker (JIRA)]

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

Ronny Becker commented on ASTERISK-19170:
-----------------------------------------

Hello,
could it be that this change is responsable for ASTERISK-19793?

> realtime queues fail to load queue information when there arent valid queue_members in the queue_members table 
> ---------------------------------------------------------------------------------------------------------------
>
>                 Key: ASTERISK-19170
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-19170
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Applications/app_queue
>    Affects Versions: SVN, 1.8.9.0, 10.1.0
>         Environment: Linux Debian 6.0.3
>            Reporter: Rene Mendoza
>            Assignee: Rene Mendoza
>            Severity: Blocker
>             Fix For: 1.8.9.0, 10.1.0
>
>         Attachments: rt_queue_member_patch.diff
>
>
> When trying to use realtime queues ( with mysql ), queues fail to load unless there are valid queue_member records in the queue_member table, in the past it was possible to have an empty queue_member table and use only Dynamic members while the queues itself were loaded from the DB using realtime
> asterisk*CLI> queue show
> [Jan  4 17:06:43] ERROR[32624]: app_queue.c:2349 load_realtime_queue: no queue_members defined in your config (extconfig.conf).
> this is the /var/log/asterisk/debug output
> [Jan  5 22:08:06] DEBUG[4728] res_config_mysql.c: MySQL RealTime: Connection okay.
> [Jan  5 22:08:06] DEBUG[4728] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM call_queues WHERE name LIKE '%' ORDER BY name
> [Jan  5 22:08:06] DEBUG[4728] res_config_mysql.c: MySQL RealTime: Connection okay.
> [Jan  5 22:08:06] DEBUG[4728] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM call_queues WHERE name = 'demo_realtime'
> [Jan  5 22:08:06] DEBUG[4728] res_config_mysql.c: MySQL RealTime: Connection okay.
> [Jan  5 22:08:06] DEBUG[4728] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM queue_assignments WHERE interface LIKE '%' AND queue_name = 'demo_realtime' ORDER BY interface 
> This happens on both 1.8-svn and svn trunk
> 1.8.8.1 and previous versions are not affected

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira