ps 5.7.37-40-1.buster install stucked

Description

Problem Version : percona-server-server-5.7   (5.7.37-40-1.buster)
                                 *                                 _*No problem with 5.7.36-39-1.buster version_

 

After setting the correct release , Installation is blocked when installing the server package :

 

 

 

Installation gets stuck at  server setup step if I don't specify password for mysql root user :

 

 

 

At this point, the processes are :

 

a kill -9 of the XXXX processes, then a "dpkg --configure -a" allows to finalize the installation correctly, but that makes the installation by ansible impossible.

 

The problem does not exist for the previous release of percona-server-5.7:

With this version, everything's OK. The problem appears with the 40-1 release.

Environment

Platform : Debian 10 (fresh new server)

 

Percona release **

 

 

 

Attachments

3

Smart Checklist

Activity

Show:

Patrick BOSSARD April 14, 2022 at 7:22 AM

That's what I have done

Hrvoje Matijakovic April 13, 2022 at 4:30 PM

Thank you for the information. This seems to be a regression, I wasn't able to reproduce the hang on 5.7.36-39. 

 

As a workaround can you please install the mailutils package after Percona Server.

Patrick BOSSARD April 13, 2022 at 2:04 PM

Heelo,

 

Many thanks for your reply.

I didn't notice the mysql-common. thanks.

 

From the image, I've got these packages installed :

 

 

They are used by mailutils

If I delete theses packages, installation is OK

What's strange is the the 5.7.37.40-1 release does not work if this package is installed
when the 5.7.36.39-1 worked fine with this package installed
(as far as I remember, the previous 5.7.37 was also ok)

Hrvoje Matijakovic April 12, 2022 at 7:09 PM
Edited

Thank you for more detailed report.

When you mentioned you installed some packages, can you tell which ones?

One of differences I've noticed is that mysql-common package has already been installed on your box. Comparing to list of packages from my install:

Was this installed before? Do you have any other (3rd party) repositories enabled?

Patrick BOSSARD April 12, 2022 at 3:54 PM

I've set up a new debian 10 LXC container, then

  • upgrade the system

  • install basic packages

  • download and install manually percona-release

  • update

  • install ps-5.7

 

 

 

Processes :

 

 

Journalctl information :

 

 

 

Logs

Only 3 files changed (except apt directory && lastlog)

  • /var/log/mysql contains one empty file "error.log"

  • /var/log/alternatives.log

  • /var/log/dpkg.log

Looking a processes, the '[percona-server-] <defunct>' is quite suspicious...
(the process /usr/sbin/mysqld --log_error_verbosity=2 is still running)

Looking at /var/lib/dpkg/info/percona-server-server-5.7.postinst script :

  • the command : my_print_defaults mysqld does not returns anything, but return code is 0

  • mysql is running, connexion is OK

  • The SQL command (UPDATE user SET plugin='auth_socket' WHERE user='root') is still not done :

 

 

  • If I kill (SIGTERM) this mysqld process, then the dkpg will be unblocked, and finish with errors

 

 

 

  • Then, if I run a "dpkg --configure -a"  configuration will be OK

 

 

Done

Details

Assignee

Reporter

Planned Version/s

Needs Review

Yes

Components

Affects versions

Priority

Smart Checklist

Created April 12, 2022 at 9:55 AM
Updated March 6, 2024 at 10:13 AM
Resolved May 30, 2022 at 11:40 AM