This is a multi-part message in MIME format. --------------050306070407000508050001 Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit On 28-04-2015 6:08, Roy Golan wrote:
On 04/28/2015 11:56 AM, Christopher Pereira wrote:
Hi, something broke Engine's Database in master:
2015-04-28 05:53:15,959 ERROR [org.ovirt.engine.core.bll.InitBackendServicesOnStartupBean] (MSC service thread 1-4) [] Failed to initialize backend: org.jboss.weld.exceptions.WeldException: WELD-000049 Unable to invoke [method] @PostConstruct private org.ovirt.engine.core.vdsbroker.ResourceManager.init() on org.ovirt.engine.core.vdsbroker.ResourceManager@38e3648c at org.jboss.weld.bean.AbstractClassBean.defaultPostConstruct(AbstractClassBean.java:518) [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31] at org.jboss.weld.bean.ManagedBean$ManagedBeanInjectionTarget.postConstruct(ManagedBean.java:174) [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31] at org.jboss.weld.bean.ManagedBean.create(ManagedBean.java:291) [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31] at org.jboss.weld.context.AbstractContext.get(AbstractContext.java:107) [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31] at org.jboss.weld.manager.BeanManagerImpl.getReference(BeanManagerImpl.java:616) [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31] at org.jboss.weld.manager.BeanManagerImpl.getReference(BeanManagerImpl.java:643) [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31] at org.ovirt.engine.core.di.Injector.instanceOf(Injector.java:73) [vdsbroker.jar:] [...] Caused by: org.postgresql.util.PSQLException: The column name gluster_tuned_profile was not found in this ResultSet. at org.postgresql.jdbc2.AbstractJdbc2ResultSet.findColumn(AbstractJdbc2ResultSet.java:2542) at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getString(AbstractJdbc2ResultSet.java:2385) at org.jboss.jca.adapters.jdbc.WrappedResultSet.getString(WrappedResultSet.java:1381) at org.ovirt.engine.core.dao.VdsGroupDAODbFacadeImpl$VdsGroupRowMapper.mapRow(VdsGroupDAODbFacadeImpl.java:306) [dal.jar:] at org.ovirt.engine.core.dao.VdsGroupDAODbFacadeImpl$VdsGroupRowMapper.mapRow(VdsGroupDAODbFacadeImpl.java:256) [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] ... 68 more
probably one of the packaging/dbscripts/upgrade script failed or didn't run
try to run this
packaging/dbscripts/upgrade/03_06_1260_add_tuned_profile_column_to_vds_groups.sql
and the vds_groups_sp.sql must be run again
1) Adding the field 'gluster_tuned_profile' to 'vds_groups' didn't fix the problem. 2) FYI: select * from schema_version order by id desc limit 1, was reporting: version | 03061240 script | upgrade/03_06_1240_revert_03061210_add_vm_host_device_commands.sql 3) I executed manually the remaining update scripts but it didn't fix the problem. 4) Then I tried: cd /usr/share/ovirt-engine/dbscripts export PGPASSWORD=... ./schema.sh -u engine -d engine -c refresh -v but it failed with: Creating views... psql:./create_views.sql:445: ERROR: column vm_device.is_using_scsi_reservation does not exist LINE 9: vm_device.is_using_scsi_reservation FATAL: Cannot execute sql command: --file=./create_views.sql 5) This field is defined in '03_06_1270_add_uses_scsi_reservation.sql' which I supposedly executed before (but probably really did not). I added manually "alter table vm_device add column is_using_scsi_reservation BOOLEAN NOT NULL DEFAULT FALSE;" ('fn_db_add_column' was not defined at this point). 6) Then I executed again "./schema.sh -u engine -d engine -c refresh -v" and this time it run until the end and fixed the problem. --------------050306070407000508050001 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: 8bit <html> <head> <meta content="text/html; charset=windows-1252" http-equiv="Content-Type"> </head> <body bgcolor="#FFFFFF" text="#000000"> On 28-04-2015 6:08, Roy Golan wrote:<br> <blockquote cite="mid:553F4E22.2070403@redhat.com" type="cite">On 04/28/2015 11:56 AM, Christopher Pereira wrote: <br> <blockquote type="cite">Hi, something broke Engine's Database in master: <br> <br> 2015-04-28 05:53:15,959 ERROR [org.ovirt.engine.core.bll.InitBackendServicesOnStartupBean] (MSC service thread 1-4) [] Failed to initialize backend: org.jboss.weld.exceptions.WeldException: WELD-000049 Unable to invoke [method] @PostConstruct private org.ovirt.engine.core.vdsbroker.ResourceManager.init() on org.ovirt.engine.core.vdsbroker.ResourceManager@38e3648c <br> at org.jboss.weld.bean.AbstractClassBean.defaultPostConstruct(AbstractClassBean.java:518) [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31] <br> at org.jboss.weld.bean.ManagedBean$ManagedBeanInjectionTarget.postConstruct(ManagedBean.java:174) [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31] <br> at org.jboss.weld.bean.ManagedBean.create(ManagedBean.java:291) [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31] <br> at org.jboss.weld.context.AbstractContext.get(AbstractContext.java:107) [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31] <br> at org.jboss.weld.manager.BeanManagerImpl.getReference(BeanManagerImpl.java:616) [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31] <br> at org.jboss.weld.manager.BeanManagerImpl.getReference(BeanManagerImpl.java:643) [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31] <br> at org.ovirt.engine.core.di.Injector.instanceOf(Injector.java:73) [vdsbroker.jar:] <br> [...]<br> Caused by: org.postgresql.util.PSQLException: The column name gluster_tuned_profile was not found in this ResultSet. <br> at org.postgresql.jdbc2.AbstractJdbc2ResultSet.findColumn(AbstractJdbc2ResultSet.java:2542)<br> at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getString(AbstractJdbc2ResultSet.java:2385)<br> at org.jboss.jca.adapters.jdbc.WrappedResultSet.getString(WrappedResultSet.java:1381)<br> at org.ovirt.engine.core.dao.VdsGroupDAODbFacadeImpl$VdsGroupRowMapper.mapRow(VdsGroupDAODbFacadeImpl.java:306) [dal.jar:] <br> at org.ovirt.engine.core.dao.VdsGroupDAODbFacadeImpl$VdsGroupRowMapper.mapRow(VdsGroupDAODbFacadeImpl.java:256) [dal.jar:] <br> at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:92) [spring-jdbc.jar:3.1.1.RELEASE] <br> at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:1) [spring-jdbc.jar:3.1.1.RELEASE] <br> at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:649) [spring-jdbc.jar:3.1.1.RELEASE] <br> at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587) [spring-jdbc.jar:3.1.1.RELEASE] <br> ... 68 more <br> <br> </blockquote> </blockquote> <blockquote cite="mid:553F4E22.2070403@redhat.com" type="cite">probably one of the packaging/dbscripts/upgrade script failed or didn't run <br> <br> try to run this <br> <br> packaging/dbscripts/upgrade/03_06_1260_add_tuned_profile_column_to_vds_groups.sql <br> <br> and the vds_groups_sp.sql must be run again <br> </blockquote> <br> 1) Adding the field 'gluster_tuned_profile' to 'vds_groups' didn't fix the problem.<br> <br> 2) FYI: select * from schema_version order by id desc limit 1, was reporting:<br> version | 03061240<br> script | upgrade/03_06_1240_revert_03061210_add_vm_host_device_commands.sql<br> <br> 3) I executed manually the remaining update scripts but it didn't fix the problem.<br> <br> 4) Then I tried:<br> <blockquote>cd /usr/share/ovirt-engine/dbscripts<br> export PGPASSWORD=...<br> ./schema.sh -u engine -d engine -c refresh -v<br> </blockquote> but it failed with:<br> <blockquote>Creating views...<br> psql:./create_views.sql:445: ERROR: column vm_device.is_using_scsi_reservation does not exist<br> LINE 9: vm_device.is_using_scsi_reservation<br> FATAL: Cannot execute sql command: --file=./create_views.sql<br> </blockquote> 5) This field is defined in '03_06_1270_add_uses_scsi_reservation.sql' which I supposedly executed before (but probably really did not).<br> I added manually "alter table vm_device add column is_using_scsi_reservation BOOLEAN NOT NULL DEFAULT FALSE;" ('fn_db_add_column' was not defined at this point).<br> <br> 6) Then I executed again "./schema.sh -u engine -d engine -c refresh -v" and this time it run until the end and fixed the problem.<br> </body> </html> --------------050306070407000508050001--