Author Topic: error while upgrading mariadb  (Read 9182 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
error while upgrading mariadb
« on: August 23, 2020, 07:21:13 AM »


upgraded mariadb with the following instructions which i found from this forum

https://www.mysterydata.com/upgrade-mariadb-5-5-to-mariadb-10-2-on-centos-7-vesta-cp/


and later i found update CWP i clicked update all

after download and update

CWP displayed following message and showing failed

please guide me what to do



Resolving Dependencies
--> Running transaction check
---> Package MariaDB-server.x86_64 0:10.1.46-1.el7.centos will be updated
---> Package MariaDB-server.x86_64 0:10.2.33-1.el7.centos will be an update
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package             Arch        Version                     Repository    Size
================================================================================
Updating:
 MariaDB-server      x86_64      10.2.33-1.el7.centos        mariadb       24 M

Transaction Summary
================================================================================
Upgrade  1 Package

Total size: 24 M
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction

******************************************************************
A MySQL or MariaDB server package (MariaDB-server-10.1.46-1.el7.centos.x86_64) is installed.

Upgrading directly from MySQL 10.1 to MariaDB 10.2 may not
be safe in all cases.  A manual dump and restore using mysqldump is
recommended.  It is important to review the MariaDB manual's Upgrading
section for version-specific incompatibilities.

A manual upgrade is required.

- Ensure that you have a complete, working backup of your data and my.cnf
  files
- Shut down the MySQL server cleanly
- Remove the existing MySQL packages.  Usually this command will
  list the packages you should remove:
  rpm -qa | grep -i '^mysql-'

  You may choose to use 'rpm --nodeps -ev ' to remove
  the package which contains the mysqlclient shared library.  The
  library will be reinstalled by the MariaDB-shared package.
- Install the new MariaDB packages supplied by MariaDB Foundation
- Ensure that the MariaDB server is started
- Run the 'mysql_upgrade' program

This is a brief description of the upgrade process.  Important details
can be found in the MariaDB manual, in the Upgrading section.
******************************************************************
error: %pre(MariaDB-server-10.2.33-1.el7.centos.x86_64) scriptlet failed, exit status 1
  Verifying  : MariaDB-server-10.2.33-1.el7.centos.x86_64                   1/2
  Verifying  : MariaDB-server-10.1.46-1.el7.centos.x86_64                   2/2

Failed:
  MariaDB-server.x86_64 0:10.1.46-1.el7.centos                                 
  MariaDB-server.x86_64 0:10.2.33-1.el7.centos                                 

Complete!



and in dashboard showing the following

Apache version: Apache/2.4.39
PHP version: 7.4.9
MySQL version: 10.2.33-MariaDB
FTP version: 1.0.47
SSH Port: 22
MySql Port: 3306
Web Servers: apache-only



from putty   mysql-v

its showing
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 32801
Server version: 10.1.46-MariaDB MariaDB Server

Offline
*****
Re: error while upgrading mariadb
« Reply #1 on: August 23, 2020, 09:29:49 AM »
helllo
first you need to remove any old version of mariadb 10.1 packages and then install 10.2

Offline
*
Re: error while upgrading mariadb
« Reply #2 on: August 23, 2020, 04:28:31 PM »
hello can you guide me how to do that


i followed this url

https://www.mysterydata.com/upgrade-mariadb-5-5-to-mariadb-10-2-on-centos-7-vesta-cp/

unable to remove old version


thanks

Offline
*
Re: error while upgrading mariadb
« Reply #3 on: August 24, 2020, 03:16:44 AM »
i tried to stop mariadb for upgrade

https://www.systemmen.com/web-server/vestacp/how-to-update-vestacp-to-mariadb-10-3-285.html

displayed  following error

[root@vps ~]# service mariadb stop
Redirecting to /bin/systemctl stop mariadb.service

** (pkttyagent:559): WARNING **: 03:12:38.769: Unable to register authentication agent: GDBus.Error:org.freedesktop.PolicyKit1.Error.Failed: Cannot determine user of subject
Error registering authentication agent: GDBus.Error:org.freedesktop.PolicyKit1.Error.Failed: Cannot determine user of subject (polkit-error-quark, 0)
[root@vps ~]# sudo yum update mysql-server

Offline
*****
Re: error while upgrading mariadb
« Reply #4 on: August 24, 2020, 08:57:29 AM »
systemctl stop mysql mysqld
yum remove MariaDB-server MariaDB-client

then follow the guide
https://www.mysterydata.com/upgrade-mariadb-5-5-to-mariadb-10-2-on-centos-7-vesta-cp/

Offline
*
Re: error while upgrading mariadb
« Reply #5 on: August 24, 2020, 11:21:40 AM »
thank you

upgraded without error