Opened 11 years ago

Closed 11 years ago

#39906 closed defect (fixed)

mysql5 @5.1.70_0: checksum mismatch

Reported by: wallygva (Wally Grotophorst) Owned by: ryandesign (Ryan Carsten Schmidt)
Priority: Normal Milestone:
Component: ports Version: 2.2.0
Keywords: Cc: pixilla (Bradley Giesbrecht), andrew.uzilov@…, mp@…
Port: mysql5

Description (last modified by larryv (Lawrence Velázquez))

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.

Attachments (3)

Portfile.patch (689 bytes) - added by dr@… 11 years ago.
Patch to correct the checksums..
Portfile.2.patch (1.4 KB) - added by mp@… 11 years ago.
Patch (hopefully) as per the stealth upgrade recipe
Portfile.3.patch (1.3 KB) - added by mp@… 11 years ago.
New Portfile patch that does not bump the server revision

Download all attachments as: .zip

Change History (20)

comment:1 Changed 11 years ago by larryv (Lawrence Velázquez)

Cc: ryandesign@… added
Description: modified (diff)
Owner: changed from macports-tickets@… to pixilla@…
Port: mysql5 added
Summary: get checksum error on update mysql5mysql5 @5.1.70_0: checksum mismatch

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

comment:2 Changed 11 years ago by 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.

comment:3 Changed 11 years ago by andrew.uzilov@…

Cc: andrew.uzilov@… added

Cc Me!

Changed 11 years ago by dr@…

Attachment: Portfile.patch added

Patch to correct the checksums..

comment:4 Changed 11 years ago by mp@…

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

comment:5 Changed 11 years ago by mp@…

Cc: mp@… added

Cc Me!

comment:6 Changed 11 years ago by 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?

comment:7 Changed 11 years ago by 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.

Last edited 11 years ago by mp@… (previous) (diff)

comment:8 in reply to:  6 Changed 11 years ago by 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.

comment:9 Changed 11 years ago by 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.

Re-packaged sources/Stealth update?

Version 0, edited 11 years ago by mp@… (next)

comment:10 in reply to:  9 Changed 11 years ago by 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.

comment:11 Changed 11 years ago by 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.

Changed 11 years ago by mp@…

Attachment: Portfile.2.patch added

Patch (hopefully) as per the stealth upgrade recipe

comment:12 Changed 11 years ago by mp@…

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

comment:13 Changed 11 years ago by ryandesign (Ryan Carsten Schmidt)

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

comment:14 Changed 11 years ago by ryandesign (Ryan Carsten Schmidt)

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

comment:15 Changed 11 years ago by mp@…

#39976 is the ticket for mysql51

comment:16 Changed 11 years ago by ryandesign (Ryan Carsten Schmidt)

Cc: pixilla@… added; ryandesign@… removed
Owner: changed from pixilla@… to ryandesign@…
Status: newassigned

Changed 11 years ago by mp@…

Attachment: Portfile.3.patch added

New Portfile patch that does not bump the server revision

comment:17 Changed 11 years ago by ryandesign (Ryan Carsten Schmidt)

Resolution: fixed
Status: assignedclosed
Note: See TracTickets for help on using tickets.