The engine version I am attempting to upgrade from was built from:
---------------
commit: dbc3d31110ce372a1fa7e06f64c4a5c64544c679
tree: ee9ee41c3e855c26f491c77fda9622c05af3fc54
parent: 82644cae97f3c546ee631ae79c925c91e7bed836

userportal,webadmin: Change remove message
Change-Id: Ia934e33d1a975e0235e1a1ffae0c8a4a7af66f10
Signed-off-by: Alexander Wels <awels@redhat.com>
---------------
Thus it is version 3.3 and not 3.2. The upgrade (built from this master this AM) was attempted ovirt a fresh install of the packages built from the above commit. I also confirmed the install was fully functional.

- DHC



On Mon, Jul 29, 2013 at 4:08 PM, Doron Fediuck <dfediuck@redhat.com> wrote:


----- Original Message -----
| From: "Alon Bar-Lev" <alonbl@redhat.com>
| To: "Doron Fediuck" <dfediuck@redhat.com>
| Cc: "Dead Horse" <deadhorseconsulting@gmail.com>, "users" <users@ovirt.org>, "Dave Chen" <wei.d.chen@intel.com>, "Eli
| Mesika" <emesika@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@redhat.com>
| > To: "Alon Bar-Lev" <alonbl@redhat.com>
| > Cc: "Dead Horse" <deadhorseconsulting@gmail.com>, "users"
| > <users@ovirt.org>, "Dave Chen" <wei.d.chen@intel.com>, "Eli
| > Mesika" <emesika@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@redhat.com>
| > | To: "Doron Fediuck" <dfediuck@redhat.com>
| > | Cc: "Dead Horse" <deadhorseconsulting@gmail.com>, "users"
| > | <users@ovirt.org>, "Dave Chen" <wei.d.chen@intel.com>, "Eli
| > | Mesika" <emesika@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@redhat.com>
| > | > To: "Alon Bar-Lev" <alonbl@redhat.com>
| > | > Cc: "Dead Horse" <deadhorseconsulting@gmail.com>, "users"
| > | > <users@ovirt.org>, "Dave Chen" <wei.d.chen@intel.com>, "Eli
| > | > Mesika" <emesika@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@redhat.com>
| > | > | To: "Dead Horse" <deadhorseconsulting@gmail.com>
| > | > | Cc: "users" <users@ovirt.org>, "Doron Fediuck" <dfediuck@redhat.com>,
| > | > | "Dave
| > | > | Chen" <wei.d.chen@intel.com>, "Eli
| > | > | Mesika" <emesika@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@gmail.com>
| > | > | > To: "Alon Bar-Lev" <alonbl@redhat.com>
| > | > | > Cc: "users" <users@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.