Welcome to Centmin Mod Community
Become a Member

MariaDB MariaDB 10.0.16 released

Discussion in 'MariaDB & General MySQL news & discussions' started by RoldanLT, Jan 28, 2015.

  1. RoldanLT

    RoldanLT Well-Known Member

    3,899
    949
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,298
    Local Time:
    10:01 AM
    1.11
    10.2
    Release date: 27 Jan 2015

    MariaDB 10.0 is the current stable series of MariaDB. It is an evolution of the MariaDB 5.5 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6.

    MariaDB 10.0.16 is a Stable (GA) release.

    For an overview of MariaDB 10.0 see the What is MariaDB 10.0? page.

    Thanks, and enjoy MariaDB!

    Notable Changes
    For a complete list of changes made in MariaDB 10.0.16, with links to detailed information on each push, see thechangelog.
     
    • Like Like x 2
  2. RoldanLT

    RoldanLT Well-Known Member

    3,899
    949
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,298
    Local Time:
    10:01 AM
    1.11
    10.2
    Resolving Dependencies
    --> Running transaction check
    ---> Package MariaDB-client.x86_64 0:10.0.15-1.el6 will be updated
    ---> Package MariaDB-client.x86_64 0:10.0.16-1.el6 will be an update
    ---> Package MariaDB-common.x86_64 0:10.0.15-1.el6 will be updated
    ---> Package MariaDB-common.x86_64 0:10.0.16-1.el6 will be an update
    ---> Package MariaDB-compat.x86_64 0:10.0.15-1.el6 will be updated
    ---> Package MariaDB-compat.x86_64 0:10.0.16-1.el6 will be an update
    ---> Package MariaDB-devel.x86_64 0:10.0.15-1.el6 will be updated
    ---> Package MariaDB-devel.x86_64 0:10.0.16-1.el6 will be an update
    ---> Package MariaDB-server.x86_64 0:10.0.15-1.el6 will be updated
    ---> Package MariaDB-server.x86_64 0:10.0.16-1.el6 will be an update
    ---> Package MariaDB-shared.x86_64 0:10.0.15-1.el6 will be updated
    ---> Package MariaDB-shared.x86_64 0:10.0.16-1.el6 will be an update
    --> Finished Dependency Resolution

    Dependencies Resolved

    ======================================================================================================================================================
    Package Arch Version Repository Size
    ======================================================================================================================================================
    Updating:
    MariaDB-client x86_64 10.0.16-1.el6 mariadb 11 M
    MariaDB-common x86_64 10.0.16-1.el6 mariadb 23 k
    MariaDB-compat x86_64 10.0.16-1.el6 mariadb 2.7 M
    MariaDB-devel x86_64 10.0.16-1.el6 mariadb 6.6 M
    MariaDB-server x86_64 10.0.16-1.el6 mariadb 57 M
    MariaDB-shared x86_64 10.0.16-1.el6 mariadb 1.3 M

    Transaction Summary
    ======================================================================================================================================================
    Upgrade 6 Package(s)

    Total download size: 78 M
    Is this ok [y/N]: y
    Downloading Packages:
    (1/6): MariaDB-10.0.16-centos6-x86_64-client.rpm | 11 MB 00:01
    (2/6): MariaDB-10.0.16-centos6-x86_64-common.rpm | 23 kB 00:00
    (3/6): MariaDB-10.0.16-centos6-x86_64-compat.rpm | 2.7 MB 00:00
    (4/6): MariaDB-10.0.16-centos6-x86_64-devel.rpm | 6.6 MB 00:00
    (5/6): MariaDB-10.0.16-centos6-x86_64-server.rpm | 57 MB 00:07
    (6/6): MariaDB-10.0.16-centos6-x86_64-shared.rpm | 1.3 MB 00:00
    ------------------------------------------------------------------------------------------------------------------------------------------------------
    Total 7.6 MB/s | 78 MB 00:10
    Running rpm_check_debug
    Running Transaction Test
    Transaction Test Succeeded
    Running Transaction
    Updating : MariaDB-compat-10.0.16-1.el6.x86_64 1/12
    Updating : MariaDB-common-10.0.16-1.el6.x86_64 2/12
    Updating : MariaDB-client-10.0.16-1.el6.x86_64 3/12
    Updating : MariaDB-server-10.0.16-1.el6.x86_64 4/12
    Updating : MariaDB-shared-10.0.16-1.el6.x86_64 5/12
    Updating : MariaDB-devel-10.0.16-1.el6.x86_64 6/12
    Cleanup : MariaDB-server-10.0.15-1.el6.x86_64 7/12
    Cleanup : MariaDB-devel-10.0.15-1.el6.x86_64 8/12
    Shutting down MySQL.. SUCCESS!
    Starting MySQL. SUCCESS!
    Cleanup : MariaDB-client-10.0.15-1.el6.x86_64 9/12
    Cleanup : MariaDB-shared-10.0.15-1.el6.x86_64 10/12
    Cleanup : MariaDB-compat-10.0.15-1.el6.x86_64 11/12
    Cleanup : MariaDB-common-10.0.15-1.el6.x86_64 12/12
    Verifying : MariaDB-client-10.0.16-1.el6.x86_64 1/12
    Verifying : MariaDB-common-10.0.16-1.el6.x86_64 2/12
    Verifying : MariaDB-compat-10.0.16-1.el6.x86_64 3/12
    Verifying : MariaDB-shared-10.0.16-1.el6.x86_64 4/12
    Verifying : MariaDB-server-10.0.16-1.el6.x86_64 5/12
    Verifying : MariaDB-devel-10.0.16-1.el6.x86_64 6/12
    Verifying : MariaDB-common-10.0.15-1.el6.x86_64 7/12
    Verifying : MariaDB-server-10.0.15-1.el6.x86_64 8/12
    Verifying : MariaDB-shared-10.0.15-1.el6.x86_64 9/12
    Verifying : MariaDB-client-10.0.15-1.el6.x86_64 10/12
    Verifying : MariaDB-compat-10.0.15-1.el6.x86_64 11/12
    Verifying : MariaDB-devel-10.0.15-1.el6.x86_64 12/12

    Updated:
    MariaDB-client.x86_64 0:10.0.16-1.el6 MariaDB-common.x86_64 0:10.0.16-1.el6 MariaDB-compat.x86_64 0:10.0.16-1.el6
    MariaDB-devel.x86_64 0:10.0.16-1.el6 MariaDB-server.x86_64 0:10.0.16-1.el6 MariaDB-shared.x86_64 0:10.0.16-1.el6

    Complete!
     
    • Like Like x 2
  3. Andy

    Andy Active Member

    312
    45
    28
    Aug 6, 2014
    Ratings:
    +54
    Local Time:
    10:01 PM
    I have 3 servers running latest centmin beta and 2 of them still having 10.0.15 version.
    I ran yum -y update many times
     
  4. eva2000

    eva2000 Administrator Staff Member

    30,152
    6,782
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,133
    Local Time:
    12:01 PM
    Nginx 1.13.x
    MariaDB 5.5
    try
    Code:
    yum clean all
    yum -y update
     
  5. Andy

    Andy Active Member

    312
    45
    28
    Aug 6, 2014
    Ratings:
    +54
    Local Time:
    10:01 PM
    same result
    Code:
    [root@andy ~]# yum clean all
    yum -y updateLoaded plugins: fastestmirror, priorities
    Cleaning repos: base elasticsearch-1.3 epel extras mariadb rpmforge updates
    Cleaning up everything
    Cleaning up list of fastest mirrors
    [root@andy ~]# yum -y update
    Loaded plugins: fastestmirror, priorities
    base                                                                                                                                                   | 3.6 kB  00:00:00
    elasticsearch-1.3                                                                                                                                      |  951 B  00:00:00
    epel/x86_64/metalink                                                                                                                                   |  12 kB  00:00:00
    epel                                                                                                                                                   | 4.4 kB  00:00:00
    extras                                                                                                                                                 | 3.4 kB  00:00:00
    mariadb                                                                                                                                                | 1.9 kB  00:00:00
    rpmforge                                                                                                                                               | 1.9 kB  00:00:00
    updates                                                                                                                                                | 3.4 kB  00:00:00
    (1/6): extras/7/x86_64/primary_db                                                                                                                      |  43 kB  00:00:00
    (2/6): base/7/x86_64/group_gz                                                                                                                          | 157 kB  00:00:00
    (3/6): epel/x86_64/group_gz                                                                                                                            | 250 kB  00:00:00
    (4/6): base/7/x86_64/primary_db                                                                                                                        | 4.9 MB  00:00:00
    (5/6): epel/x86_64/primary_db                                                                                                                          | 3.9 MB  00:00:01
    (6/6): updates/7/x86_64/primary_db                                                                                                                     | 6.6 MB  00:00:00
    (1/5): elasticsearch-1.3/primary                                                                                                                       | 1.7 kB  00:00:00
    (2/5): mariadb/primary_db                                                                                                                              |  23 kB  00:00:00
    (3/5): epel/x86_64/updateinfo                                                                                                                          | 277 kB  00:00:00
    (4/5): epel/x86_64/pkgtags                                                                                                                             | 1.3 MB  00:00:00
    (5/5): rpmforge/primary_db                                                                                                                             | 125 kB  00:00:01
    Determining fastest mirrors
     * base: mirror.us.leaseweb.net
     * epel: mirrors.mit.edu
     * extras: mirror.us.leaseweb.net
     * rpmforge: repoforge.mirror.constant.com
     * updates: mirror.us.leaseweb.net
    elasticsearch-1.3                                                                                                                                                         8/8
    124 packages excluded due to repository priority protections
    No packages marked for update
    [root@andy ~]# mysql
    Welcome to the MariaDB monitor.  Commands end with ; or \g.
    Your MariaDB connection id is 4924711
    Server version: 10.0.15-MariaDB MariaDB Server
    
    Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
     
  6. eva2000

    eva2000 Administrator Staff Member

    30,152
    6,782
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,133
    Local Time:
    12:01 PM
    Nginx 1.13.x
    MariaDB 5.5
    what's output from command

    Code:
    rpm -qa MariaDB*
    
    for example
    Code:
    rpm -qa MariaDB*
    MariaDB-common-10.0.16-1.el7.centos.x86_64
    MariaDB-client-10.0.16-1.el7.centos.x86_64
    MariaDB-shared-10.0.16-1.el7.centos.x86_64
    MariaDB-server-10.0.16-1.el7.centos.x86_64
    MariaDB-compat-10.0.16-1.el7.centos.x86_64
    MariaDB-devel-10.0.16-1.el7.centos.x86_64
    and

    Code:
    yum list MariaDB* | grep MariaDB
     
    example output

    Code:
    yum list MariaDB* | grep MariaDB
    MariaDB-client.x86_64                   10.0.16-1.el7.centos            @mariadb
    MariaDB-common.x86_64                   10.0.16-1.el7.centos            @mariadb
    MariaDB-compat.x86_64                   10.0.16-1.el7.centos            @mariadb
    MariaDB-devel.x86_64                    10.0.16-1.el7.centos            @mariadb
    MariaDB-server.x86_64                   10.0.16-1.el7.centos            @mariadb
    MariaDB-shared.x86_64                   10.0.16-1.el7.centos            @mariadb
    MariaDB-Galera-test.x86_64              10.0.16-1.el7.centos            mariadb
    MariaDB-connect-engine.x86_64           10.0.16-1.el7.centos            mariadb
    MariaDB-oqgraph-engine.x86_64           10.0.16-1.el7.centos            mariadb
    MariaDB-test.x86_64                     10.0.16-1.el7.centos            mariadb 
     
    • Like Like x 1
  7. Andy

    Andy Active Member

    312
    45
    28
    Aug 6, 2014
    Ratings:
    +54
    Local Time:
    10:01 PM
    Code:
    rpm -qa MariaDB*
    MariaDB-common-10.0.16-1.el6.x86_64
    MariaDB-devel-10.0.16-1.el6.x86_64
    MariaDB-compat-10.0.16-1.el6.x86_64
    MariaDB-client-10.0.16-1.el6.x86_64
    MariaDB-shared-10.0.16-1.el6.x86_64
    MariaDB-server-10.0.16-1.el6.x86_64
    [root@andy ~]# yum list MariaDB* | grep MariaDB
    MariaDB-client.x86_64                      10.0.16-1.el6                @mariadb
    MariaDB-common.x86_64                      10.0.16-1.el6                @mariadb
    MariaDB-compat.x86_64                      10.0.16-1.el6                @mariadb
    MariaDB-devel.x86_64                       10.0.16-1.el6                @mariadb
    MariaDB-server.x86_64                      10.0.16-1.el6                @mariadb
    MariaDB-shared.x86_64                      10.0.16-1.el6                @mariadb
    MariaDB-Galera-test.x86_64                 10.0.16-1.el6                mariadb
    MariaDB-cassandra-engine.x86_64            10.0.16-1.el6                mariadb
    MariaDB-connect-engine.x86_64              10.0.16-1.el6                mariadb
    MariaDB-oqgraph-engine.x86_64              10.0.16-1.el6                mariadb
    MariaDB-test.x86_64                        10.0.16-1.el6                mariadb
     
  8. eva2000

    eva2000 Administrator Staff Member

    30,152
    6,782
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,133
    Local Time:
    12:01 PM
    Nginx 1.13.x
    MariaDB 5.5
    from that output, you already have MariaDB 10.0.16 installed it seems

    double check with command

    Code:
    mysqladmin ver
    
     
  9. Andy

    Andy Active Member

    312
    45
    28
    Aug 6, 2014
    Ratings:
    +54
    Local Time:
    10:01 PM
    mysqladmin ver
    mysqladmin Ver 9.1 Distrib 10.0.16-MariaDB, for Linux on x86_64
    Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.

    Server version 10.0.15-MariaDB
    Protocol version 10
    Connection Localhost via UNIX socket
    UNIX socket /var/lib/mysql/mysql.sock
    Uptime: 69 days 18 hours 9 min 49 sec

    Threads: 4 Questions: 178163425 Slow queries: 542 Opens: 17630 Flush tables: 1 Open tables: 675 Queries per second avg: 29.560
     
    • Like Like x 1
  10. Andy

    Andy Active Member

    312
    45
    28
    Aug 6, 2014
    Ratings:
    +54
    Local Time:
    10:01 PM
    Server version 10.0.15-MariaDB
    Why is that?
     
  11. eva2000

    eva2000 Administrator Staff Member

    30,152
    6,782
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,133
    Local Time:
    12:01 PM
    Nginx 1.13.x
    MariaDB 5.5
    that's weird, YUM says you're on MariaDB 10.0.16 but mysqladmin ver says 10.0.15 !

    Uptime says 69 days so maybe you need a MySQL restart which should of happened when updated. Try
    Code:
    mysqladmin flush-tables
    service mysql restart
    mysqladmin ver
    
     
  12. Andy

    Andy Active Member

    312
    45
    28
    Aug 6, 2014
    Ratings:
    +54
    Local Time:
    10:01 PM
    [root@andy ~]# mysqladmin flush-tables
    [root@andy ~]# service mysql restart
    ERROR! MySQL server PID file could not be found!
    Starting MySQL SUCCESS!
    [root@andy ~]# mysqladmin ver
    mysqladmin Ver 9.1 Distrib 10.0.16-MariaDB, for Linux on x86_64
    Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.

    Server version 10.0.15-MariaDB
    Protocol version 10
    Connection Localhost via UNIX socket
    UNIX socket /var/lib/mysql/mysql.sock
    Uptime: 69 days 18 hours 15 min 46 sec

    Threads: 2 Questions: 178181372 Slow queries: 542 Opens: 17725 Flush tables: 3 Open tables: 33 Queries per second avg: 29.562
     
  13. eva2000

    eva2000 Administrator Staff Member

    30,152
    6,782
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,133
    Local Time:
    12:01 PM
    Nginx 1.13.x
    MariaDB 5.5
    seems MySQL server isn't properly restarting as uptime still 69 days and 10.0.15... might need to check your mysql error logs

    Code:
    tail -50 /var/log/mysqld.log | sed -e "s/$(hostname)/yourhostname/"
     
  14. Andy

    Andy Active Member

    312
    45
    28
    Aug 6, 2014
    Ratings:
    +54
    Local Time:
    10:01 PM
    Code:
    150203 18:25:39 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
    150203 18:25:39 [ERROR] Aborting
    
    150203 18:25:39 [Note] /usr/sbin/mysqld: Shutdown complete
    
    150203 18:25:39 mysqld_safe mysqld from pid file /var/lib/mysql/yourhostname.pid ended
    150203 18:25:39 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    150203 18:25:39 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    150203 18:25:40 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    150203 18:25:40 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    150203 18:25:41 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    150203 18:25:41 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    150203 18:25:42 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    150203 18:25:42 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    150203 18:25:43 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    150203 18:25:43 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    150203 18:25:44 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    150203 18:25:44 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    150203 18:25:45 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    150203 18:25:45 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    150203 18:25:46 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    150203 18:25:46 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    150203 18:25:47 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    150203 18:25:47 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    150203 18:25:48 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    150203 18:25:48 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    150203 18:25:49 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    150203 18:25:49 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    150203 18:25:49 [Note] InnoDB: Unable to open the first data file
    2015-02-03 18:25:49 7fd16dbe2880  InnoDB: Operating system error number 11 in a file operation.
    InnoDB: Error number 11 means 'Resource temporarily unavailable'.
    InnoDB: Some operating system error numbers are described at
    InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
    150203 18:25:49 [ERROR] InnoDB: Can't open './ibdata1'
    150203 18:25:49 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
    150203 18:25:49 [ERROR] Plugin 'InnoDB' init function returned error.
    150203 18:25:49 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    150203 18:25:49 [Note] Plugin 'FEDERATED' is disabled.
    150203 18:25:49 [Note] Plugin 'ARCHIVE' is disabled.
    150203 18:25:49 [ERROR] mysqld: Can't lock aria control file '/var/lib/mysql/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
    150203 18:26:20 [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'
    150203 18:26:20 [ERROR] Plugin 'Aria' init function returned error.
    150203 18:26:20 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
    150203 18:26:20 [Note] Plugin 'FEEDBACK' is disabled.
    150203 18:26:20 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
    150203 18:26:20 [ERROR] Aborting
    
    150203 18:26:20 [Note] /usr/sbin/mysqld: Shutdown complete
    
    150203 18:26:20 mysqld_safe mysqld from pid file /var/lib/mysql/yourhostname.pid ended
     
  15. eva2000

    eva2000 Administrator Staff Member

    30,152
    6,782
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,133
    Local Time:
    12:01 PM
    Nginx 1.13.x
    MariaDB 5.5
    hmmm what do you get from output from command below

    with mysql running
    Code:
    lsof | grep '/var/lib/mysql/aria_log_control'
    and also when mysql server is stopped
    Code:
    mysqlstop; lsof | grep '/var/lib/mysql/aria_log_control'; mysqlstart
    if there's still processes listed with 2nd output then you can first do a mysqladmin flush-tables and mysqladmin flush-logs and wait 1-5 minutes and then try to manually kill the process ids and then try restarting mysql server
     
  16. Andy

    Andy Active Member

    312
    45
    28
    Aug 6, 2014
    Ratings:
    +54
    Local Time:
    10:01 PM
    Code:
    [root@andy ~]# lsof | grep '/var/lib/mysql/aria_log_control'
    mysqld    30711         mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711  5775   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711  7432   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711  7474   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711  8770   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 12896   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 12898   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 12900   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 12903   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 12904   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 27913   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30712   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30713   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30714   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30715   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30716   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30717   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30719   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30720   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30721   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30722   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30723   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30724   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30725   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30726   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30727   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30728   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30729   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30730   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30732   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30755   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30757   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30759   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30760   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30761   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30778   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30779   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    Code:
    [root@andy ~]# mysqlstop; lsof | grep '/var/lib/mysql/aria_log_control'; mysqlstart
     ERROR! MySQL server PID file could not be found!
    mysqld    30711         mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711  5775   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711  7432   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711  7474   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711  8770   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 12896   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 12898   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 12900   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 12903   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 12904   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 27913   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30712   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30713   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30714   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30715   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30716   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30717   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30719   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30720   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30721   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30722   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30723   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30724   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30725   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30726   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30727   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30728   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30729   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30730   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30732   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30755   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30757   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30759   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30760   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30761   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30778   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    mysqld    30711 30779   mysql   13uW     REG              9,125        52  805561185 /var/lib/mysql/aria_log_control
    Starting MySQL SUCCESS!
     
  17. eva2000

    eva2000 Administrator Staff Member

    30,152
    6,782
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,133
    Local Time:
    12:01 PM
    Nginx 1.13.x
    MariaDB 5.5
    you have a stubborn process id 30711 heh

    see what is currently running in mysql processes
    Code:
    mysqladmin proc
    try
    Code:
    mysqladmin flush-tables
    mysqladmin flush-logs
    sleep 30
    service nginx stop
    kill -9 30711
    service mysql stop
    lsof | grep '/var/lib/mysql/aria_log_control'
    service mysql start
    service nginx start
    at the lsof line, it should return empty for clean mysql shutdown, if not then kill the process id(s) that return on the left column i.e. 30711 otherwise starting mysql server should be fine

    nginx stop/start just there so visitors don't get mysql can't connect errors
     
    Last edited: Feb 4, 2015
    • Like Like x 2
  18. Andy

    Andy Active Member

    312
    45
    28
    Aug 6, 2014
    Ratings:
    +54
    Local Time:
    10:01 PM
    Code:
    mysqladmin ver
    mysqladmin  Ver 9.1 Distrib 10.0.16-MariaDB, for Linux on x86_64
    Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.
    
    Server version          10.0.16-MariaDB
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /var/lib/mysql/mysql.sock
    Uptime:                 16 sec
    
    Threads: 2  Questions: 388  Slow queries: 0  Opens: 47  Flush tables: 1  Open tables: 106  Queries per second avg: 24.250
     
    • Like Like x 1
  19. eva2000

    eva2000 Administrator Staff Member

    30,152
    6,782
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,133
    Local Time:
    12:01 PM
    Nginx 1.13.x
    MariaDB 5.5
    Great :D
     
  20. RoldanLT

    RoldanLT Well-Known Member

    3,899
    949
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,298
    Local Time:
    10:01 AM
    1.11
    10.2
    Eva always very useful.
    Thanks for always helping your members ;)
    Salute!