[Engine-devel] UI: VM list not populating
Daniel Erez
derez at redhat.com
Mon Jan 6 20:56:00 UTC 2014
----- Original Message -----
> From: "Adam Litke" <alitke at redhat.com>
> To: "Daniel Erez" <derez at redhat.com>
> Cc: "Alexander Wels" <awels at redhat.com>, engine-devel at 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 at redhat.com>
> >> To: "Daniel Erez" <derez at redhat.com>
> >> Cc: "Alexander Wels" <awels at redhat.com>, engine-devel at 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 at redhat.com>
> >> >> To: "Alexander Wels" <awels at redhat.com>
> >> >> Cc: engine-devel at 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.properties
> >>
> >> 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.properties
> >
> >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
>
>
More information about the Engine-devel
mailing list