[Solved] Kubuntu 19.10 upgrade breaks mysql/mariadb

Have a MythTV related problem? Ask for help from other MythTV users here.

Moderator: Forum Moderators

Post Reply
halucigenia
Senior
Posts: 122
Joined: Tue Nov 11, 2014 11:03 am
Great Britain

[Solved] Kubuntu 19.10 upgrade breaks mysql/mariadb

Post by halucigenia »

Hi, I have just upgraded my master backend to Kubuntu 19.10 and it seems to brake mysql/mariadb so I can't get my mythconverg database running.
Any Ideas, anyone?
Last edited by halucigenia on Mon Nov 18, 2019 2:16 pm, edited 1 time in total.
halucigenia
Senior
Posts: 122
Joined: Tue Nov 11, 2014 11:03 am
Great Britain

Re: Kubuntu 19.10 upgrade breaks mysql/mariadb

Post by halucigenia »

Well, I have managed to uninstall and reinstall mariadb with some dificulty because of dependencies. I had to uninstall and reinstall mythtv amongst other things.
Back to the same issue of not being able to start the service.

Code: Select all

sudo systemctl start mariadb.service
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.

Code: Select all

sudo systemctl status mariadb.service
Failed to start MariaDB 10.3.17 database server.

Code: Select all

journalctl -xe
The unit mariadb.service has entered the 'failed' state with result 'exit-code'.
Oct 29 19:11:51 kb01 systemd[1]: Failed to start MariaDB 10.3.17 database server.
-- Subject: A start job for unit mariadb.service has failed
-- Defined-By: systemd
User avatar
bill6502
Developer
Posts: 2307
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Kubuntu 19.10 upgrade breaks mysql/mariadb

Post by bill6502 »

Maybe /var/log/mysql/error.log will have more details on the job that failed.
halucigenia
Senior
Posts: 122
Joined: Tue Nov 11, 2014 11:03 am
Great Britain

Re: Kubuntu 19.10 upgrade breaks mysql/mariadb

Post by halucigenia »

Thanks bill6502 I did check /var/log/mysql/error.log but it did not help much.

Eventually, after a bit more un-installing, purging of various dependencies and re-installing of mariadb and running 'sudo mysql_secure_installation' (at first that would not even run) I did get it working.
halucigenia
Senior
Posts: 122
Joined: Tue Nov 11, 2014 11:03 am
Great Britain

Re: Kubuntu 19.10 upgrade breaks mysql/mariadb

Post by halucigenia »

mysql/mariadb stopped running again and would not start. I discovered that it had something to do with apparmor 'the AppArmor profile for /usr/sbin/mysqld is still loaded in the kernel' apparently
see here https://askubuntu.com/questions/750604/ ... 74_1145791
and I found that running

Code: Select all

sudo aa-remove-unknown
Fixed it this time.
User avatar
Steve Goodey
Moderator
Posts: 219
Joined: Fri Feb 07, 2014 6:30 pm
Location: Colchester, England
Great Britain

Re: Kubuntu 19.10 upgrade breaks mysql/mariadb

Post by Steve Goodey »

Hello,

If you're happy with the fix could you possibly added [Solved] to the subject line in the first post?

Ta.
Don't forget the Wiki.
halucigenia
Senior
Posts: 122
Joined: Tue Nov 11, 2014 11:03 am
Great Britain

Re: Kubuntu 19.10 upgrade breaks mysql/mariadb

Post by halucigenia »

It took a week for it to break again, but it's been almost a week now since the last attempt at fixing it, so, OK, it's solved (I hope).
Post Reply