<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 07/02/17 15:35, Douglas Sargent
wrote:<br>
</div>
<blockquote
cite="mid:CAHJ5J5jsKOrb0BFco6CGiBKrvy5rvGrRSV+kbE5mKOFsvxegFw@mail.gmail.com"
type="cite">
<div dir="ltr">Hi all,<br>
<div>
<div style="font-size:12.8px"><br>
</div>
<div style="font-size:12.8px"> was hoping someone can
help point me out how to debug this, rather than reinstall
everything from scratch, </div>
<div style="font-size:12.8px"><br>
</div>
<div style="font-size:12.8px"> 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.</div>
<div style="font-size:12.8px"><br>
</div>
<div style="font-size:12.8px">doug@Hydra:~$ sudo service mysql
start</div>
<div style="font-size:12.8px">[sudo] password for doug: </div>
<div style="font-size:12.8px">Job for mysql.service failed
because the control process exited with error code. See
"systemctl status mysql.service" and "journalctl -xe" for
details.</div>
<div style="font-size:12.8px">doug@Hydra:~$ systemctl status
mysql.service</div>
<div style="font-size:12.8px">● mysql.service - MySQL
Community Server</div>
<div style="font-size:12.8px"> Loaded: loaded
(/lib/systemd/system/mysql.<wbr>service; enabled; vendor
preset: enabled)</div>
<div style="font-size:12.8px"> Active: activating
(start-post) since Sun 2017-02-05 10:38:38 PST; 223ms ago</div>
<div style="font-size:12.8px"> Process: 4673
ExecStartPre=/usr/share/mysql/<wbr>mysql-systemd-start pre
(code=exited, status=0/SUCCESS)</div>
<div style="font-size:12.8px"> Main PID: 4676 (mysqld);
: 4677 (mysql-systemd-s)</div>
<div style="font-size:12.8px"> CGroup:
/system.slice/mysql.service</div>
<div style="font-size:12.8px"> ├─4676
/usr/sbin/mysqld</div>
<div style="font-size:12.8px"> └─control</div>
<div style="font-size:12.8px"> ├─4677 /bin/bash
/usr/share/mysql/mysql-<wbr>systemd-start post</div>
<div style="font-size:12.8px"> └─4680 sleep 1</div>
<div style="font-size:12.8px"><br>
</div>
<div style="font-size:12.8px">Feb 05 10:38:38 Hydra
systemd[1]: Starting MySQL Community Server...</div>
<div style="font-size:12.8px">doug@Hydra:~$ journalctl -xe</div>
<div style="font-size:12.8px">-- Unit mysql.service has begun
starting up.</div>
<div style="font-size:12.8px">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</div>
<div style="font-size:12.8px">Feb 05 10:39:08 Hydra
audit[4832]: AVC apparmor="DENIED" operation="open"
profile="/usr/sbin/mysqld" name="/sys/devices/system/<wbr>node/"
pid=4832 comm="mysqld" reque</div>
<div style="font-size:12.8px">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</div>
<div style="font-size:12.8px">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</div>
<div style="font-size:12.8px">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</div>
<div style="font-size:12.8px">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</div>
<div style="font-size:12.8px">Feb 05 10:39:10 Hydra
systemd[1]: mysql.service: Main process exited, code=exited,
status=1/FAILURE</div>
<div style="font-size:12.8px">Feb 05 10:39:38 Hydra
systemd[1]: Failed to start MySQL Community Server.</div>
<div style="font-size:12.8px">-- Subject: Unit mysql.service
has failed</div>
<div style="font-size:12.8px">-- Defined-By: systemd</div>
<div style="font-size:12.8px">-- Support: <a
moz-do-not-send="true"
href="http://lists.freedesktop.org/mailman/listinfo/systemd-devel"
target="_blank">http://lists.freedesktop.org/<wbr>mailman/listinfo/systemd-devel</a></div>
<div style="font-size:12.8px">-- </div>
<div style="font-size:12.8px">-- Unit mysql.service has
failed.</div>
<div style="font-size:12.8px">-- </div>
<div style="font-size:12.8px">-- The result is failed.</div>
<div style="font-size:12.8px">Feb 05 10:39:38 Hydra
systemd[1]: mysql.service: Unit entered failed state.</div>
<div style="font-size:12.8px">Feb 05 10:39:38 Hydra
systemd[1]: mysql.service: Failed with result 'exit-code'.</div>
<div style="font-size:12.8px">Feb 05 10:39:39 Hydra
systemd[1]: mysql.service: Service hold-off time over,
scheduling restart.</div>
<div style="font-size:12.8px">Feb 05 10:39:39 Hydra
systemd[1]: Stopped MySQL Community Server.</div>
<div style="font-size:12.8px">-- Subject: Unit mysql.service
has finished shutting down</div>
<div style="font-size:12.8px">-- Defined-By: systemd</div>
<div style="font-size:12.8px">-- Support: <a
moz-do-not-send="true"
href="http://lists.freedesktop.org/mailman/listinfo/systemd-devel"
target="_blank">http://lists.freedesktop.org/<wbr>mailman/listinfo/systemd-devel</a></div>
<div style="font-size:12.8px">-- </div>
<div style="font-size:12.8px">-- Unit mysql.service has
finished shutting down.</div>
<div style="font-size:12.8px">Feb 05 10:39:39 Hydra
systemd[1]: Starting MySQL Community Server...</div>
<div style="font-size:12.8px">-- Subject: Unit mysql.service
has begun start-up</div>
<div style="font-size:12.8px">-- Defined-By: systemd</div>
<div style="font-size:12.8px">-- Support: <a
moz-do-not-send="true"
href="http://lists.freedesktop.org/mailman/listinfo/systemd-devel"
target="_blank">http://lists.freedesktop.org/<wbr>mailman/listinfo/systemd-devel</a></div>
<div style="font-size:12.8px">-- </div>
<div style="font-size:12.8px">-- Unit mysql.service has begun
starting up.</div>
<div style="font-size:12.8px">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</div>
<div style="font-size:12.8px">Feb 05 10:39:39 Hydra
audit[4941]: AVC apparmor="DENIED" operation="open"
profile="/usr/sbin/mysqld" name="/sys/devices/system/<wbr>node/"
pid=4941 comm="mysqld" reque</div>
<div style="font-size:12.8px">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</div>
<div style="font-size:12.8px">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</div>
<div style="font-size:12.8px">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</div>
<div style="font-size:12.8px">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</div>
<div style="font-size:12.8px">Feb 05 10:39:40 Hydra
systemd[1]: mysql.service: Main process exited, code=exited,
status=1/FAILURE</div>
<div style="font-size:12.8px">lines 1769-1806/1806 (END</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
</blockquote>
Have a look in /var/log/mysql/error.log, If it has something like <br>
[ERROR] unknown variable 'table_cache=128'<br>
This is preventing mysql from starting.<br>
<br>
I suspect you have a file named mythtv-tweaks.cnf in
/etc/mysql/conf.d/<br>
<br>
Edit this file and comment out (just put # at start of line) the
line<br>
table_cache = 128<br>
<br>
so it looks like<br>
#table_cache = 128<br>
<br>
then reboot<br>
<br>
Mike<br>
</body>
</html>