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

rdan · May 27, 2014

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

rdan · May 27, 2014

Please take a look @eva2000

rdan · May 27, 2014

Running
service mysql start
mysql: unrecognized service
Opz

rdan · May 27, 2014

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

rdan · May 27, 2014

Looks like problem here: http://centos.alt.ru/repository/centos/6/x86_64/repodata/repomd.xml

Matt · May 27, 2014

Yeah, your server can't reach the repo at the minute where it's trying to get the install from.

eva2000 · May 27, 2014

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

rdan · May 27, 2014

Even me, can't readh the repo url.
Any fix for this?
Why am I using .ru domain?

rdan · May 27, 2014

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

eva2000 · May 27, 2014

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

rdan · May 27, 2014

And now, got this:
yum -q -y remove perl-DBD-MySQL
Warning: RPMDB altered outside of yum.

eva2000 · May 27, 2014

oh re-read post 7 instructions i gave you the wrong repo contents for centos5 not centos6

/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

eva2000 · May 27, 2014

RoldanLT said: ↑

And now, got this:
yum -q -y remove perl-DBD-MySQL
Warning: RPMDB altered outside of yum.
Click to expand...

can ignore that

rdan · May 27, 2014

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

rdan · May 27, 2014

eva2000 said: ↑
oh re-read post 7 instructions i gave you the wrong repo contents for centos5 not centos6

/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
Click to expand...
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

rdan · May 27, 2014

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

eva2000 · May 27, 2014

that's correct then, so you can proceed from http://community.centminmod.com/thr...my-live-server-got-an-error-help.72/#post-212 check if MariaDB 10 exists

for rpm -e errors, if you still get errors removing on packages use rpm -e --nodeps instead
Code:
rpm -e --nodeps $OLDMARIADBSHARED

rdan · May 27, 2014

eva2000 said: ↑
that's correct then, so you can proceed from http://community.centminmod.com/thr...my-live-server-got-an-error-help.72/#post-212 check if MariaDB 10 exists

for rpm -e errors, if you still get errors removing on packages use rpm -e --nodeps instead
Code:
rpm -e --nodeps $OLDMARIADBSHARED
Click to expand...
# 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.

eva2000 · May 27, 2014

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

rdan · May 27, 2014

eva2000 said: ↑

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
Click to expand...

Thank you so much !~

Log in / Register

Forums

Get the most out of your Centmin Mod LEMP stack

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

rdan Well-Known Member

rdan Well-Known Member

rdan Well-Known Member

rdan Well-Known Member

rdan Well-Known Member

Matt Well-Known Member

eva2000 Administrator Staff Member

rdan Well-Known Member

rdan Well-Known Member

eva2000 Administrator Staff Member

rdan Well-Known Member

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

rdan Well-Known Member

rdan Well-Known Member

rdan Well-Known Member

eva2000 Administrator Staff Member

rdan Well-Known Member

eva2000 Administrator Staff Member

rdan Well-Known Member

.

Log in / Register

Useful Searches

Get the most out of your Centmin Mod LEMP stack

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

rdan Well-Known Member

rdan Well-Known Member

rdan Well-Known Member

rdan Well-Known Member

rdan Well-Known Member

Matt Well-Known Member

eva2000 Administrator Staff Member

rdan Well-Known Member

rdan Well-Known Member

eva2000 Administrator Staff Member

rdan Well-Known Member

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

rdan Well-Known Member

rdan Well-Known Member

rdan Well-Known Member

eva2000 Administrator Staff Member

rdan Well-Known Member

eva2000 Administrator Staff Member

rdan Well-Known Member

.