/ Register

Learn about Centmin Mod LEMP Stack today
Register Now

[Solved] MariaDB upgrade from 5.5.37 to 10.0.11 Error

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

Tags:
Previous Thread Next Thread
Loading...
  1. May 31, 2014 #1
    rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    11:00 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. May 31, 2014 #2
    eva2000

    eva2000 Administrator Staff Member

    53,558
    12,135
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,678
    Local Time:
    1:00 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  3. May 31, 2014 #3
    rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    11:00 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. May 31, 2014 #4
    rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    11:00 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. May 31, 2014 #5
    eva2000

    eva2000 Administrator Staff Member

    53,558
    12,135
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,678
    Local Time:
    1:00 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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. May 31, 2014 #6
    rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    11:00 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. May 31, 2014 #7
    eva2000

    eva2000 Administrator Staff Member

    53,558
    12,135
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,678
    Local Time:
    1:00 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    /etc/yum.repos.d/centalt.repo should not exist on fresh installs anymore as it's totally disabled from initial install
     
  8. May 31, 2014 #8
    rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    11:00 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. May 31, 2014 #9
    rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    11:00 PM
    Mainline
    10.2
    But how come it is there?
     
  10. May 31, 2014 #10
    eva2000

    eva2000 Administrator Staff Member

    53,558
    12,135
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,678
    Local Time:
    1:00 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  11. May 31, 2014 #11
    rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    11:00 PM
    Mainline
    10.2
    Thanks , What about post #8 ? :)
     
  12. May 31, 2014 #12
    rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    11:00 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. May 31, 2014 #13
    eva2000

    eva2000 Administrator Staff Member

    53,558
    12,135
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,678
    Local Time:
    1:00 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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
     
  14. May 31, 2014 #14
    rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    11:00 PM
    Mainline
    10.2
    Aw right :D
     
  15. May 31, 2014 #15
    rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    11:00 PM
    Mainline
    10.2
  16. Jun 3, 2014 #16
    eva2000

    eva2000 Administrator Staff Member

    53,558
    12,135
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,678
    Local Time:
    1:00 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  17. Jun 4, 2014 #17
    rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    11:00 PM
    Mainline
    10.2
    I just load the two drives and select one for installation.
     
  18. Jun 4, 2014 #18
    eva2000

    eva2000 Administrator Staff Member

    53,558
    12,135
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,678
    Local Time:
    1:00 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    I see :)
     
Previous Thread Next Thread
Loading...

.