Re: [ovirt-users] Upgrade to 4.2 Postgresql Error

On Thu, Dec 21, 2017 at 4:30 PM, Simone Tiraboschi <stirabos(a)redhat.com&gt; wrote: > > > On Thu, Dec 21, 2017 at 8:41 AM, Sandro Bonazzola <sbonazzo(a)redhat.com&gt; > wrote: > >> >> >> 2017-12-20 16:07 GMT+01:00 Gabriel Stein <gabrielstein(a)gmail.com&gt;: >> >>> Hi! >>> >>> well, I'm a update fever and I decided to update my ovirt to 4.2.0. >>> >> >> Thanks for this valuable feedback! Simone has already replied and will >> check your setup logs. >> >> >> >> >>> >>> How I'm doingi it? >>> >>> I'm following the rules! >>> >>> 1 - Global Maintenance Mode >>> 2 - Yum Install ovirt-release-4.2 >>> 3- yum update ovirt-setup*. >>> >>> But, by the engine-setup I have a conflict with the system collation >>> and postgresql. Unfortunatelly I changed via puppet to the german >>> collation(de_DE-UTF8) of ovirt-engine hosted vm(because it's a standard for >>> us) but this was after the engine-setup and the DB Configuration from >>> Postgresql. >>> >> >> Adding also Didi >> >> >>> >>> I think that I can easily change the system collation to us-US-UFT8 but >>> I'm afraid that I can "destroy" my hosted-engine VM with that change, is >>> hosted-engine so sensible? >>> >>> How I know that error? The logs are saying that(and the error in on >>> postgresql upgrade part of setup)! >>> >>> *Performing Consistency Checks* >>> *-----------------------------* >>> *Checking cluster versions ok* >>> *Checking database user is the install user ok* >>> *Checking database connection settings ok* >>> *Checking for prepared transactions ok* >>> *Checking for reg* system OID user data types ok* >>> *Checking for contrib/isn with bigint-passing mismatch ok* >>> *Checking for invalid "line" user columns ok* >>> *Creating dump of global objects ok* >>> *Creating dump of database schemas* >>> * engine* >>> * ovirt_engine_history* >>> * postgres* >>> * template1* >>> * ok* >>> >>> *lc_collate values for database "postgres" do not match: old >>> "en_US.UTF-8", new "de_DE.UTF-8"* >>> *Failure, exiting* >>> >>> I would be thankful if someone could give me some hint about that! >>> >> > OK, reproduced. > The issue happens if and only if you changed system wide locales after > having installed ovirt-engine but before upgrading it to 4.2. > I'm going to open a bug to track it. > https://bugzilla.redhat.com/show_bug.cgi?id=1528371 > > In engine-setup we are explicitly setting en_US.UTF-8 as the locale of > the engine DB but we are not touching at all the locale of postgres own DB > which match the system wide locale and your issue is indeed on the postgres > DB, not on the engine one. > pg_upgrade cannot change it on the fly on upgrades. > > I tried to find a working fix with env variables but unfortunately > nothing I tired worked. > The only workaround I was able to find is to temporary set the locale you > had at first successful engine-setup execution time (en_US.UTF-8 in your > case but it varies) under /etc/locale.conf and only then execute > engine-setup to upgrade it to 4.2. > After that you could safely switch back /etc/locale.conf to whatever you > need. > All the env variable I tried seams absolutely not relevant for this > specific issue. > > > > >> >>> Best Regards, >>> >>> Gabriel >>> PS: If I go to devconf in Brno I will pay a lot of beers to the >>> developer of the engine-setup rollback! Saved my life! >>> >> >> The specific developer won't be there, but you're welcome to reach oVirt >> people there and share some beer :-) >> >> >> >>> >>> >>> >>> >>> >>> >>> Gabriel Stein >>> ------------------------------ >>> Gabriel Ferraz Stein >>> Tel.: +49 (0) 170 2881531 >>> >>> _______________________________________________ >>> Users mailing list >>> Users(a)ovirt.org >>> http://lists.ovirt.org/mailman/listinfo/users >>> >>> >> >> >> -- >> >> SANDRO BONAZZOLA >> >> ASSOCIATE MANAGER, SOFTWARE ENGINEERING, EMEA ENG VIRTUALIZATION R&D >> >> Red Hat EMEA <https://www.redhat.com/> >> <https://red.ht/sig> >> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> >> >> >> _______________________________________________ >> Users mailing list >> Users(a)ovirt.org >> http://lists.ovirt.org/mailman/listinfo/users >> >> >