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)
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 mysql5 → mysql5 @5.1.70_0: checksum mismatch |
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: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:6 follow-up: 8 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.
comment:8 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 follow-up: 10 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.
So re-packaged sources/stealth update?
Mailed the last mentioned committer about it and asked for a comment here.
comment:10 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:16 Changed 11 years ago by ryandesign (Ryan Carsten Schmidt)
Cc: | pixilla@… added; ryandesign@… removed |
---|---|
Owner: | changed from pixilla@… to ryandesign@… |
Status: | new → assigned |
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: | assigned → closed |
Thanks for the ticket. In the future, please Cc relevant port maintainers (
port info --maintainers
).