[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
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 -- kubuntu-bugs mailing list kubuntu-b...@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/kubuntu-bugs
[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
** Changed in: akonadi (Ubuntu) Status: Confirmed => Invalid -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to 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 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[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
Status changed to 'Confirmed' because the bug affects multiple users. ** Changed in: akonadi (Ubuntu) Status: New => Confirmed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to 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 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[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
Attached the log from akonadictl --verbose stop ** Attachment added: "akonadi-stop-log.txt" https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1876398/+attachment/5371797/+files/akonadi-stop-log.txt -- 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 -- kubuntu-bugs mailing list kubuntu-b...@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/kubuntu-bugs
[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
Attached the crashlog, unfortunately I couldn't get all of the symbols but I can reproduce the bug 100% of the time, so if somebody how to get the debug symbols I'll be happy to help. ** Attachment added: "akonadiserver-20200515-022504.kcrash.txt" https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1876398/+attachment/5371796/+files/akonadiserver-20200515-022504.kcrash.txt -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to 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 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[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
The attachment "Patch to create akonadi backend any" seems to be a patch. If it isn't, please remove the "patch" flag from the attachment, remove the "patch" tag, and if you are a member of the ~ubuntu- reviewers, unsubscribe the team. [This is an automated message performed by a Launchpad user owned by ~brian-murray, for any issues please contact him.] ** Tags added: patch -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to 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 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[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
I think this should address the dependency problem, apologies if the patch isn't against the corrupt upstream. ** Patch added: "Patch to create akonadi backend any" https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1876398/+attachment/5371789/+files/0001-create-akonadi-backend-any-metapackage.patch -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to 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 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[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
It appears that akondictl stop doesn't cleanup mysqld-akonadictl Akonadi Control: stopped Akonadi Server: stopped Akonadi Server Search Support: available (Remote Search, Akonadi Search Plugin) Available Agent Types: akonadi_akonotes_resource, akonadi_archivemail_agent, akonadi_birthdays_resource, akonadi_contacts_resource, akonadi_davgroupware_resource, akonadi_ews_resource, akonadi_ewsmta_resource, akonadi_followupreminder_agent, akonadi_googlecalendar_resource, akonadi_googlecontacts_resource, akonadi_ical_resource, akonadi_icaldir_resource, akonadi_imap_resource, akonadi_indexing_agent, akonadi_kalarm_dir_resource, akonadi_kalarm_resource, akonadi_kolab_resource, akonadi_maildir_resource, akonadi_maildispatcher_agent, akonadi_mailfilter_agent, akonadi_mbox_resource, akonadi_migration_agent, akonadi_mixedmaildir_resource, akonadi_newmailnotifier_agent, akonadi_notes_agent, akonadi_notes_resource, akonadi_openxchange_resource, akonadi_pop3_resource, akonadi_sendlater_agent, akonadi_tomboynotes_resource, akonadi_unifiedmailbox_agent, akonadi_vcard_resource, akonadi_vcarddir_resource $ akonadictl start org.kde.pim.akonadicontrol: Service org.freedesktop.Akonadi.Control.lock already registered, terminating now. Error: akonadi_control was started but didn't register at D-Bus session bus. Make sure your system is set up correctly! $ org.kde.pim.akonadiserver: Failed to connect to database! org.kde.pim.akonadiserver: Database error: "Can't connect to local MySQL server through socket '/run/user/1000/akonadi/mysql.socket' (2) QMYSQL: Unable to connect" org.kde.pim.akonadiserver: Shutting down AkonadiServer... org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally... $ pkill mysqld-akonadi $ akonadictl start I've also attached the full output of akonadiselftest, but AFAICT there is nothing of use in there. ** Attachment added: "Full log" https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1876398/+attachment/5371731/+files/akonadi-selftest-report-20200514.txt -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to 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 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[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
Bug present even when akonadi-backend-mysql installed, akonadi-backend-mysql 4:19.12.3-0ubuntu2 Plus the dependencies for the package are wrong if a package depends on A or B or C, setting it to recommends A and B and C isn't the same thing. ** Changed in: akonadi (Ubuntu) Status: Invalid => New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to 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 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[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
akonadi recommends it's mysql backend, not depends on it, as you can validly choose alternative such as the sqlite or postgresql ones. so looks like you broke things yourself by weirdly doing -no-install- recommends Also there is no need to report the same not bug 11 times! ** Package changed: akonadiconsole (Ubuntu) => akonadi (Ubuntu) ** Changed in: akonadi (Ubuntu) Status: New => Invalid -- 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 -- kubuntu-bugs mailing list kubuntu-b...@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/kubuntu-bugs
