Bug#924788: /usr/bin/akonadictl: aKonadi server with postgreSQL backend fails to start after buster upgrade

[Hefee]

Control: tags -1 +moreinfo unreproducible 

Hey,

Sorry that I haven't found time to look to it further.

>From the file list it seems like you switched to from PostgresQL backend to 
Mysql backend by dist-upgrade and than started it. That removed all of the 
postgres cluster. Maybe the config that selected the PostgresQL was removed 
while the upgrade? I need more information in order to fix anything.

> I expect that aKonadi should be using postgreSQL 11, not 9.6, but that it
> will auto-migrate my data.

I don't know when this support was added to Akonadi, but bookworm will support 
for sure automatic upgrades to new PostgresQL versions.

Regards,

hefee


signature.asc
Description: This is a digitally signed message part.

Bug#924788: /usr/bin/akonadictl: aKonadi server with postgreSQL backend fails to start after buster upgrade

[Boyd Stephen Smith Jr.]

Package: akonadi-server
Version: 4:18.08.3-4
Severity: normal
File: /usr/bin/akonadictl

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Dear Maintainer,

*** Reporter, please consider answering these questions, where appropriate ***

Upgraded to buster last night, including cleaning up any stragling *.dpkg-* and
*.ucf-* files.  Rebooted this morning to get into new kernel.  Kmail couldn't
start aKonadi automatically.  It also failed to start from the command-line.

- ---8<---
% akonadictl start
Connecting to deprecated signal 
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
The files belonging to this database system will be owned by user "bss".
   ~
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are enabled.

initdb: directory "/home/bss/.local/share/akonadi/db_data" exists but is not 
empty
If you want to create a new database system, either remove or empty
the directory "/home/bss/.local/share/akonadi/db_data" or run initdb
with an argument other than "/home/bss/.local/share/akonadi/db_data".
org.kde.pim.akonadiserver: Database process exited unexpectedly during initial 
connection!
org.kde.pim.akonadiserver: executable: "/usr/lib/postgresql/9.6/bin/pg_ctl"
org.kde.pim.akonadiserver: arguments: ("start", "-w", "--timeout=10", 
"--pgdata=/home/bss/.local/share/akonadi/db_data", "-o \"-klocalhost\" -h ''")
org.kde.pim.akonadiserver: stdout: ""
org.kde.pim.akonadiserver: stderr: "LOG:  skipping missing configuration file 
\"/home/bss/.local/share/akonadi/db_data/postgresql.auto.conf\"\npg_ctl: 
directory \"/home/bss/.local/share/akonadi/db_data\" is not a database cluster 
directory\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.akonadicontrol: Application 'akonadiserver' exited normally...

% find /home/bss/.local/share/akonadi/db_data -ls
   120368  0 drwxr-xr-x   1 bss  bss   242 Jun  4  2012 
/home/bss/.local/share/akonadi/db_data
   120372  0 drwx--   1 bss  bss   920 Aug  5  2010 
/home/bss/.local/share/akonadi/db_data/akonadi
   121225 12 -rw-rw   1 bss  bss  8664 Aug  5  2010 
/home/bss/.local/share/akonadi/db_data/akonadi/collectionattributetable.frm
   121226112 -rw-rw   1 bss  bss114688 Dec 20  2011 
/home/bss/.local/share/akonadi/db_data/akonadi/collectionattributetable.ibd
   121227 12 -rw-rw   1 bss  bss  8622 Aug  5  2010 
/home/bss/.local/share/akonadi/db_data/akonadi/collectionmimetyperelation.frm
   121228 96 -rw-rw   1 bss  bss 98304 Dec 20  2011 
/home/bss/.local/share/akonadi/db_data/akonadi/collectionmimetyperelation.ibd
   121229 12 -rw-rw   1 bss  bss  8620 Aug  5  2010 
/home/bss/.local/share/akonadi/db_data/akonadi/collectionpimitemrelation.frm
   121230 96 -rw-rw   1 bss  bss 98304 Aug  5  2010 
/home/bss/.local/share/akonadi/db_data/akonadi/collectionpimitemrelation.ibd
   121231 12 -rw-rw   1 bss  bss  9074 Aug  5  2010 
/home/bss/.local/share/akonadi/db_data/akonadi/collectiontable.frm
   121232112 -rw-rw   1 bss  bss114688 Dec 20  2011 
/home/bss/.local/share/akonadi/db_data/akonadi/collectiontable.ibd
   121233  4 -rw-rw   1 bss  bss65 Aug  5  2010 
/home/bss/.local/share/akonadi/db_data/akonadi/db.opt
   121234 12 -rw-rw   1 bss  bss  8586 Aug  5  2010 
/home/bss/.local/share/akonadi/db_data/akonadi/flagtable.frm
   121235112 -rw-rw   1 bss  bss114688 Aug  5  2010 
/home/bss/.local/share/akonadi/db_data/akonadi/flagtable.ibd
   121236 12 -rw-rw   1 bss  bss  8586 Aug  5  2010 
/home/bss/.local/share/akonadi/db_data/akonadi/mimetypetable.frm
   121237112 -rw-rw   1 bss  bss114688 Aug 18  2010 
/home/bss/.local/share/akonadi/db_data/akonadi/mimetypetable.ibd
   121238 12 -rw-rw   1 bss  bss  8768 Aug  5  2010 
/home/bss/.local/share/akonadi/db_data/akonadi/parttable.frm
   121239  11264 -rw-rw   1 bss  bss  11534336 Jun  1  2012 
/home/bss/.local/share/akonadi/db_data/akonadi/parttable.ibd
   121240 12 -rw-rw   1 bss  bss  8608 Aug  5  2010 
/home/bss/.local/share/akonadi/db_data/akonadi/pimitemflagrelation.frm
   121241 96 -rw-rw   1 bss  bss 98304 Aug  5  2010 
/home/bss/.local/share/akonadi/db_data/akonadi/pimitemflagrelation.ibd
   121242 12 -rw-rw   1 bss  bss  8842 Aug  5  2010