Problema de Inicialização MariaDB

xbBrunobx
(usa Debian)

Enviado em 14/03/2024 - 14:48h

Bom dia/Boa tarde/ Boa noite!

Utilizo o MariaDB como o banco de dados do GLPI, recentemente o programa começou a apresentar erro de desconexão com banco. Após fazer uma análise do que estava ocorrendo, encontrei um erro com o serviço do MariaDB, sendo ele:

root@SVGLPI:~# sudo service mysqld start

Job for mariadb.service failed because of unavailable resources or another system error.

See "systemctl status mariadb.service" and "journalctl -xe" for details.

 

A principio o erro foi resolvido renomeando o arquivo ib_logfile0 de log do MySql em /var/lib/mysql/, porem o problema foi resolvido por um dia, no outro voltou a ocorrer e não funcionou mais. vou deixar o resultado do "systemctl status mariadb.service" and "journalctl -xe" abaixo, alguem pode me dar uma luz?

oot@SVGLPI:~# systemctl status mariadb.service

● mariadb.service - MariaDB 10.5.23 database server

     Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor prese>

     Active: failed (Result: resources) since Thu 2024-03-14 09:27:04 -03; 4h 2>

       Docs: man:mariadbd(8)

             https://mariadb.com/kb/en/library/systemd/

      Tasks: 5 (limit: 6899)

     Memory: 71.6M

        CPU: 5h 40.556s

     CGroup: /system.slice/mariadb.service

             └─734 /usr/sbin/mariadbd



mar 14 13:46:48 SVGLPI systemd[1]: mariadb.service: Failed with result 'resourc>

mar 14 13:46:48 SVGLPI systemd[1]: mariadb.service: Unit process 734 (mariadbd)>

mar 14 13:46:48 SVGLPI systemd[1]: Failed to start MariaDB 10.5.23 database ser>

mar 14 13:51:11 SVGLPI systemd[1]: mariadb.service: Found left-over process 734>

mar 14 13:51:11 SVGLPI systemd[1]: This usually indicates unclean termination o>

mar 14 13:51:11 SVGLPI systemd[1]: mariadb.service: Will not start SendSIGKILL=>

mar 14 13:51:11 SVGLPI systemd[1]: mariadb.service: Failed to run 'start-pre' t>

mar 14 13:51:11 SVGLPI systemd[1]: mariadb.service: Failed with result 'resourc>

mar 14 13:51:11 SVGLPI systemd[1]: mariadb.service: Unit process 734 (mariadbd)>

mar 14 13:51:11 SVGLPI systemd[1]: Failed to start MariaDB 10.5.23 database ser>





root@SVGLPI:~# journalctl --since=yesterday -u mariadb

-- Journal begins at Sat 2023-07-22 17:39:01 -03, ends at Thu 2024-03-14 14:08:>

mar 14 00:00:25 SVGLPI systemd[1]: mariadb.service: Main process exited, code=k>

mar 14 00:00:25 SVGLPI systemd[1]: mariadb.service: Failed with result 'signal'.

mar 14 00:00:25 SVGLPI systemd[1]: mariadb.service: Consumed 42min 58.631s CPU >

mar 14 00:00:30 SVGLPI systemd[1]: mariadb.service: Scheduled restart job, rest>

mar 14 00:00:30 SVGLPI systemd[1]: Stopped MariaDB 10.5.23 database server.

mar 14 00:00:30 SVGLPI systemd[1]: mariadb.service: Consumed 42min 58.631s CPU >

mar 14 00:00:30 SVGLPI systemd[1]: Starting MariaDB 10.5.23 database server...

mar 14 00:01:02 SVGLPI systemd[1]: Started MariaDB 10.5.23 database server.

mar 14 00:01:05 SVGLPI debian-start[281551]: ERROR 1045 (28000): Access denied >

mar 14 00:29:15 SVGLPI systemd[1]: mariadb.service: Main process exited, code=k>

mar 14 00:29:15 SVGLPI systemd[1]: mariadb.service: Failed with result 'signal'.

mar 14 00:29:15 SVGLPI systemd[1]: mariadb.service: Consumed 5min 7.735s CPU ti>

mar 14 00:29:20 SVGLPI systemd[1]: mariadb.service: Scheduled restart job, rest>

mar 14 00:29:20 SVGLPI systemd[1]: Stopped MariaDB 10.5.23 database server.

mar 14 00:29:20 SVGLPI systemd[1]: mariadb.service: Consumed 5min 7.735s CPU ti>

mar 14 00:29:20 SVGLPI systemd[1]: Starting MariaDB 10.5.23 database server...

mar 14 00:29:27 SVGLPI systemd[1]: Started MariaDB 10.5.23 database server.

mar 14 00:29:27 SVGLPI /etc/mysql/debian-start[282250]: Upgrading MySQL tables >

mar 14 00:29:27 SVGLPI debian-start[282262]: ERROR 1045 (28000): Access denied >

mar 14 01:26:55 SVGLPI systemd[1]: mariadb.service: Main process exited, code=k>

mar 14 01:26:55 SVGLPI systemd[1]: mariadb.service: Failed with result 'signal'.

mar 14 01:26:55 SVGLPI systemd[1]: mariadb.service: Consumed 5min 35.439s CPU t>

lines 1-23...skipping...

-- Journal begins at Sat 2023-07-22 17:39:01 -03, ends at Thu 2024-03-14 14:08:01 -03. --

mar 14 00:00:25 SVGLPI systemd[1]: mariadb.service: Main process exited, code=killed, status=6/ABRT

mar 14 00:00:25 SVGLPI systemd[1]: mariadb.service: Failed with result 'signal'.

mar 14 00:00:25 SVGLPI systemd[1]: mariadb.service: Consumed 42min 58.631s CPU time.

mar 14 00:00:30 SVGLPI systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 259.

mar 14 00:00:30 SVGLPI systemd[1]: Stopped MariaDB 10.5.23 database server.

mar 14 00:00:30 SVGLPI systemd[1]: mariadb.service: Consumed 42min 58.631s CPU time.

mar 14 00:00:30 SVGLPI systemd[1]: Starting MariaDB 10.5.23 database server...

mar 14 00:01:02 SVGLPI systemd[1]: Started MariaDB 10.5.23 database server.

mar 14 00:01:05 SVGLPI debian-start[281551]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: N>

mar 14 00:29:15 SVGLPI systemd[1]: mariadb.service: Main process exited, code=killed, status=6/ABRT

mar 14 00:29:15 SVGLPI systemd[1]: mariadb.service: Failed with result 'signal'.

mar 14 00:29:15 SVGLPI systemd[1]: mariadb.service: Consumed 5min 7.735s CPU time.

mar 14 00:29:20 SVGLPI systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 260.

mar 14 00:29:20 SVGLPI systemd[1]: Stopped MariaDB 10.5.23 database server.

mar 14 00:29:20 SVGLPI systemd[1]: mariadb.service: Consumed 5min 7.735s CPU time.

mar 14 00:29:20 SVGLPI systemd[1]: Starting MariaDB 10.5.23 database server...

mar 14 00:29:27 SVGLPI systemd[1]: Started MariaDB 10.5.23 database server.

mar 14 00:29:27 SVGLPI /etc/mysql/debian-start[282250]: Upgrading MySQL tables if necessary.

mar 14 00:29:27 SVGLPI debian-start[282262]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: N>

mar 14 01:26:55 SVGLPI systemd[1]: mariadb.service: Main process exited, code=killed, status=6/ABRT

mar 14 01:26:55 SVGLPI systemd[1]: mariadb.service: Failed with result 'signal'.

mar 14 01:26:55 SVGLPI systemd[1]: mariadb.service: Consumed 5min 35.439s CPU time.

mar 14 01:27:00 SVGLPI systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 261.

mar 14 01:27:00 SVGLPI systemd[1]: Stopped MariaDB 10.5.23 database server.

mar 14 01:27:00 SVGLPI systemd[1]: mariadb.service: Consumed 5min 35.439s CPU time.

mar 14 01:27:00 SVGLPI systemd[1]: Starting MariaDB 10.5.23 database server...

mar 14 01:27:04 SVGLPI systemd[1]: Started MariaDB 10.5.23 database server.

mar 14 01:27:05 SVGLPI /etc/mysql/debian-start[283869]: Checking for insecure root accounts.

mar 14 01:27:05 SVGLPI debian-start[283872]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: N>

mar 14 02:30:36 SVGLPI systemd[1]: mariadb.service: Main process exited, code=killed, status=6/ABRT

mar 14 02:30:36 SVGLPI systemd[1]: mariadb.service: Failed with result 'signal'.

mar 14 02:30:36 SVGLPI systemd[1]: mariadb.service: Consumed 5min 35.164s CPU time.

mar 14 02:30:41 SVGLPI systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 262.

mar 14 02:30:41 SVGLPI systemd[1]: Stopped MariaDB 10.5.23 database server.

mar 14 02:30:41 SVGLPI systemd[1]: mariadb.service: Consumed 5min 35.164s CPU time.

mar 14 02:30:41 SVGLPI systemd[1]: Starting MariaDB 10.5.23 database server...

mar 14 02:30:44 SVGLPI systemd[1]: Started MariaDB 10.5.23 database server.

mar 14 02:30:44 SVGLPI /etc/mysql/debian-start[285432]: Upgrading MySQL tables if necessary.



 

danniel-lara
(usa Fedora)

Enviado em 14/03/2024 - 17:37h

A maneira mais simples de resolver isso é recriar o arquivo ib_logfile0. Para fazer isso, você precisará parar o servidor MySQL e excluir qualquer fragmento restante do arquivo ib_logfile0, se houver. Em seguida, reinicie o servidor MySQL. Ele deverá recriar automaticamente o arquivo ib_logfile0 com as configurações padrão.