De repente, o mysql / mariadb não inicia

1

De repente, depois de simplesmente adicionar algumas tabelas ao banco de dados dentro da instalação ... o serviço não será iniciado. Qualquer ajuda bem-vinda.

systemctl start mariadb
Job for mariadb.service failed. See 'systemctl status mariadb.service' and 'journalctl -xn' for details.
systemctl status mariadb
mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled)
   Active: failed (Result: exit-code) since Wed 2015-01-07 22:47:01 EST; 9s ago
  Process: 19037 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=1/FAILURE)
  Process: 19036 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS)
  Process: 19009 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
 Main PID: 19036 (code=exited, status=0/SUCCESS)

Jan 07 22:47:00 JX-Store systemd[1]: Starting MariaDB database server...
Jan 07 22:47:00 JX-Store mysqld_safe[19036]: 150107 22:47:00 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Jan 07 22:47:00 JX-Store mysqld_safe[19036]: 150107 22:47:00 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Jan 07 22:47:00 JX-Store mysqld_safe[19036]: 150107 22:47:00 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
Jan 07 22:47:01 JX-Store systemd[1]: mariadb.service: control process exited, code=exited status=1
Jan 07 22:47:01 JX-Store systemd[1]: Failed to start MariaDB database server.
Jan 07 22:47:01 JX-Store systemd[1]: Unit mariadb.service entered failed state.
Jan 07 22:47:00 JX-Store systemd[1]: Starting MariaDB database server...
-- Subject: Unit mariadb.service has begun with start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has begun starting up.
Jan 07 22:47:00 JX-Store mysqld_safe[19036]: 150107 22:47:00 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Jan 07 22:47:00 JX-Store mysqld_safe[19036]: 150107 22:47:00 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Jan 07 22:47:00 JX-Store mysqld_safe[19036]: 150107 22:47:00 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
Jan 07 22:47:01 JX-Store systemd[1]: mariadb.service: control process exited, code=exited status=1
Jan 07 22:47:01 JX-Store systemd[1]: Failed to start MariaDB database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
Jan 07 22:47:01 JX-Store systemd[1]: Unit mariadb.service entered failed state.

mariadb.log

150107 22:47:00 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150107 22:47:00 InnoDB: The InnoDB memory heap is disabled
150107 22:47:00 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150107 22:47:00 InnoDB: Compressed tables use zlib 1.2.7
150107 22:47:00 InnoDB: Using Linux native AIO
150107 22:47:00 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137756672 bytes) failed; errno 12
150107 22:47:00 InnoDB: Completed initialization of buffer pool
150107 22:47:00 InnoDB: Fatal error: cannot allocate memory for the buffer pool
150107 22:47:00 [ERROR] Plugin 'InnoDB' init function returned error.
150107 22:47:00 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150107 22:47:00 [ERROR] mysqld: Out of memory (Needed 128917504 bytes)
150107 22:47:00 [ERROR] mysqld: Out of memory (Needed 96681984 bytes)
150107 22:47:00 [Note] Plugin 'FEEDBACK' is disabled.
150107 22:47:00 [ERROR] Unknown/unsupported storage engine: InnoDB
150107 22:47:00 [ERROR] Aborting

150107 22:47:00 [Note] /usr/libexec/mysqld: Shutdown complete

150107 22:47:00 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
    
por Ryan Prentiss 08.01.2015 / 04:53

1 resposta

1

A questão é que o sistema não pode atribuir nenhuma memória ao processo para poder iniciar, você precisa parar alguns outros processos para que a memória fique livre para ser alocada para o MariaDB ou você precise adicionar mais memória RAM ou espaço SWAP ao servidor para que os processos possam ser iniciados corretamente.

    
por 08.01.2015 / 09:57