[Users] upgrade to latest master not working

[Doron Fediuck]

----- Original Message -----
| From: "Alon Bar-Lev" <alonbl at redhat.com>
| To: "Doron Fediuck" <dfediuck at redhat.com>
| Cc: "Dead Horse" <deadhorseconsulting at gmail.com>, "users" <users at ovirt.org>, "Dave Chen" <wei.d.chen at intel.com>, "Eli
| Mesika" <emesika at redhat.com>
| Sent: Monday, July 29, 2013 11:51:35 PM
| Subject: Re: [Users] upgrade to latest master not working
| 
| 
| 
| ----- Original Message -----
| > From: "Doron Fediuck" <dfediuck at redhat.com>
| > To: "Alon Bar-Lev" <alonbl at redhat.com>
| > Cc: "Dead Horse" <deadhorseconsulting at gmail.com>, "users"
| > <users at ovirt.org>, "Dave Chen" <wei.d.chen at intel.com>, "Eli
| > Mesika" <emesika at redhat.com>
| > Sent: Monday, July 29, 2013 11:43:46 PM
| > Subject: Re: [Users] upgrade to latest master not working
| > 
| > 
| > 
| > ----- Original Message -----
| > | From: "Alon Bar-Lev" <alonbl at redhat.com>
| > | To: "Doron Fediuck" <dfediuck at redhat.com>
| > | Cc: "Dead Horse" <deadhorseconsulting at gmail.com>, "users"
| > | <users at ovirt.org>, "Dave Chen" <wei.d.chen at intel.com>, "Eli
| > | Mesika" <emesika at redhat.com>
| > | Sent: Monday, July 29, 2013 11:31:42 PM
| > | Subject: Re: [Users] upgrade to latest master not working
| > | 
| > | 
| > | 
| > | ----- Original Message -----
| > | > From: "Doron Fediuck" <dfediuck at redhat.com>
| > | > To: "Alon Bar-Lev" <alonbl at redhat.com>
| > | > Cc: "Dead Horse" <deadhorseconsulting at gmail.com>, "users"
| > | > <users at ovirt.org>, "Dave Chen" <wei.d.chen at intel.com>, "Eli
| > | > Mesika" <emesika at redhat.com>
| > | > Sent: Monday, July 29, 2013 11:27:41 PM
| > | > Subject: Re: [Users] upgrade to latest master not working
| > | > 
| > | > 
| > | > 
| > | > ----- Original Message -----
| > | > | From: "Alon Bar-Lev" <alonbl at redhat.com>
| > | > | To: "Dead Horse" <deadhorseconsulting at gmail.com>
| > | > | Cc: "users" <users at ovirt.org>, "Doron Fediuck" <dfediuck at redhat.com>,
| > | > | "Dave
| > | > | Chen" <wei.d.chen at intel.com>, "Eli
| > | > | Mesika" <emesika at redhat.com>
| > | > | Sent: Monday, July 29, 2013 10:47:01 PM
| > | > | Subject: Re: [Users] upgrade to latest master not working
| > | > | 
| > | > | 
| > | > | 
| > | > | ----- Original Message -----
| > | > | > From: "Dead Horse" <deadhorseconsulting at gmail.com>
| > | > | > To: "Alon Bar-Lev" <alonbl at redhat.com>
| > | > | > Cc: "users" <users at ovirt.org>
| > | > | > Sent: Monday, July 29, 2013 10:41:34 PM
| > | > | > Subject: Re: [Users] upgrade to latest master not working
| > | > | > 
| > | > | > server.log attached
| > | > | 
| > | > | Thanks!
| > | > | 
| > | > | My guess is that I8ce3448a[1] broke master.
| > | > | 
| > | > | [1] http://gerrit.ovirt.org/#/c/14605/
| > | > | 
| > | > 
| > | > Works perfectly on my Gentoo with master.
| > | > 
| > | 
| > | I doubt you are upgrading from 3.2 :)
| > | 
| > 
| > Just did:
| > 
| > $ git checkout origin/engine_3.2
| > $ cd backend/manager/dbscripts/
| > $ ./create_db.sh -d upgrade32-test -u engine
| > ~/dev/ovirt/ovirt-engine/backend/manager/dbscripts
| > ~/dev/ovirt/ovirt-engine/backend/manager/dbscripts
| > Creating the database: upgrade32-test
| > dropdb: database removal failed: ERROR:  database "upgrade32-test" does not
| > exist
| > user name is: engine
| > Creating tables...
| > Creating functions...
| > Creating common functions...
| > Inserting data  ...
| > Inserting pre-defined roles ...
| > Running upgrade scripts...
| > upgrade script detected a change in Config, View or Stored Procedure...
| > Running  upgrade sql script upgrade/pre_upgrade/0000_config.sql ...
| > 
| > ...
| > 
| > Creating stored procedures from vm_templates_sp.sql ...
| > Running  upgrade sql script
| > upgrade/post_upgrade/0010_add_object_column_white_list_table.sql ...
| > Running  upgrade sql script
| > upgrade/post_upgrade/0020_create_materialized_views.sql ...
| > Refreshing materialized views...
| > ~/dev/ovirt/ovirt-engine/backend/manager/dbscripts
| > 
| > $ git checkout master
| > $ cd ../../../packaging/dbscripts/
| > $ ./upgrade.sh -d upgrade32-test -u engine
| > upgrade script detected a change in Config, View or Stored Procedure...
| > Running upgrade sql script upgrade/pre_upgrade/0000_config.sql ...
| > 
| > ...
| > 
| > Creating stored procedures from vms_sp.sql ...
| > Running upgrade sql script
| > upgrade/post_upgrade/0010_add_object_column_white_list_table.sql ...
| > Running upgrade sql script
| > upgrade/post_upgrade/0020_create_materialized_views.sql ...
| > Refreshing materialized views...
| > Done.
| >  
| > 
| > Seems to work well. Am I missing something?
| > 
| 
| Start jboss?
| 
| Please take over this issue, you have relevant logs, and a cooperative user.
| 
| Thanks,
| Alon
| 

Since jboss is up and running very well after upgrade I do not see a problem.
Is it possible that the install / upgrade process didn't complete due to other
errors ending up with this state?

In the meantime you can manually create the missing function to get your
setup running. The only problem is that if my assumption is correct on
upgrade not finishing, you will hit the next db change as an error. So
I'd try and look at the install/upgrade log files to see if db upgrade
failed at some point.