Summary: | Unable to spawn mysqld server with mariadb 10.1 | ||
---|---|---|---|
Product: | [Frameworks and Libraries] Akonadi | Reporter: | Bruno J. <maxijac> |
Component: | server | Assignee: | kdepim bugs <kdepim-bugs> |
Status: | RESOLVED NOT A BUG | ||
Severity: | grave | CC: | dvratil, guillaume.debure, rapiteanu.catalin |
Priority: | NOR | ||
Version: | unspecified | ||
Target Milestone: | --- | ||
Platform: | Arch Linux | ||
OS: | Linux | ||
Latest Commit: | Version Fixed In: | ||
Sentry Crash Report: |
Description
Bruno J.
2015-11-27 22:44:49 UTC
Confirmed here also on akonadi 15.11.80 on archlinux @maxijac, can't find any evidence of defaults-file being dropped, could you find this information somewhere ? I got this solved by deleting the whole ~/.local/share/akonadi. However, this is not the way to go, so I propose to leave this bug opened, as it is a sign that something changed between mariadb 10.1.8 and 10.1.9 that prevents akonadi from starting... I did not find any evidence of --defaults-file being dropped, I can only assume. By removing the whole configuration of akonadi you probably reverted to another DB backend like sqlite but it is not a solution. Nope, my backend is still mysql, I did not change my ~/.config/akonadiserverrc : [Debug] Tracer=null [%General] Driver=QMYSQL [QMYSQL] Host= Name=akonadi Options="UNIX_SOCKET=/tmp/akonadi-guillaume.xVlx6G/mysql.socket" ServerPath=/usr/bin/mysqld StartServer=true But I agree there must be a more elegant solution than removing the entire akonadi folder, as this means (in my case) resynchronisation of my whole imap accounts I tried this earlier and it did not change anything for me. Can you "ps aux | grep mysqld" and give the command line invocation of mysqld please? Make sure to wait a bit after startup of akonadi as the several retries may skew the test. ps aux | grep mysqld /usr/bin/mysqld --defaults-file=/home/guillaume/.local/share/akonadi/mysql.conf --datadir=/home/guillaume/.local/share/akonadi/db_data/ --socket=/tmp/akonadi-guillaume.xVlx6G/mysql.socket I have to add that I did a few things before deleting /.local/share/akonadi : chown mysql:mysql /var/lib/mysql -R (there were indeed some permission issues) mysql_upgrade (both commands issued after reading the very excellent archlinux wiki on mysql troubleshooting : https://wiki.archlinux.org/index.php/MySQL#Troubleshooting) Maybe it is the combination of the three actions that solved it for me ? Indeed, this bug is so weird. So I kind of fixed it on my side too. I fixed it by wiping the entire db in .local/. The weird part is that it is indeed still called with "defaults-file" and works. But if I call mysqld with tha same parameters AND -v il rejects the option and quits with an error. So the error is not in akonadi. Not sure why mysqld does that though. Apparently --defaults-file *MUST* be the first switch on the command line, otherwise MySQL complains (this is behavior is documented in mysqld man pages). |