----- Original Message -----
From: "Adam Litke" <alitke@redhat.com> To: "Daniel Erez" <derez@redhat.com> Cc: "Alexander Wels" <awels@redhat.com>, engine-devel@ovirt.org Sent: Monday, January 6, 2014 10:42:08 PM Subject: Re: [Engine-devel] UI: VM list not populating
On 06/01/14 15:31 -0500, Daniel Erez wrote:
----- Original Message -----
From: "Adam Litke" <alitke@redhat.com> To: "Daniel Erez" <derez@redhat.com> Cc: "Alexander Wels" <awels@redhat.com>, engine-devel@ovirt.org Sent: Monday, January 6, 2014 9:51:57 PM Subject: Re: [Engine-devel] UI: VM list not populating
On 06/01/14 14:32 -0500, Daniel Erez wrote:
----- Original Message -----
From: "Adam Litke" <alitke@redhat.com> To: "Alexander Wels" <awels@redhat.com> Cc: engine-devel@ovirt.org Sent: Monday, January 6, 2014 9:11:48 PM Subject: Re: [Engine-devel] UI: VM list not populating
Might be an issue of a stale osinfo properties file, 'displayProtocols' has recently been introduced by [1]
Try overwriting osinfo-defaults.properties with the updated one from latest bits /ovirt-engine/packaging/conf/osinfo-defaults.properties --> $HOME/ovirt-engine/share/ovirt-engine/conf
[1] http://gerrit.ovirt.org/#/c/18677/14/packaging/conf/osinfo-defaults.properti...
Thanks for the suggestion but it did not seem to resolve the issue. Also, my proprties file has os.other.displayProtocols.value and os.other.spiceSupport.value. This seems different from [1] above which indicates that the spiceSupport key is removed entirely.
Actually spiceSupport key was added a bit later by: http://gerrit.ovirt.org/#/c/18220/17/packaging/conf/osinfo-defaults.properti...
Can you please check if VMs list is displayed correctly from the userportal? (I just wonder if there's some race in 'initCache/initDisplayTypes' mechanism).
Does not work in the User Portal either. I don't know if this is related, but I have started to observe some new errors in server.log. I wonder if I have done too much rebasing and schema upgrading on my local DB:
Yeah, looks like the DB needs upgrading... (if you don't have any important data you can just try creating a new one). Regarding the user portal, I'm guessing you don't see any VMs as you have to assign permissions to them first from the webadmin. Can you try creating some new VMs from the user portal, to see if the list is displayed correctly. Also, look whether you get a similar error in the engine log file as the webadmin.
2014-01-06 15:39:20,451 WARN [org.ovirt.engine.core.vdsbroker.VdsManager] (DefaultQuartzScheduler_Worker-31) Failed to refresh VDS , vds = 203848b8-1d84-4c01-a267-c11280d0ad0f : lager, error = org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from getinterface_viewbyvds_id(?, ?, ?)]; nested exception is org.postgresql.util.PSQLException: The column name qos_overridden was not found in this ResultSet., continuing.: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from getinterface_viewbyvds_id(?, ?, ?)]; nested exception is org.postgresql.util.PSQLException: The column name qos_overridden was not found in this ResultSet. at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98) [spring-jdbc.jar:3.1.1.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) [spring-jdbc.jar:3.1.1.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) [spring-jdbc.jar:3.1.1.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) [spring-jdbc.jar:3.1.1.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603) [spring-jdbc.jar:3.1.1.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637) [spring-jdbc.jar:3.1.1.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666) [spring-jdbc.jar:3.1.1.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:706) [spring-jdbc.jar:3.1.1.RELEASE] at org.ovirt.engine.core.dal.dbbroker.PostgresDbEngineDialect$PostgresSimpleJdbcCall.executeCallInternal(PostgresDbEngineDialect.java:154) [dal.jar:] at org.ovirt.engine.core.dal.dbbroker.PostgresDbEngineDialect$PostgresSimpleJdbcCall.doExecute(PostgresDbEngineDialect.java:120) [dal.jar:] at org.springframework.jdbc.core.simple.SimpleJdbcCall.execute(SimpleJdbcCall.java:181) [spring-jdbc.jar:3.1.1.RELEASE] at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeImpl(SimpleJdbcCallsHandler.java:137) [dal.jar:] at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeReadList(SimpleJdbcCallsHandler.java:103) [dal.jar:] at org.ovirt.engine.core.dao.network.InterfaceDaoDbFacadeImpl.getAllInterfacesForVds(InterfaceDaoDbFacadeImpl.java:167) [dal.jar:] at org.ovirt.engine.core.dao.network.InterfaceDaoDbFacadeImpl.getAllInterfacesForVds(InterfaceDaoDbFacadeImpl.java:150) [dal.jar:] at org.ovirt.engine.core.vdsbroker.vdsbroker.VdsBrokerObjectsBuilder.updateNetworkData(VdsBrokerObjectsBuilder.java:930) [vdsbroker.jar:] at org.ovirt.engine.core.vdsbroker.vdsbroker.VdsBrokerObjectsBuilder.updateVDSDynamicData(VdsBrokerObjectsBuilder.java:326) [vdsbroker.jar:] at org.ovirt.engine.core.vdsbroker.vdsbroker.GetCapabilitiesVDSCommand.executeVdsBrokerCommand(GetCapabilitiesVDSCommand.java:17) [vdsbroker.jar:] at org.ovirt.engine.core.vdsbroker.vdsbroker.VdsBrokerCommand.executeVDSCommand(VdsBrokerCommand.java:96) [vdsbroker.jar:] at org.ovirt.engine.core.vdsbroker.VDSCommandBase.executeCommand(VDSCommandBase.java:56) [vdsbroker.jar:] at org.ovirt.engine.core.dal.VdcCommandBase.execute(VdcCommandBase.java:28) [dal.jar:] at org.ovirt.engine.core.vdsbroker.VdsManager.refreshCapabilities(VdsManager.java:537) [vdsbroker.jar:] at org.ovirt.engine.core.vdsbroker.VdsUpdateRunTimeInfo.beforeFirstRefreshTreatment(VdsUpdateRunTimeInfo.java:883) [vdsbroker.jar:] at org.ovirt.engine.core.vdsbroker.VdsUpdateRunTimeInfo.refreshVdsRunTimeInfo(VdsUpdateRunTimeInfo.java:494) [vdsbroker.jar:] at org.ovirt.engine.core.vdsbroker.VdsUpdateRunTimeInfo.refresh(VdsUpdateRunTimeInfo.java:335) [vdsbroker.jar:] at org.ovirt.engine.core.vdsbroker.VdsManager.onTimer(VdsManager.java:236) [vdsbroker.jar:] at sun.reflect.GeneratedMethodAccessor16.invoke(Unknown Source) [:1.7.0_45] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_45] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_45] at org.ovirt.engine.core.utils.timer.JobWrapper.execute(JobWrapper.java:60) [scheduler.jar:] at org.quartz.core.JobRunShell.run(JobRunShell.java:213) [quartz.jar:] at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557) [quartz.jar:] Caused by: org.postgresql.util.PSQLException: The column name qos_overridden was not found in this ResultSet. at org.postgresql.jdbc2.AbstractJdbc2ResultSet.findColumn(AbstractJdbc2ResultSet.java:2542) at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getBoolean(AbstractJdbc2ResultSet.java:2390) at org.jboss.jca.adapters.jdbc.WrappedResultSet.getBoolean(WrappedResultSet.java:615) at org.ovirt.engine.core.dao.network.InterfaceDaoDbFacadeImpl$2.mapRow(InterfaceDaoDbFacadeImpl.java:278) [dal.jar:] at org.ovirt.engine.core.dao.network.InterfaceDaoDbFacadeImpl$2.mapRow(InterfaceDaoDbFacadeImpl.java:252) [dal.jar:] at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:92) [spring-jdbc.jar:3.1.1.RELEASE] at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:1) [spring-jdbc.jar:3.1.1.RELEASE] at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:649) [spring-jdbc.jar:3.1.1.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587) [spring-jdbc.jar:3.1.1.RELEASE] ... 27 more