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