[Engine-devel] UI: VM list not populating
Adam Litke
alitke at redhat.com
Mon Jan 6 21:11:56 UTC 2014
On 06/01/14 15:56 -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 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.
New VMs created in the admin portal and user portal do not show up in
the list. I just see the animated boxes indicating that the data is
loading. The same error appears in the engine.log. I will try to
blow away the data and start over.
>
>>
>> 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