Control Web Panel

WebPanel => MySQL => Topic started by: iphonephu on June 18, 2017, 06:29:07 AM

Title: [error] mysqld: Can't lock aria control file '/var/lib/mysql/aria_log_control'
Post by: iphonephu on June 18, 2017, 06:29:07 AM

My log from htop:
(http://i.imgur.com/c0Ft5jK.png)

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

Title: Re: [error] mysqld: Can't lock aria control file '/var/lib/mysql/aria_log_control'
Post by: 24x7servermanagement on August 31, 2017, 08:20:07 PM

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

ps -ef | grep mysqld