Re: Akonadi won't start

On Tuesday, April 19, 2022 2:37:43 PM EDT Paul Brown wrote:
> On Tuesday, 19 April 2022 18:25:58 CEST Mike Diehl wrote:
> > Hi all,
> > 
> > I've been using kde on this machine for several months, now.  But
> > suddenly,
> > akonadi won't start:
> > 
> > 
> > =====================================================================
> > mdiehl@mikeworkstation:~$ akonadictl start
> > 
> > Connecting to deprecated signal
> > QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
> > mdiehl@mikeworkstation:~$ 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/mdiehl/.local/share/akonadi/mysql.conf",
> > "--datadir=/home/mdiehl/.local/share/akonadi/db_data/",
> > "--socket=/run/user/1000/akonadi/mysql.socket",
> > "--pid-file=/run/user/1000/akonadi/mysql.pid") org.kde.pim.akonadiserver:
> > stdout: ""
> > org.kde.pim.akonadiserver: stderr: "mysqld-akonadi: [ERROR] Failed to open
> > required defaults file:
> > /home/mdiehl/.local/share/akonadi/mysql.conf\nmysqld-akonadi: [ERROR]
> > Fatal
> > error in defaults handling. Program aborted!\n" 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/1000/akonadi/mysql.socket' (2)' Check that mysqld is running
> > and
> > that the socket: '/run/user/1000/akonadi/mysql.socket' exists!
> > org.kde.pim.akonadiserver: Failed to remove runtime connection config file
> > org.kde.pim.akonadiserver: Shutting down AkonadiServer...
> > org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited
> > normally...
> > =====================================================================
> > 
> > Any ideas would be most appreciated.
> > 
> > Mike.
> 
> Hey Mike,
> 
> Try moving your akonadi directory out of the way:
> 
> mv .local/share/akonadi/ .local/share/akonadi_old
> 
> And then try starting akonadi again.
> 
> Akonadi will rebuild the databases and you won't loose any emails or
> calendars, although you may have to tweak stuff in you email profiles and
> folders, as, when rebuilding, you may discover that Kmail is now saving sent
> message in... oh... the drafts folder or the trashbin... it can be
> anywhere.
> 
> Another thing that may be affected are your local email filters, and, if you
> have more than one identity, the identity associated with each folder.
> 
> ... Yeah, my setup is a bit clunky.
> 
> Cheers
> 
> Paul

Hi Paul,

Thanks for getting back to me so quickly.

Well, I tried what you suggested:

====================================================
mdiehl@mikeworkstation:~/.local/share$ mv akonadi akonadi.orig

mdiehl@mikeworkstation:~/.local/share$ akonadictl start

Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
mdiehl@mikeworkstation:~/.local/share$ org.kde.pim.akonadiserver: Starting up the Akonadi Server...
mysqld-akonadi: [ERROR] Failed to open required defaults file: /home/mdiehl/.local/share/
mysqld-akonadi: [ERROR] Fatal error in defaults handling. Program aborted!
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/mdiehl/.local/share/akonadi/mysql.conf", "--datadir=/home/mdiehl/.local/share/akonadi/db_data/", "--socket=/run/user/1000/akonadi/mysql.socket", "--pid-file=/run/user/1000/akonadi/mysql.pid")
org.kde.pim.akonadiserver: stdout: ""
org.kde.pim.akonadiserver: stderr: "mysqld-akonadi: [ERROR] Failed to open required defaults file: /home/mdiehl/.local/share/akonadi/mysql.conf\nmysqld-akonadi: [ERROR] Fatal error in defaults handling. Program aborted!\n"
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/1000/akonadi/mysql.socket' (2)'
Check that mysqld is running and that the socket: '/run/user/1000/akonadi/mysql.socket' exists!
org.kde.pim.akonadiserver: Failed to remove runtime connection config file
org.kde.pim.akonadiserver: Shutting down AkonadiServer...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally...

====================================================


It would seem that more drastic measures are required....

Mike.