I upgraded Ubuntu 19.04 to 19.10 and Akonadi (5.11.3) does not start after rebooting. When I try to start the akonadi server in the command line this is what I get:
~$ akonadictl start
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
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/me/.local/share/akonadi/mysql.conf", "--datadir=/home/me/.local/share/akonadi/db_data/", "--socket=/run/user/1001/akonadi/default/mysql.socket", "--pid-file=/run/user/1001/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/1001/akonadi/default/mysql.socket' (2)' Check that mysqld is running and that the socket: '/run/user/1001/akonadi/default/mysql.socket' exists!
org.kde.pim.akonadiserver: Failed to remove runtime connection config file org.kde.pim.akonadiserver: Shutting down AkonadiServer...
I check the mysql.err file with the following input.
~$ cat ~/.local/share/akonadi/db_data/mysql.err
2019-10-19T11:27:02.910707Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2019-10-19T11:27:02.910736Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17-0ubuntu2) starting as process 8385
2019-10-19T11:27:02.912513Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2019-10-19T11:27:02.912523Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead. 2019-10-19T11:27:02.917836Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2019-10-19T11:27:03.171213Z 1 [ERROR] [MY-010781] [Server] Found ./mysql/index_stats.frm file in mysql schema. DD will create .ibd file with same name. Please rename table and start upgrade process again.
2019-10-19T11:27:03.171223Z 1 [ERROR] [MY-010336] [Server] Found .frm file with same name as one of the Dictionary Tables.
2019-10-19T11:27:03.171330Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2019-10-19T11:27:03.171338Z 0 [ERROR] [MY-013236] [Server] The designated data directory /home/me/.local/share/akonadi/db_data/ is unusable. You can remove all files that the server added to it.
2019-10-19T11:27:03.697829Z 0 [ERROR] [MY-010065] [Server] Failed to shutdown components infrastructure.
2019-10-19T11:27:03.171475Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-10-19T11:27:03.697752Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.17-0ubuntu2) (Ubuntu).
Why Akonadi does not start after upgrade from Ubuntu 19.04 to 19.10? Is this connected to the upgrade to mysql 8.0? How can this be solved?