Re: Aw: Re: [opensuse-factory] akonadi fails to start with latest TW (20200128) - postgres changes version

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" 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