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 RoldanLT, May 31, 2014.

  1. RoldanLT

    RoldanLT Well-Known Member

    3,830
    929
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,258
    Local Time:
    7:04 PM
    1.11
    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

    29,033
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,782
    Local Time:
    9:04 PM
    Nginx 1.13.x
    MariaDB 5.5
    • Like Like x 1
  3. RoldanLT

    RoldanLT Well-Known Member

    3,830
    929
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,258
    Local Time:
    7:04 PM
    1.11
    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. RoldanLT

    RoldanLT Well-Known Member

    3,830
    929
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,258
    Local Time:
    7:04 PM
    1.11
    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

    29,033
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,782
    Local Time:
    9:04 PM
    Nginx 1.13.x
    MariaDB 5.5
    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. RoldanLT

    RoldanLT Well-Known Member

    3,830
    929
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,258
    Local Time:
    7:04 PM
    1.11
    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

    29,033
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,782
    Local Time:
    9:04 PM
    Nginx 1.13.x
    MariaDB 5.5
    /etc/yum.repos.d/centalt.repo should not exist on fresh installs anymore as it's totally disabled from initial install
     
  8. RoldanLT

    RoldanLT Well-Known Member

    3,830
    929
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,258
    Local Time:
    7:04 PM
    1.11
    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. RoldanLT

    RoldanLT Well-Known Member

    3,830
    929
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,258
    Local Time:
    7:04 PM
    1.11
    10.2
    But how come it is there?
     
  10. eva2000

    eva2000 Administrator Staff Member

    29,033
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,782
    Local Time:
    9:04 PM
    Nginx 1.13.x
    MariaDB 5.5
  11. RoldanLT

    RoldanLT Well-Known Member

    3,830
    929
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,258
    Local Time:
    7:04 PM
    1.11
    10.2
    Thanks , What about post #8 ? :)
     
  12. RoldanLT

    RoldanLT Well-Known Member

    3,830
    929
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,258
    Local Time:
    7:04 PM
    1.11
    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

    29,033
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,782
    Local Time:
    9:04 PM
    Nginx 1.13.x
    MariaDB 5.5
    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. RoldanLT

    RoldanLT Well-Known Member

    3,830
    929
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,258
    Local Time:
    7:04 PM
    1.11
    10.2
    Aw right :D
     
  15. RoldanLT

    RoldanLT Well-Known Member

    3,830
    929
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,258
    Local Time:
    7:04 PM
    1.11
    10.2
  16. eva2000

    eva2000 Administrator Staff Member

    29,033
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,782
    Local Time:
    9:04 PM
    Nginx 1.13.x
    MariaDB 5.5
  17. RoldanLT

    RoldanLT Well-Known Member

    3,830
    929
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,258
    Local Time:
    7:04 PM
    1.11
    10.2
    I just load the two drives and select one for installation.
     
  18. eva2000

    eva2000 Administrator Staff Member

    29,033
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,782
    Local Time:
    9:04 PM
    Nginx 1.13.x
    MariaDB 5.5
    I see :)