FS#58458 - [percona-server] mysql_upgrade segfaults

Attached to Project: Community Packages
Opened by Michael Taboada (lilmike) - Friday, 04 May 2018, 16:05 GMT
Last edited by Massimiliano Torromeo (mtorromeo) - Wednesday, 19 September 2018, 14:05 GMT
Task Type Bug Report
Category Packages
Status Closed
Assigned To Massimiliano Torromeo (mtorromeo)
Architecture All
Severity High
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 2
Private No

Details

Description:

When running mysql_upgrade -u root -p, then entering my root password, it runs the queries to upgrade the database version (I did this because of a percona-server update today). It then segfaults.

[lilmike@mtmail ~]$ mysql_upgrade -u root -p
Enter password:
Checking if update is needed.
Checking server version.
Running queries to upgrade MySQL server.
Segmentation fault (core dumped)


Additional info:
* package version(s) 5.7.21_21-1
* config and/or log files etc. Nothing really relevent, just a "aborted connection" warning.


Steps to reproduce:

Update to percona-server (version indicated above) then run mysql_upgrade -u root -p (as a non-root user), enter your password.
This task depends upon

Closed by  Massimiliano Torromeo (mtorromeo)
Wednesday, 19 September 2018, 14:05 GMT
Reason for closing:  Fixed
Additional comments about closing:  percona-server-clients-5.7.23_23-2
Comment by Florian Pritz (bluewind) - Tuesday, 18 September 2018, 17:30 GMT
Removing the default collation from the compilation options as suggested here[1] works for me. I don't know why this default has been changed in our PKGBUILD since I think it can be set in the config file too, but I'd suggest removing it so that mysql_upgrade works again.

[1] https://bugs.mysql.com/bug.php?id=84221
Comment by Massimiliano Torromeo (mtorromeo) - Wednesday, 19 September 2018, 11:54 GMT
Thanks Florian!
I'm going to test this myself and hopefully release a fixed version soon.
Comment by Massimiliano Torromeo (mtorromeo) - Wednesday, 19 September 2018, 14:05 GMT
I confirm that setting "-DDEFAULT_COLLATION=utf8mb4_general_ci" as opposed to "-DDEFAULT_COLLATION=utf8mb4_unicode_ci" fixes the issue.
New package is up, I'm closing this.

Loading...