very very slow Server Software Update

galantina

Member
Sep 2, 2004
15
0
151
Hi everyone!

As many peaople did I also had trouble with mysql 4.0 on my server today. I tried to solve the problem with changing my mysql version in tweak settings to 4.1 and running Update Server Software afterwards. My problem is that the script (Update Server Software) is running for a few hours because mysql RPMS are downloading extremly slow. After few hours proccess just stopped. After that I run it again hopping that the script will use some faster mirror this time, but it used the same mirror again (http://mysql.mirrors.hoobly.com//). I wonder how can I change the mirror for mysql downloads and shouldn't it be done by a script itself?

Thanks.

Best regards.
 

cPanelNick

Administrator
Staff member
Mar 9, 2015
3,488
35
158
cPanel Access Level
DataCenter Provider
rm -rf /root/.cpmysqlrpm

will force it to recheck mirrors.

This problem should be moot next month as we are switching to building our own mysql rpms instead of the offical ones as there have been too many problems to count.
 

jamesbond

Well-Known Member
Oct 9, 2002
738
1
168
I just killed the upcp processes, it was still trying to download mysql after 10 hours.

I will try upgrading to 4.0.27 later again, because all mirrors seems either very very slow or not working at all.

Is it possible to update using the rpm's located here (this is for a RH 7.3 server) :

http://updates.cpanel.net/mysqlinstall/4.0.27-0/redhat/7.3/

I noticed MySQL-shared-compat-4.0.27-0.i386.rpm is missing there, is that a problem?
 

cPanelNick

Administrator
Staff member
Mar 9, 2015
3,488
35
158
cPanel Access Level
DataCenter Provider
jamesbond said:
I just killed the upcp processes, it was still trying to download mysql after 10 hours.

I will try upgrading to 4.0.27 later again, because all mirrors seems either very very slow or not working at all.

Is it possible to update using the rpm's located here (this is for a RH 7.3 server) :

http://updates.cpanel.net/mysqlinstall/4.0.27-0/redhat/7.3/

I noticed MySQL-shared-compat-4.0.27-0.i386.rpm is missing there, is that a problem?
Those rpms are just fine to update from. Just before to run /scripts/perlinstaller --force Bundle::DBD::mysql afterwards.

You don't need shared-compat with those since they are native built.
 

cPanelNick

Administrator
Staff member
Mar 9, 2015
3,488
35
158
cPanel Access Level
DataCenter Provider
also the point is moot, since if you have the latest RELEASE or newer it will use those anyways (instead of the mysql official ones)
 

jamesbond

Well-Known Member
Oct 9, 2002
738
1
168
cpanelnick said:
also the point is moot, since if you have the latest RELEASE or newer it will use those anyways (instead of the mysql official ones)
I did a /scripts/upcp, and as I expected it tries to install mysql (and testing mirrors for an eternity) before it gets to upgrade to RELEASE.

I'll give it another half hour :)

If no suitable mirrors can be found the following should work, right?

touch /etc/mysqlupdisable
/scripts/upcp
rm /etc/mysqlupdisable
/scripts/mysqlup
/scripts/perlinstaller --force Bundle::DBD::mysql

I hope this also helps others in the same situation.

UPDATE:

Upgraded to the latest RELEASE, but mysqlup still doesn't work (it's not trying to get the updates from cpanel.net)

MySQL Setup Script Version 7.0
Loaded cPPkgs::MySQL ok!
Fetching version information from http://updates.cpanel.net/mysqlinstall/version (RELEASE)....Fetching http://updates.cpanel.net/mysqlinstall/version (0)[email protected]%......Done
Use of uninitialized value in split at /scripts/cPpkgversions.pm line 59.
Use of uninitialized value in split at /scripts/cPpkgversions.pm line 59.
Use of uninitialized value in split at /scripts/cPpkgversions.pm line 59.
Done
This is the MySQL 4.0.27 installer release number 0 for platform
MySQL-shared is out of date (MySQL-shared-4.0.25-0 != MySQL-shared-4.0.27-0)
MySQL-shared-compat is out of date (MySQL-shared-compat-4.0.25-0 != MySQL-shared-compat-4.0.27-0)
MySQL-devel is out of date (MySQL-devel-4.0.25-0 != MySQL-devel-4.0.27-0)
MySQL-embedded is out of date (MySQL-embedded-4.0.25-0 != MySQL-embedded-4.0.27-0)
MySQL-client is out of date (MySQL-client-4.0.25-0 != MySQL-client-4.0.27-0)
MySQL-bench is out of date (MySQL-bench-4.0.25-0 != MySQL-bench-4.0.27-0)
MySQL-server is out of date (MySQL-server-4.0.25-0 != MySQL-server-4.0.27-0)
MySQL-shared is out of date (MySQL-shared-4.0.25-0 != MySQL-shared-4.0.27-0)

and further down:

Resetting MySQL to cPanel Defaults and Installing the Latest Version
About to fetch MySQL-shared-4.0.27-0.i386.rpm
Ping:1000 Testing connection speed to mysql.localhost.net.ar using wget...(35620 bytes/s)...Done
Ping:1000 Testing connection speed to mysql.mirrored.ca using wget...(310450 bytes/s)...Done
Ping:1000 Testing connection speed to www.stathy.com using wget...test failed...Done
Ping:1000 Testing connection speed to mysql.cs.pu.edu.tw using wget...(10280 bytes/s)...Done
--19:28:53-- http://mysql.mirrored.ca//Downloads/MySQL-4.0/MySQL-shared-4.0.27-0.i386.rpm
=> `/var/spool/cpupdates/MySQL-shared-4.0.27-0.i386.rpm'
Resolving mysql.mirrored.ca... done.
Connecting to mysql.mirrored.ca[142.77.49.222]:80... connected.
HTTP request sent, awaiting response... 404 Not Found
19:28:53 ERROR 404: Not Found.

--19:28:53-- http://mysql.localhost.net.ar//Downloads/MySQL-4.0/MySQL-shared-4.0.27-0.i386.rpm
=> `/var/spool/cpupdates/MySQL-shared-4.0.27-0.i386.rpm'
Resolving mysql.localhost.net.ar... done.
Connecting to mysql.localhost.net.ar[200.43.193.199]:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 254,277 [text/plain]

0K .......... .......... .......... .......... .......... 20% 42.55 KB/s
50K .......... .......... .......... .......... .......... 40% 74.18 KB/s
100K .......... .......... .......... .......... .......... 60% 74.74 KB/s
150K .......... .......... .......... .......... .......... 80% 99.60 KB/s
200K .......... .......... .......... .......... ........ 100% 129.54 KB/s

19:28:56 (73.19 KB/s) - `/var/spool/cpupdates/MySQL-shared-4.0.27-0.i386.rpm' saved [254277/254277]

Checking MySQL-shared-4.0.27-0.i386.rpm ....Done
MySQL-shared-4.0.27-0
Check failed with status: 0 and error code 0 !
--19:28:57-- http://mysql.cs.pu.edu.tw//Downloads/MySQL-4.0/MySQL-shared-4.0.27-0.i386.rpm
=> `/var/spool/cpupdates/MySQL-shared-4.0.27-0.i386.rpm'

and so on...
 
Last edited:

jamesbond

Well-Known Member
Oct 9, 2002
738
1
168
Well, this is just odd. Is there perhaps some cache file I have to remove? Cause mysqlup still is testing mirrors instead of just getting the cpanel.net rpm's.

All the 'working' mirrors seem to return this error:


Checking MySQL-shared-4.0.27-0.i386.rpm ....Done
MySQL-shared-4.0.27-0
Check failed with status: 0 and error code 0 !


I'm on 10.8.2-RELEASE_119
 

tetraweb

Member
May 19, 2003
16
0
151
DId you ever resolve this, Jamesbond? I get identical results from upcp every night, trying to update itself to 4.0.27 and having a heck of a time...

Greg
 

jamesbond

Well-Known Member
Oct 9, 2002
738
1
168
No, that server is still running 4.0.25. I disabled mysql updates (touch /etc/mysqlupdisable) to prevent it from trying to update to 4.0.27 everyday.

Last week I tried updating (by removing /etc/mysqlupdisable and running /scripts/upcp) but still the same issues.

I haven't really looked into why this server is doing this. Hopefully someone has a fix for this :)

You could install it manually, but that doesn't solve the mirror issue for updates in the future.