[mythtv-users] mysql wont startup - just ran backup & optimize from MCC
Douglas Sargent
dbsargent at gmail.com
Tue Feb 7 16:11:41 UTC 2017
Mike,
you are a rockstar, it started right up again!!!!
thanks
Doug
On Tue, Feb 7, 2017 at 7:54 AM, Mike Bibbings <mike.bibbings at gmail.com>
wrote:
> On 07/02/17 15:35, Douglas Sargent wrote:
>
> Hi all,
>
> was hoping someone can help point me out how to debug this, rather
> than reinstall everything from scratch,
>
> Mythtv server was running fine, all patches up to date. Has rebooted
> multiple times. Today from MCC I ran optimize tables and backed up the
> database. Then I erased some tuners (left 1) and added another one (testing
> a second ceton device). When I restarted Mythtv it did not show the new
> tuner in the back-end nor in upcoming recordings, only the one I had left,
> it also showed 4 tuners with no name that I had erased, but no upcoming
> recording associated to them. Went back into the Back-end configuration,
> erased all tuners added 2 (old ceton new ceton device). Restarted mythtv
> could not see the new tuner, Rebooted the pc, now mysql wont start up.
>
> doug at Hydra:~$ sudo service mysql start
> [sudo] password for doug:
> Job for mysql.service failed because the control process exited with error
> code. See "systemctl status mysql.service" and "journalctl -xe" for details.
> doug at Hydra:~$ systemctl status mysql.service
> ● mysql.service - MySQL Community Server
> Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor
> preset: enabled)
> Active: activating (start-post) since Sun 2017-02-05 10:38:38 PST;
> 223ms ago
> Process: 4673 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre
> (code=exited, status=0/SUCCESS)
> Main PID: 4676 (mysqld); : 4677 (mysql-systemd-s)
> CGroup: /system.slice/mysql.service
> ├─4676 /usr/sbin/mysqld
> └─control
> ├─4677 /bin/bash /usr/share/mysql/mysql-systemd-start post
> └─4680 sleep 1
>
> Feb 05 10:38:38 Hydra systemd[1]: Starting MySQL Community Server...
> doug at Hydra:~$ journalctl -xe
> -- Unit mysql.service has begun starting up.
> Feb 05 10:39:08 Hydra audit[4832]: AVC apparmor="DENIED" operation="open"
> profile="/usr/sbin/mysqld" name="/proc/4832/status" pid=4832 comm="mysqld"
> requested_mas
> Feb 05 10:39:08 Hydra audit[4832]: AVC apparmor="DENIED" operation="open"
> profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=4832
> comm="mysqld" reque
> Feb 05 10:39:08 Hydra audit[4832]: AVC apparmor="DENIED" operation="open"
> profile="/usr/sbin/mysqld" name="/proc/4832/status" pid=4832 comm="mysqld"
> requested_mas
> Feb 05 10:39:08 Hydra kernel: audit: type=1400 audit(1486319948.808:50):
> apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld"
> name="/proc/4832/status" pi
> Feb 05 10:39:08 Hydra kernel: audit: type=1400 audit(1486319948.808:51):
> apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld"
> name="/sys/devices/system/n
> Feb 05 10:39:08 Hydra kernel: audit: type=1400 audit(1486319948.808:52):
> apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld"
> name="/proc/4832/status" pi
> Feb 05 10:39:10 Hydra systemd[1]: mysql.service: Main process exited,
> code=exited, status=1/FAILURE
> Feb 05 10:39:38 Hydra systemd[1]: Failed to start MySQL Community Server.
> -- Subject: Unit mysql.service has failed
> -- Defined-By: systemd
> -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
> --
> -- Unit mysql.service has failed.
> --
> -- The result is failed.
> Feb 05 10:39:38 Hydra systemd[1]: mysql.service: Unit entered failed state.
> Feb 05 10:39:38 Hydra systemd[1]: mysql.service: Failed with result
> 'exit-code'.
> Feb 05 10:39:39 Hydra systemd[1]: mysql.service: Service hold-off time
> over, scheduling restart.
> Feb 05 10:39:39 Hydra systemd[1]: Stopped MySQL Community Server.
> -- Subject: Unit mysql.service has finished shutting down
> -- Defined-By: systemd
> -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
> --
> -- Unit mysql.service has finished shutting down.
> Feb 05 10:39:39 Hydra systemd[1]: Starting MySQL Community Server...
> -- Subject: Unit mysql.service has begun start-up
> -- Defined-By: systemd
> -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
> --
> -- Unit mysql.service has begun starting up.
> Feb 05 10:39:39 Hydra audit[4941]: AVC apparmor="DENIED" operation="open"
> profile="/usr/sbin/mysqld" name="/proc/4941/status" pid=4941 comm="mysqld"
> requested_mas
> Feb 05 10:39:39 Hydra audit[4941]: AVC apparmor="DENIED" operation="open"
> profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=4941
> comm="mysqld" reque
> Feb 05 10:39:39 Hydra audit[4941]: AVC apparmor="DENIED" operation="open"
> profile="/usr/sbin/mysqld" name="/proc/4941/status" pid=4941 comm="mysqld"
> requested_mas
> Feb 05 10:39:39 Hydra kernel: audit: type=1400 audit(1486319979.059:53):
> apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld"
> name="/proc/4941/status" pi
> Feb 05 10:39:39 Hydra kernel: audit: type=1400 audit(1486319979.059:54):
> apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld"
> name="/sys/devices/system/n
> Feb 05 10:39:39 Hydra kernel: audit: type=1400 audit(1486319979.059:55):
> apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld"
> name="/proc/4941/status" pi
> Feb 05 10:39:40 Hydra systemd[1]: mysql.service: Main process exited,
> code=exited, status=1/FAILURE
> lines 1769-1806/1806 (END
>
> Have a look in /var/log/mysql/error.log, If it has something like
> [ERROR] unknown variable 'table_cache=128'
> This is preventing mysql from starting.
>
> I suspect you have a file named mythtv-tweaks.cnf in /etc/mysql/conf.d/
>
> Edit this file and comment out (just put # at start of line) the line
> table_cache = 128
>
> so it looks like
> #table_cache = 128
>
> then reboot
>
> Mike
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20170207/b2015adc/attachment.html>
More information about the mythtv-users
mailing list