<div dir="ltr">The engine version I am attempting to upgrade from was built from:<br>---------------<br>commit: dbc3d31110ce372a1fa7e06f64c4a5c64544c679<br>tree: ee9ee41c3e855c26f491c77fda9622c05af3fc54<br>parent: 82644cae97f3c546ee631ae79c925c91e7bed836<br>
<br>userportal,webadmin: Change remove message<br>Change-Id: Ia934e33d1a975e0235e1a1ffae0c8a4a7af66f10<br>Signed-off-by: Alexander Wels &lt;<a href="mailto:awels@redhat.com">awels@redhat.com</a>&gt;<br>---------------<br>
<div class="gmail_extra">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.<br>
<br></div><div class="gmail_extra">- DHC<br></div><div class="gmail_extra"><br><br></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Jul 29, 2013 at 4:08 PM, Doron Fediuck <span dir="ltr">&lt;<a href="mailto:dfediuck@redhat.com" target="_blank">dfediuck@redhat.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="im"><br>
<br>
----- Original Message -----<br>
| From: &quot;Alon Bar-Lev&quot; &lt;<a href="mailto:alonbl@redhat.com">alonbl@redhat.com</a>&gt;<br>
| To: &quot;Doron Fediuck&quot; &lt;<a href="mailto:dfediuck@redhat.com">dfediuck@redhat.com</a>&gt;<br>
| Cc: &quot;Dead Horse&quot; &lt;<a href="mailto:deadhorseconsulting@gmail.com">deadhorseconsulting@gmail.com</a>&gt;, &quot;users&quot; &lt;<a href="mailto:users@ovirt.org">users@ovirt.org</a>&gt;, &quot;Dave Chen&quot; &lt;<a href="mailto:wei.d.chen@intel.com">wei.d.chen@intel.com</a>&gt;, &quot;Eli<br>

| Mesika&quot; &lt;<a href="mailto:emesika@redhat.com">emesika@redhat.com</a>&gt;<br>
</div><div><div class="h5">| Sent: Monday, July 29, 2013 11:51:35 PM<br>
| Subject: Re: [Users] upgrade to latest master not working<br>
|<br>
|<br>
|<br>
| ----- Original Message -----<br>
| &gt; From: &quot;Doron Fediuck&quot; &lt;<a href="mailto:dfediuck@redhat.com">dfediuck@redhat.com</a>&gt;<br>
| &gt; To: &quot;Alon Bar-Lev&quot; &lt;<a href="mailto:alonbl@redhat.com">alonbl@redhat.com</a>&gt;<br>
| &gt; Cc: &quot;Dead Horse&quot; &lt;<a href="mailto:deadhorseconsulting@gmail.com">deadhorseconsulting@gmail.com</a>&gt;, &quot;users&quot;<br>
| &gt; &lt;<a href="mailto:users@ovirt.org">users@ovirt.org</a>&gt;, &quot;Dave Chen&quot; &lt;<a href="mailto:wei.d.chen@intel.com">wei.d.chen@intel.com</a>&gt;, &quot;Eli<br>
| &gt; Mesika&quot; &lt;<a href="mailto:emesika@redhat.com">emesika@redhat.com</a>&gt;<br>
| &gt; Sent: Monday, July 29, 2013 11:43:46 PM<br>
| &gt; Subject: Re: [Users] upgrade to latest master not working<br>
| &gt;<br>
| &gt;<br>
| &gt;<br>
| &gt; ----- Original Message -----<br>
| &gt; | From: &quot;Alon Bar-Lev&quot; &lt;<a href="mailto:alonbl@redhat.com">alonbl@redhat.com</a>&gt;<br>
| &gt; | To: &quot;Doron Fediuck&quot; &lt;<a href="mailto:dfediuck@redhat.com">dfediuck@redhat.com</a>&gt;<br>
| &gt; | Cc: &quot;Dead Horse&quot; &lt;<a href="mailto:deadhorseconsulting@gmail.com">deadhorseconsulting@gmail.com</a>&gt;, &quot;users&quot;<br>
| &gt; | &lt;<a href="mailto:users@ovirt.org">users@ovirt.org</a>&gt;, &quot;Dave Chen&quot; &lt;<a href="mailto:wei.d.chen@intel.com">wei.d.chen@intel.com</a>&gt;, &quot;Eli<br>
| &gt; | Mesika&quot; &lt;<a href="mailto:emesika@redhat.com">emesika@redhat.com</a>&gt;<br>
| &gt; | Sent: Monday, July 29, 2013 11:31:42 PM<br>
| &gt; | Subject: Re: [Users] upgrade to latest master not working<br>
| &gt; |<br>
| &gt; |<br>
| &gt; |<br>
| &gt; | ----- Original Message -----<br>
| &gt; | &gt; From: &quot;Doron Fediuck&quot; &lt;<a href="mailto:dfediuck@redhat.com">dfediuck@redhat.com</a>&gt;<br>
| &gt; | &gt; To: &quot;Alon Bar-Lev&quot; &lt;<a href="mailto:alonbl@redhat.com">alonbl@redhat.com</a>&gt;<br>
| &gt; | &gt; Cc: &quot;Dead Horse&quot; &lt;<a href="mailto:deadhorseconsulting@gmail.com">deadhorseconsulting@gmail.com</a>&gt;, &quot;users&quot;<br>
| &gt; | &gt; &lt;<a href="mailto:users@ovirt.org">users@ovirt.org</a>&gt;, &quot;Dave Chen&quot; &lt;<a href="mailto:wei.d.chen@intel.com">wei.d.chen@intel.com</a>&gt;, &quot;Eli<br>
| &gt; | &gt; Mesika&quot; &lt;<a href="mailto:emesika@redhat.com">emesika@redhat.com</a>&gt;<br>
| &gt; | &gt; Sent: Monday, July 29, 2013 11:27:41 PM<br>
| &gt; | &gt; Subject: Re: [Users] upgrade to latest master not working<br>
| &gt; | &gt;<br>
| &gt; | &gt;<br>
| &gt; | &gt;<br>
| &gt; | &gt; ----- Original Message -----<br>
| &gt; | &gt; | From: &quot;Alon Bar-Lev&quot; &lt;<a href="mailto:alonbl@redhat.com">alonbl@redhat.com</a>&gt;<br>
| &gt; | &gt; | To: &quot;Dead Horse&quot; &lt;<a href="mailto:deadhorseconsulting@gmail.com">deadhorseconsulting@gmail.com</a>&gt;<br>
| &gt; | &gt; | Cc: &quot;users&quot; &lt;<a href="mailto:users@ovirt.org">users@ovirt.org</a>&gt;, &quot;Doron Fediuck&quot; &lt;<a href="mailto:dfediuck@redhat.com">dfediuck@redhat.com</a>&gt;,<br>
| &gt; | &gt; | &quot;Dave<br>
| &gt; | &gt; | Chen&quot; &lt;<a href="mailto:wei.d.chen@intel.com">wei.d.chen@intel.com</a>&gt;, &quot;Eli<br>
| &gt; | &gt; | Mesika&quot; &lt;<a href="mailto:emesika@redhat.com">emesika@redhat.com</a>&gt;<br>
| &gt; | &gt; | Sent: Monday, July 29, 2013 10:47:01 PM<br>
| &gt; | &gt; | Subject: Re: [Users] upgrade to latest master not working<br>
| &gt; | &gt; |<br>
| &gt; | &gt; |<br>
| &gt; | &gt; |<br>
| &gt; | &gt; | ----- Original Message -----<br>
| &gt; | &gt; | &gt; From: &quot;Dead Horse&quot; &lt;<a href="mailto:deadhorseconsulting@gmail.com">deadhorseconsulting@gmail.com</a>&gt;<br>
| &gt; | &gt; | &gt; To: &quot;Alon Bar-Lev&quot; &lt;<a href="mailto:alonbl@redhat.com">alonbl@redhat.com</a>&gt;<br>
| &gt; | &gt; | &gt; Cc: &quot;users&quot; &lt;<a href="mailto:users@ovirt.org">users@ovirt.org</a>&gt;<br>
| &gt; | &gt; | &gt; Sent: Monday, July 29, 2013 10:41:34 PM<br>
| &gt; | &gt; | &gt; Subject: Re: [Users] upgrade to latest master not working<br>
| &gt; | &gt; | &gt;<br>
| &gt; | &gt; | &gt; server.log attached<br>
| &gt; | &gt; |<br>
| &gt; | &gt; | Thanks!<br>
| &gt; | &gt; |<br>
| &gt; | &gt; | My guess is that I8ce3448a[1] broke master.<br>
| &gt; | &gt; |<br>
| &gt; | &gt; | [1] <a href="http://gerrit.ovirt.org/#/c/14605/" target="_blank">http://gerrit.ovirt.org/#/c/14605/</a><br>
| &gt; | &gt; |<br>
| &gt; | &gt;<br>
| &gt; | &gt; Works perfectly on my Gentoo with master.<br>
| &gt; | &gt;<br>
| &gt; |<br>
| &gt; | I doubt you are upgrading from 3.2 :)<br>
| &gt; |<br>
| &gt;<br>
| &gt; Just did:<br>
| &gt;<br>
| &gt; $ git checkout origin/engine_3.2<br>
| &gt; $ cd backend/manager/dbscripts/<br>
| &gt; $ ./create_db.sh -d upgrade32-test -u engine<br>
| &gt; ~/dev/ovirt/ovirt-engine/backend/manager/dbscripts<br>
| &gt; ~/dev/ovirt/ovirt-engine/backend/manager/dbscripts<br>
| &gt; Creating the database: upgrade32-test<br>
| &gt; dropdb: database removal failed: ERROR:  database &quot;upgrade32-test&quot; does not<br>
| &gt; exist<br>
| &gt; user name is: engine<br>
| &gt; Creating tables...<br>
| &gt; Creating functions...<br>
| &gt; Creating common functions...<br>
| &gt; Inserting data  ...<br>
| &gt; Inserting pre-defined roles ...<br>
| &gt; Running upgrade scripts...<br>
| &gt; upgrade script detected a change in Config, View or Stored Procedure...<br>
| &gt; Running  upgrade sql script upgrade/pre_upgrade/0000_config.sql ...<br>
| &gt;<br>
| &gt; ...<br>
| &gt;<br>
| &gt; Creating stored procedures from vm_templates_sp.sql ...<br>
| &gt; Running  upgrade sql script<br>
| &gt; upgrade/post_upgrade/0010_add_object_column_white_list_table.sql ...<br>
| &gt; Running  upgrade sql script<br>
| &gt; upgrade/post_upgrade/0020_create_materialized_views.sql ...<br>
| &gt; Refreshing materialized views...<br>
| &gt; ~/dev/ovirt/ovirt-engine/backend/manager/dbscripts<br>
| &gt;<br>
| &gt; $ git checkout master<br>
| &gt; $ cd ../../../packaging/dbscripts/<br>
| &gt; $ ./upgrade.sh -d upgrade32-test -u engine<br>
| &gt; upgrade script detected a change in Config, View or Stored Procedure...<br>
| &gt; Running upgrade sql script upgrade/pre_upgrade/0000_config.sql ...<br>
| &gt;<br>
| &gt; ...<br>
| &gt;<br>
| &gt; Creating stored procedures from vms_sp.sql ...<br>
| &gt; Running upgrade sql script<br>
| &gt; upgrade/post_upgrade/0010_add_object_column_white_list_table.sql ...<br>
| &gt; Running upgrade sql script<br>
| &gt; upgrade/post_upgrade/0020_create_materialized_views.sql ...<br>
| &gt; Refreshing materialized views...<br>
| &gt; Done.<br>
| &gt;  <br>
| &gt;<br>
| &gt; Seems to work well. Am I missing something?<br>
| &gt;<br>
|<br>
| Start jboss?<br>
|<br>
| Please take over this issue, you have relevant logs, and a cooperative user.<br>
|<br>
| Thanks,<br>
| Alon<br>
|<br>
<br>
</div></div>Since jboss is up and running very well after upgrade I do not see a problem.<br>
Is it possible that the install / upgrade process didn&#39;t complete due to other<br>
errors ending up with this state?<br>
<br>
In the meantime you can manually create the missing function to get your<br>
setup running. The only problem is that if my assumption is correct on<br>
upgrade not finishing, you will hit the next db change as an error. So<br>
I&#39;d try and look at the install/upgrade log files to see if db upgrade<br>
failed at some point.<br>
</blockquote></div><br></div></div>