Problema com reinicio do serviço do MySQL

Minions
(usa Nenhuma)

Enviado em 12/02/2021 - 23:10h

/etc/rc.d/rc.mysqld restart
210212 22:58:50 mysqld_safe Logging to '/var/lib/mysql/darkstar.err'.
210212 22:58:50 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

Só fica nesta tela

leandropscardua
(usa Ubuntu)

Enviado em 13/02/2021 - 10:13h

Tente se conectar ao servidor (mysql localhost ou telnet localhost 3306). Se não conseguir veja os logs
cat /var/lib/mysql/darkstar.err

Minions
(usa Nenhuma)

Enviado em 13/02/2021 - 11:00h

Estou rodando o mysql que é MariaDB na realidade, localmente sem usar a rede. O problema acontece quando:

# /etc/rc.d/rc.mysqld start
210213 10:56:15 mysqld_safe Logging to '/var/lib/mysql/darkstar.err'.
210213 10:56:15 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

ou

# /etc/rc.d/rc.mysqld restart
210213 10:56:53 mysqld_safe Logging to '/var/lib/mysql/darkstar.err'.
210213 10:56:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql


Para STOP esta funcionando

# /etc/rc.d/rc.mysqld stop


# cat /var/lib/mysql/darkstar.err
...

210213 10:56:15 [Note] InnoDB: Using Linux native AIO
210213 10:56:15 [Note] InnoDB: Not using CPU crc32 instructions
210213 10:56:15 [Note] InnoDB: Initializing buffer pool, size = 128.0M
210213 10:56:15 [Note] InnoDB: Completed initialization of buffer pool
210213 10:56:15 [Note] InnoDB: Highest supported file format is Barracuda.
210213 10:56:15 [Note] InnoDB: 128 rollback segment(s) are active.
210213 10:56:15 [Note] InnoDB: Waiting for purge to start
210213 10:56:15 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.42-84.2 started; log sequence number 16694813
210213 10:56:15 [Note] Plugin 'FEEDBACK' is disabled.
210213 10:56:15 [Note] /usr/libexec/mysqld: ready for connections.
Version: '10.0.38-MariaDB' socket: '/var/run/mysql/mysql.sock' port: 0 MariaDB Server
210213 10:56:51 [Note] /usr/libexec/mysqld: Normal shutdown
210213 10:56:51 [Note] Event Scheduler: Purging the queue. 0 events
210213 10:56:51 [Note] InnoDB: FTS optimize thread exiting.
210213 10:56:51 [Note] InnoDB: Starting shutdown...
210213 10:56:52 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
210213 10:56:53 [Note] InnoDB: Shutdown completed; log sequence number 16694823
210213 10:56:53 [Note] /usr/libexec/mysqld: Shutdown complete

210213 10:56:53 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended
210213 10:56:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
210213 10:56:54 [Note] /usr/libexec/mysqld (mysqld 10.0.38-MariaDB) starting as process 6624 ...
210213 10:56:54 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

210213 10:56:54 [Note] InnoDB: Using mutexes to ref count buffer pool pages
210213 10:56:54 [Note] InnoDB: The InnoDB memory heap is disabled
210213 10:56:54 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
210213 10:56:54 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
210213 10:56:54 [Note] InnoDB: Compressed tables use zlib 1.2.11
210213 10:56:54 [Note] InnoDB: Using Linux native AIO
210213 10:56:54 [Note] InnoDB: Not using CPU crc32 instructions
210213 10:56:54 [Note] InnoDB: Initializing buffer pool, size = 128.0M
210213 10:56:54 [Note] InnoDB: Completed initialization of buffer pool
210213 10:56:54 [Note] InnoDB: Highest supported file format is Barracuda.
210213 10:56:54 [Note] InnoDB: 128 rollback segment(s) are active.
210213 10:56:54 [Note] InnoDB: Waiting for purge to start
210213 10:56:54 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.42-84.2 started; log sequence number 16694823
210213 10:56:54 [Note] Plugin 'FEEDBACK' is disabled.
210213 10:56:54 [Note] /usr/libexec/mysqld: ready for connections.
Version: '10.0.38-MariaDB' socket: '/var/run/mysql/mysql.sock' port: 0 MariaDB Server



Obs: A senha do MySQL esta funcionando.

leandropscardua
(usa Ubuntu)

Enviado em 13/02/2021 - 11:39h

Segundo o log já está no ar
210213 10:56:54 [Note] /usr/libexec/mysqld: ready for connections.

Minions
(usa Nenhuma)

Enviado em 13/02/2021 - 14:26h

O negocio do "start" e "restart" fica preso no terminal?? Mesmo usando o & no final Era para fica igual ao "stop".


Mesmo carregando o DB, fica esse problema da iniciação do serviço dele.....

# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 6
Server version: 10.0.38-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

leandropscardua
(usa Ubuntu)

Enviado em 14/02/2021 - 00:29h

Sim. Como vc inicializou pela linha de comando ele fica ali rodanso. Por isso se configura p rodar como serviço.

Minions
(usa Nenhuma)

Enviado em 14/02/2021 - 01:39h

O serviço do samba, apache e squid não funciona deste modo do MySQL. Podemos start, restart e stop via terminal sem fica travado na tela.

Esse problema (start, restart) com MySQL ocorre em outras distro?