mariadb - a nova instalação falha na reinicialização

Question

Tenho vasculhado por uma solução para isso por um tempo. Inicialmente, na tentativa de executar o mysql estou recebendo:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Há bastante informação sobre isso, mas nenhuma realmente me levou a lugar nenhum.

Procurando um pouco mais, parece que a falha é que a inicialização falha em um tempo limite quando está tentando carregar.

Ao desinstalar o mariadb e seguir novamente o processo de instalação, o sistema funciona como esperado ... Até a reinicialização do servidor, então nada! O erro do soquete como acima. Eu estou na linha de pensamento que o erro de soquete é secundário para o serviço nem mesmo em execução após a reinicialização.

Antes de reinicializar os comandos de serviço para iniciar, parar, reiniciar e recarregar, funcione bem.

Estou executando o UFW sem nenhuma porta habilitada para o MySQL, mas ainda não estou acessando o servidor remotamente, supondo que isso não seja um problema - todo o acesso ao db é / (será) do sistema de arquivos local via páginas hospedadas.

Estou executando o Ubuntu estável mais antigo, o diretório inicial criptografado e que foi instalado com a opção LAMP. Eu desinstalei o que eu pensava ser o MySQL (mas poderia ter sido o MariaDB) em favor da instalação do MariaDB. Agora esses problemas. Antes da desinstalação inicial, o servidor era um novo Ubuntu (e não há problemas de capacidade de disco rígido) e eu não tinha testado mysql antes que assim não posso comentar sobre o erro antes disso.

Eu estou bastante preso a onde investigar em seguida, para que seus pensamentos sejam apreciados.

Também de nota eu não pareço ter um arquivo mariadb * .log ou mysql * .log para interrogar como por algumas sugestões

service mariadb status da seguinte forma:

● mariadb.service - MariaDB 10.2.14 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: failed (Result: timeout) since Sat 2018-04-14 13:01:43 BST; 1min 28s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 1362 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 1074 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR='/usr/bin/galera_recovery'; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit
  Process: 1061 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 1014 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
 Main PID: 1362 (code=exited, status=0/SUCCESS)
      CPU: 574ms

Apr 14 13:01:40 smcserver systemd[1]: mariadb.service: Start operation timed out. Terminating.
Apr 14 13:01:41 smcserver mysqld[1362]: 2018-04-14 13:01:41 139873867650816 [Note] InnoDB: Starting shutdown...
Apr 14 13:01:41 smcserver mysqld[1362]: 2018-04-14 13:01:41 139873151330048 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
Apr 14 13:01:41 smcserver mysqld[1362]: 2018-04-14 13:01:41 139873151330048 [Note] InnoDB: Buffer pool(s) dump completed at 180414 13:01:41
Apr 14 13:01:43 smcserver mysqld[1362]: 2018-04-14 13:01:43 139873867650816 [Note] InnoDB: Shutdown completed; log sequence number 1620137
Apr 14 13:01:43 smcserver mysqld[1362]: 2018-04-14 13:01:43 139873867650816 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
Apr 14 13:01:43 smcserver mysqld[1362]: 2018-04-14 13:01:43 139873867650816 [Note] /usr/sbin/mysqld: Shutdown complete
Apr 14 13:01:43 smcserver systemd[1]: Failed to start MariaDB 10.2.14 database server.
Apr 14 13:01:43 smcserver systemd[1]: mariadb.service: Unit entered failed state.
Apr 14 13:01:43 smcserver systemd[1]: mariadb.service: Failed with result 'timeout'.

E este é o meu journalctl -u mariadb.service log:

Apr 14 13:00:06 smcserver systemd[1]: Starting MariaDB 10.2.14 database server...
Apr 14 13:00:14 smcserver mysqld[1362]: 2018-04-14 13:00:14 139874051098816 [Note] /usr/sbin/mysqld (mysqld 10.2.14-MariaDB-10.2.14+maria~artful-log) starting as process 1362 ...
Apr 14 13:00:16 smcserver mysqld[1362]: 2018-04-14 13:00:16 139874051098816 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Apr 14 13:00:16 smcserver mysqld[1362]: 2018-04-14 13:00:16 139874051098816 [Note] InnoDB: Uses event mutexes
Apr 14 13:00:16 smcserver mysqld[1362]: 2018-04-14 13:00:16 139874051098816 [Note] InnoDB: Compressed tables use zlib 1.2.11
Apr 14 13:00:16 smcserver mysqld[1362]: 2018-04-14 13:00:16 139874051098816 [Note] InnoDB: Using Linux native AIO
Apr 14 13:00:16 smcserver mysqld[1362]: 2018-04-14 13:00:16 139874051098816 [Note] InnoDB: Number of pools: 1
Apr 14 13:00:16 smcserver mysqld[1362]: 2018-04-14 13:00:16 139874051098816 [Note] InnoDB: Using generic crc32 instructions
Apr 14 13:00:16 smcserver mysqld[1362]: 2018-04-14 13:00:16 139874051098816 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
Apr 14 13:00:16 smcserver mysqld[1362]: 2018-04-14 13:00:16 139874051098816 [Note] InnoDB: Completed initialization of buffer pool
Apr 14 13:00:16 smcserver mysqld[1362]: 2018-04-14 13:00:16 139873311708928 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page
Apr 14 13:00:17 smcserver mysqld[1362]: 2018-04-14 13:00:17 139874051098816 [Note] InnoDB: Highest supported file format is Barracuda.
Apr 14 13:00:17 smcserver mysqld[1362]: 2018-04-14 13:00:17 139874051098816 [Note] InnoDB: 128 out of 128 rollback segments are active.
Apr 14 13:00:17 smcserver mysqld[1362]: 2018-04-14 13:00:17 139874051098816 [Note] InnoDB: Creating shared tablespace for temporary tables
Apr 14 13:00:17 smcserver mysqld[1362]: 2018-04-14 13:00:17 139874051098816 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
Apr 14 13:00:17 smcserver mysqld[1362]: 2018-04-14 13:00:17 139874051098816 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Apr 14 13:00:18 smcserver mysqld[1362]: 2018-04-14 13:00:18 139874051098816 [Note] InnoDB: 5.7.21 started; log sequence number 1620109
Apr 14 13:00:18 smcserver mysqld[1362]: 2018-04-14 13:00:18 139873151330048 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Apr 14 13:00:18 smcserver mysqld[1362]: 2018-04-14 13:00:18 139873151330048 [Note] InnoDB: Buffer pool(s) load completed at 180414 13:00:18
Apr 14 13:00:18 smcserver mysqld[1362]: 2018-04-14 13:00:18 139874051098816 [Note] Plugin 'FEEDBACK' is disabled.
Apr 14 13:00:18 smcserver mysqld[1362]: 2018-04-14 13:00:18 139874051098816 [Note] Server socket created on IP: '127.0.0.1'.
Apr 14 13:00:19 smcserver mysqld[1362]: 2018-04-14 13:00:19 139874051098816 [Note] Reading of all Master_info entries succeded
Apr 14 13:00:19 smcserver mysqld[1362]: 2018-04-14 13:00:19 139874051098816 [Note] Added new Master_info '' to hash table
Apr 14 13:00:19 smcserver mysqld[1362]: 2018-04-14 13:00:19 139874051098816 [Note] /usr/sbin/mysqld: ready for connections.
Apr 14 13:00:19 smcserver mysqld[1362]: Version: '10.2.14-MariaDB-10.2.14+maria~artful-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
Apr 14 13:01:40 smcserver mysqld[1362]: 2018-04-14 13:01:40 139873867650816 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
Apr 14 13:01:40 smcserver mysqld[1362]: 2018-04-14 13:01:40 139873193293568 [Note] InnoDB: FTS optimize thread exiting.
Apr 14 13:01:40 smcserver mysqld[1362]: 2018-04-14 13:01:40 139873867650816 [Note] Event Scheduler: Purging the queue. 0 events
Apr 14 13:01:40 smcserver systemd[1]: mariadb.service: Start operation timed out. Terminating.
Apr 14 13:01:41 smcserver mysqld[1362]: 2018-04-14 13:01:41 139873867650816 [Note] InnoDB: Starting shutdown...
Apr 14 13:01:41 smcserver mysqld[1362]: 2018-04-14 13:01:41 139873151330048 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
Apr 14 13:01:41 smcserver mysqld[1362]: 2018-04-14 13:01:41 139873151330048 [Note] InnoDB: Buffer pool(s) dump completed at 180414 13:01:41
Apr 14 13:01:43 smcserver mysqld[1362]: 2018-04-14 13:01:43 139873867650816 [Note] InnoDB: Shutdown completed; log sequence number 1620137
Apr 14 13:01:43 smcserver mysqld[1362]: 2018-04-14 13:01:43 139873867650816 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
Apr 14 13:01:43 smcserver mysqld[1362]: 2018-04-14 13:01:43 139873867650816 [Note] /usr/sbin/mysqld: Shutdown complete
Apr 14 13:01:43 smcserver systemd[1]: Failed to start MariaDB 10.2.14 database server.
Apr 14 13:01:43 smcserver systemd[1]: mariadb.service: Unit entered failed state.
Apr 14 13:01:43 smcserver systemd[1]: mariadb.service: Failed with result 'timeout'.

    

Answer 1

Quanto ram está no sistema, contanto que você seja sudo quando tentar iniciar o mysql, você também precisará de pelo menos 1GB de Ram para iniciá-lo.