[ovirt-devel] Engine Broken - The column name gluster_tuned_profile was not found in this ResultSet

[Christopher Pereira]

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 at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/devel/attachments/20150428/d6413e9a/attachment.html>