Re: [Engine-devel] UI: VM list not populating

----- Original Message ----- > From: "Adam Litke" <alitke(a)redhat.com&gt; > To: "Daniel Erez" <derez(a)redhat.com&gt; > Cc: "Alexander Wels" <awels(a)redhat.com&gt;, engine-devel(a)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(a)redhat.com&gt; > >> To: "Daniel Erez" <derez(a)redhat.com&gt; > >> Cc: "Alexander Wels" <awels(a)redhat.com&gt;, engine-devel(a)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(a)redhat.com&gt; > >> >> To: "Alexander Wels" <awels(a)redhat.com&gt; > >> >> Cc: engine-devel(a)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 > >