[Users] upgrade to latest master not working

Tue Jul 30 10:54:52 UTC 2013

Thanks.
So this leads me further to the upgrade procedure
which may have fail, thus not completing the DB upgrade.
Can you please check the upgrade logs to see if something
matches this flow?

----- Original Message -----
| From: "Dead Horse" <deadhorseconsulting at gmail.com>
| To: "Doron Fediuck" <dfediuck at redhat.com>
| Cc: "Alon Bar-Lev" <alonbl at redhat.com>, "users" <users at ovirt.org>, "Dave Chen" <wei.d.chen at intel.com>, "Eli Mesika"
| <emesika at redhat.com>
| Sent: Tuesday, July 30, 2013 6:37:55 AM
| Subject: Re: [Users] upgrade to latest master not working
| 
| 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 at 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 at redhat.com> wrote:
| 
| >
| >
| > ----- 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.
| >
| 