O MariaDB não inicia no Ubuntu: não é possível bloquear o arquivo de controle de aria

0

Eu me deparo com esse erro ocasionalmente após um backup agendado. Em cima de um serviço mysql restart ... ele não consegue aparecer.

A tentativa de um início manual me dá isso.

mysqld 
161125  7:40:48 [ERROR] mysqld: Can't lock aria control file '/var/lib/mysql/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds 
161125  7:40:49 [Note] InnoDB: Using mutexes to ref count buffer pool pages 
161125  7:40:49 [Note] InnoDB: The InnoDB memory heap is disabled 
161125  7:40:49 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 
161125  7:40:49 [Note] InnoDB: Memory barrier is not used 
161125  7:40:49 [Note] InnoDB: Compressed tables use zlib 1.2.8 
161125  7:40:49 [Note] InnoDB: Using Linux native AIO 
161125  7:40:49 [Note] InnoDB: Using CPU crc32 instructions 
161125  7:40:49 [Note] InnoDB: Initializing buffer pool, size = 64.0M 
161125  7:40:49 [Note] InnoDB: Completed initialization of buffer pool 
161125  7:40:49 [Note] InnoDB: Highest supported file format is Barracuda. 
161125  7:40:49 [Note] InnoDB: 128 rollback segment(s) are active. 
161125  7:40:49 [Note] InnoDB: Waiting for urge to start 
161125  7:40:49 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 13113858453 
161125  7:40:49 [Note] Plugin 'FEEDBACK' is disabled. 
161125  7:40:49 [ERROR] mysqld: File '/var/log/mysql/mariadb-bin.009076' not found (Errcode: 2 "No such file or directory") 
161125  7:40:49 [ERROR] Failed to open log    (file '/var/log/mysql/mariadb-bin.009076', errno 2) 
161125  7:40:49 [ERROR] Could not open log file 
161125  7:40:49 [ERROR] Can't init tc log 
161125  7:40:49 [ERROR] Aborting
161125  7:40:49 [Note] InnoDB: FTS optimize thread exiting. 
161125  7:40:49 [Note] InnoDB: Starting shutdown... 
161125  7:40:51 [Note] InnoDB: Shutdown completed; log sequence number 13113858463
161125  7:40:51 [Note] mysqld: Shutdown complete

Eu tentei apagar o arquivo aria_log_control e começar de novo, mas o mesmo erro ocorre.

O mysqld_safe também não está fazendo isso.

 mysqld_safe 
161206 12:36:14 mysqld_safe Logging to syslog. 
161206 12:36:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 
161206 12:36:16 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 
root@server:/var/lib/mysql# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory") 

O que mais eu devo olhar?

Obrigado!

    
por Daniel Wilson 06.12.2016 / 16:59

1 resposta

2

Após excluir os arquivos aria_log * e os arquivos ib_logfile *, desativei o log binário por

O Mysql começou ...

    
por Daniel Wilson 06.12.2016 / 23:58