[opensuse-factory] akonadi fails to start with latest TW (20200128) - postgres changes version
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. org.kde.pim.akonadiserver: Database process exited unexpectedly during initial connection! org.kde.pim.akonadiserver: executable: "/usr/bin/pg_ctl" org.kde.pim.akonadiserver: arguments: ("start", "-w", "--timeout=10", "--pgdata=/home/docb/.local/share/akonadi/db_data", "-o \"-k/tmp/akonadi-docb.N9ni6K\" -h ''") org.kde.pim.akonadiserver: stdout: "warte auf Start des Servers....2020-01-30 09:19:14.655 CET [5520]FATAL: Datenbankdateien sind inkompatibel mit Server\n2020-01-30 09:19:14.655 CET [5520]DETAIL: Das Datenverzeichnis wurde von PostgreSQL Version 11 initialisiert, welche nicht mit dieser Version 12.1 kompatibel ist.\n Warten beendet\n" org.kde.pim.akonadiserver: stderr: "pg_ctl: konnte Server nicht starten\nPr\xC3\xBC""fen Sie die Logausgabe.\n" org.kde.pim.akonadiserver: exit code: 1 org.kde.pim.akonadiserver: process error: "Unknown error" org.kde.pim.akonadiserver: Failed to remove runtime connection config file org.kde.pim.akonadiserver: Shutting down AkonadiServer... org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally... Just a heads-up, will now look into the conversion options Cheers Axel -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
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 -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
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 Thanks Axel -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
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
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
Am Donnerstag, 30. Januar 2020, 16:40:15 CET schrieb Knurpht-openSUSE:
Op donderdag 30 januari 2020 10:49:21 CET schreef Hans-Peter Jansen:
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 ).
Should have mentioned, I'm an IMAP only shop here (cyrus for historical reasons, but sieve is working quite well there). Well, apart from this local maildir thingy..
All in all quite some work and waiting for things to finish.
No fun - remembers me at the horrors of a full akonadi init. Takes several days and suffers from some conceptual issues (account indexes change).
Then again, all well and pretty snappy now.
Yeah, kmail with Postgres is blazingly fast, compared to other MUAs on huge piles of mails. Cheers, Pete -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
participants (5)
-
Axel Braun -
Axel Braun
-
Christophe Giboudeaux -
Hans-Peter Jansen -
Knurpht-openSUSE