erro ao reiniciar o MYSQL para instalação do CACTI

[lelecomb]

Boa tarde guerreiros,
estou tendo um probleminha e preciso da ajuda de vocês. A
o reiniciar o serviço do mysql em meu ubuntu 16.04 ele mostra o seguinte erro:

Código: [Selecionar]

root@srv-cacti:~# service mysql restart
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
root@srv-cacti:~# systemctl status mysql.service
● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: activating (start-post) (Result: exit-code) since Qua 2018-09-26 14:40:32 -04; 13s ago
  Process: 11265 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
  Process: 11257 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
 Main PID: 11265 (code=exited, status=1/FAILURE);         : 11266 (mysql-systemd-s)
    Tasks: 2
   Memory: 328.0K
      CPU: 347ms
   CGroup: /system.slice/mysql.service
           └─control
             ├─11266 /bin/bash /usr/share/mysql/mysql-systemd-start post
             └─11322 sleep 1

Set 26 14:40:32 srv-cacti systemd[1]: Starting MySQL Community Server...
Set 26 14:40:34 srv-cacti systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE



root@srv-cacti:~# journalctl -xe
--
-- A unidade mysql.service concluiu o desligamento.
Set 26 14:47:09 srv-cacti systemd[1]: Starting MySQL Community Server...
-- Subject: Unidade mysql.service sendo iniciado
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- A unidade mysql.service está sendo iniciada.
Set 26 14:47:09 srv-cacti kernel: audit: type=1400 audit(1537987629.464:232): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/12623/status" pi
Set 26 14:47:09 srv-cacti audit[12623]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/12623/status" pid=12623 comm="mysqld" requested_ma
Set 26 14:47:09 srv-cacti audit[12623]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=12623 comm="mysqld" reque
Set 26 14:47:09 srv-cacti audit[12623]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/12623/status" pid=12623 comm="mysqld" requested_ma
Set 26 14:47:09 srv-cacti kernel: audit: type=1400 audit(1537987629.468:233): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/no
Set 26 14:47:09 srv-cacti kernel: audit: type=1400 audit(1537987629.468:234): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/12623/status" pi
Set 26 14:47:11 srv-cacti systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Set 26 14:47:39 srv-cacti systemd[1]: [b]Failed to start MySQL Community Server.[/b]
-- Subject: A unidade mysql.service falhou
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- A unidade mysql.service falhou.
--
-- O resultado é failed.
Set 26 14:47:39 srv-cacti systemd[1]: mysql.service: Unit entered failed state.
Set 26 14:47:39 srv-cacti systemd[1]: mysql.service: Failed with result 'exit-code'.
Set 26 14:47:39 srv-cacti systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Set 26 14:47:39 srv-cacti systemd[1]: Stopped MySQL Community Server.
-- Subject: A unidade mysql.service concluiu o desligamento
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- A unidade mysql.service concluiu o desligamento.
Set 26 14:47:39 srv-cacti systemd[1]: Starting MySQL Community Server...
-- Subject: Unidade mysql.service sendo iniciado
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- A unidade mysql.service está sendo iniciada.
Set 26 14:47:39 srv-cacti audit[12724]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/12724/status" pid=12724 comm="mysqld" requested_ma
Set 26 14:47:39 srv-cacti audit[12724]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=12724 comm="mysqld" reque
Set 26 14:47:39 srv-cacti audit[12724]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/12724/status" pid=12724 comm="mysqld" requested_ma
Set 26 14:47:39 srv-cacti kernel: audit: type=1400 audit(1537987659.964:235): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/12724/status" pi
Set 26 14:47:39 srv-cacti kernel: audit: type=1400 audit(1537987659.964:236): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/no
Set 26 14:47:39 srv-cacti kernel: audit: type=1400 audit(1537987659.964:237): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/12724/status" pi
Set 26 14:47:41 srv-cacti systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE



root@srv-cacti:~# tail -30 /var/log/mysql/error.log
2018-09-26T18:50:12.762605Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2018-09-26T18:50:12.762610Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2018-09-26T18:50:12.762615Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-09-26T18:50:12.762620Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-09-26T18:50:12.762625Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-09-26T18:50:12.762630Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-09-26T18:50:12.762634Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-09-26T18:50:12.762639Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-09-26T18:50:12.762644Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-09-26T18:50:12.762649Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-09-26T18:50:12.762654Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2018-09-26T18:50:12.762658Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-09-26T18:50:12.762663Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-09-26T18:50:12.762668Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2018-09-26T18:50:12.762673Z 0 [Note] Shutting down plugin 'InnoDB'
2018-09-26T18:50:12.762829Z 0 [Note] InnoDB: FTS optimize thread exiting.
2018-09-26T18:50:12.763046Z 0 [Note] InnoDB: Starting shutdown...
2018-09-26T18:50:12.863558Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2018-09-26T18:50:12.863764Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180926 14:50:12
2018-09-26T18:50:14.373815Z 0 [Note] InnoDB: Shutdown completed; log sequence number 13895818
2018-09-26T18:50:14.377309Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-09-26T18:50:14.377330Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2018-09-26T18:50:14.377342Z 0 [Note] Shutting down plugin 'MyISAM'
2018-09-26T18:50:14.377368Z 0 [Note] Shutting down plugin 'CSV'
2018-09-26T18:50:14.377376Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-09-26T18:50:14.377451Z 0 [Note] Shutting down plugin 'sha256_password'
2018-09-26T18:50:14.377458Z 0 [Note] Shutting down plugin 'mysql_native_password'
2018-09-26T18:50:14.377681Z 0 [Note] Shutting down plugin 'binlog'
2018-09-26T18:50:14.378002Z 0 [Note] /usr/sbin/mysqld: Shutdown complete




Poderiam me ajudar com este entrave? Muito grato.

[zekkerj]

 

Set 26 14:47:09 srv-cacti kernel: audit: type=1400 audit(1537987629.464:232): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/12623/status" pi

Hmmmm. Pq o AppArmor está bloqueando seu MySQLd??? 

[lelecomb]

Set 26 14:47:09 srv-cacti kernel: audit: type=1400 audit(1537987629.464:232): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/12623/status" pi

Hmmmm. Pq o AppArmor está bloqueando seu MySQLd??? 

realmente não sei te responder, como não entendo muito de BANCO DE DADOS, estou seguindo um tutorial na net. podes dá um help?

[zekkerj]

Esse servidor foi instalado do zero ou atualizado de versão anterior?
Ele está mesmo com o 16.04, ou está com o 18.04, e vc só errou a digitação?