On 10/12/13 03:29 PM, Michal Skrivanek wrote:
On 10 Dec 2013, at 15:26, Frank Wall <fw@moov.de> wrote:
Hi Roy,
On 2013-12-10 8:24, Roy Golan wrote: can you run this so we would know if the script ever ran on your env? psql engine postgres -c "select * from schema_version where version ='03030660';" engine=# select * from schema_version where version ='03030660'; -[ RECORD 1 ]+--------------------------------------------------------- id | 246 version | 03030660 script | upgrade/03_03_0660_add_enabled_column_to_policy_unit.sql checksum | 5e791c91f298ca662f275e21524e9e30 installed_by | engine started_at | 2013-09-02 20:43:54.8651 ended_at | 2013-09-02 20:43:54.900773 state | INSTALLED current | f comment |
Though I'm pretty sure the upgrade process (using `engine-setup`) did not report any error. While grepping through all recent upgrade logs I cannot find any invocation of 03_03_0660_alter_os_type_unassigned_to_other.sql. So it did run. It was supposed to change the id. Is it possible you so ehow overwrote it manually or anything like that?
no it didn't. look at the script name. and Frank says he can't find the name in the log. Something is wrong at this env since the script upgrade/03_03_0660_add_enabled_column_to_policy_unit.sql in the git repo is 03_03_0690 while 03_03_0660 should be the osinfo script. how was this engine installed, upgraded in time? nightly or with official releases? Please also try to "ls /usr/share/ovirt-engine/dbscripts/upgrade | grep unassigned" so we would know if you have the script at all.
Thanks - Frank