Control Web Panel
WebPanel => Updates => Topic started by: dp41646 on November 29, 2020, 12:35:12 PM
-
Hi,
today I've received notification for MariaDB update to version 10.2.36-1.el7.centos
This is part of log:
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.36-1.el7.centos.x86_64) scriptlet failed, exit status 1
Verifying : MariaDB-server-10.1.48-1.el7.centos.x86_64 1/2
Verifying : MariaDB-server-10.2.36-1.el7.centos.x86_64 2/2
Failed:
MariaDB-server.x86_64 0:10.1.48-1.el7.centos
MariaDB-server.x86_64 0:10.2.36-1.el7.centos
Complete!
-
Hello,
I have the same problem, I have the pro version.
Thank you, for the one who has a solution.
-
Here is the solution I found:
First step to save your database (I didn't do it!)
mysqldump --all-databases > /home/fullbackup.sql.gz
Uninstall MariaDB client:
yum remove MariaDB-server MariaDB-client -y
Now install MariaDB, it will automatically install MariaDB 10.2 (10.2.36):
yum install MariaDB-server MariaDB-client -y
Then to finish:
mysql_upgrade
-
Is it really necessary to do this upgrade? Do we have to?
-
I'll wait for a CWP official solution, probably a script update to do the upgrade process automatically...
-
Here is the solution I found:
First step to save your database (I didn't do it!)
mysqldump --all-databases > /home/fullbackup.sql.gz
Uninstall MariaDB client:
yum remove MariaDB-server MariaDB-client -y
Now install MariaDB, it will automatically install MariaDB 10.2 (10.2.36):
yum install MariaDB-server MariaDB-client -y
Then to finish:
mysql_upgrade
You didn't do the all procedure or only the backup step?
It worked for you?
-
I'll wait for a CWP official solution, probably a script update to do the upgrade process automatically...
me too...
-
Here is the solution I found:
First step to save your database (I didn't do it!)
mysqldump --all-databases > /home/fullbackup.sql.gz
Uninstall MariaDB client:
yum remove MariaDB-server MariaDB-client -y
Now install MariaDB, it will automatically install MariaDB 10.2 (10.2.36):
yum install MariaDB-server MariaDB-client -y
Then to finish:
mysql_upgrade
well , this worked fine for me .. thanks .. ;)
-
Below the steps that I made...
1. Create a backup file.
mysqldump --all-databases > /home/fullbackup.sql.gz
2. Disable InnoDB fast shutdown
mysql
mysql -> SET GLOBAL innodb_fast_shutdown = 0;
3. Stop MariaDB
service mysql stop
4. Manually uninstall MariaDB 10.1
yum remove MariaDB-server MariaDB-client -y
5. Manually install MariaDB 10.2
yum install MariaDB-server MariaDB-client -y
6. Start MariaDB
service mysql start
7. Upgrade the DB to compatibility
mysql_upgrade
8. Enable service "mariadb.service" on "Services config -> Start-up Services".
systemctl enable mariadb.service
9. Reboot to check if all right.
reboot
If everything all right, relax and drink a coffee. If not, breath and drink a coffee to find a fix, but stay calm... you have a backup (Do you made the 1st step, right?).
-
I'll wait for a CWP official solution, probably a script update to do the upgrade process automatically...
I will also love this.
I also have the same issue in all my 3 VPS.
Atleast waiting for an official guide to fix this.
-
I did this and fixed my issue:
mysqldump --all-databases > /root/fullbackup.sql.gz
yum remove MariaDB-server MariaDB-client -y
yum install MariaDB-server MariaDB-client -y
mysql_upgrade
systemctl enable mariadb.service
This finished in like 1 minute or so...
And for cleanup
rm /root/fullbackup.sql.gz
-
It's highly recommended set innodb_fast_shutdown to 0 and manually stop the mariadb.service before remove current version and install the new version...
-
I have the same problem ....
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.36-1.el7.centos.x86_64) scriptlet failed, exit status 1
Verifying : MariaDB-server-10.1.48-1.el7.centos.x86_64 1/2
Verifying : MariaDB-server-10.2.36-1.el7.centos.x86_64 2/2
Failed:
MariaDB-server.x86_64 0:10.1.48-1.el7.centos
MariaDB-server.x86_64 0:10.2.36-1.el7.centos
Complete!
Complete! ?????
-
Below the steps that I made...
1. Create a backup file.
mysqldump --all-databases > /home/fullbackup.sql.gz
2. Disable InnoDB fast shutdown
mysql
mysql -> SET GLOBAL innodb_fast_shutdown = 0;
3. Stop MariaDB
service mysql stop
4. Manually uninstall MariaDB 10.1
yum remove MariaDB-server MariaDB-client -y
5. Manually install MariaDB 10.2
yum install MariaDB-server MariaDB-client -y
6. Start MariaDB
service mysql start
7. Upgrade the DB to compatibility
mysql_upgrade
8. Enable service "mariadb.service" on "Services config -> Start-up Services".
systemctl enable mariadb.service
9. Reboot to check if all right.
reboot
If everything all right, relax and drink a coffee. If not, breath and drink a coffee to find a fix, but stay calm... you have a backup (Do you made the 1st step, right?).
Works for me.
Thank You!
-
@sandeep
I followed your how to on how to upgrade MariaDB following this instruction set: https://forum.centos-webpanel.com/index.php?topic=9471.msg33152#msg33152
It worked, thanks for the support you give it is the best IMHO
Now I have this issue in CWP admin (using CWPpro) in the services status panel it displays "MySQL Database Server" = failed
"The status log reads: InnoDB: Unable to lock ./ibdata1 error: 11
[Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files."
How does one go about clearing this up?
Running on CentOS 7.5
-
Hi, I do not think somebody can help you on the forum. There are too many reasons and the problem must be checked by a system administrator.
-
Ref.: https://www.mysterydata.com/update-upgrade-to-mariadb-10-4-on-vestacp-cwp-centos-7/
Go thru the steps again, make sure NOT to miss one or else it will mess everything up.
Especially Step 2. You want to follow the 2nd step labeled "For MariaDB 10.0/10.1/10.2/10.3 :", and NOT the 1st one.
I've used this guide on multiple servers, never had a problem.
If it still doesn't work. I agree with Igor, you'll have to have CWP support look at it.
CentOS 8 is a little easier, it has 10.4 by default.
You create the repo for 10.5, run dnf update and BAM that's it.
-
Upgrade successful
But my email smtp giving error when sending email
SMTP 451. Failed to add recipient.
Server configuration problem.
Please help
Here is the solution I found:
First step to save your database (I didn't do it!)
mysqldump --all-databases > /home/fullbackup.sql.gz
Uninstall MariaDB client:
yum remove MariaDB-server MariaDB-client -y
Now install MariaDB, it will automatically install MariaDB 10.2 (10.2.36):
yum install MariaDB-server MariaDB-client -y
Then to finish:
mysql_upgrade