Mailinglist Archive: opensuse-factory (365 mails)

< Previous Next >
Re: Aw: Re: [opensuse-factory] akonadi fails to start with latest TW (20200128) - postgres changes version
  • From: Knurpht-openSUSE <knurpht@xxxxxxxxxxxx>
  • Date: Thu, 30 Jan 2020 16:40:15 +0100
  • Message-id: <7528857.lg8glRMNfM@knurpht-hp>
Op donderdag 30 januari 2020 10:49:21 CET schreef Hans-Peter Jansen:
Am Donnerstag, 30. Januar 2020, 10:35:19 CET schrieb Axel Braun:
Hello Christophe

Gesendet: Donnerstag, 30. Januar 2020 um 09:49 Uhr
Von: "Christophe Giboudeaux" <christophe@xxxxxxx>
An: opensuse-factory@xxxxxxxxxxxx
Betreff: Re: [opensuse-factory] akonadi fails to start with latest TW

(20200128) - postgres changes version

Hello,

On jeudi 30 janvier 2020 09:27:34 CET Axel Braun wrote:
Hi,

seems there is an issue with akonadi on TW if you are using postgres
as
database-backend:

docb@T520:~> akonadictl start
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
docb@T520:~> org.kde.pim.akonadiserver: Starting up the Akonadi
Server...
(QFileInfo(/usr/lib/postgresql/bin),
QFileInfo(/usr/lib/postgresql/lib64))
org.kde.pim.akonadiserver: Cluster PG_VERSION is 11 , PostgreSQL
server
is
version 12 , will attempt to upgrade the cluster
org.kde.pim.akonadiserver: Postgres db cluster upgrade failed, Akonadi

will

fail to start. Sorry.

Read
https://userbase.kde.org/Akonadi#How_to_upgrade_my_PostgreSQL_database.

3F

Well, I did not know that page, but this is basically how I proceeded as
well. Important is to keep the locale-setting to the one the akonadi-db is
created (usually en_US.UTF-8). I hit that trap....

Now akonadi is working again

Writing this *after* todays upgrade, before reboot!

Here are my notes (given, you have backups):

export OLD=11
export NEW=12
sudo zyp in postgresql$NEW-contrib
# stop akonadi
akonadictl stop
# move away old db
mv $HOME/.local/share/akonadi/db_data
$HOME/.local/share/akonadi/db_data_$OLD # create new db
/usr/lib/postgresql$NEW/bin/initdb
--pgdata=$HOME/.local/share/akonadi/db_data --locale=en_US.UTF-8 # check
upgrade
/usr/lib/postgresql$NEW/bin/pg_upgrade -b /usr/lib/postgresql$OLD/bin -B
/usr/lib/postgresql$NEW/bin -d $HOME/.local/share/akonadi/db_data_$OLD -D
$HOME/.local/share/akonadi/db_data --check # perform upgrade, if no issues
/usr/lib/postgresql$NEW/bin/pg_upgrade -b /usr/lib/postgresql$OLD/bin -B
/usr/lib/postgresql$NEW/bin -d $HOME/.local/share/akonadi/db_data_$OLD -D
$HOME/.local/share/akonadi/db_data # start akonadi
akonadictl start
# check consistency
akonadictl fsck

Last command took about 20 minutes for

$ du -sh .local/share/akonadi/db_data
32G .local/share/akonadi/db_data

Cheers,
Pete
Thanks Pete.

Some notes:
- This recreates the ID's of the collections it seems, hence all ~20 filters
move posts on the MLs to the wrong folders. Also declared some locally
archived folders to Unread ( where all messages had been read before ). All in
all quite some work and waiting for things to finish. Then again, all well and
pretty snappy now.

--
Gertjan Lettink a.k.a. Knurpht
openSUSE Board Member
openSUSE Forums Team


--
To unsubscribe, e-mail: opensuse-factory+unsubscribe@xxxxxxxxxxxx
To contact the owner, e-mail: opensuse-factory+owner@xxxxxxxxxxxx

< Previous Next >
Follow Ups