Bug 1048735

Summary: [Admin Portal] Cluster: initialized = false does not change view
Product: Red Hat Enterprise Virtualization Manager Reporter: Jiri Belka <jbelka>
Component: ovirt-engine-webadmin-portalAssignee: Eli Mesika <emesika>
Status: CLOSED CURRENTRELEASE QA Contact: Petr Beňas <pbenas>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 3.3.0CC: acathrow, ecohen, eedri, emesika, iheim, knesenko, pbenas, pstehlik, Rhev-m-bugs, sbonazzo, talayan, yeylon
Target Milestone: ---   
Target Release: 3.4.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard: infra
Fixed In Version: av3 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Infra RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
engine.log none

Description Jiri Belka 2014-01-06 09:35:44 UTC
Description of problem:
Seems 'Cluster: initialized = false' does not change view, I did this search while having only Default cluster and it was Up.

Version-Release number of selected component (if applicable):
is30 (i see same with rhevm-3.2.5-0.49.el6ev.noarch)

How reproducible:
100%

Steps to Reproduce:
1. have Default cluster up
2. Cluster: initialized = false
3.

Actual results:
no change?

Expected results:
empty list

Additional info:
initialized 	String 	True or False indicating the status of the cluster.

Thus I suppose if I put 'false' then it should not show my cluster.

Comment 1 Jiri Belka 2014-01-06 11:11:22 UTC
Created attachment 846022 [details]
engine.log

Comment 2 Eli Mesika 2014-01-07 13:04:33 UTC
From the log :

2014-01-06 12:09:44,341 DEBUG [org.ovirt.engine.core.bll.SearchQuery] (ajp-/127.0.0.1:8702-13) Detailed stacktrace:: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM (SELECT * FROM vds_groups_view WHERE ( vds_group_id IN (SELECT vds_groups_storage_domain.vds_group_id FROM  vds_groups_storage_domain   WHERE  vds_groups_storage_domain.null = '0' ))  ORDER BY name ASC ) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is org.postgresql.util.PSQLException: ERROR: column vds_groups_storage_domain.null does not exist

The problem is that the is_initialized column was removed from vds_groups_storage_domain view , we have now only is_initialized column in vds_static (Host) level

The fixing patch will therefor remove this option from the Cluster search options

Comment 3 Tareq Alayan 2014-02-18 12:19:56 UTC
reassign. 

The option Cluster: initialized = true is still available in Cluster tab


tested on ovirt-engine-3.4.0-0.7.beta2.el6.noarch

Comment 6 Petr Beňas 2014-04-10 14:08:51 UTC
Verified in av6. It's no more possible to search for Cluster: initialized.

Comment 7 Itamar Heim 2014-06-12 14:09:13 UTC
Closing as part of 3.4.0