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: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.