Want to subscribe to topics you're interested in?
Become a Member

cminfo not compatible with MariaDB 10.1?

Discussion in 'Bug Reports' started by rdan, Dec 2, 2015.

  1. rdan

    rdan Premium Member Premium Member

    4,245
    1,033
    113
    May 25, 2014
    Ratings:
    +1,481
    Local Time:
    11:57 PM
    Mainline
    10.2
    I got this output:
    Code:
     System Up Since:     2015-11-17 07:59:10
    System Uptime:     up 2 weeks, 16 hours, 50 minutes
    MySQL Server Started     not running
    MySQL Uptime:         not running
    MySQL Uptime (secs):     not running
    Server Type:         kvm
    CentOS Version:     7.1
    Centmin Mod:         1.2.3-eva2000.09
    Nginx PageSpeed:     OFF
    Nginx Version:     1.9.7
    PHP-FPM Version:     5.6.16
    MariaDB Version:     10.1.9
    CSF Firewall:         v8.08
    Memcached Server:     1.4.24
    NSD Version:         61:
    Siege Version:     3.1.0
    Maldet Version:     not installed
    ClamAV Version:     not installed
    ElasticSearch:     2.1.0
    
    Seems not detecting for this value:

     
    • Informative Informative x 1
  2. eva2000

    eva2000 Administrator Staff Member

    35,617
    7,844
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,093
    Local Time:
    1:57 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    Ah variables changed i think in MariaDB 10.1. Thanks for bug report !

    on MariaDB 10.0.x
    Code:
    rpm -qa | grep -i MariaDB-server | head -n1 | cut -d '-' -f3
    10.0.22
    Code:
    mysqladmin ext | awk '/Uptime|Uptime_since_flush_status/ { print $4 }' | head -n1
    4271
    Code:
    mysqladmin ver | awk '/Uptime/ { print $2, $3, $4, $5, $6, $7, $8, $9 }'
    1 hour 11 min 43 sec  
    Code:
    mysql -e "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP() - variable_value) AS server_start FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE variable_name='Uptime';" | egrep -Ev '+--|server_start'
    2015-12-01 16:07:08
     
    • Like Like x 1
  3. eva2000

    eva2000 Administrator Staff Member

    35,617
    7,844
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,093
    Local Time:
    1:57 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    let's see what MariaDB 10.1.9 shows for these commands

    on MariaDB 10.1.9
    Code:
    rpm -qa | grep -i MariaDB-server | head -n1 | cut -d '-' -f3
    10.1.9
    why ? the full name without cut is
    Code:
    rpm -qa | grep -i MariaDB-server
    MariaDB-server-10.1.9-1.el7.centos.x86_64
    Code:
    mysqladmin ext | awk '/Uptime|Uptime_since_flush_status/ { print $4 }' | head -n1
    614
    
    Code:
    mysqladmin ver | awk '/Uptime/ { print $2, $3, $4, $5, $6, $7, $8, $9 }'
    10 min 30 sec    
    
    Code:
    mysql -e "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP() - variable_value) AS server_start FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE variable_name='Uptime';" | egrep -Ev '+--|server_start'
    2015-12-01 17:23:14
    
    all work fine.. so it's probably because you're using mysql remote database server ? There's no provisions in cminfo for remote mysql database servers right now, so it's normal to have what you see
     
  4. rdan

    rdan Premium Member Premium Member

    4,245
    1,033
    113
    May 25, 2014
    Ratings:
    +1,481
    Local Time:
    11:57 PM
    Mainline
    10.2
    No, just local server.
     
  5. eva2000

    eva2000 Administrator Staff Member

    35,617
    7,844
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,093
    Local Time:
    1:57 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    strange then.. what do you get when you run those listed above commands manually on MariaDB 10.1 ?
     
  6. eva2000

    eva2000 Administrator Staff Member

    35,617
    7,844
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,093
    Local Time:
    1:57 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    Ah might be related to my code in cminfo and fact on CentOS7 only MariaDB service name changed from mysql to mariadb !

    see code centminmod/cminfo.sh at master · centminmod/centminmod · GitHub

    strangely MariaDB 10.1. has both service names in use
    Code:
    service mysql status
     ERROR! MySQL is running but PID file could not be found
    
    Code:
    service mariadb status
    Redirecting to /bin/systemctl status  mariadb.service
    mariadb.service - MariaDB database server
       Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled)
      Drop-In: /etc/systemd/system/mariadb.service.d
               └─migrated-from-my.cnf-settings.conf
       Active: active (running) since Tue 2015-12-01 17:23:15 UTC; 24min ago
    Main PID: 907 (mysqld)
       Status: "Taking your SQL requests now..."
       CGroup: /system.slice/mariadb.se
     
  7. rdan

    rdan Premium Member Premium Member

    4,245
    1,033
    113
    May 25, 2014
    Ratings:
    +1,481
    Local Time:
    11:57 PM
    Mainline
    10.2
    All work fine, hmmm.
    [​IMG]
     
  8. eva2000

    eva2000 Administrator Staff Member

    35,617
    7,844
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,093
    Local Time:
    1:57 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    • Like Like x 1
  9. eva2000

    eva2000 Administrator Staff Member

    35,617
    7,844
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,093
    Local Time:
    1:57 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    • Like Like x 1
    • Informative Informative x 1
..