Opened 14 years ago

Closed 4 years ago

#25674 closed defect (fixed)

mysql5 fetch takes a long time from mysql.mirrors.pair.com

Reported by: weinmaster@… Owned by: ryandesign (Ryan Carsten Schmidt)
Priority: Normal Milestone:
Component: ports Version: 1.9.1
Keywords: Cc: pixilla (Bradley Giesbrecht), chrisbloom7 (Chris Bloom), chrstphrchvz (Christopher Chavez)
Port: mysql5

Description (last modified by mf2k (Frank Schima))

When attempting to install the mysql5-server port, the operation hangs at the following:

---> Attempting to fetch mysql-5.1.48.tar.gz from http://mysql.mirrors.pair.com/Downloads/MySQL-5.1/

Change History (16)

comment:1 Changed 14 years ago by mf2k (Frank Schima)

Description: modified (diff)
Keywords: mysql5 removed
Owner: changed from macports-tickets@… to ryandesign@…

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

Port: mysql5 added; mysql5-server removed
Summary: mysql5-server fails to fetchmysql5 fetch takes a long time from mysql.mirrors.pair.com

I am able to download from that server, but it goes at a rate of 10K/sec, so it would take 40 minutes to complete. How long did you wait? Maybe we should remove that mirror if it is routinely that slow.

comment:3 Changed 14 years ago by adrian@…

Here's a "Me too"

I'm getting about 5K/minute from the host. Even going to the directory in my browser resulted in the file list taking about 20 seconds to fully load.

comment:4 Changed 14 years ago by weinmaster@…

I am still unable to download from the specified server. What I experience is the 5k/minute rate, but interlaced with 2 seconds of no activity. Even after giving the port 2+ hours to download, it didn't complete. I agree with adrian@…, downloading mysql5 directly from the website takes about 20 seconds.

comment:5 Changed 14 years ago by chrisbloom7 (Chris Bloom)

Cc: chrisbloom7@… added

Cc Me!

comment:6 Changed 14 years ago by chrisbloom7 (Chris Bloom)

I tried updating MacPorts, thinking maybe I had an old version and some mirror had changed, but that didn't change anything. It just sits there at "Attempting to fetch mysql-5.1.48.tar.gz from http://mysql.mirrors.pair.com/Downloads/MySQL-5.1/"

comment:7 Changed 14 years ago by chrisbloom7 (Chris Bloom)

Now I'm noticing the same behavior from the gettext mirror, too.

Attempting to fetch gettext-0.18.1.1.tar.gz from http://distfiles.macports.org/gettext

comment:8 Changed 14 years ago by chrisbloom7 (Chris Bloom)

Still an issue with MySQL. I just called Pair Netlworks to let them know about the issue since it seems to be their server that is responding so slow, and less to do with MacPorts. Still, it woud be helpful if there was a way to specify a different mirror to use or to specify a download speed threshold before trying another server.

comment:9 Changed 14 years ago by chrisbloom7 (Chris Bloom)

Received a response from Pair Networks:


Thank you for brining this to our attention. We are taking a look at it now. This machine also hosts the Firefox mirror and we are seeing a lot of traffic to that. Which may be the cause of the slowness you experienced.


Trying to download directly via my browser saw speeds of 2mb/sec initially, but it's slowly sinking back to the single-digit kb/sec range.

I also let MacPorts chug away for an hour or so in the background and MySQL did eventually install, but not sure how long it took exactly.

comment:10 Changed 10 years ago by jmroot (Joshua Root)

Cc: pixilla@… added

comment:11 Changed 6 years ago by chrstphrchvz (Christopher Chavez)

Did this issue ever go away? When I curl a file from that mirror, it seems to download very quickly, but spends several seconds stuck at 99% before finishing:

$ curl http://mysql.mirrors.pair.com/Downloads/MySQL-5.1/mysql-5.1.73.tar.gz --output mysql-5.1.73.tar.gz
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
  2 22.9M    2  611k    0     0  1204k      0  0:00:19 --:--:--  0:00:19 1204k
 28 22.9M   28 6627k    0     0  4289k      0  0:00:05  0:00:01  0:00:04 4287k
 63 22.9M   63 14.4M    0     0  5901k      0  0:00:03  0:00:02  0:00:01 5899k
 99 22.9M   99 22.7M    0     0  6612k      0  0:00:03  0:00:03 --:--:-- 6610k
 99 22.9M   99 22.8M    0     0  5142k      0  0:00:04  0:00:04 --:--:-- 5142k
 99 22.9M   99 22.8M    0     0  4212k      0  0:00:05  0:00:05 --:--:-- 4515k
 99 22.9M   99 22.8M    0     0  3569k      0  0:00:06  0:00:06 --:--:-- 3347k
 99 22.9M   99 22.8M    0     0  3095k      0  0:00:07  0:00:07 --:--:-- 1702k
 99 22.9M   99 22.8M    0     0  2733k      0  0:00:08  0:00:08 --:--:-- 31632
 99 22.9M   99 22.8M    0     0  2447k      0  0:00:09  0:00:09 --:--:--     0
 99 22.9M   99 22.8M    0     0  2215k      0  0:00:10  0:00:10 --:--:--     0
 99 22.9M   99 22.8M    0     0  2023k      0  0:00:11  0:00:11 --:--:--     0
 99 22.9M   99 22.8M    0     0  1861k      0  0:00:12  0:00:12 --:--:--     0
 99 22.9M   99 22.8M    0     0  1723k      0  0:00:13  0:00:13 --:--:--     0
 99 22.9M   99 22.8M    0     0  1605k      0  0:00:14  0:00:14 --:--:--     0
 99 22.9M   99 22.8M    0     0  1501k      0  0:00:15  0:00:15 --:--:--     0
 99 22.9M   99 22.8M    0     0  1410k      0  0:00:16  0:00:16 --:--:--     0
 99 22.9M   99 22.8M    0     0  1330k      0  0:00:17  0:00:17 --:--:--     0
 99 22.9M   99 22.8M    0     0  1258k      0  0:00:18  0:00:18 --:--:--     0
100 22.9M  100 22.9M    0     0  1184k      0  0:00:19  0:00:19 --:--:--  8900

comment:12 Changed 6 years ago by chrstphrchvz (Christopher Chavez)

Cc: chrstphrchvz added

comment:13 Changed 4 years ago by chrstphrchvz (Christopher Chavez)

http://mysql.mirrors.pair.com has now been refusing connections for some time.

There is a PR open which will remove it: https://github.com/macports/macports-ports/pull/7257

comment:14 Changed 4 years ago by chrisbloom7 (Chris Bloom)

Cc: chrisbloom7 added

comment:15 Changed 4 years ago by chrisbloom7 (Chris Bloom)

Cc: chrisbloom7 removed

comment:16 Changed 4 years ago by Eric F <3958664+iefdev@…>

Resolution: fixed
Status: newclosed

In f99cd49cdc409be79cbfe48a44cd489c9215f995/macports-ports (master):

Update mirror_sites.tcl (https://github.com/macports/macports-ports/pull/7257)

Remove dead URLs; add new ones.

Closes: #60558
See: #60509
Closes: #25674

Note: See TracTickets for help on using tickets.