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


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

seems there is an issue with akonadi on TW if you are using postgres

docb@T520:~> akonadictl start
Connecting to deprecated signal
docb@T520:~> org.kde.pim.akonadiserver: Starting up the Akonadi
org.kde.pim.akonadiserver: Cluster PG_VERSION is 11 , PostgreSQL
version 12 , will attempt to upgrade the cluster
org.kde.pim.akonadiserver: Postgres db cluster upgrade failed, Akonadi


fail to start. Sorry.



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
--pgdata=$HOME/.local/share/akonadi/db_data --locale=en_US.UTF-8 # check
/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

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