[Bug 1850162] [NEW] Akonadi server will not start after upgrade to kubuntu 19.10

[doctordruidphd]

Public bug reported:


After upgrading from kubntu-19.04 to 19.10, the akonadi server will not
start. This means that knotes, kalarm, etc do not work. Manually trying
to start akonadi, as configured for mysql, produces the following:

----------
greenman at Crynfyd19.04 ~/.config/akonadi$ akonadictl start
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
greenman at Crynfyd19.04 ~/.config/akonadi$ org.kde.pim.akonadiserver: Starting up the Akonadi Server...
org.kde.pim.akonadiserver: database server stopped unexpectedly
org.kde.pim.akonadiserver: Database process exited unexpectedly during initial connection!
org.kde.pim.akonadiserver: executable: "/usr/sbin/mysqld-akonadi"
org.kde.pim.akonadiserver: arguments: ("--defaults-file=/home/greenman/.local/share/akonadi/mysql.conf", "--datadir=/home/greenman/.local/share/akonadi/db_data/", "--socket=/run/user/1000/akonadi/default/mysql.socket", "--pid-file=/run/user/1000/akonadi/default/mysql.pid")
org.kde.pim.akonadiserver: stdout: ""
org.kde.pim.akonadiserver: stderr: ""
org.kde.pim.akonadiserver: exit code: 1
org.kde.pim.akonadiserver: process error: "Unknown error"
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/run/user/1000/akonadi/default/mysql.socket' (2)'
Check that mysqld is running and that the socket: '/run/user/1000/akonadi/default/mysql.socket' exists!
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...

----------

Switching akonadi to postgresql using the instructions found here
(modified for local installation): https://www.enricozini.org/blog/2015
/akonadi-install/

----------
greenman at Crynfyd19.04 ~/.local/share/akonadi$ akonadictl start
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
greenman at Crynfyd19.04 ~/.local/share/akonadi$ org.kde.pim.akonadiserver: Starting up the Akonadi Server...
The files belonging to this database system will be owned by user "greenman".
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.

fixing permissions on existing directory /home/greenman/.local/share/akonadi/db_data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default timezone ... America/Los_Angeles
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    /usr/lib/postgresql/11/bin/pg_ctl -D
/home/greenman/.local/share/akonadi/db_data -l logfile start

org.kde.pim.akonadiserver: Failed to create database
org.kde.pim.akonadiserver: Query error: "ERROR:  syntax error at or near \"-\"\nLINE 1: CREATE DATABASE akonadi-greenman\n                               ^\n(42601) QPSQL: Unable to create query"
org.kde.pim.akonadiserver: Database error: "could not connect to server: No such file or directory\n\tIs the server running locally and accepting\n\tconnections on Unix domain socket \"/run/user/1000/akonadi/default/.s.PGSQL.5432\"?\nQPSQL: Unable to connect"
waiting for server to shut down.... done
server stopped
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...

----------

Attempting to start the server with the line metioned above:

----------
greenman at Crynfyd19.04 ~/.local/share/akonadi$ /usr/lib/postgresql/11/bin/pg_ctl -D /home/greenman/.local/share/akonadi/db_data -l logfile start
waiting for server to start.... stopped waiting
pg_ctl: could not start server
Examine the log output.

----------

And the logfile is:

----------
greenman at Crynfyd19.04 ~/.local/share/akonadi$ cat logfile
2019-10-28 07:56:40.520 PDT [3139] LOG:  could not bind IPv4 address "127.0.0.1": Address already in use
2019-10-28 07:56:40.520 PDT [3139] HINT:  Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
2019-10-28 07:56:40.520 PDT [3139] WARNING:  could not create listen socket for "localhost"
2019-10-28 07:56:40.531 PDT [3139] FATAL:  could not create any TCP/IP sockets
2019-10-28 07:56:40.531 PDT [3139] LOG:  database system is shut down
----------

According to lsof there is nothing else using port 5432; I have opened
the port with ufw, so there should be no access problem.

Still, it will not start. I have tried deleting both
~/.local/share/akonadi and ~/.config/akonadi, reinstalling and
reconfiguring akonadi-server. So far nothing has worked.

----------

greenman at Crynfyd19.04 ~/.local/share/akonadi$ lsb_release -rd
Description:    Ubuntu 19.10
Release:        19.10

greenman at Crynfyd19.04 ~/.local/share/akonadi$ apt-cache policy akonadi-server
akonadi-server:
  Installed: 4:19.04.3-0ubuntu3
  Candidate: 4:19.04.3-0ubuntu3
  Version table:
 *** 4:19.04.3-0ubuntu3 500
        500 http://us.archive.ubuntu.com/ubuntu eoan/universe amd64 Packages
        100 /var/lib/dpkg/status

** Affects: akonadi (Ubuntu)
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Kubuntu
Bugs, which is subscribed to akonadi in Ubuntu.
https://bugs.launchpad.net/bugs/1850162

Title:
  Akonadi server will not start after upgrade to kubuntu 19.10

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1850162/+subscriptions