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

Douglas Sargent dbsargent at gmail.com
Tue Feb 7 15:35:51 UTC 2017


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


More information about the mythtv-users mailing list