Hide Forgot
Created attachment 1229066 [details] engine log Description of problem: Failed to run VM - Exception: org.springframework.jdbc.BadSqlGrammarException: Prepa redStatementCallback; bad SQL grammar Version-Release number of selected component (if applicable): 4.1.0-0.2.master.20161206231204.git3921e29.el7.centos How reproducible: 100 Steps to Reproduce: 1. Try to run VM on latest master 4.1.0-0.2.master.20161206231204.git3921e29.el7.centos Actual results: Failed 2016-12-07 16:03:39,659+02 ERROR [org.ovirt.engine.core.bll.RunVmCommand] (org.ovirt.thread.pool-6-thread-9) [bb854e95-dff7-4149-9817-f924ee7af797] Command 'org.ovirt.engine.core.bll.RunVmCommand' failed: Prepared StatementCallback; bad SQL grammar [select * from getvnicprofilebyvnicprofileid(?)]; nested exception is org.postgresql.util.PSQLException: The column name migratable was not found in this ResultSet. 2016-12-07 16:03:39,659+02 ERROR [org.ovirt.engine.core.bll.RunVmCommand] (org.ovirt.thread.pool-6-thread-9) [bb854e95-dff7-4149-9817-f924ee7af797] Exception: org.springframework.jdbc.BadSqlGrammarException: Prepa redStatementCallback; bad SQL grammar [select * from getvnicprofilebyvnicprofileid(?)]; nested exception is org.postgresql.util.PSQLException: The column name migratable was not found in this ResultSet. at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:99) [spring-jdbc.jar:4.2.4.RELEASE] Expected results: Should work Additional info: It is caused by the 'migratable' parameter we added for vNIC profile. Please note this is also affecting the vNIC profile sub tab, it is broken and can't be loaded. Another thing is that when trying to create new vNIC profile the 'migratable' property is checked by default.
This bug affecting another scenario like remove network from dc 2016-12-07 16:45:05,936+02 ERROR [org.ovirt.engine.core.bll.network.dc.RemoveNetworkCommand] (org.ovirt.thread.pool-6-thread-37) [2072dcd2-a20c-477c-84ee-845e1a20110d] Command 'org.ovirt.engine.core.bll.network.dc .RemoveNetworkCommand' failed: PreparedStatementCallback; bad SQL grammar [select * from getvnicprofilesbynetworkid(?)]; nested exception is org.postgresql.util.PSQLException: The column name migratable was not found in this ResultSet. 2016-12-07 16:45:05,936+02 ERROR [org.ovirt.engine.core.bll.network.dc.RemoveNetworkCommand] (org.ovirt.thread.pool-6-thread-37) [2072dcd2-a20c-477c-84ee-845e1a20110d] Exception: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from getvnicprofilesbynetworkid(?)]; nested exception is org.postgresql.util.PSQLException: The column name migratable was not found in this ResultSet. at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:99) [spring-jdbc.jar:4.2.4.RELEASE]
note the setup I've seen this happening on was quite dirty with other exceptions, so proabably not all db upgrade scripts were executed correctly. Please check that
this issue no longer shows up after upgrade to recent master branch.