Red Hat Bugzilla – Bug 1269021
Searching an errata with "!" displays incorrect results
Last modified: 2017-05-16 09:27:55 EDT
Description of problem: ----------------------- I tried to exclude a or some package(s) by searching but got incorrect results. There are 587 installable errata in my test Satellite client. When I try to exclude kernel by searching with 'package_name != kernel', kernel erratas are not excluded. However, when I try to exclude bind by searching with 'package_name != bind', bind erratas are excluded. I tried some of packages to exclude. I tried these below and it looked they worked fine as I expected. 'package_name !~ bind' 'package_name !~ bind or ~ ypbind' 'package_name !~ pam' 'package_name !~ pam or ~ spamassassin or ~ pam_passwdqc' 'package_name !~ net-snmp' 'package_name !~ tzdata' 'package_name !~ sqlite' 'package_name !~ selinux-policy' 'package_name !~ python' 'package_name !~ sudo' 'package_name !~ dovecot' 'package_name !~ grep' 'package_name !~ openssl' 'package_name !~ cpuspeed' : : I tired these below and it didn't look they worked. I don't know why those erratas are not excluded. 'package_name !~ lvm2' 'package_name !~ kernel' 'package_name !~ sssd' Version-Release number of selected component (if applicable): -------------------------------------------------------------- Red Hat Satellite Version 6.1.2 How reproducible: ----------------- always Steps to Reproduce: ------------------- 1.Navigate to Web UI -> Content -> Errata Tab (or) Navigate to Hosts -> Content Hosts -> Select a Content host -> Errata Tab 2.Search for package_name !~ kernel Actual results: --------------- kernel erratas are not excluded. Expected results: ----------------- kernel erratas are excluded. Additional info: ----------------
The reason for this is the way that the search works via simple sql joins. For example in this case a particular errata (RHSA-2016:0185) contains these packages: kernel-3.10.0-327.10.1.el7.x86_64 kernel-abi-whitelists-3.10.0-327.10.1.el7.noarch kernel-debug-3.10.0-327.10.1.el7.x86_64 kernel-debug-devel-3.10.0-327.10.1.el7.x86_64 kernel-devel-3.10.0-327.10.1.el7.x86_64 kernel-doc-3.10.0-327.10.1.el7.noarch kernel-headers-3.10.0-327.10.1.el7.x86_64 kernel-tools-3.10.0-327.10.1.el7.x86_64 kernel-tools-libs-3.10.0-327.10.1.el7.x86_64 perf-3.10.0-327.10.1.el7.x86_64 python-perf-3.10.0-327.10.1.el7.x86_64 What the query 'package_name !~ kernel' actually is saying is 'return me all errata where every package in the errata's package list does not contain the word 'kernel'. For the above errata the following query works: package_name !~ kernel and package_name !~ perf This is not ideal I agree and will have to think about a possible solution
There is a an upstream issue opened for this. We will no longer be tracking this downstream. If you believe this was closed in error please feel free to re-open with additional information.
Actually, I was incorrect in my previous comment. This is not fixed upstream, but given priorties I do not believe we will be addressing this in the near term.
Created redmine issue http://projects.theforeman.org/issues/19356 from this bug
While reviewing some scoped search documentation (the library we use for searching), I realized that this is possible to do in 6.2: Simply search for: "not package_name = nss" And this will return you all errata that do not have the package 'nss' in it. I believe this resolves this request. Apologies for not realizing this earlier.