Created attachment 1387799 [details] production.log stacktrace Description of problem: Version-Release number of selected component (if applicable): 5.9.0.17 How reproducible: Always Steps to Reproduce: 1. Go to Services -> My Services 2. Create filter with expression: Service: Aggregate All Vm Cpus = 454 3. Actual results: Exception appears Expected results: Additional info:
I can not recreate reported issue. Is it possible to have access to appliance where we can recreate or attach db dump ?
Created attachment 1388032 [details] db dump
So a proposed solution is here: https://github.com/ManageIQ/manageiq/pull/16915 This effectively removes the filtering via SQL for these columns, but as explain in the pull request, it is ideal since the poor performance this can cause on index actions is far worse for the appliance then a N+1 based filter. The solution to make it work for both is far more involved, and arguably not worth it. * * * Of note, this is an issue in versions all the way back to 5.6 (darga), since the changes to these columns was introduced and backported in this patch: https://github.com/ManageIQ/manageiq/pull/11502 Causing the issues in this BZ.
Verified in 5.10.0.3. This filter works now.