(Solved) Upgrade from MySQL to MariaDB breaks Akonadi

[Volker Wysk]

Hello!

When you upgrade 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.

The problem can be repaired by doing this, after the installation of MariaDB:

akonadictl stop
rm -r ~/.local/share/akonadi
akonadictl start

Bye,
Volker

[Daniel Vrátil]

Post by Volker Wysk
Hello!
When you upgrade 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?

Post by Volker Wysk
akonadictl stop
rm -r ~/.local/share/akonadi
akonadictl start
Bye,
Volker

[Volker Wysk]

Post by Volker Wysk
MySQL to MariaDB, Akonadi won't start any longer. This

Post by Volker Wysk
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