[mythtv-users] mysql wont startup - just ran backup & optimize from MCC

[Mike Bibbings]

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 
> <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 
> <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 
> <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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20170207/aa0b1287/attachment.html>