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@krop.fr> An: opensuse-factory@opensuse.org 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@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org