MariaDB won't start on Ubuntu: Can't lock aria control file

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

MariaDB won't start on Ubuntu: Can't lock aria control file

Postby DanielWilson » 06. December 2016 20:18

I run into this error occassionaly after a scheduled backup. Upon a service mysql restart ... it fails to come up.

Attempting a manual start, gives me this.

Code: Select all
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


I have tried deleting the aria_log_control file and starting again, but the same error occurs.

mysqld_safe isn't doing it either.

Code: Select all
 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")


What else should I look at?

Thanks!
DanielWilson
 
Posts: 2
Joined: 06. December 2016 19:45
XAMPP version: 14.04
Operating System: Ubuntu

Re: MariaDB won't start on Ubuntu: Can't lock aria control f

Postby DanielWilson » 07. December 2016 16:24

After deleting the aria_log* files and the ib_logfile* files, I turned off binary logging per http://community.rtcamp.com/t/mariadb-bin-log-eat-my-disk-space/4278/4

Mysql started ...
DanielWilson
 
Posts: 2
Joined: 06. December 2016 19:45
XAMPP version: 14.04
Operating System: Ubuntu


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 36 guests