mysql5 @5.1.70_0: checksum mismatch

[wallyg@…]

Keep getting checksum error. Trying to update from mysql5 @5.1.68_0 to mysql5 @5.1.70_0. Here's top of my main.log file:

:debug:checksum checksum phase started at Tue Jul 30 10:20:29 EDT 2013
:notice:checksum --->  Verifying checksums for mysql5
:debug:checksum Executing org.macports.checksum (mysql5)
:info:checksum --->  Checksumming mysql-5.1.70.tar.gz
:error:checksum Checksum (rmd160) mismatch for mysql-5.1.70.tar.gz
:info:checksum Portfile checksum: mysql-5.1.70.tar.gz rmd160 9a7978aa9370c56ed5c3a0a9f3ca135255f19cd8
:info:checksum Distfile checksum: mysql-5.1.70.tar.gz rmd160 3992485cf86171c9838585e1e073ff999966a11d
:error:checksum Checksum (sha256) mismatch for mysql-5.1.70.tar.gz
:info:checksum Portfile checksum: mysql-5.1.70.tar.gz sha256 9e03a343cf1b72b07f9c9bf7be24ffc808aa5c1a9daa590aaf2bc6a7a31f60ed
:info:checksum Distfile checksum: mysql-5.1.70.tar.gz sha256 05ffdce6b94d8ea6bb69a1585685c40e8f3e5ce903231fc62d475a56ebec040c
:info:checksum The correct checksum line may be:
:info:checksum checksums           rmd160  3992485cf86171c9838585e1e073ff999966a11d \
                    sha256  05ffdce6b94d8ea6bb69a1585685c40e8f3e5ce903231fc62d475a56ebec040c
:error:checksum org.macports.checksum for port mysql5 returned: Unable to verify file checksums
:debug:checksum Error code: NONE

other updates (at least all those up to mysql5 ran fine.

[larryv (Lawrence Velázquez)]

Thanks for the ticket. In the future, please Cc relevant port maintainers (port info --maintainers).

[ryandesign (Ryan Carsten Schmidt)]

Thank you for the ticket. We should fix this problem, but note that the mysql5 port is deprecated. Please switch to the mysql51, mysql55, mysql56, percona or mariadb port.

[andrew.uzilov@…]

Cc Me!

[dr@…]

Patch to correct the checksums..

[mp@…]

The switch from mysql5 to mysql51 or the other ones mentioned is not practicable at the moment, see #39961

[mp@…]

Cc Me!

[mp@…]

I may be missing something here, but to me it seems the file

​http://ftp.plusline.de/mysql/Downloads/MySQL-5.1/mysql-5.1.70.tar.gz

(which is the first distfile my install happens to pick) does *not* match the current Portfile's checksums, whereas

​http://distfiles.macports.org/mysql51/mysql-5.1.70.tar.gz

does... Ideas?

[mp@…]

Having checked a few more sources, I think the file on the distfiles.macports.org archive is wrong (different version?) and so are the checksums.

[ryandesign (Ryan Carsten Schmidt)]

Replying to mp@…:

I may be missing something here, but to me it seems the file

​http://ftp.plusline.de/mysql/Downloads/MySQL-5.1/mysql-5.1.70.tar.gz

(which is the first distfile my install happens to pick) does *not* match the current Portfile's checksums, whereas

​http://distfiles.macports.org/mysql51/mysql-5.1.70.tar.gz

does... Ideas?

That's exactly what "checksum mismatch" means. Now someone has to go read wiki:FAQ#checksums and follow it to determine what the difference is, and what we should do about it.

[mp@…]

I checked three official mirrors (including the CDN as linked from the MySQL website) and they provide sources with the checksums as per the patch above.

The differences between the distfiles.macports.org one (with the current checksums) and the other ones are subtle. Most notably, the "Changelog" file in the "distfiles" version has a lot of entries all with "branch nick: mysql-5.1.70-release".

The "official" one has only one entry (!) with "tags: mysql-5.1.70". This single revision is also the last one in the "distfiles" version, albeit branch- and not tag-based.

So re-packaged sources/stealth update?

Mailed the last mentioned committer about it and asked for a comment here.

[ryandesign (Ryan Carsten Schmidt)]

Replying to mp@…:

So re-packaged sources/stealth update?

I suspect so, since the same thing happened for mysql55; see #39513.

The patch is insufficient because it does not follow the stealth update recipe.

The mysql51 port lists the same checksums as the mysql5 port so I assume it is equally affected.

[mp@…]

Here's part of a diff of one particular file:

--- mysql-5.1.70-macports/scripts/fill_help_tables.sql	2013-05-13 15:35:51.000000000 +0200
+++ mysql-5.1.70-plusline/scripts/fill_help_tables.sql	2013-07-15 06:12:52.000000000 +0200
@@ -15,9 +15,9 @@

 -- DO NOT EDIT THIS FILE. It is generated automatically.

--- File generation date: 2013-05-06
+-- File generation date: 2013-07-02
 -- MySQL series: 5.1
--- Document repository revision: 35091
+-- Document repository revision: 35518

As the official release was on 2013-06-03, that looks as if they indeed made a stealth upgrade on July 2nd or later.

[mp@…]

Patch (hopefully) as per the stealth upgrade recipe

[mp@…]

Who takes care of changing the files on the MacPorts distfile mirrors?

[ryandesign (Ryan Carsten Schmidt)]

The MacPorts distfiles mirrors automatically mirror files when portfiles are committed.

[ryandesign (Ryan Carsten Schmidt)]

Thanks for the patch. There is no need to increase revision_server since mysql5-server does not use the distfile.

[mp@…]

#39976 is the ticket for mysql51

[mp@…]

New Portfile patch that does not bump the server revision

[ryandesign (Ryan Carsten Schmidt)]

r108851