Após excluir os arquivos aria_log * e os arquivos ib_logfile *, desativei o log binário por
O Mysql começou ...
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!