Discover Centmin Mod today
Register Now

MariaDB Upgrade to MariaDB 10 on my Live server, got an error help :(

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by RoldanLT, May 27, 2014.

  1. RoldanLT

    RoldanLT Well-Known Member

    3,930
    960
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,311
    Local Time:
    1:22 AM
    1.11
    10.2
    mysql_upgrade
    inc/mariadb_upgrade10.inc: line 315: mysql_upgrade: command not found
    ------------------------------------------------
    Installing MariaDB 10 plugins
    ------------------------------------------------
    mysql -e "INSTALL SONAME 'metadata_lock_info';"
    inc/mariadb_upgrade10.inc: line 320: mysql: command not found
    mysql -e "INSTALL SONAME 'query_cache_info';"
    inc/mariadb_upgrade10.inc: line 322: mysql: command not found
    mysql -e "INSTALL SONAME 'query_response_time';"
    inc/mariadb_upgrade10.inc: line 324: mysql: command not found
    mysql -t -e "SELECT * FROM mysql.plugin;"
    inc/mariadb_upgrade10.inc: line 331: mysql: command not found
    mysql -t -e "SHOW PLUGINS;"
    inc/mariadb_upgrade10.inc: line 333: mysql: command not found
    mysql -t -e "SHOW ENGINES;"
    inc/mariadb_upgrade10.inc: line 335: mysql: command not found
    mysql: unrecognized service

    http://centos.alt.ru/repository/centos/6/x86_64/repodata/repomd.xml: [Errno 14] PYCURL ERROR 22 - "The requested URL returned error: 404 Not Found"
    Trying other mirror.
    Error: Cannot retrieve repository metadata (repomd.xml) for repository: CentALT. Please verify its path and try again
     
  2. RoldanLT

    RoldanLT Well-Known Member

    3,930
    960
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,311
    Local Time:
    1:22 AM
    1.11
    10.2
  3. RoldanLT

    RoldanLT Well-Known Member

    3,930
    960
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,311
    Local Time:
    1:22 AM
    1.11
    10.2
    Running
    service mysql start
    mysql: unrecognized service
    Opz :(
     
  4. RoldanLT

    RoldanLT Well-Known Member

    3,930
    960
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,311
    Local Time:
    1:22 AM
    1.11
    10.2
    Log:

    #####################################################
    Current MariaDB versions installed:
    MariaDB-compat-5.5.37-1.el6.x86_64
    MariaDB-common-5.5.37-1.el6.x86_64
    MariaDB-shared-5.5.37-1.el6.x86_64
    #####################################################
    Proceeding to remove existing MariaDB versions:
    please wait while processing....
    http://centos.alt.ru/repository/centos/6/x86_64/repodata/repomd.xml: [Errno 14] PYCURL ERROR 22 - "The requested URL returned error: 404 Not Found"
    Trying other mirror.
    Error: Cannot retrieve repository metadata (repomd.xml) for repository: CentALT. Please verify its path and try again
    You could try using --skip-broken to work around the problem
    You could try running: rpm -Va --nofiles --nodigest
    rpm -e
    rpm -e
    rpm -e
    rpm -e
    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
    rpm: no packages given for erase
    rpm: no packages given for erase
    rpm: no packages given for erase
    error: Failed dependencies:
    libmysqlclient.so.18()(64bit) is needed by (installed) postfix-2:2.11.0-1.el6.x86_64
    libmysqlclient.so.18(libmysqlclient_18)(64bit) is needed by (installed) postfix-2:2.11.0-1.el6.x86_64
    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-shared-5.5.37-1.el6.x86_64
    rpm: no packages given for erase
    Loaded plugins: downloadonly, fastestmirror, priorities
    Cleaning repos: CentALT 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: CentALT 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
    *************************************************

    http://centos.alt.ru/repository/centos/6/x86_64/repodata/repomd.xml: [Errno 14] PYCURL ERROR 22 - "The requested URL returned error: 404 Not Found"
    Trying other mirror.
    Error: Cannot retrieve repository metadata (repomd.xml) for repository: CentALT. Please verify its path and try again

    real 0m4.236s
    user 0m0.208s
    sys 0m0.056s

    *************************************************
    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: centos.mirror.iweb.ca
    * epel: less.cogeco.net
    * extras: centos.mirror.iweb.ca
    * rpmforge: mirror.team-cymru.org
    * updates: centos.mirror.iweb.ca
    http://centos.alt.ru/repository/centos/6/x86_64/repodata/repomd.xml: [Errno 14] PYCURL ERROR 22 - "The requested URL returned error: 404 Not Found"
    Trying other mirror.
    Error: Cannot retrieve repository metadata (repomd.xml) for repository: CentALT. Please verify its path and try again

    real 0m1.054s
    user 0m0.196s
    sys 0m0.024s

    *************************************************
    * Adjust old MariaDB 5.2.x /etc/my.cnf
    for MariaDB 5.5 my.cnf compatibility
    *************************************************

    mysql: unrecognized service
     
  5. RoldanLT

    RoldanLT Well-Known Member

    3,930
    960
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,311
    Local Time:
    1:22 AM
    1.11
    10.2
  6. Matt

    Matt Moderator Staff Member

    691
    320
    63
    May 25, 2014
    Sheffield, UK
    Ratings:
    +445
    Local Time:
    5:22 PM
    1.7.1
    MariaDB 10
    Yeah, your server can't reach the repo at the minute where it's trying to get the install from.
     
  7. eva2000

    eva2000 Administrator Staff Member

    30,546
    6,849
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,262
    Local Time:
    3:22 AM
    Nginx 1.13.x
    MariaDB 5.5
    looks like MariaDB 10 wasn't properly installed as CentALT repo is 404 not found now http://centos.alt.ru/pub/repository/centos/6/ :(

    so you might need to do it manually

    first disable CentALT repo

    edit /etc/yum.repos.d/centalt.repo and set enable=0

    then type yum clean all

    then remove remaining MariaDB 5.5 packages typing these commands

    Code:
    OLDMARIADBSHARED=`rpm -qa | grep MariaDB | awk '/MariaDB-shared/'`
    OLDMARIADBCLIENT=`rpm -qa | grep MariaDB | awk '/MariaDB-client/'`
    OLDMARIADBDEVEL=`rpm -qa | grep MariaDB | awk '/MariaDB-devel/'`
    OLDMARIADBSERVER=`rpm -qa | grep MariaDB | awk '/MariaDB-server/'`
    OLDMARIADBTEST=`rpm -qa | grep MariaDB | awk '/MariaDB-test/'`
    OLDMARIADBCOMMON=`rpm -qa | grep MariaDB | awk '/MariaDB-common/'`
    yum -q -y remove perl-DBD-MySQL
    rpm -e $OLDMARIADBTEST
    rpm -e $OLDMARIADBCLIENT
    rpm -e $OLDMARIADBDEVEL
    rpm -e $OLDMARIADBSERVER
    rpm -e $OLDMARIADBSHARED
    rpm -e $OLDMARIADBCOMMON
    rpm -e $OLDMARIADBCOMPAT
    yum clean all
    if you still get errors removing on packages use rpm -e --nodeps instead

    then add MariaDB 10 repo key

    Code:
    rpm --import http://yum.mariadb.org/RPM-GPG-KEY-MariaDB
    then ensure MariaDB 10 repo was setup properly for 64bit OS in /etc/yum.repos.d/mariadb.repo ensure you see the following

    Code:
    # rpm --import http://yum.mariadb.org/RPM-GPG-KEY-MariaDB
    # /etc/yum.repos.d/mariadb.repo
    # yum install MariaDB-server MariaDB-client
    # http://downloads.mariadb.org/mariadb/repositories/
    [mariadb]
    name = MariaDB
    baseurl = http://yum.mariadb.org/10.0/centos6-amd64
    gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
    gpgcheck=1
    
    then type yum clean all

    then check that MariaDB 10 packages are available type

    Code:
    yum list MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared
    then if they are install them

    Code:
    yum -y install MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared
    for each and every package conflict you get, do a rpm -e packagename command and then try again for yum install. If you still get errors removing on packages use rpm -e --nodeps instead

    backup my.cnf

    Code:
    cp -a /etc/my.cnf /etc/my.cnf-newold
    then adjust my.cnf for MariaDB 10 compatibility

    Code:
    sed -i 's/skip-pbxt/#skip-pbxt/g' /etc/my.cnf
    sed -i 's/innodb_use_purge_thread = 4/innodb_purge_threads=1/g' /etc/my.cnf
    sed -i 's/innodb_extra_rsegments/#innodb_extra_rsegments/g' /etc/my.cnf
    sed -i 's/innodb_adaptive_checkpoint/innodb_adaptive_flushing_method/g' /etc/my.cnf
    sed -i 's/innodb_additional_mem_pool_size/#innodb_additional_mem_pool_size/g' /etc/my.cnf
    sed -i 's/skip-innodb/innodb=ON/g' /etc/my.cnf
    
    echo "" >> /etc/my.cnf
    echo "" >> /etc/my.cnf
    echo "[mariadb-10.0]" >> /etc/my.cnf
    echo "# 2 variables needed to switch from XtraDB to InnoDB plugins" >> /etc/my.cnf
    echo "#plugin-load=ha_innodb" >> /etc/my.cnf
    echo "#ignore_builtin_innodb" >> /etc/my.cnf
    echo "" >> /etc/my.cnf
    echo "## MariaDB 10 InnoDB plugin only" >> /etc/my.cnf
    echo "#innodb_buffer_pool_load_now=1" >> /etc/my.cnf
    echo "#innodb_buffer_pool_dump_now=1" >> /etc/my.cnf
    echo "## Disabled settings" >> /etc/my.cnf
    echo "performance_schema=OFF" >> /etc/my.cnf
    echo "innodb_stats_on_metadata=OFF" >> /etc/my.cnf
    echo "innodb_sort_buffer_size=2M" >> /etc/my.cnf
    echo "innodb_online_alter_log_max_size=128M" >> /etc/my.cnf
    echo "query_cache_strip_comments=0" >> /etc/my.cnf
    echo "log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk" >> /etc/my.cnf
    
    then start mysql

    Code:
    service mysql start
    then run mysql_upgrade

    Code:
    mysql_upgrade
    then type the following

    Code:
        echo "------------------------------------------------"
        echo "Installing MariaDB 10 plugins"
        echo "------------------------------------------------"
        echo "mysql -e \"INSTALL SONAME 'metadata_lock_info';\""
        mysql -e "INSTALL SONAME 'metadata_lock_info';"
        echo "mysql -e \"INSTALL SONAME 'query_cache_info';\""
        mysql -e "INSTALL SONAME 'query_cache_info';"
        echo "mysql -e \"INSTALL SONAME 'query_response_time';\""
        mysql -e "INSTALL SONAME 'query_response_time';"
        echo "mysql -t -e \"SELECT * FROM mysql.plugin;\""
        mysql -t -e "SELECT * FROM mysql.plugin;"
        echo "mysql -t -e \"SHOW PLUGINS;\""
        mysql -t -e "SHOW PLUGINS;"
        echo "mysql -t -e \"SHOW ENGINES;\""
        mysql -t -e "SHOW ENGINES;"
    sed -i 's/innodb_doublewrite = 1/#innodb_doublewrite = 1/g' /etc/my.cnf
    sed -i 's/innodb_doublewrite=1/#innodb_doublewrite=1/g' /etc/my.cnf
    service mysql restart
    yum -q -y install perl-DBD-MySQL
    
     
    Last edited: May 27, 2014
  8. RoldanLT

    RoldanLT Well-Known Member

    3,930
    960
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,311
    Local Time:
    1:22 AM
    1.11
    10.2
    Even me, can't readh the repo url.
    Any fix for this?
    Why am I using .ru domain?
     
  9. RoldanLT

    RoldanLT Well-Known Member

    3,930
    960
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,311
    Local Time:
    1:22 AM
    1.11
    10.2
    And now, stuck on this:

    yum -q -y remove perl-DBD-MySQL
    http://centos.alt.ru/repository/centos/6/x86_64/repodata/repomd.xml: [Errno 14] PYCURL ERROR 22 - "The requested URL returned error: 404 Not Found"
    Trying other mirror.
    Error: Cannot retrieve repository metadata (repomd.xml) for repository: CentALT. Please verify its path and try again
    You could try using --skip-broken to work around the problem
    You could try running: rpm -Va --nofiles --nodigest
    [root@server32 centmin-v1.2.3mod]# yum -q -y remove perl-DBD-MySQL --skip-broken
    http://centos.alt.ru/repository/centos/6/x86_64/repodata/repomd.xml: [Errno 14] PYCURL ERROR 22 - "The requested URL returned error: 404 Not Found"
    Trying other mirror.
    Error: Cannot retrieve repository metadata (repomd.xml) for repository: CentALT. Please verify its path and try again
    You could try running: rpm -Va --nofiles --nodigest
     
  10. eva2000

    eva2000 Administrator Staff Member

    30,546
    6,849
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,262
    Local Time:
    3:22 AM
    Nginx 1.13.x
    MariaDB 5.5
    did you do above post's first instruction to edit /etc/yum.repos.d/centalt.repo and set enable=0

    then type yum clean all

    CentALT repo just so happens to be run off that domain
     
  11. RoldanLT

    RoldanLT Well-Known Member

    3,930
    960
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,311
    Local Time:
    1:22 AM
    1.11
    10.2
    And now, got this:
    yum -q -y remove perl-DBD-MySQL
    Warning: RPMDB altered outside of yum.
     
  12. eva2000

    eva2000 Administrator Staff Member

    30,546
    6,849
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,262
    Local Time:
    3:22 AM
    Nginx 1.13.x
    MariaDB 5.5
    oh re-read post 7 instructions i gave you the wrong repo contents for centos5 not centos6 :eek:

    /etc/yum.repos.d/mariadb.repo ensure you see the following

    Code:
    # rpm --import http://yum.mariadb.org/RPM-GPG-KEY-MariaDB
    # /etc/yum.repos.d/mariadb.repo
    # yum install MariaDB-server MariaDB-client
    # http://downloads.mariadb.org/mariadb/repositories/
    [mariadb]
    name = MariaDB
    baseurl = http://yum.mariadb.org/10.0/centos6-amd64
    gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
    gpgcheck=1
    
     
  13. eva2000

    eva2000 Administrator Staff Member

    30,546
    6,849
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,262
    Local Time:
    3:22 AM
    Nginx 1.13.x
    MariaDB 5.5
    can ignore that
     
  14. RoldanLT

    RoldanLT Well-Known Member

    3,930
    960
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,311
    Local Time:
    1:22 AM
    1.11
    10.2
    This?

    rpm -e $OLDMARIADBSHARED
    error: Failed dependencies:
    libmysqlclient.so.18()(64bit) is needed by (installed) postfix-2:2.11.0-1.el6.x86_64
    libmysqlclient.so.18(libmysqlclient_18)(64bit) is needed by (installed) postfix-2:2.11.0-1.el6.x86_64
     
  15. RoldanLT

    RoldanLT Well-Known Member

    3,930
    960
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,311
    Local Time:
    1:22 AM
    1.11
    10.2
    I got:
    # rpm --import http://yum.mariadb.org/RPM-GPG-KEY-MariaDB
    # /etc/yum.repos.d/mariadb.repo
    # yum install MariaDB-server MariaDB-client
    # http://downloads.mariadb.org/mariadb/repositories/
    [mariadb]
    name = MariaDB
    baseurl = http://yum.mariadb.org/10.0/centos6-amd64
    gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
    gpgcheck=1
    exclude=MariaDB-Galera-server
     
  16. RoldanLT

    RoldanLT Well-Known Member

    3,930
    960
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,311
    Local Time:
    1:22 AM
    1.11
    10.2
    This can't be ignore right?

    # rpm -e $OLDMARIADBSHARED
    error: Failed dependencies:
    libmysqlclient.so.18()(64bit) is needed by (installed) postfix-2:2.11.0-1.el6.x86_64
    libmysqlclient.so.18(libmysqlclient_18)(64bit) is needed by (installed) postfix-2:2.11.0-1.el6.x86_64
    [root@server32 ~]# rpm -e $OLDMARIADBCOMMON
    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-shared-5.5.37-1.el6.x86_64
     
  17. eva2000

    eva2000 Administrator Staff Member

    30,546
    6,849
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,262
    Local Time:
    3:22 AM
    Nginx 1.13.x
    MariaDB 5.5
    Last edited: May 27, 2014
  18. RoldanLT

    RoldanLT Well-Known Member

    3,930
    960
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,311
    Local Time:
    1:22 AM
    1.11
    10.2
    # rpm -e --nodeps $OLDMARIADBSHARED
    error: package MariaDB-shared-5.5.37-1.el6.x86_64 is not installed
    [root@server32 ~]# rpm -e --nodeps $OLDMARIADBCOMMON
    error: package MariaDB-common-5.5.37-1.el6.x86_64 is not installed


    Thanks a lot for the help :(

    Looks working now.
     
    • Like Like x 1
  19. eva2000

    eva2000 Administrator Staff Member

    30,546
    6,849
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,262
    Local Time:
    3:22 AM
    Nginx 1.13.x
    MariaDB 5.5
    yeah ignore not installed errors, means you already uninstalled them :)

    Aren't you glad the forum exists heh.

    Hence, why MariaDB 10 upgrade routine in .07 beta is still disabled by default :)

    off to bed for me :D
     
    • Like Like x 2
  20. RoldanLT

    RoldanLT Well-Known Member

    3,930
    960
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,311
    Local Time:
    1:22 AM
    1.11
    10.2
    Thank you so much !~ (y) :angelic:
     
    • Like Like x 1