[Users] update from 3.3 beta to RC failed during db upgrade

[Alon Bar-Lev]

----- Original Message -----
> From: "Eli Mesika" <emesika at redhat.com>
> To: "Alon Bar-Lev" <alonbl at redhat.com>
> Cc: "Alex Lourie" <alourie at redhat.com>, "Jakub Bittner" <j.bittner at nbu.cz>, users at ovirt.org
> Sent: Wednesday, August 28, 2013 4:22:06 PM
> Subject: Re: [Users] update from 3.3 beta to RC failed during db upgrade
> 
> 
> 
> ----- Original Message -----
> > From: "Alon Bar-Lev" <alonbl at redhat.com>
> > To: "Eli Mesika" <emesika at redhat.com>
> > Cc: "Alex Lourie" <alourie at redhat.com>, "Jakub Bittner" <j.bittner at nbu.cz>,
> > users at ovirt.org
> > Sent: Tuesday, August 27, 2013 7:54:15 PM
> > Subject: Re: [Users] update from 3.3 beta to RC failed during db upgrade
> > 
> > 
> > 
> > ----- Original Message -----
> > > From: "Eli Mesika" <emesika at redhat.com>
> > > To: "Alex Lourie" <alourie at redhat.com>, "Alon Bar-Lev"
> > > <alonbl at redhat.com>
> > > Cc: "Jakub Bittner" <j.bittner at nbu.cz>, users at ovirt.org
> > > Sent: Tuesday, August 27, 2013 6:59:10 PM
> > > Subject: Re: [Users] update from 3.3 beta to RC failed during db upgrade
> > > 
> > > 
> > > 
> > > ----- Original Message -----
> > > > From: "Alex Lourie" <alourie at redhat.com>
> > > > To: "Jakub Bittner" <j.bittner at nbu.cz>
> > > > Cc: "Alon Bar-Lev" <alonbl at redhat.com>, "Eli Mesika"
> > > > <emesika at redhat.com>,
> > > > users at ovirt.org
> > > > Sent: Tuesday, August 27, 2013 6:45:13 PM
> > > > Subject: Re: [Users] update from 3.3 beta to RC failed during db
> > > > upgrade
> > > > 
> > > > I think we already have such a tool. Will check with Eli and update.
> > > 
> > > I have such a script , do you want me to post it upstream ???
> > 
> > Yes, it will be great.
> 
> Should that be located in dbscripts or dbutils (or you don't mind ....)

Better dbutils no? so it comes with setup, as dbscripts is versionlocked.

> 
> > 
> > It should be run on 3.2 and prepare it to upgrade in case of post-restore.
> > 
> > > 
> > > > 
> > > > --
> > > > 
> > > > Best regards,
> > > > 
> > > > Alex Lourie
> > > > Software Developer in Integration
> > > > Red Hat
> > > > 
> > > > 
> > > > ----- Original Message -----
> > > > > From: "Jakub Bittner" <j.bittner at nbu.cz>
> > > > > To: "Alon Bar-Lev" <alonbl at redhat.com>
> > > > > Cc: "Alex Lourie" <alourie at redhat.com>, "Eli Mesika"
> > > > > <emesika at redhat.com>,
> > > > > users at ovirt.org
> > > > > Sent: Tuesday, August 27, 2013 6:31:11 PM
> > > > > Subject: Re: [Users] update from 3.3 beta to RC failed during db
> > > > > upgrade
> > > > > 
> > > > > Dne 27.8.2013 16:13, Alon Bar-Lev napsal(a):
> > > > > >
> > > > > > ----- Original Message -----
> > > > > >> From: "Jakub Bittner" <j.bittner at nbu.cz>
> > > > > >> Cc: users at ovirt.org
> > > > > >> Sent: Tuesday, August 27, 2013 4:33:34 PM
> > > > > >> Subject: Re: [Users] update from 3.3 beta to RC failed during db
> > > > > >> upgrade
> > > > > >>
> > > > > >> Dne 26.8.2013 15:13, Alex Lourie napsal(a):
> > > > > >>> Sure, I'll investigate.
> > > > > >>>
> > > > > >> Maybe I found a problem which causes function owner to be postgre.
> > > > > >> I
> > > > > >> use
> > > > > >> restore command as postgre (as on wiki:
> > > > > >> http://wiki.ovirt.org/User:Adrian15/oVirt_engine_migration#Restore_Postgresql_database
> > > > > >> )
> > > > > >>
> > > > > >> cd /usr/share/ovirt-engine/dbscripts
> > > > > >> ./restore.sh -u postgres -f /path/to/engine_sql_DATE.sql -r
> > > > > > Nice!
> > > > > > Thank you!
> > > > > >
> > > > > > Eli, can you please confirm, or suggest alternate way.
> > > > > >
> > > > > > We should probably provide a script to change ownership for users
> > > > > > who
> > > > > > made
> > > > > > restore.
> > > > > >
> > > > > > Regards,
> > > > > > Alon
> > > > > That script would be perfect, because I dont know how to easily
> > > > > switch
> > > > > owner of function.
> > > > > 
> > > > > Last time I did it by exporting db, manually change owner postgre to
> > > > > owner engine in sql backup file and restore db from it.
> > > > > 
> > > > 
> > > 
> > 
>