[Bug 1876398] Re: Akonadi Console Launch: Failed to connect to database: Can't connect to local MySQL server through socket '/run/user/1000/akonadi/mysql.socket' (2) QMYSQL: Unable to connect

[Encolpe Degoute]

This bug last for years around akonadictl. 
What seems to happen: the mysql crash partialy letting a mysqld-ak process locking the $HOME/.local/share/akonadi/db_data/ibdata1 file. I don't know why but other files seem to block the restart.

So:
1. Verify that the akonadictl is stopped 
2. Kill the mysqld-ak process
3. Cleanup files
4. Restart akonadictl

akonadictl stop  #Optional
cd $HOME/.local/share/akonadi/db_data
kill $(lsof $HOME/.local/share/akonadi/db_data/ibdata1 | cut -d ' ' -f 2)
rm mysql.err* multi-master.info ib_logfile* aria_log*
akonadictl --verbose start

This not fix the upstream bug that crash the mysqld service.

In some extrem case I remove the $HOME/.local/share/akonadi/db_data folder.
You will loose your IMAP cache but not your account configuration.

-- 
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/1876398

Title:
  Akonadi Console Launch: Failed to connect to database: Can't connect
  to local MySQL server through socket
  '/run/user/1000/akonadi/mysql.socket' (2) QMYSQL: Unable to connect

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