Re: [Users] upgrade to latest master not working

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(a)gmail.com&gt; | To: "Doron Fediuck" <dfediuck(a)redhat.com&gt; | Cc: "Alon Bar-Lev" <alonbl(a)redhat.com&gt;, "users" <users(a)ovirt.org&gt;, "Dave Chen" <wei.d.chen(a)intel.com&gt;, "Eli Mesika" | <emesika(a)redhat.com&gt; | 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(a)redhat.com&gt; | --------------- | 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(a)redhat.com&gt; wrote: | | > | > | > ----- Original Message ----- | > | From: "Alon Bar-Lev" <alonbl(a)redhat.com&gt; | > | To: "Doron Fediuck" <dfediuck(a)redhat.com&gt; | > | Cc: "Dead Horse" <deadhorseconsulting(a)gmail.com&gt;, "users" < | > users(a)ovirt.org&gt;, "Dave Chen" <wei.d.chen(a)intel.com&gt;, "Eli | > | Mesika" <emesika(a)redhat.com&gt; | > | Sent: Monday, July 29, 2013 11:51:35 PM | > | Subject: Re: [Users] upgrade to latest master not working | > | | > | | > | | > | ----- Original Message ----- | > | > From: "Doron Fediuck" <dfediuck(a)redhat.com&gt; | > | > To: "Alon Bar-Lev" <alonbl(a)redhat.com&gt; | > | > Cc: "Dead Horse" <deadhorseconsulting(a)gmail.com&gt;, "users" | > | > <users(a)ovirt.org&gt;, "Dave Chen" <wei.d.chen(a)intel.com&gt;, "Eli | > | > Mesika" <emesika(a)redhat.com&gt; | > | > 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(a)redhat.com&gt; | > | > | To: "Doron Fediuck" <dfediuck(a)redhat.com&gt; | > | > | Cc: "Dead Horse" <deadhorseconsulting(a)gmail.com&gt;, "users" | > | > | <users(a)ovirt.org&gt;, "Dave Chen" <wei.d.chen(a)intel.com&gt;, "Eli | > | > | Mesika" <emesika(a)redhat.com&gt; | > | > | Sent: Monday, July 29, 2013 11:31:42 PM | > | > | Subject: Re: [Users] upgrade to latest master not working | > | > | | > | > | | > | > | | > | > | ----- Original Message ----- | > | > | > From: "Doron Fediuck" <dfediuck(a)redhat.com&gt; | > | > | > To: "Alon Bar-Lev" <alonbl(a)redhat.com&gt; | > | > | > Cc: "Dead Horse" <deadhorseconsulting(a)gmail.com&gt;, "users" | > | > | > <users(a)ovirt.org&gt;, "Dave Chen" <wei.d.chen(a)intel.com&gt;, "Eli | > | > | > Mesika" <emesika(a)redhat.com&gt; | > | > | > 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(a)redhat.com&gt; | > | > | > | To: "Dead Horse" <deadhorseconsulting(a)gmail.com&gt; | > | > | > | Cc: "users" <users(a)ovirt.org&gt;, "Doron Fediuck" < | > dfediuck(a)redhat.com&gt;, | > | > | > | "Dave | > | > | > | Chen" <wei.d.chen(a)intel.com&gt;, "Eli | > | > | > | Mesika" <emesika(a)redhat.com&gt; | > | > | > | Sent: Monday, July 29, 2013 10:47:01 PM | > | > | > | Subject: Re: [Users] upgrade to latest master not working | > | > | > | | > | > | > | | > | > | > | | > | > | > | ----- Original Message ----- | > | > | > | > From: "Dead Horse" <deadhorseconsulting(a)gmail.com&gt; | > | > | > | > To: "Alon Bar-Lev" <alonbl(a)redhat.com&gt; | > | > | > | > Cc: "users" <users(a)ovirt.org&gt; | > | > | > | > 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. | > |