[kdepim-users] Trouble starting konadi database.

Fri May 27 10:40:09 BST 2016

Hi,

the initial warnings (akonadi/akondaiconnectionrc not existing) are to be 
expected, since the file exists only when Akonadi is running. So this is 
basically KMail complaining about Akonadi not running. Then it proceeds to 
start Akonadi, which fails due to the MySQL error, which is the actual problem 
here.

I can see you are on Kubuntu, so I assume you are running with MySQL Community 
Edition 5.7?

There are two things that I notice that I find weird: 

> 2016-05-24 22:17:53 [WARNING] mysql_install_db is deprecated. Please
> consider switching to mysqld --initialize

This means Akonadi calls mysql_install_db: that should not happen if you 
already have an existing database. Or are trying to start with a fresh setup?

> 2016-05-24 22:17:53 [ERROR]   Child process: /usr/sbin/mysqldterminated
> prematurely with errno= 32
> 2016-05-24 22:17:53 [ERROR]   Failed to execute /usr/sbin/mysqld
> --defaults-file=/etc/xdg/akonadi/mysql-global.conf --bootstrap
> --datadir=/home/beatty/.local/share/akonadi/db_data
> --lc-messages-dir=/usr/share/mysql --lc-messages=en_US --basedir=/usr

This has some switches that Akonadi does not pass to mysqld (--bootstrap --lc-
messages --basedir) and it calls with --defaults-file=/etc/xdg/akonadi/mysql-
global.conf, which is also wrong. Akonadi explicitly starts mysqld with 
"mysql.conf" filename, not "mysql-global.conf". I wonder if Kubuntu did some 
patches and messed up? I suggest you open a bug on Kubuntu bug tracker and 
provide them with this information.

We had a problem with Akonadi and MySQL Community Edition 5.7 because they 
removed some command line options so Akonadi wasn't able to start the mysqld 
process anymore. It's possible that Kubuntu tried to do some clever patching 
to make Akonadi work again but did not do it right. I pushed a commit to 
Applications/16.04 branch (namely commit 213e7f9d9) last week that implements 
proper support for MySQL 5.7, I suggest you talk to Kubuntu and ask them to 
replace their patches with this one, which actually works.

Cheers,
Daniel

On Tuesday, May 24, 2016 10:36:09 PM CEST John Beatty wrote:
> To whom ever might be able to help,
> I'm trying to get kontact to run. I launch the command it simply gives
> me the following message "The Akonadi personal information management
> service is not operational."
> 
> I've tried to search the web for possible solutions and I can't seem to
> find one that matches my problem.  As background this system has been
> upgraded from 14.04 to 14.10 to 15.04 to 15.10 to 16.04 and its beta
> versions inbetween.
> 
> To get more information I attempted to run it by  the comand line and it
> gives me a long list of errors. See below.
> The first thing that I see that might be a possible problem is
> "connection config file 'akonadi/akonadiconnectionrc' can not be found".
> Its not there. Is this something I'm missing and if so how do I generate
> it?
> 
> Further down the  output is  "mysqld: [ERROR]  Could not open required
> defaults file: /etc/xdg/akonadi/mysql-global.conf". That file is there
> and here is the listing:
> ls -l /etc/xdg/akonadi/mysql-global.conf
> -rw-r--r-- 1 root root 3659 Apr 20 04:42 /etc/xdg/akonadi/mysql-global.conf
> 
> Thanks in advance,
> John B.
> 
> ============================================================================
> ======================= Running kontact from the terminal:
> "kontact
> "KMail Kernel ETM"
> executing akonadi_control
> ""
> Akonadi Client Session: connection config file
> 'akonadi/akonadiconnectionrc' can not be found in "/home/beatty/.config"
> nor in any of ("/etc/xdg/xdg-plasma", "/etc/xdg",
> "/usr/share/kubuntu-default-settings/kf5-settings")
> connectToServer "/home/beatty/.local/share/akonadi/akonadiserver.socket"
> Akonadi Client Session: connection config file
> 'akonadi/akonadiconnectionrc' can not be found in "/home/beatty/.config"
> nor in any of ("/etc/xdg/xdg-plasma", "/etc/xdg",
> "/usr/share/kubuntu-default-settings/kf5-settings")
> connectToServer "/home/beatty/.local/share/akonadi/akonadiserver.socket"
> log_kidentitymanagement: IdentityManager: There was no default identity.
> Marking first one as default.
> Connecting to deprecated signal
> QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
> search paths:  ("/opt/android-sdk-linux/tools",
> "/opt/android-sdk-linux/platform-tools", "/home/beatty/bin",
> "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin",
> "/bin", "/usr/games", "/usr/local/games", "/snap/bin", "/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"
> Akonadi server is already starting up
> Akonadi server is already starting up
> Akonadi server is already starting up
> Akonadi server is already starting up
> Akonadi server is already starting up
> 2016-05-24 22:17:53 [WARNING] mysql_install_db is deprecated. Please
> consider switching to mysqld --initialize
> 2016-05-24 22:17:53 [ERROR]   Child process: /usr/sbin/mysqldterminated
> prematurely with errno= 32
> 2016-05-24 22:17:53 [ERROR]   Failed to execute /usr/sbin/mysqld
> --defaults-file=/etc/xdg/akonadi/mysql-global.conf --bootstrap
> --datadir=/home/beatty/.local/share/akonadi/db_data
> --lc-messages-dir=/usr/share/mysql --lc-messages=en_US --basedir=/usr
> -- server log begin --
> mysqld: [ERROR] Could not open required defaults file:
> /etc/xdg/akonadi/mysql-global.conf
> mysqld: [ERROR] Fatal error in defaults handling. Program aborted!
> 
> -- server log end --
> Akonadi server is already starting up
> Akonadi server is already starting up
> Akonadi server is already starting up
> Akonadi server is already starting up
> Akonadi server is already starting up
> Akonadi server is already starting up
> "KAddressBook::GlobalContactSession"
> Akonadi server is already starting up
> Akonadi Client Session: connection config file
> 'akonadi/akonadiconnectionrc' can not be found in "/home/beatty/.config"
> nor in any of ("/etc/xdg/xdg-plasma", "/etc/xdg",
> "/usr/share/kubuntu-default-settings/kf5-settings")
> connectToServer "/home/beatty/.local/share/akonadi/akonadiserver.socket"
> Akonadi server is already starting up
> Socket error occurred: "QLocalSocket::connectToServer: Invalid name"
> Socket error occurred: "QLocalSocket::connectToServer: Invalid name"
> org.kde.akonadi.ETM: GEN true false false
> org.kde.akonadi.ETM: collection: QVector()
> org.kde.akonadi.ETM:
> Akonadi server is already starting up
> Akonadi server is already starting up
> Akonadi server is already starting up
> Akonadi server is already starting up
> org.kde.akonadi.ETM: GEN true false true
> org.kde.akonadi.ETM: collection: QVector()
> org.kde.akonadi.ETM: GEN true false true
> org.kde.akonadi.ETM: collection: QVector()
> org.kde.akonadi.ETM: GEN true false true
> org.kde.akonadi.ETM: collection: QVector()
> Socket error occurred: "QLocalSocket::connectToServer: Invalid name"
> org.kde.akonadi.ETM: GEN true false true
> org.kde.akonadi.ETM: collection: QVector()
> QObject::connect: No such signal
> QDBusAbstractInterface::iconChanged(bool,QString,QString)
> Akonadi server is already starting up
> Akonadi server is already starting up
> Akonadi server is already starting up
> finishedLoading "file:///usr/share/kf5/infopage/kde_infopage.css"
> finishedLoading "file:///usr/share/akregator/about/akregator.css"
> "http://www.kde.org/dotkdeorg.rdf"
> "https://www.linux.com/rss/feeds.php"
> "http://planetkde.org/rss20.xml"
> "http://pim.planetkde.org/rss20.xml"
> "http://www.kde.org/dot/kde-apps-content.rdf"
> "http://www.kde.org/kde-look-content.rdf"
> "http://planet.kde-espana.org/atom.xml"
> "http://planet.ubuntu.com/rss20.xml"
> "http://feeds.feedburner.com/ubuntu-fridge"
> "http://www.kubuntu.org/news/feed"
> "http://wire.kubuntu.org/?feed=rss2"
> log_akregator: Couldn't reach favicon service. Request favicon for
> QUrl("http://www.kde.org/")  failed
> log_akregator: Couldn't reach favicon service. Request favicon for
> QUrl("http://planet.ubuntu.com/")  failed
> log_akregator: Couldn't reach favicon service. Request favicon for
> QUrl("http://www.linux.com/")  failed
> log_akregator: Couldn't reach favicon service. Request favicon for
> QUrl("http://pim.planetkde.org/")  failed
> log_akregator: Couldn't reach favicon service. Request favicon for
> QUrl("http://planet.kde-espana.org/")  failed
> log_akregator: Couldn't reach favicon service. Request favicon for
> QUrl("http://feeds.feedburner.com/")  failed
> log_akregator: Couldn't reach favicon service. Request favicon for
> QUrl("http://www.kubuntu.org/")  failed
> log_akregator: Couldn't reach favicon service. Request favicon for
> QUrl("http://wire.kubuntu.org/")  failed
> log_akregator: Couldn't reach favicon service. Request favicon for
> QUrl("http://planetkde.org/")  failed
> log_akregator: Couldn't reach favicon service. Request favicon for
> QUrl("http://www.kde.org/")  failed
> log_akregator: Couldn't reach favicon service. Request favicon for
> QUrl("http://www.kde.org/")  failed
> Database process exited unexpectedly during initial connection!
> executable: "/usr/sbin/mysqld-akonadi"
> arguments:
> ("--defaults-file=/home/beatty/.local/share/akonadi/mysql.conf",
> "--datadir=/home/beatty/.local/share/akonadi/db_data/",
> "--socket=/tmp/akonadi-beatty.zbq90U/mysql.socket")
> stdout: ""
> stderr: "mysqld: [ERROR] Could not open required defaults file:
> /home/beatty/.local/share/akonadi/mysql.conf\nmysqld: [ERROR] Fatal
> error in defaults handling. Program aborted!\n"
> exit code: 1
> process error: "Unknown error"
> terminating service threads
> terminating connection threads
> stopping db process
> mysqladmin: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket
> '/tmp/akonadi-beatty.zbq90U/mysql.socket' (2)'
> Check that mysqld is running and that the socket:
> '/tmp/akonadi-beatty.zbq90U/mysql.socket' exists!
> Failed to remove Unix socket
> Failed to remove runtime connection config file
> Application 'akonadiserver' exited normally...
> ============== SESSION: Server state changed to  4
> Job error:  "Unknown error." for collection: QVector()
> 
> Job error:  "Unknown error." for collection: QVector()
> 
> ============== SESSION: Server state changed to  4
> log_messagelist: Failed to load tags  "Unknown error."
> log_mailcommon: failed to retrieve tags  "Unknown error."
> log_kmail: "Unknown error."
> Job error:  "Unknown error." for collection: QVector()
> 
> Job error:  "Unknown error." for collection: QVector()
> 
> Job error:  "Unknown error." for collection: QVector()
> 
> "Unknown error."
> 4
> ============== SESSION: Server state changed to  4
> Job error:  "Unknown error." for collection: QVector()
> 
> Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )
> Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] Position( 0x0
> "null" : 0 ) Position( 0x0 "null" : 0 )
> 
> Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )
> Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] 0
> 
> [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0
> "null" : 0 )
> 
> less /etc/xdg/akonadi/mysql-global.conf
> 0x2492c08 deleted without having been removed from the factory first.
> This will leak standalone popupmenus and could lead to crashes.
> 0x235ff38 deleted without having been removed from the factory first.
> This will leak standalone popupmenus and could lead to crashes.
> 0x24718f0 deleted without having been removed from the factory first.
> This will leak standalone popupmenus and could lead to crashes.
> 0x24a8848 deleted without having been removed from the factory first.
> This will leak standalone popupmenus and could lead to crashes.
> 0x24ccd78 deleted without having been removed from the factory first.
> This will leak standalone popupmenus and could lead to crashes.
> 0x24b97a8 deleted without having been removed from the factory first.
> This will leak standalone popupmenus and could lead to crashes.
> 0x24e48a8 deleted without having been removed from the factory first.
> This will leak standalone popupmenus and could lead to crashes.
> 0x2453b28 deleted without having been removed from the factory first.
> This will leak standalone popupmenus and could lead to crashes.
> 0x24b6810 deleted without having been removed from the factory first.
> This will leak standalone popupmenus and could lead to crashes."
> 
> 
> _______________________________________________
> KDE PIM users mailing list
> Subscription management: https://mail.kde.org/mailman/listinfo/kdepim-users

-- 
Daniel Vrátil
www.dvratil.cz | dvratil at kde.org
IRC: dvratil on Freenode (#kde, #kontact, #akonadi, #fedora-kde)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kdepim-users/attachments/20160527/cab65ea6/attachment.sig>