Não consigo iniciar o servico MySQL

1. Não consigo iniciar o servico MySQL

Michel Soares
ricknyc

(usa Outra)

Enviado em 23/06/2021 - 09:41h

Não consigo iniciar o serviço de mysql-server, me da erro, abaixo tudo que ja fiz e o que me responde de erros, não sei ao certo o que mais posso fazer, se tem uma alternativa, ou se só refazendo tudo do zero, a qual perderia tudo do meu banco.

"
[email protected]:/etc/mysql# journalctl -xe -u mysql
-- Subject: Unit process exited
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- An ExecStart= process belonging to unit mysql.service has exited.
--
-- The process' exit code is 'exited' and its exit status is 1.
jun 23 09:22:57 zabbix systemd[1]: mysql.service: Failed with result 'exit-code'.
-- Subject: Unit failed
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- The unit mysql.service has entered the 'failed' state with result 'exit-code'.
jun 23 09:22:57 zabbix systemd[1]: Failed to start MySQL Community Server.
-- Subject: A unidade mysql.service falhou
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- A unidade mysql.service falhou.
--
-- O resultado é failed.
jun 23 09:23:59 zabbix systemd[1]: Starting MySQL Community Server...
-- Subject: Unidade mysql.service sendo iniciado
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- A unidade mysql.service está sendo iniciada.
jun 23 09:24:00 zabbix mysqld[2157]: 2021-06-23T12:24:00.081574Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23) starting as process 2157
jun 23 09:24:00 zabbix mysqld[2157]: 2021-06-23T12:24:00.094606Z 0 [Warning] [MY-000081] [Server] option 'innodb-force-recovery': unsigned value 10 adjusted to 6.
jun 23 09:24:00 zabbix mysqld[2157]: 2021-06-23T12:24:00.099307Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
jun 23 09:24:00 zabbix mysqld[2157]: 2021-06-23T12:24:00.451399Z 1 [Warning] [MY-012637] [InnoDB] 1048576 bytes should have been written. Only 864256 bytes written. Retrying for the remaining bytes.
jun 23 09:24:00 zabbix mysqld[2157]: 2021-06-23T12:24:00.451832Z 1 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
jun 23 09:24:00 zabbix mysqld[2157]: 2021-06-23T12:24:00.452084Z 1 [ERROR] [MY-012639] [InnoDB] Write to file ./ibtmp1 failed at offset 4194304, 1048576 bytes should have been written, only 864256 were written. Operating system error num
jun 23 09:24:00 zabbix mysqld[2157]: 2021-06-23T12:24:00.452310Z 1 [ERROR] [MY-012640] [InnoDB] Error number 28 means 'No space left on device'
jun 23 09:24:00 zabbix mysqld[2157]: 2021-06-23T12:24:00.452566Z 1 [ERROR] [MY-012267] [InnoDB] Could not set the file size of './ibtmp1'. Probably out of disk space
jun 23 09:24:00 zabbix mysqld[2157]: 2021-06-23T12:24:00.452743Z 1 [ERROR] [MY-012926] [InnoDB] Unable to create the shared innodb_temporary.
jun 23 09:24:00 zabbix mysqld[2157]: 2021-06-23T12:24:00.452930Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
jun 23 09:24:00 zabbix mysqld[2157]: 2021-06-23T12:24:00.749417Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
jun 23 09:24:00 zabbix mysqld[2157]: 2021-06-23T12:24:00.749911Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
jun 23 09:24:00 zabbix mysqld[2157]: 2021-06-23T12:24:00.750148Z 0 [ERROR] [MY-010119] [Server] Aborting
jun 23 09:24:00 zabbix mysqld[2157]: 2021-06-23T12:24:00.750565Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23) MySQL Community Server - GPL.
jun 23 09:24:00 zabbix systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
-- Subject: Unit process exited
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- An ExecStart= process belonging to unit mysql.service has exited.
--
-- The process' exit code is 'exited' and its exit status is 1.
jun 23 09:24:00 zabbix systemd[1]: mysql.service: Failed with result 'exit-code'.
-- Subject: Unit failed
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- The unit mysql.service has entered the 'failed' state with result 'exit-code'.
jun 23 09:24:00 zabbix systemd[1]: Failed to start MySQL Community Server.
-- Subject: A unidade mysql.service falhou
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- A unidade mysql.service falhou.
--
-- O resultado é failed.
"


O que já fiz de configuração.

Alterei o CacheSize do zabbix de 8M para 2G.
Verifiquei memoria RAM e não esta faltando.
Sist. Arq. Tam. Usado Disp. Uso% Montado em
udev 971M 0 971M 0% /dev
tmpfs 198M 5,7M 192M 3% /run
/dev/sda1 4,0G 1,7G 2,1G 45% /
tmpfs 986M 0 986M 0% /dev/shm
tmpfs 5,0M 0 5,0M 0% /run/lock
tmpfs 986M 0 986M 0% /sys/fs/cgroup
/dev/sda5 1,7G 1,6G 4,8M 100% /var
/dev/sda7 352M 2,1M 327M 1% /tmp
/dev/sda8 13G 41M 12G 1% /home
tmpfs 198M 0 198M 0% /run/user/0

Alterei permissão.
chown mysql:mysql /var/log/mysql/*


Confg
nano /etc/mysql/my.cnf
[client-server]

# Import all .cnf files from configuration directory
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/





  


2. Re: Não consigo iniciar o servico MySQL

leandro peçanha scardua
leandropscardua

(usa Ubuntu)

Enviado em 23/06/2021 - 12:44h


jun 23 09:24:00 zabbix mysqld[2157]: 2021-06-23T12:24:00.452310Z 1 [ERROR] [MY-012640] [InnoDB] Error number 28 means 'No space left on device'

/dev/sda5 1,7G 1,6G 4,8M 100% /var

Disco cheio.