Welcome to Centmin Mod Community
Register Now

[Solved] MariaDB upgrade from 5.5.37 to 10.0.11 Error

Discussion in 'Bug Reports' started by rdan, May 31, 2014.

  1. rdan

    rdan Premium Member Premium Member

    4,197
    1,014
    113
    May 25, 2014
    Ratings:
    +1,438
    Local Time:
    4:56 PM
    Mainline
    10.2
    The problem with cent-alt still exsit on MariaDB upgrade menu [HASHTAG]#11[/HASHTAG] then #3:
    Code:
    --------------------------------------------------------
            MariaDB MySQL Upgrade Sub-Menu
    --------------------------------------------------------
    1). MariaDB 5.2.x Branch Upgrade Only
    2). MariaDB 5.2.x to MariaDB 5.5 YUM upgrade
    3). MariaDB 5.5 to MariaDB 10.x YUM upgrade
    4). Back to Main menu
    --------------------------------------------------------
    Enter option [ 1 - 4 ] 3
    --------------------------------------------------------
    
    --------------------------------------------------------------------------------
    This script's MariaDB 10.x upgrade process is still in
    beta testing stages. So please test on a test server
    and not a live production server. But if you use on
    live server or if MySQL databases already exist,
    please back them up before running this upgrade
    script via mysqldump - instructions at:
    http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html.
    
    For each DATABASENAME backup via mysqldump i.e.
    
      mysqldump --opt --routines DATABASENAME > /path/to/DATABASENAME_backup.sql
    --------------------------------------------------------------------------------
    
    Have you backed up your databases ? [y/n] y
    
    MariaDB 10.x no longer works with mydumper
    MySQL backup tool. But still works with MariaDB 5.2.x
    Do you want to continue with upgrade to MariaDB 10.x ? [y/n] y
    #####################################################
    Current MariaDB versions installed:
    MariaDB-common-5.5.37-1.el6.x86_64
    MariaDB-shared-5.5.37-1.el6.x86_64
    MariaDB-compat-5.5.37-1.el6.x86_64
    MariaDB-client-5.5.37-1.el6.x86_64
    MariaDB-server-5.5.37-1.el6.x86_64
    MariaDB-devel-5.5.37-1.el6.x86_64
    #####################################################
    Proceeding to remove existing MariaDB versions:
    please wait while processing....
    rpm -e
    rpm -e MariaDB-client-5.5.37-1.el6.x86_64
    rpm -e MariaDB-devel-5.5.37-1.el6.x86_64
    rpm -e MariaDB-server-5.5.37-1.el6.x86_64
    rpm -e MariaDB-shared-5.5.37-1.el6.x86_64
    rpm -e MariaDB-common-5.5.37-1.el6.x86_64
    rpm: no packages given for erase
    error: Failed dependencies:
            MariaDB-client is needed by (installed) MariaDB-server-5.5.37-1.el6.x86_64
    warning: /etc/init.d/mysql saved as /etc/init.d/mysql.rpmsave
    error: Failed dependencies:
            MariaDB-common is needed by (installed) MariaDB-compat-5.5.37-1.el6.x86_64
            MariaDB-common is needed by (installed) MariaDB-client-5.5.37-1.el6.x86_64
    rpm: no packages given for erase
    Loaded plugins: downloadonly, fastestmirror, priorities
    Cleaning repos: base epel extras mariadb rpmforge updates
    Cleaning up Everything
    Cleaning up list of fastest mirrors
    #####################################################
    *************************************************
    MariaDB 10.x Repo setup...
    *************************************************
    
    Loaded plugins: downloadonly, fastestmirror, priorities
    Cleaning repos: base epel extras mariadb rpmforge updates
    Cleaning up Everything
    rpm --import http://yum.mariadb.org/RPM-GPG-KEY-MariaDB
    
    grep: /etc/yum.repos.d/centalt.repo: No such file or directory
    
    *************************************************
    MariaDB 10.x check available packages
    yum -q list MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared
    *************************************************
    
    Error: File contains no section headers.
    file: file://///etc/yum.repos.d/centalt.repo, line: 1
    'exclude=mariadb*\n'
    
    real    0m0.115s
    user    0m0.103s
    sys     0m0.012s
    
    *************************************************
    MariaDB 10.x YUM install...
    yum -q -y install MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared
    *************************************************
    
    Loaded plugins: downloadonly, fastestmirror, priorities
    Error: File contains no section headers.
    file: file://///etc/yum.repos.d/centalt.repo, line: 1
    'exclude=mariadb*\n'
    
    real    0m0.115s
    user    0m0.103s
    sys     0m0.011s
    
    *************************************************
    * Adjust old MariaDB 5.2.x /etc/my.cnf
      for MariaDB 5.5 my.cnf compatibility
    *************************************************
    
    mysql: unrecognized service
    
    ------------------------------------------------
    Updating MySQL database tables
    ------------------------------------------------
    Do you have a MySQL root password set ? [y/n]: n
    
    mysql_upgrade
    inc/mariadb_upgrade10.inc: line 315: mysql_upgrade: command not found
    ------------------------------------------------
    Installing MariaDB 10 plugins
    ------------------------------------------------
    mysql -e "INSTALL SONAME 'metadata_lock_info';"
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    mysql -e "INSTALL SONAME 'query_cache_info';"
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    mysql -e "INSTALL SONAME 'query_response_time';"
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    mysql -t -e "SELECT * FROM mysql.plugin;"
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    mysql -t -e "SHOW PLUGINS;"
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    mysql -t -e "SHOW ENGINES;"
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    mysql: unrecognized service
    
    Error: File contains no section headers.
    file: file://///etc/yum.repos.d/centalt.repo, line: 1
    'exclude=mariadb*\n'
    
    ------------------------------------------------
    MariaDB 10.x Upgrade completed
    ------------------------------------------------
    
    --------------------------------------------------------
            MariaDB MySQL Upgrade Sub-Menu
    --------------------------------------------------------
    1). MariaDB 5.2.x Branch Upgrade Only
    2). MariaDB 5.2.x to MariaDB 5.5 YUM upgrade
    3). MariaDB 5.5 to MariaDB 10.x YUM upgrade
    4). Back to Main menu
    --------------------------------------------------------
    
    I'm using the latest beta zip.
     
  2. eva2000

    eva2000 Administrator Staff Member

    34,624
    7,653
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +11,771
    Local Time:
    6:56 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    • Like Like x 1
  3. rdan

    rdan Premium Member Premium Member

    4,197
    1,014
    113
    May 25, 2014
    Ratings:
    +1,438
    Local Time:
    4:56 PM
    Mainline
    10.2
    Still got this problem:
    Code:
    MariaDB 10.x no longer works with mydumper
    MySQL backup tool. But still works with MariaDB 5.2.x
    Do you want to continue with upgrade to MariaDB 10.x ? [y/n] y
    #####################################################
    Current MariaDB versions installed:
    MariaDB-common-5.5.37-1.el6.x86_64
    MariaDB-compat-5.5.37-1.el6.x86_64
    MariaDB-client-5.5.37-1.el6.x86_64
    #####################################################
    Proceeding to remove existing MariaDB versions:
    please wait while processing....
    No Match for argument: perl-DBD-MySQL
    Error: File contains no section headers.
    file: file://///etc/yum.repos.d/centalt.repo, line: 1
    'exclude=mariadb*\n'
    rpm -e
    rpm -e MariaDB-client-5.5.37-1.el6.x86_64
    rpm -e
    rpm -e
    rpm -e
    rpm -e MariaDB-common-5.5.37-1.el6.x86_64
    rpm: no packages given for erase
    rpm: no packages given for erase
    rpm: no packages given for erase
    rpm: no packages given for erase
    error: Failed dependencies:
            MariaDB-common is needed by (installed) MariaDB-compat-5.5.37-1.el6.x86_64
    rpm: no packages given for erase
    Loaded plugins: downloadonly, fastestmirror, priorities
    Error: File contains no section headers.
    file: file://///etc/yum.repos.d/centalt.repo, line: 1
    'exclude=mariadb*\n'
    #####################################################
    *************************************************
    MariaDB 10.x Repo setup...
    *************************************************
    
    Loaded plugins: downloadonly, fastestmirror, priorities
    Error: File contains no section headers.
    file: file://///etc/yum.repos.d/centalt.repo, line: 1
    'exclude=mariadb*\n'
    rpm --import http://yum.mariadb.org/RPM-GPG-KEY-MariaDB
    
    *************************************************
    MariaDB 10.x check available packages
    yum -q list MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared
    *************************************************
    
    Error: File contains no section headers.
    file: file://///etc/yum.repos.d/centalt.repo, line: 1
    'exclude=mariadb*\n'
    
    real    0m0.115s
    user    0m0.104s
    sys     0m0.010s
    
    *************************************************
    MariaDB 10.x YUM install...
    yum -q -y install MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared
    *************************************************
    
    Loaded plugins: downloadonly, fastestmirror, priorities
    Error: File contains no section headers.
    file: file://///etc/yum.repos.d/centalt.repo, line: 1
    'exclude=mariadb*\n'
    
    real    0m0.115s
    user    0m0.098s
    sys     0m0.016s
    
    *************************************************
    * Adjust old MariaDB 5.2.x /etc/my.cnf
      for MariaDB 5.5 my.cnf compatibility
    *************************************************
    
    mysql: unrecognized service
    
    ------------------------------------------------
    Updating MySQL database tables
    ------------------------------------------------
    Do you have a MySQL root password set ? [y/n]: n
    
    mysql_upgrade
    inc/mariadb_upgrade10.inc: line 324: mysql_upgrade: command not found
    ------------------------------------------------
    Installing MariaDB 10 plugins
    ------------------------------------------------
    mysql -e "INSTALL SONAME 'metadata_lock_info';"
    inc/mariadb_upgrade10.inc: line 329: mysql: command not found
    mysql -e "INSTALL SONAME 'query_cache_info';"
    inc/mariadb_upgrade10.inc: line 331: mysql: command not found
    mysql -e "INSTALL SONAME 'query_response_time';"
    inc/mariadb_upgrade10.inc: line 333: mysql: command not found
    mysql -t -e "SELECT * FROM mysql.plugin;"
    inc/mariadb_upgrade10.inc: line 340: mysql: command not found
    mysql -t -e "SHOW PLUGINS;"
    inc/mariadb_upgrade10.inc: line 342: mysql: command not found
    mysql -t -e "SHOW ENGINES;"
    inc/mariadb_upgrade10.inc: line 344: mysql: command not found
    mysql: unrecognized service
    
    Error: File contains no section headers.
    file: file://///etc/yum.repos.d/centalt.repo, line: 1
    'exclude=mariadb*\n'
    
    ------------------------------------------------
    MariaDB 10.x Upgrade completed
    ------------------------------------------------
    
    --------------------------------------------------------
            MariaDB MySQL Upgrade Sub-Menu
    --------------------------------------------------------
    1). MariaDB 5.2.x Branch Upgrade Only
    2). MariaDB 5.2.x to MariaDB 5.5 YUM upgrade
    3). MariaDB 5.5 to MariaDB 10.x YUM upgrade
    4). Back to Main menu
    --------------------------------------------------------
    Enter option [ 1 - 4 ] 4
    
     
  4. rdan

    rdan Premium Member Premium Member

    4,197
    1,014
    113
    May 25, 2014
    Ratings:
    +1,438
    Local Time:
    4:56 PM
    Mainline
    10.2
    Maybe something wrong with the way you modify centalt.repo?
    Running this also produce an error:
    Code:
    # yum clean all
    Loaded plugins: downloadonly, fastestmirror, priorities
    Error: File contains no section headers.
    file: file://///etc/yum.repos.d/centalt.repo, line: 1
    'exclude=mariadb*\n'
    
    checking centalt.repo file content:
    Code:
    exclude=mariadb*
    
     
  5. eva2000

    eva2000 Administrator Staff Member

    34,624
    7,653
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +11,771
    Local Time:
    6:56 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    fresh download and re-install or just replacing updated .07 beta 21 files and trying rerunning menu option [HASHTAG]#11[/HASHTAG] again ?

    The fix is for fresh installs for the later need to do the following 2 commands before trying again
    Code:
    rm -rf /etc/yum.repos.d/centalt.repo
    yum clean all
     
  6. rdan

    rdan Premium Member Premium Member

    4,197
    1,014
    113
    May 25, 2014
    Ratings:
    +1,438
    Local Time:
    4:56 PM
    Mainline
    10.2
    It should be this?
    Code:
    [CentALT]
    name=CentALT Packages for Enterprise Linux 6 - $basearch
    baseurl=http://centos.alt.ru/repository/centos/6/$basearch/
    enabled=0
    gpgcheck=0
    
    priority=9
    exclude=mariadb*
    
     
  7. eva2000

    eva2000 Administrator Staff Member

    34,624
    7,653
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +11,771
    Local Time:
    6:56 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    /etc/yum.repos.d/centalt.repo should not exist on fresh installs anymore as it's totally disabled from initial install
     
  8. rdan

    rdan Premium Member Premium Member

    4,197
    1,014
    113
    May 25, 2014
    Ratings:
    +1,438
    Local Time:
    4:56 PM
    Mainline
    10.2
    Upgraded fine now, but I have two remaining v5.5.37 installed.
    How come it is still there?
    How to fix/remove them?

    Code:
    Do you want to continue with upgrade to MariaDB 10.x ? [y/n] y
    #####################################################
    Current MariaDB versions installed:
    MariaDB-common-5.5.37-1.el6.x86_64
    MariaDB-compat-5.5.37-1.el6.x86_64
    #####################################################
    Proceeding to remove existing MariaDB versions:
    please wait while processing....
    No Match for argument: perl-DBD-MySQL
    rpm -e
    rpm -e
    rpm -e
    rpm -e
    rpm -e
    rpm -e MariaDB-common-5.5.37-1.el6.x86_64
    rpm: no packages given for erase
    rpm: no packages given for erase
    rpm: no packages given for erase
    rpm: no packages given for erase
    rpm: no packages given for erase
    error: Failed dependencies:
            MariaDB-common is needed by (installed) MariaDB-compat-5.5.37-1.el6.x86_64
    rpm: no packages given for erase
    Loaded plugins: downloadonly, fastestmirror, priorities
    Cleaning repos: base epel extras mariadb rpmforge updates
    Cleaning up Everything
    Cleaning up list of fastest mirrors
    #####################################################
    *************************************************
    MariaDB 10.x Repo setup...
    *************************************************
    
    Loaded plugins: downloadonly, fastestmirror, priorities
    Cleaning repos: base epel extras mariadb rpmforge updates
    Cleaning up Everything
    rpm --import http://yum.mariadb.org/RPM-GPG-KEY-MariaDB
    
    *************************************************
    MariaDB 10.x check available packages
    yum -q list MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared
    *************************************************
    
    Installed Packages
    MariaDB-common.x86_64                   5.5.37-1.el6                    @mariadb
    MariaDB-compat.x86_64                   5.5.37-1.el6                    @mariadb
    Available Packages
    MariaDB-client.x86_64                   10.0.11-1.el6                   mariadb
    MariaDB-common.x86_64                   10.0.11-1.el6                   mariadb
    MariaDB-compat.x86_64                   10.0.11-1.el6                   mariadb
    MariaDB-devel.x86_64                    10.0.11-1.el6                   mariadb
    MariaDB-server.x86_64                   10.0.11-1.el6                   mariadb
    MariaDB-shared.x86_64                   10.0.11-1.el6                   mariadb
    
    real    0m13.099s
    user    0m4.747s
    sys     0m0.237s
    
    *************************************************
    MariaDB 10.x YUM install...
    yum -q -y install MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared
    *************************************************
    
    Loaded plugins: downloadonly, fastestmirror, priorities
    Loading mirror speeds from cached hostfile
    * base: less.cogeco.net
    * epel: less.cogeco.net
    * extras: centos.bhs.mirrors.ovh.net
    * rpmforge: repoforge.mirror.constant.com
    * updates: centos.bhs.mirrors.ovh.net
    1544 packages excluded due to repository priority protections
    Setting up Install Process
    Resolving Dependencies
    --> Running transaction check
    ---> Package MariaDB-client.x86_64 0:10.0.11-1.el6 will be installed
    ---> Package MariaDB-common.x86_64 0:5.5.37-1.el6 will be updated
    ---> Package MariaDB-common.x86_64 0:10.0.11-1.el6 will be an update
    ---> Package MariaDB-compat.x86_64 0:5.5.37-1.el6 will be updated
    ---> Package MariaDB-compat.x86_64 0:10.0.11-1.el6 will be an update
    ---> Package MariaDB-devel.x86_64 0:10.0.11-1.el6 will be installed
    ---> Package MariaDB-server.x86_64 0:10.0.11-1.el6 will be installed
    ---> Package MariaDB-shared.x86_64 0:10.0.11-1.el6 will be installed
    --> Finished Dependency Resolution
    
    Dependencies Resolved
    
    ================================================================================
    Package               Arch          Version               Repository      Size
    ================================================================================
    Installing:
    MariaDB-client        x86_64        10.0.11-1.el6         mariadb         11 M
    MariaDB-devel         x86_64        10.0.11-1.el6         mariadb        6.5 M
    MariaDB-server        x86_64        10.0.11-1.el6         mariadb         52 M
    MariaDB-shared        x86_64        10.0.11-1.el6         mariadb        1.3 M
    Updating:
    MariaDB-common        x86_64        10.0.11-1.el6         mariadb         23 k
    MariaDB-compat        x86_64        10.0.11-1.el6         mariadb        2.7 M
    
    Transaction Summary
    ================================================================================
    Install       4 Package(s)
    Upgrade       2 Package(s)
    
    Total download size: 74 M
    Downloading Packages:
    --------------------------------------------------------------------------------
    Total                                           6.7 MB/s |  74 MB     00:10
    Running rpm_check_debug
    Running Transaction Test
    Transaction Test Succeeded
    Running Transaction
    Warning: RPMDB altered outside of yum.
      Updating   : MariaDB-common-10.0.11-1.el6.x86_64                          1/8
      Updating   : MariaDB-compat-10.0.11-1.el6.x86_64                          2/8
      Installing : MariaDB-client-10.0.11-1.el6.x86_64                          3/8
      Installing : MariaDB-server-10.0.11-1.el6.x86_64                          4/8
      Installing : MariaDB-devel-10.0.11-1.el6.x86_64                           5/8
      Installing : MariaDB-shared-10.0.11-1.el6.x86_64                          6/8
      Cleanup    : MariaDB-common-5.5.37-1.el6.x86_64                           7/8
      Cleanup    : MariaDB-compat-5.5.37-1.el6.x86_64                           8/8
      Verifying  : MariaDB-client-10.0.11-1.el6.x86_64                          1/8
      Verifying  : MariaDB-compat-10.0.11-1.el6.x86_64                          2/8
      Verifying  : MariaDB-devel-10.0.11-1.el6.x86_64                           3/8
      Verifying  : MariaDB-common-10.0.11-1.el6.x86_64                          4/8
      Verifying  : MariaDB-server-10.0.11-1.el6.x86_64                          5/8
      Verifying  : MariaDB-shared-10.0.11-1.el6.x86_64                          6/8
      Verifying  : MariaDB-common-5.5.37-1.el6.x86_64                           7/8
      Verifying  : MariaDB-compat-5.5.37-1.el6.x86_64                           8/8
    
    Installed:
      MariaDB-client.x86_64 0:10.0.11-1.el6  MariaDB-devel.x86_64 0:10.0.11-1.el6
      MariaDB-server.x86_64 0:10.0.11-1.el6  MariaDB-shared.x86_64 0:10.0.11-1.el6
    
    Updated:
      MariaDB-common.x86_64 0:10.0.11-1.el6  MariaDB-compat.x86_64 0:10.0.11-1.el6
    
    Complete!
    
    real    0m30.362s
    user    0m15.977s
    sys     0m1.162s
    
    *************************************************
    * Adjust old MariaDB 5.2.x /etc/my.cnf
      for MariaDB 5.5 my.cnf compatibility
    *************************************************
    
    Starting MySQL..... SUCCESS!
    
    ------------------------------------------------
    Updating MySQL database tables
    ------------------------------------------------
    Do you have a MySQL root password set ? [y/n]: n
    
    mysql_upgrade
    Phase 1/3: Fixing table and database names
    Phase 2/3: Checking and upgrading tables
    Processing databases
    information_schema
    mysql
    mysql.columns_priv                                 OK
    mysql.db                                           OK
    mysql.event                                        OK
    mysql.func                                         OK
    mysql.help_category                                OK
    mysql.help_keyword                                 OK
    mysql.help_relation                                OK
    mysql.help_topic                                   OK
    mysql.host                                         OK
    mysql.ndb_binlog_index                             OK
    mysql.plugin                                       OK
    mysql.proc                                         OK
    mysql.procs_priv                                   OK
    mysql.proxies_priv                                 OK
    mysql.servers                                      OK
    mysql.tables_priv                                  OK
    mysql.time_zone                                    OK
    mysql.time_zone_leap_second                        OK
    mysql.time_zone_name                               OK
    mysql.time_zone_transition                         OK
    mysql.time_zone_transition_type                    OK
    mysql.user                                         OK
    performance_schema
    test
    Phase 3/3: Running 'mysql_fix_privilege_tables'...
    OK
    ------------------------------------------------
    Installing MariaDB 10 plugins
    ------------------------------------------------
    mysql -e "INSTALL SONAME 'metadata_lock_info';"
    mysql -e "INSTALL SONAME 'query_cache_info';"
    mysql -e "INSTALL SONAME 'query_response_time';"
    mysql -t -e "SELECT * FROM mysql.plugin;"
    +---------------------------+------------------------+
    | name                      | dl                     |
    +---------------------------+------------------------+
    | METADATA_LOCK_INFO        | metadata_lock_info.so  |
    | QUERY_CACHE_INFO          | query_cache_info.so    |
    | QUERY_RESPONSE_TIME       | query_response_time.so |
    | QUERY_RESPONSE_TIME_AUDIT | query_response_time.so |
    +---------------------------+------------------------+
    mysql -t -e "SHOW PLUGINS;"
    +-----------------------------+----------+--------------------+------------------------+---------+
    | Name                        | Status   | Type               | Library                | License |
    +-----------------------------+----------+--------------------+------------------------+---------+
    | binlog                      | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
    | mysql_native_password       | ACTIVE   | AUTHENTICATION     | NULL                   | GPL     |
    | mysql_old_password          | ACTIVE   | AUTHENTICATION     | NULL                   | GPL     |
    | CSV                         | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
    | MEMORY                      | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
    | MyISAM                      | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
    | MRG_MyISAM                  | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
    | BLACKHOLE                   | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
    | InnoDB                      | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
    | XTRADB_READ_VIEW            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | XTRADB_INTERNAL_HASH_TABLES | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | XTRADB_RSEG                 | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_TRX                  | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_LOCKS                | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_LOCK_WAITS           | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_CMP                  | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_CMP_RESET            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_CMPMEM               | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_CMPMEM_RESET         | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_CMP_PER_INDEX        | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_CMP_PER_INDEX_RESET  | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_BUFFER_PAGE          | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_BUFFER_PAGE_LRU      | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_BUFFER_POOL_STATS    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_METRICS              | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_FT_DEFAULT_STOPWORD  | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_FT_DELETED           | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_FT_BEING_DELETED     | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_FT_CONFIG            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_FT_INDEX_CACHE       | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_FT_INDEX_TABLE       | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_SYS_TABLES           | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_SYS_TABLESTATS       | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_SYS_INDEXES          | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_SYS_COLUMNS          | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_SYS_FIELDS           | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_SYS_FOREIGN          | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_SYS_FOREIGN_COLS     | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_SYS_TABLESPACES      | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_SYS_DATAFILES        | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | INNODB_CHANGED_PAGES        | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | FEDERATED                   | DISABLED | STORAGE ENGINE     | NULL                   | GPL     |
    | ARCHIVE                     | DISABLED | STORAGE ENGINE     | NULL                   | GPL     |
    | PERFORMANCE_SCHEMA          | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
    | Aria                        | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
    | FEEDBACK                    | DISABLED | INFORMATION SCHEMA | NULL                   | GPL     |
    | partition                   | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
    | METADATA_LOCK_INFO          | ACTIVE   | INFORMATION SCHEMA | metadata_lock_info.so  | GPL     |
    | QUERY_CACHE_INFO            | ACTIVE   | INFORMATION SCHEMA | query_cache_info.so    | BSD     |
    | QUERY_RESPONSE_TIME         | ACTIVE   | INFORMATION SCHEMA | query_response_time.so | GPL     |
    | QUERY_RESPONSE_TIME_AUDIT   | ACTIVE   | AUDIT              | query_response_time.so | GPL     |
    +-----------------------------+----------+--------------------+------------------------+---------+
    mysql -t -e "SHOW ENGINES;"
    +--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
    | Engine             | Support | Comment                                                                    | Transactions | XA   | Savepoints |
    +--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
    | CSV                | YES     | CSV storage engine                                                         | NO           | NO   | NO         |
    | MRG_MyISAM         | YES     | Collection of identical MyISAM tables                                      | NO           | NO   | NO         |
    | MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                  | NO           | NO   | NO         |
    | BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears)             | NO           | NO   | NO         |
    | MyISAM             | YES     | MyISAM storage engine                                                      | NO           | NO   | NO         |
    | InnoDB             | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES          | YES  | YES        |
    | ARCHIVE            | NO      | Archive storage engine                                                     | NULL         | NULL | NULL       |
    | FEDERATED          | NO      | FederatedX pluggable storage engine                                        | NULL         | NULL | NULL       |
    | PERFORMANCE_SCHEMA | YES     | Performance Schema                                                         | NO           | NO   | NO         |
    | Aria               | YES     | Crash-safe tables with MyISAM heritage                                     | NO           | NO   | NO         |
    +--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
    Shutting down MySQL.. SUCCESS!
    Starting MySQL... SUCCESS!
    
    
    ------------------------------------------------
    MariaDB 10.x Upgrade completed
    ------------------------------------------------
    
    --------------------------------------------------------
            MariaDB MySQL Upgrade Sub-Menu
    --------------------------------------------------------
    1). MariaDB 5.2.x Branch Upgrade Only
    2). MariaDB 5.2.x to MariaDB 5.5 YUM upgrade
    3). MariaDB 5.5 to MariaDB 10.x YUM upgrade
    4). Back to Main menu
    --------------------------------------------------------
    
     
  9. rdan

    rdan Premium Member Premium Member

    4,197
    1,014
    113
    May 25, 2014
    Ratings:
    +1,438
    Local Time:
    4:56 PM
    Mainline
    10.2
    But how come it is there?
     
  10. eva2000

    eva2000 Administrator Staff Member

    34,624
    7,653
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +11,771
    Local Time:
    6:56 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
  11. rdan

    rdan Premium Member Premium Member

    4,197
    1,014
    113
    May 25, 2014
    Ratings:
    +1,438
    Local Time:
    4:56 PM
    Mainline
    10.2
    Thanks , What about post #8 ? :)
     
  12. rdan

    rdan Premium Member Premium Member

    4,197
    1,014
    113
    May 25, 2014
    Ratings:
    +1,438
    Local Time:
    4:56 PM
    Mainline
    10.2
    MariaDB-common.x86_64 is not removed because it's required for MariaDB-compat based on this log:
    So maybe alter the command to remove rpm's?
    MariaDB-compat first then MariaDB-common?
     
  13. eva2000

    eva2000 Administrator Staff Member

    34,624
    7,653
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +11,771
    Local Time:
    6:56 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    they got updated fine i see your posted extract

    Code:
    *************************************************
    MariaDB 10.x YUM install...
    yum -q -y install MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared
    *************************************************
    
    Loaded plugins: downloadonly, fastestmirror, priorities
    Loading mirror speeds from cached hostfile
    * base: less.cogeco.net
    * epel: less.cogeco.net
    * extras: centos.bhs.mirrors.ovh.net
    * rpmforge: repoforge.mirror.constant.com
    * updates: centos.bhs.mirrors.ovh.net
    1544 packages excluded due to repository priority protections
    Setting up Install Process
    Resolving Dependencies
    --> Running transaction check
    ---> Package MariaDB-client.x86_64 0:10.0.11-1.el6 will be installed
    ---> Package MariaDB-common.x86_64 0:5.5.37-1.el6 will be updated
    ---> Package MariaDB-common.x86_64 0:10.0.11-1.el6 will be an update
    ---> Package MariaDB-compat.x86_64 0:5.5.37-1.el6 will be updated
    ---> Package MariaDB-compat.x86_64 0:10.0.11-1.el6 will be an update
    ---> Package MariaDB-devel.x86_64 0:10.0.11-1.el6 will be installed
    ---> Package MariaDB-server.x86_64 0:10.0.11-1.el6 will be installed
    ---> Package MariaDB-shared.x86_64 0:10.0.11-1.el6 will be installed
    --> Finished Dependency Resolution
    
    Dependencies Resolved
    
    ================================================================================
    Package               Arch          Version               Repository      Size
    ================================================================================
    Installing:
    MariaDB-client        x86_64        10.0.11-1.el6         mariadb         11 M
    MariaDB-devel         x86_64        10.0.11-1.el6         mariadb        6.5 M
    MariaDB-server        x86_64        10.0.11-1.el6         mariadb         52 M
    MariaDB-shared        x86_64        10.0.11-1.el6         mariadb        1.3 M
    Updating:
    MariaDB-common        x86_64        10.0.11-1.el6         mariadb         23 k
    MariaDB-compat        x86_64        10.0.11-1.el6         mariadb        2.7 M
    
    Transaction Summary
    ================================================================================
    Install       4 Package(s)
    Upgrade       2 Package(s)
    
    Total download size: 74 M
    Downloading Packages:
    --------------------------------------------------------------------------------
    Total                                           6.7 MB/s |  74 MB     00:10
    Running rpm_check_debug
    Running Transaction Test
    Transaction Test Succeeded
    Running Transaction
    Warning: RPMDB altered outside of yum.
      Updating   : MariaDB-common-10.0.11-1.el6.x86_64                          1/8
      Updating   : MariaDB-compat-10.0.11-1.el6.x86_64                          2/8
      Installing : MariaDB-client-10.0.11-1.el6.x86_64                          3/8
      Installing : MariaDB-server-10.0.11-1.el6.x86_64                          4/8
      Installing : MariaDB-devel-10.0.11-1.el6.x86_64                           5/8
      Installing : MariaDB-shared-10.0.11-1.el6.x86_64                          6/8
      Cleanup    : MariaDB-common-5.5.37-1.el6.x86_64                           7/8
      Cleanup    : MariaDB-compat-5.5.37-1.el6.x86_64                           8/8
      Verifying  : MariaDB-client-10.0.11-1.el6.x86_64                          1/8
      Verifying  : MariaDB-compat-10.0.11-1.el6.x86_64                          2/8
      Verifying  : MariaDB-devel-10.0.11-1.el6.x86_64                           3/8
      Verifying  : MariaDB-common-10.0.11-1.el6.x86_64                          4/8
      Verifying  : MariaDB-server-10.0.11-1.el6.x86_64                          5/8
      Verifying  : MariaDB-shared-10.0.11-1.el6.x86_64                          6/8
      Verifying  : MariaDB-common-5.5.37-1.el6.x86_64                           7/8
      Verifying  : MariaDB-compat-5.5.37-1.el6.x86_64                           8/8
    
    Installed:
      MariaDB-client.x86_64 0:10.0.11-1.el6  MariaDB-devel.x86_64 0:10.0.11-1.el6
      MariaDB-server.x86_64 0:10.0.11-1.el6  MariaDB-shared.x86_64 0:10.0.11-1.el6
    
    Updated:
      MariaDB-common.x86_64 0:10.0.11-1.el6  MariaDB-compat.x86_64 0:10.0.11-1.el6
    
    Complete!
    
    real    0m30.362s
    user    0m15.977s
    sys     0m1.162s
    
    *************************************************
    * Adjust old MariaDB 5.2.x /etc/my.cnf
      for MariaDB 5.5 my.cnf compatibility
    just type yum list to check

    Code:
    yum -q list MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared
     
    • Like Like x 1
  14. rdan

    rdan Premium Member Premium Member

    4,197
    1,014
    113
    May 25, 2014
    Ratings:
    +1,438
    Local Time:
    4:56 PM
    Mainline
    10.2
    Aw right :D
     
  15. rdan

    rdan Premium Member Premium Member

    4,197
    1,014
    113
    May 25, 2014
    Ratings:
    +1,438
    Local Time:
    4:56 PM
    Mainline
    10.2
  16. eva2000

    eva2000 Administrator Staff Member

    34,624
    7,653
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +11,771
    Local Time:
    6:56 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
  17. rdan

    rdan Premium Member Premium Member

    4,197
    1,014
    113
    May 25, 2014
    Ratings:
    +1,438
    Local Time:
    4:56 PM
    Mainline
    10.2
    I just load the two drives and select one for installation.
     
  18. eva2000

    eva2000 Administrator Staff Member

    34,624
    7,653
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +11,771
    Local Time:
    6:56 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    I see :)
     
..