<div dir="ltr">Mike,<div><br></div><div> you are a rockstar, it started right up again!!!!</div><div><br></div><div> thanks</div><div><br></div><div>Doug</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Feb 7, 2017 at 7:54 AM, Mike Bibbings <span dir="ltr"><<a href="mailto:mike.bibbings@gmail.com" target="_blank">mike.bibbings@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"><div><div class="h5">
<div class="m_366977947562624630moz-cite-prefix">On 07/02/17 15:35, Douglas Sargent
wrote:<br>
</div>
<blockquote 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.ser<wbr>vice; 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-systemd<wbr>-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/node<wbr>/"
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 href="http://lists.freedesktop.org/mailman/listinfo/systemd-devel" target="_blank">http://lists.<wbr>freedesktop.org/mailman/<wbr>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 href="http://lists.freedesktop.org/mailman/listinfo/systemd-devel" target="_blank">http://lists.<wbr>freedesktop.org/mailman/<wbr>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 href="http://lists.freedesktop.org/mailman/listinfo/systemd-devel" target="_blank">http://lists.<wbr>freedesktop.org/mailman/<wbr>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/node<wbr>/"
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="m_366977947562624630mimeAttachmentHeader"></fieldset>
</blockquote></div></div>
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<span class="HOEnZb"><font color="#888888"><br>
<br>
Mike<br>
</font></span></div>
<br>______________________________<wbr>_________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" rel="noreferrer" target="_blank">http://lists.mythtv.org/<wbr>mailman/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" rel="noreferrer" target="_blank">http://wiki.mythtv.org/<wbr>Mailing_List_etiquette</a><br>
MythTV Forums: <a href="https://forum.mythtv.org" rel="noreferrer" target="_blank">https://forum.mythtv.org</a><br>
<br></blockquote></div><br></div>