(Solved) Upgrade from MySQL to MariaDB breaks Akonadi

[Volker Wysk]

Am Montag, 14. August 2017, 10:11:13 CEST schrieb Daniel Vrátil:
>  MySQL to MariaDB, Akonadi won't start any longer. This
> 
> > happens on Kubuntu, but it could also happen somewhere else.
> > 
> > The package mariadb-server needs to be installed for MariaDB (again, on
> > (K)Ubuntu).
> > 
> > This replaces MySQL (mysql-server-core-5.7 and mysql-client-core-5.7).
> > After that, Akonadi won't start any longer. "aconadictl start" outputs a
> > lot of messages.
> 
> Do you have any of those messages so that we can try to fix the problem?

I'm afraid I can't reproduce the problem any longer, after ~/.local/share/
akonadi has been deleted and regenerated. However I have two snippets. 

This is in ~/.local/share/akonadi/akonadiserver.error:

---snip---
"\nSql error: Table 'akonadi.tagremoteidresourcerelationtable' doesn't exist 
in engine QMYSQL: Unable to execute query\nQuery: ALTER TABLE 
TagRemoteIdResourceRelationTable ADD COLUMN tagId BIGINT NOT NULL" 
Unable to initialize database. 
---snip---

This was the output of "akonadictl start":

---snip---
Starting Akonadi Server...
   done.
Connecting to deprecated signal 
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
desktop ~ $ akonadiprivate_log: search paths:  ("/root/bin", "/home/v/bin", "/
sbin", "/usr/sbin", "/bin", "/usr/bin", "/usr/local/bin", "/usr/local/sbin", 
"/usr/bin/X11", "/usr/local/opt/kde/kdesrc-build", "/usr/sbin", "/usr/local/
sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/
local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db:  "/usr/bin/mysql_install_db"
Found mysqlcheck:  "/usr/bin/mysqlcheck"
Using mysqld: "/usr/sbin/mysqld-akonadi"
mysqld reports version 10.0.31 (MariaDB)
Executing: "/usr/sbin/mysqld-akonadi" "--defaults-file=/home/v/.local/share/
akonadi/mysql.conf --datadir=/home/v/.local/share/akonadi/db_data/ --socket=/
tmp/akonadi-v.FJ0ric/mysql.socket"
Database process exited unexpectedly during initial connection!
executable: "/usr/sbin/mysqld-akonadi"
arguments: ("--defaults-file=/home/v/.local/share/akonadi/mysql.conf", "--
datadir=/home/v/.local/share/akonadi/db_data/", "--socket=/tmp/akonadi-
v.FJ0ric/mysql.socket")
stdout: ""
stderr: "170810 19:14:15 [Note] /usr/sbin/mysqld (mysqld 10.0.31-
MariaDB-0ubuntu0.16.04.2) starting as process 30749 ...\n"
exit code: 1
process error: "Unknown error"
terminating service threads
terminating connection threads
stopping db process
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/akonadi-
v.FJ0ric/mysql.socket' (2 "No such file or directory")'
Check that mysqld is running and that the socket: '/tmp/akonadi-v.FJ0ric/
mysql.socket' exists!
Failed to remove Unix socket
Failed to remove runtime connection config file
Application 'akonadiserver' exited normally...
---snip---

Hope this helps!

Bye
Volker