[ovirt-users] sql error when viewing system disks

[Jeremiah Jahn]

version 3.4

System->Disks tab->All checked


Caused by: org.postgresql.util.PSQLException: The column name
disk_storage_type was not found in this ResultSet.
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.findColumn(AbstractJdbc2ResultSet.java:2542)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getInt(AbstractJdbc2ResultSet.java:2406)
at org.jboss.jca.adapters.jdbc.WrappedResultSet.getInt(WrappedResultSet.java:1073)
at org.ovirt.engine.core.dao.DiskDaoDbFacadeImpl$DiskRowMapper.mapRow(DiskDaoDbFacadeImpl.java:116)
[dal.jar:]
at org.ovirt.engine.core.dao.DiskDaoDbFacadeImpl$DiskRowMapper.mapRow(DiskDaoDbFacadeImpl.java:106)
[dal.jar:]



 ERROR [org.ovirt.engine.core.bll.SearchQuery] (ajp--127.0.0.1-8702-3)
Query SearchQuery failed. Exception message is StatementCallback; bad
SQL grammar [SELECT * FROM (SELECT * FROM vds WHERE ( vds_id IN
(SELECT vds_with_tags.vds_id FROM  vds_with_tags   WHERE
vds_with_tags.vds_group_name LIKE 'Default' ))  ORDER BY vds_name ASC
) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is
org.postgresql.util.PSQLException: The column name disk_storage_type
was not found in this ResultSet. :
org.springframework.jdbc.BadSqlGrammarException: StatementCallback;
bad SQL grammar [SELECT * FROM (SELECT * FROM vds WHERE ( vds_id IN
(SELECT vds_with_tags.vds_id FROM  vds_with_tags   WHERE
vds_with_tags.vds_group_name LIKE 'Default' ))  ORDER BY vds_name ASC
) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is
org.postgresql.util.PSQLException: The column name disk_storage_type
was not found in this ResultSet.:
org.springframework.jdbc.BadSqlGrammarException: StatementCallback;
bad SQL grammar [SELECT * FROM (SELECT * FROM vds WHERE ( vds_id IN
(SELECT vds_with_tags.vds_id FROM  vds_with_tags   WHERE
vds_with_tags.vds_group_name LIKE 'Default' ))  ORDER BY vds_name ASC
) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is
org.postgresql.util.PSQLException: The column name disk_storage_type
was not found in this ResultSet.