Welcome to Centmin Mod Community
Register Now

MariaDB Failed to stop on MYSQLRESTART, But fine starting with this errors

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by rdan, Feb 29, 2020.

  1. rdan

    rdan Well-Known Member

    4,959
    1,182
    113
    May 25, 2014
    Ratings:
    +1,795
    Local Time:
    9:19 PM
    Mainline
    10.2
    • CentOS Version: CentOS 7 64bit
    • Centmin Mod Version Installed: 123.09beta01
    • MariaDB MySQL Version Installed: 10.3.22
    Code:
    2020-02-28 19:34:23 0 [ERROR] mysqld: Can't lock aria control file '/var/lib/mysql/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
    2020-02-28 19:34:54 0 [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'
    2020-02-28 19:34:54 0 [ERROR] Plugin 'Aria' init function returned error.
    2020-02-28 19:34:54 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
    2020-02-28 19:34:54 0 [Note] InnoDB: Using Linux native AIO
    2020-02-28 19:34:54 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2020-02-28 19:34:54 0 [Note] InnoDB: Uses event mutexes
    2020-02-28 19:34:54 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
    2020-02-28 19:34:54 0 [Note] InnoDB: Number of pools: 1
    2020-02-28 19:34:54 0 [Note] InnoDB: Using SSE2 crc32 instructions
    2020-02-28 19:34:54 0 [Note] InnoDB: Initializing buffer pool, total size = 12G, instances = 12, chunk size = 128M
    2020-02-28 19:34:54 0 [Note] InnoDB: Completed initialization of buffer pool
    2020-02-28 19:34:55 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
    2020-02-28 19:34:55 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:34:55 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:34:55 0 [Note] InnoDB: Retrying to lock the first data file
    2020-02-28 19:34:56 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:34:56 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:34:57 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:34:57 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:34:58 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:34:58 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:34:59 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:34:59 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:00 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:00 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:01 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:01 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:02 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:02 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:03 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:03 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:04 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:04 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:05 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:05 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:06 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:06 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:07 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:07 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:08 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:08 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:09 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:09 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:10 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:10 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:11 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:11 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:12 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:12 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:13 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:13 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:14 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:14 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:15 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:15 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:16 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:16 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:17 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:17 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:18 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:18 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:19 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:19 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:20 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:20 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:21 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:21 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:22 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:22 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:23 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:23 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:24 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:24 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:25 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:25 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:26 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:26 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:27 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:27 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:28 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:28 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:29 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:29 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:30 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:30 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:31 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:31 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:32 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:32 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:33 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:33 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:34 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:34 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:35 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:35 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:36 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:36 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:37 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:37 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:38 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:38 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:39 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:39 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:40 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:40 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:41 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:41 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:42 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:42 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:43 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:43 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:44 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:44 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:45 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:45 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:46 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:46 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:47 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:47 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:48 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:48 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:49 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:49 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:50 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:50 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:51 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:51 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:52 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:52 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:53 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:53 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:54 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:54 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:55 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:55 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:56 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:56 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:57 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:57 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:58 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:58 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:35:59 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:35:59 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:36:00 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:36:00 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:36:01 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:36:01 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:36:02 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:36:02 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:36:03 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:36:03 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:36:04 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:36:04 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:36:05 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:36:05 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:36:06 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:36:06 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:36:07 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:36:07 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:36:08 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:36:08 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:36:09 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:36:09 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:36:10 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:36:10 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:36:11 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:36:11 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:36:12 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:36:12 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:36:13 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:36:13 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:36:14 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:36:14 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:36:15 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:36:15 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:36:16 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:36:16 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:36:17 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:36:17 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:36:18 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:36:18 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:36:19 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:36:19 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:36:20 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:36:20 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:36:21 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:36:21 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:36:22 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:36:22 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2020-02-28 19:36:23 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
    2020-02-28 19:36:23 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    

     
  2. rdan

    rdan Well-Known Member

    4,959
    1,182
    113
    May 25, 2014
    Ratings:
    +1,795
    Local Time:
    9:19 PM
    Mainline
    10.2
  3. rdan

    rdan Well-Known Member

    4,959
    1,182
    113
    May 25, 2014
    Ratings:
    +1,795
    Local Time:
    9:19 PM
    Mainline
    10.2
     
  4. eva2000

    eva2000 Administrator Staff Member

    44,693
    10,193
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,794
    Local Time:
    11:19 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    that's restart of server i.e. reboot not service restart

    The cause of the problem is right in the error log itself
    your failed to stop MariaDB MySQL server so it's still running but still managed to start up a 2nd MySQL server process so they're conflicting. Ensure you stop the 2nd or subsequent MySQL processes and then find out why original process isn't properly being stopped and stop it before starting again.
     
  5. eva2000

    eva2000 Administrator Staff Member

    44,693
    10,193
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,794
    Local Time:
    11:19 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    what's contents of your mysqlrestart command shortcut ?
    Code (Text):
    cat /usr/bin/mysqlrestart
     
  6. rdan

    rdan Well-Known Member

    4,959
    1,182
    113
    May 25, 2014
    Ratings:
    +1,795
    Local Time:
    9:19 PM
    Mainline
    10.2
    Code:
    # cat /usr/bin/mysqlrestart
    systemctl daemon-reload; service mysql restart
    
     
  7. eva2000

    eva2000 Administrator Staff Member

    44,693
    10,193
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,794
    Local Time:
    11:19 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    that looks correct for newest CentOS 7 installed Centmin Mod 123.09beta01 installations
     
  8. rdan

    rdan Well-Known Member

    4,959
    1,182
    113
    May 25, 2014
    Ratings:
    +1,795
    Local Time:
    9:19 PM
    Mainline
    10.2
     
  9. eva2000

    eva2000 Administrator Staff Member

    44,693
    10,193
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,794
    Local Time:
    11:19 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    Ah re-read Sunka's post yeah but there's many reasons why restart a service doesn't work especially MariaDB. More active your mysql server is, the longer a mysql restart takes usually and also improper mysql restarts or server reboots can have a cascading effect on subsequent restarts/reboots too due to how InnoDB auto recovery works.
     
  10. rdan

    rdan Well-Known Member

    4,959
    1,182
    113
    May 25, 2014
    Ratings:
    +1,795
    Local Time:
    9:19 PM
    Mainline
    10.2
    I rebooted the server itslef, but still same error when I do mysqlrestart.
    :confused:
     
  11. rdan

    rdan Well-Known Member

    4,959
    1,182
    113
    May 25, 2014
    Ratings:
    +1,795
    Local Time:
    9:19 PM
    Mainline
    10.2
     
  12. eva2000

    eva2000 Administrator Staff Member

    44,693
    10,193
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,794
    Local Time:
    11:19 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    so tried mysql restart service now and it works ? be sure you're looking at current timestamp for mysql errors as they could be previous logged errors

    improper reboot during MySQL activity can cause problems due to how InnoDB auto recovery works too

    MySQL :: MySQL 5.7 Reference Manual :: 14.19.2 InnoDB Recovery

    not to say you experienced a MySQL server crash though

    but blindly rebooting server for MySQL issues can lead to further MySQL data issues further down the road
     
  13. eva2000

    eva2000 Administrator Staff Member

    44,693
    10,193
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,794
    Local Time:
    11:19 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    If you still have issues with restarting and that error, then probably need to hire someone to professionally look into the root cause :)