[ovirt-users] sql error when viewing system disks
Daniel Erez
derez at redhat.com
Sun Apr 13 06:10:15 UTC 2014
----- Original Message -----
> From: "Jeremiah Jahn" <jeremiah at goodinassociates.com>
> To: users at ovirt.org
> Sent: Thursday, April 10, 2014 6:20:38 PM
> Subject: [ovirt-users] sql error when viewing system disks
>
> version 3.4
>
> System->Disks tab->All checked
Seems like an instance of bug 1073574 [1],
should be already resolved for version 3.4.1.
Just for a quick workaround, refreshing the browser should
mitigate the issue as well.
[1] https://bugzilla.redhat.com/show_bug.cgi?id=1073574
>
>
> 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.
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
More information about the Users
mailing list