MariaDB update failed

[dp41646]

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!

[comeback]

Hello,

I have the same problem, I have the pro version.

Thank you, for the one who has a solution.

[comeback]

Here is the solution I found:

First step to save your database (I didn't do it!)

Code Select Expand

mysqldump --all-databases > /home/fullbackup.sql.gz

Uninstall MariaDB client:

Code Select Expand

yum remove MariaDB-server MariaDB-client -y

Now install MariaDB, it will automatically install MariaDB 10.2 (10.2.36):

Code Select Expand

yum install MariaDB-server MariaDB-client -y

Then to finish:

Code Select Expand

mysql_upgrade

[acss001]

Is it really necessary to do this upgrade? Do we have to?

[ehstbr]

I'll wait for a CWP official solution, probably a script update to do the upgrade process automatically...

[ehstbr]

Here is the solution I found:

First step to save your database (I didn't do it!)

Code Select Expand

mysqldump --all-databases > /home/fullbackup.sql.gz

Uninstall MariaDB client:

Code Select Expand

yum remove MariaDB-server MariaDB-client -y

Now install MariaDB, it will automatically install MariaDB 10.2 (10.2.36):

Code Select Expand

yum install MariaDB-server MariaDB-client -y

Then to finish:

Code Select Expand

mysql_upgrade

You didn't do the all procedure or only the backup step?

It worked for you?

[dp41646]

I'll wait for a CWP official solution, probably a script update to do the upgrade process automatically...

me too...

[intramanga]

Here is the solution I found:

First step to save your database (I didn't do it!)

Code Select Expand

mysqldump --all-databases > /home/fullbackup.sql.gz

Uninstall MariaDB client:

Code Select Expand

yum remove MariaDB-server MariaDB-client -y

Now install MariaDB, it will automatically install MariaDB 10.2 (10.2.36):

Code Select Expand

yum install MariaDB-server MariaDB-client -y

Then to finish:

Code Select Expand

mysql_upgrade

well , this worked fine for me .. thanks .. 

[ehstbr]

Below the steps that I made...

1. Create a backup file.

Code Select Expand

mysqldump --all-databases > /home/fullbackup.sql.gz

2. Disable InnoDB fast shutdown

Code Select Expand

mysql

mysql -> SET GLOBAL innodb_fast_shutdown = 0;

3. Stop MariaDB

Code Select Expand

service mysql stop

4. Manually uninstall MariaDB 10.1

Code Select Expand

yum remove MariaDB-server MariaDB-client -y

5. Manually install MariaDB 10.2

Code Select Expand

yum install MariaDB-server MariaDB-client -y

6. Start MariaDB

Code Select Expand

service mysql start

7. Upgrade the DB to compatibility

Code Select Expand

mysql_upgrade

8. Enable service "mariadb.service" on "Services config -> Start-up Services".

Code Select Expand

systemctl enable mariadb.service

9. Reboot to check if all right.

Code Select Expand

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?).

[anandmys]

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.

[SubZero5]

I did this and fixed my issue:

Code Select Expand

mysqldump --all-databases > /root/fullbackup.sql.gz

Code Select Expand

yum remove MariaDB-server MariaDB-client -y

Code Select Expand

yum install MariaDB-server MariaDB-client -y

Code Select Expand

mysql_upgrade

Code Select Expand

systemctl enable mariadb.service

This finished in like 1 minute or so...

And for cleanup

Code Select Expand

rm /root/fullbackup.sql.gz

[ehstbr]

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...

[kalybg]

I have the same problem ....

Code Select Expand

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! ??

[herman1506]

Below the steps that I made...

1. Create a backup file.

Code Select Expand

mysqldump --all-databases > /home/fullbackup.sql.gz

2. Disable InnoDB fast shutdown

Code Select Expand

mysql

mysql -> SET GLOBAL innodb_fast_shutdown = 0;

3. Stop MariaDB

Code Select Expand

service mysql stop

4. Manually uninstall MariaDB 10.1

Code Select Expand

yum remove MariaDB-server MariaDB-client -y

5. Manually install MariaDB 10.2

Code Select Expand

yum install MariaDB-server MariaDB-client -y

6. Start MariaDB

Code Select Expand

service mysql start

7. Upgrade the DB to compatibility

Code Select Expand

mysql_upgrade

8. Enable service "mariadb.service" on "Services config -> Start-up Services".

Code Select Expand

systemctl enable mariadb.service

9. Reboot to check if all right.

Code Select Expand

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!

[~Q~]

@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