Hello, I cannot start Kontact and KMail, receive "the akonadi personal information management service is not operational" error. After running "akonadictl start" have following error:

Code: Select all

➜  akonadictl start
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
➜  akonadi 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"
org.kde.pim.akonadiserver: arguments: ("--defaults-file=/home/dmitry/.local/share/akonadi/mysql.conf", "--datadir=/home/dmitry/.local/share/akonadi/db_data/", "--socket=/tmp/akonadi-dmitry.y782rn/mysql.socket", "--pid-file=/tmp/akonadi-dmitry.y782rn/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 '/tmp/akonadi-dmitry.y782rn/mysql.socket' (2)'
Check that mysqld is running and that the socket: '/tmp/akonadi-dmitry.y782rn/mysql.socket' exists!
org.kde.pim.akonadiserver: Failed to remove runtime connection config file
org.kde.pim.akonadicontrol: Application 'akonadiserver' exited normally...


How to make this apps working? Tried to remove files from ~/.local/share/akonadi, but not helped.

OS Fedora 28, plasma version 5.13.3, KDE frameworks version 5.48.0

I have a similar error running
KDE Plasma 5.12.0
KDE Frameworks 5.44.0
Under KUbuntu 18.04

akonadictl start
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
tonbaz@muscat:~$ 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/tonbaz/.local/share/akonadi/mysql.conf", "--datadir=/home/tonbaz/.local/share/akonadi/db_data/", "--socket=/tmp/akonadi-tonbaz.2Xobxp/mysql.socket", "--pid-file=/tmp/akonadi-tonbaz.2Xobxp/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"
org.kde.pim.akonadiserver: Failed to remove runtime connection config file
org.kde.pim.akonadicontrol: Application 'akonadiserver' exited normally...

Looks like something might be wrong with the MySQL installation on your system. Check if there's an error file in ~/.local/share/akonadi (or ~/.local/share/akonadi/db_data)

Thanks - error is below

cat .local/share/akonadi/db_data/mysql.err
2018-09-12T22:41:51.001008Z 0 [Warning] The syntax '--log_warnings/-W' is deprecated and will be removed in a future release. Please use '--log_error_verbosity' instead.
2018-09-12T22:41:51.001092Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-09-12T22:41:51.001108Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2018-09-12T22:41:51.001140Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2018-09-12T22:41:51.001167Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.18.04.1) starting as process 15336 ...
2018-09-12T22:41:51.006099Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-09-12T22:41:51.006119Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-09-12T22:41:51.006126Z 0 [Note] InnoDB: Uses event mutexes
2018-09-12T22:41:51.006132Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-09-12T22:41:51.006138Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-09-12T22:41:51.006144Z 0 [Note] InnoDB: Using Linux native AIO
2018-09-12T22:41:51.006487Z 0 [Note] InnoDB: Number of pools: 1
2018-09-12T22:41:51.006608Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-09-12T22:41:51.008432Z 0 [Note] InnoDB: Initializing buffer pool, total size = 80M, instances = 1, chunk size = 80M
2018-09-12T22:41:51.016713Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-09-12T22:41:51.018390Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-09-12T22:41:51.028594Z 0 [ERROR] InnoDB: The Auto-extending innodb_system data file './ibdata1' is of a different size 640 pages (rounded down to MB) than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!
2018-09-12T22:41:51.028638Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2018-09-12T22:41:51.629263Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2018-09-12T22:41:51.629317Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-09-12T22:41:51.629331Z 0 [ERROR] Failed to initialize builtin plugins.
2018-09-12T22:41:51.629338Z 0 [ERROR] Aborting

2018-09-12T22:41:51.629347Z 0 [Note] Binlog end
2018-09-12T22:41:51.629381Z 0 [Note] Shutting down plugin 'CSV'
2018-09-12T22:41:51.629595Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

Never saw this before, but googling the error message turned out with this: https://ximalas.info/2016/05/18/mysql-5 ... too-small/ - just update ~/.local/share/akonadi/my.conf instead of /var/run/...

Sorry for the delay in responding, but I decided to do a "clean" install of Kontact, or at least a new installation on using the same home partition.
Unfortunately re installation did not resulted in any change

As I didn't have any data stored I decided to do a completely new installation

sudo apt-get purge kontact
sudo apt autoremove
mv akonadi akonadi_20181009
sudo apt-get kontact

A new akonadi directory was created on restarting kontact

This seems to have done the trick