Author Topic: [error] mysqld: Can't lock aria control file '/var/lib/mysql/aria_log_control'  (Read 37147 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
My log from htop:


dig inside the log:
Code: [Select]
170616 05:48:43 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2017-06-16  5:48:43 140184783263776 [Note] /usr/sbin/mysqld (mysqld 10.1.24-MariaDB) starting as process 5016 ...
2017-06-16  5:48:43 140184783263776 [ERROR] mysqld: Can't lock aria control file '/var/lib/mysql/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
2017-06-16  5:49:14 140184783263776 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/var/lib/mysql/aria_log_control'
2017-06-16  5:49:14 140184783263776 [ERROR] Plugin 'Aria' init function returned error.
2017-06-16  5:49:14 140184783263776 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2017-06-16  5:49:14 140184783263776 [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.

2017-06-16  5:49:14 140184783263776 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-06-16  5:49:14 140184783263776 [Note] InnoDB: The InnoDB memory heap is disabled
2017-06-16  5:49:14 140184783263776 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-06-16  5:49:14 140184783263776 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-06-16  5:49:14 140184783263776 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-06-16  5:49:14 140184783263776 [Note] InnoDB: Using Linux native AIO
2017-06-16  5:49:14 140184783263776 [Note] InnoDB: Using SSE crc32 instructions
2017-06-16  5:49:14 140184783263776 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-06-16  5:49:14 140184783263776 [Note] InnoDB: Completed initialization of buffer pool
2017-06-16  5:49:15 140184783263776 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2017-06-16  5:49:15 140184783263776 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2017-06-16  5:49:15 140184783263776 [Note] InnoDB: Retrying to lock the first data file
2017-06-16  5:49:16 140184783263776 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2017-06-16  5:49:16 140184783263776 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2017-06-16  5:49:17 140184783263776 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2017-06-16  5:49:17 140184783263776 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.

CWPpro version: 0.9.8.249

Please help
« Last Edit: June 18, 2017, 07:18:08 AM by iphonephu »

Offline
***
There might be two processes running for MySQL, check using this command :-

ps -ef | grep mysqld
https://www.24x7servermanagement.com/
Server Management, Server Security, Server Monitoring.
India's Leading Managed Service Provider !!