[Home]

Summary:ASTERISK-28719: Cannot remove defaultrule from queue using realtime queues
Reporter:EDV O-TON (edvoton)Labels:
Date Opened:2020-01-29 02:00:47.000-0600Date Closed:
Priority:MinorRegression?No
Status:Open/NewComponents:Core/Configuration
Versions:16.7.0 Frequency of
Occurrence		Constant
Related
Issues:
is duplicated byASTERISK-29324 app_queue: Queuerule still works in queue, even after unset it
is related toASTERISK-28781 res_config_odbc: Sorcery doesn't set default value if the ODBC realtime value is blank
is related toASTERISK-28805 follow me with empty database fileds broken after res odbc fix for empty strings
Environment:Ubuntu 18.04.3 with all latest patches until 29-01-2020Attachments:
Description:When using realtime queues setting the field 'defaultrule' in the queues table to a valid rule will activate this for the queue without the need to reload anything. When trying to remove the rule again by setting the field to null or empty nothing happens and the rule is still active. All possible reloads using cli won't work and just restarting asterisk will help. Another way is setting the defaultrule field to a non existing rule and then again to empty but that's not what I would have expected...
Comments:By: Asterisk Team (asteriskteam) 2020-01-29 02:00:48.790-0600

Thanks for creating a report! The issue has entered the triage process. That means the issue will wait in this status until a Bug Marshal has an opportunity to review the issue. Once the issue has been reviewed you will receive comments regarding the next steps towards resolution.

A good first step is for you to review the [Asterisk Issue Guidelines|https://wiki.asterisk.org/wiki/display/AST/Asterisk+Issue+Guidelines] if you haven't already. The guidelines detail what is expected from an Asterisk issue report.

Then, if you are submitting a patch, please review the [Patch Contribution Process|https://wiki.asterisk.org/wiki/display/AST/Patch+Contribution+Process].

Please note that once your issue enters an open state it has been accepted. As Asterisk is an open source project there is no guarantee or timeframe on when your issue will be looked into. If you need expedient resolution you will need to find and pay a suitable developer. Asking for an update on your issue will not yield any progress on it and will not result in a response. All updates are posted to the issue when they occur.
By: Sean Bright (seanbright) 2020-01-29 09:15:21.195-0600

SQL {{NULL}} is silently ignored. You can set {{defaultrule}} to the empty string once the referenced review is merged.
By: EDV O-TON (edvoton) 2020-01-31 02:25:54.955-0600

Thank you very much for your quick help!
By: Friendly Automation (friendly-automation) 2020-02-05 09:41:43.818-0600

Change 13722 merged by Friendly Automation:
res_config_odbc: Preserve empty strings returned by the database

[https://gerrit.asterisk.org/c/asterisk/+/13722|https://gerrit.asterisk.org/c/asterisk/+/13722]
By: Friendly Automation (friendly-automation) 2020-02-05 09:49:55.246-0600

Change 13710 merged by Friendly Automation:
res_config_odbc: Preserve empty strings returned by the database

[https://gerrit.asterisk.org/c/asterisk/+/13710|https://gerrit.asterisk.org/c/asterisk/+/13710]
By: Friendly Automation (friendly-automation) 2020-02-05 09:50:28.261-0600

Change 13711 merged by Friendly Automation:
res_config_odbc: Preserve empty strings returned by the database

[https://gerrit.asterisk.org/c/asterisk/+/13711|https://gerrit.asterisk.org/c/asterisk/+/13711]
By: Friendly Automation (friendly-automation) 2020-02-05 10:41:21.334-0600

Change 13712 merged by Friendly Automation:
res_config_odbc: Preserve empty strings returned by the database

[https://gerrit.asterisk.org/c/asterisk/+/13712|https://gerrit.asterisk.org/c/asterisk/+/13712]
By: Sean Bright (seanbright) 2020-04-08 08:47:07.369-0500

This change was reverted.