[opensuse-factory] akonadi fails to start with latest TW (20200128) - postgres changes version - openSUSE Factory

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

Axel Braun

30 Jan 2020 30 Jan '20

09:27

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

Show replies by date

Christophe Giboudeaux

30 Jan 30 Jan

09:49

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

Axel Braun

10:35

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

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

Hans-Peter Jansen

10:49

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

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

Knurpht-openSUSE

16:40

New subject: 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

Hans-Peter Jansen

19:31

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

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

1559

Age (days ago)

1559

Last active (days ago)

List overview

Download

5 comments

5 participants

participants (5)

Axel Braun
Axel Braun
Christophe Giboudeaux
Hans-Peter Jansen
Knurpht-openSUSE