Update MySQL problem on FreeBSD

tuxons

Member
Dec 16, 2009
5
0
51
Good afternoon, I would like to update on the server MySQL to version 5.1 but when I start MySQL Upgrade, and I choose version 5.1 the script mysqlup hangs and loads CPU on 100 %. Excuse for my English.
 

cPanelDon

cPanel Quality Assurance Analyst
Staff member
Nov 5, 2008
2,545
12
268
Houston, Texas, U.S.A.
cPanel Access Level
DataCenter Provider
Twitter
Good afternoon, I would like to update on the server MySQL to version 5.1 but when I start MySQL Upgrade, and I choose version 5.1 the script mysqlup hangs and loads CPU on 100 %. Excuse for my English.
Via root SSH access, please let us know the output from the following command:
Code:
# ps afuxww
 

tuxons

Member
Dec 16, 2009
5
0
51
Via root SSH access, please let us know the output from the following command:
Code:
# ps afuxww
root 1062 0.0 0.1 7272 5236 ?? I 6:18AM 0:00.05 cPhulkd - processor (perl5.8.9)
root 5031 0.0 0.3 13968 12556 ?? S 6:19AM 0:01.03 cpsrvd - waiting for connections (cpsrvd-ssl)
root 7024 0.0 0.1 5272 3152 ?? IN 6:19AM 0:00.02 cpanellogd - sleeping for logs (perl5.8.9)
mysql 8664 0.0 0.8 60900 30800 ?? I 6:19AM 1:17.02 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql --pid-file=/var/db/mysql/server.tflgroup.info.pid
root 15625 0.0 0.8 121144 29988 ?? Ss 7:17AM 0:01.11 /usr/local/apache/bin/httpd
root 16146 0.0 0.0 3256 1456 ?? Is 6:39AM 0:00.02 pure-ftpd (SERVER) (pure-ftpd)
root 16148 0.0 0.0 3256 1000 ?? Is 6:39AM 0:00.01 /usr/local/sbin/pure-authd -B -s /var/run/ftpd.sock -r /usr/local/sbin/pureauth
root 29278 0.0 0.8 121144 29984 ?? I 10:55AM 0:00.00 /usr/local/apache/bin/httpd
root 31808 0.0 0.8 31476 29164 ?? I 11:31AM 0:01.18 spamd child (perl)
nobody 32120 0.0 1.3 125240 48976 ?? I 11:38AM 0:03.05 /usr/local/apache/bin/httpd
nobody 32139 0.0 1.3 125240 47024 ?? I 11:39AM 0:02.04 /usr/local/apache/bin/httpd
nobody 32200 0.0 1.3 125240 46860 ?? I 11:40AM 0:01.36 /usr/local/apache/bin/httpd
nobody 32201 0.0 1.4 127288 52776 ?? S 11:40AM 0:02.58 /usr/local/apache/bin/httpd
nobody 33718 0.0 1.3 126264 47772 ?? S 11:49AM 0:01.78 /usr/local/apache/bin/httpd
nobody 33720 0.0 1.3 125240 45996 ?? I 11:49AM 0:01.75 /usr/local/apache/bin/httpd
root 34096 0.0 0.4 14704 13004 ?? I 11:55AM 0:00.03 whostmgrd - serving 91.144.177.117 (cpsrvd-ssl)
root 34099 0.0 0.4 15060 13468 ?? I 11:55AM 0:00.05 whostmgrd - serving 91.144.177.117 (cpsrvd-ssl)
root 34101 0.0 0.3 14128 12720 ?? S 11:55AM 0:00.02 whostmgrd - serving 91.144.177.117 (cpsrvd-ssl)
root 34103 0.0 0.4 14656 13012 ?? I 11:55AM 0:00.02 whostmgrd - serving 91.144.177.117 (cpsrvd-ssl)
root 34108 0.0 0.3 14128 12700 ?? I 11:55AM 0:00.01 whostmgrd - serving 91.144.177.117 (cpsrvd-ssl)
nobody 34111 0.0 0.9 123192 33200 ?? I 11:55AM 0:00.04 /usr/local/apache/bin/httpd
nobody 34128 0.0 1.2 124216 44408 ?? I 11:56AM 0:00.27 /usr/local/apache/bin/httpd
nobody 34129 0.0 1.3 125240 45812 ?? I 11:56AM 0:00.42 /usr/local/apache/bin/httpd
mailnull 34429 0.0 0.2 9256 5552 ?? S 11:58AM 0:00.02 /usr/local/sbin/exim -bd -q30m (exim-4.71-0)
root 34453 0.0 0.1 8440 3904 ?? Ss 11:58AM 0:00.02 sshd: [email protected] (sshd)
mailnull 34603 0.0 0.0 0 0 ?? Z 11:58AM 0:00.01 <defunct>
root 66995 0.0 0.0 3240 1156 ?? Is 6:57AM 0:00.00 /usr/sbin/inetd -wW
mailnull 67653 0.0 0.1 8576 3756 ?? Ss 6:58AM 0:00.58 /usr/local/sbin/exim -bd -q30m (exim-4.71-0)
root 67854 0.0 0.0 3148 1452 ?? Ss 6:58AM 0:00.29 /usr/local/sbin/dovecot
root 67856 0.0 0.0 3276 1516 ?? S 6:58AM 0:00.15 dovecot-auth
dovecot 67869 0.0 0.1 4860 2664 ?? I 6:58AM 0:00.00 pop3-login
dovecot 67870 0.0 0.1 4860 2664 ?? I 6:58AM 0:00.00 pop3-login
dovecot 67871 0.0 0.1 4860 2696 ?? I 6:58AM 0:00.04 imap-login
dovecot 67872 0.0 0.1 4860 2696 ?? I 6:58AM 0:00.03 imap-login
root 8648 0.0 0.0 3636 1636 v0 Is 6:19AM 0:00.01 login [pam] (login)
root 14090 0.0 0.1 4464 2284 v0 I+ 6:19AM 0:00.01 -csh (csh)
root 8649 0.0 0.0 3184 1076 v1 Is+ 6:19AM 0:00.00 /usr/libexec/getty Pc ttyv1
root 8650 0.0 0.0 3184 1076 v2 Is+ 6:19AM 0:00.00 /usr/libexec/getty Pc ttyv2
root 8651 0.0 0.0 3184 1076 v3 Is+ 6:19AM 0:00.00 /usr/libexec/getty Pc ttyv3
root 8652 0.0 0.0 3184 1076 v4 Is+ 6:19AM 0:00.00 /usr/libexec/getty Pc ttyv4
root 8653 0.0 0.0 3184 1076 v5 Is+ 6:19AM 0:00.00 /usr/libexec/getty Pc ttyv5
root 8654 0.0 0.0 3184 1076 v6 Is+ 6:19AM 0:00.00 /usr/libexec/getty Pc ttyv6
root 8655 0.0 0.0 3184 1076 v7 Is+ 6:19AM 0:00.00 /usr/libexec/getty Pc ttyv7
root 1080 0.0 0.3 15344 11356 con- I 6:18AM 0:00.01 cpdavd - accepting connections on 2077 and 2078 (perl5.8.9)
root 8584 0.0 0.1 5272 3152 con- IN 6:19AM 0:00.02 cpanellogd - sleeping for logs (perl5.8.9)
root 8592 0.0 0.0 3464 1408 con- I 6:19AM 0:00.00 /bin/sh /usr/local/bin/mysqld_safe --user=mysql
root 34599 0.0 0.1 4464 2368 p0 Ss 11:58AM 0:00.01 -csh (csh)
root 34607 0.0 0.0 3244 1112 p0 R+ 11:58AM 0:00.00 ps afuxww
secondary part
 

npluis

Member
Feb 21, 2007
11
0
151
Any news on this? I have the same thing and top shows mysql at about 2-30% busy even though Show MySQL Processes shows nothing.

# ps afuxww
root 10069 103.0 0.3 25900 11040 ?? R 2:55PM 309:29.99 /scripts/mysqlup (perl)
root 18 97.3 0.0 0 16 ?? RL 22Jul09 209064:56.86 [idle: cpu0]
root 17 97.1 0.0 0 16 ?? RL 22Jul09 210087:27.46 [idle: cpu1]
root 11 93.6 0.0 0 16 ?? RL 22Jul09 208408:10.13 [idle: cpu7]
root 13 83.1 0.0 0 16 ?? RL 22Jul09 206763:05.04 [idle: cpu5]
root 16 82.4 0.0 0 16 ?? RL 22Jul09 204932:24.39 [idle: cpu2]
root 15 80.7 0.0 0 16 ?? RL 22Jul09 206921:30.05 [idle: cpu3]
root 14 79.1 0.0 0 16 ?? RL 22Jul09 202736:05.03 [idle: cpu4]
root 12 68.3 0.0 0 16 ?? RL 22Jul09 201296:10.10 [idle: cpu6]
mysql 43560 0.8 13.3 1199664 557880 ?? S Mon11AM 718:56.58 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql --pid-file=/var/db/mysql/host.pid
 

cPanelDon

cPanel Quality Assurance Analyst
Staff member
Nov 5, 2008
2,545
12
268
Houston, Texas, U.S.A.
cPanel Access Level
DataCenter Provider
Twitter
Any news on this? I have the same thing and top shows mysql at about 2-30% busy even though Show MySQL Processes shows nothing.
Thank you for the information. More information is needed to have a better idea what the issue may be; please let us know the output of the following command:
Code:
# grep -H '' /etc/*release /usr/local/cpanel/version
Please also consider submitting a support request as the issue may need more thorough inspection and diagnosis via direct access. If needed, the link in my forums signature may be used to initiate a ticket submission. When available, please PM me referencing this thread and your new ticket ID number so that I may follow-up internally.

Internal case notes: #34835, #36352
 

tuxons

Member
Dec 16, 2009
5
0
51
Thank you for the information. More information is needed to have a better idea what the issue may be; please let us know the output of the following command:
Code:
# grep -H '' /etc/*release /usr/local/cpanel/version
Please also consider submitting a support request as the issue may need more thorough inspection and diagnosis via direct access. If needed, the link in my forums signature may be used to initiate a ticket submission. When available, please PM me referencing this thread and your new ticket ID number so that I may follow-up internally.

Internal case notes: #34835, #36352
At performance of this command grep-H "/etc/*release/usr/local/cpanel/version to me informs grep: No match.
 

cPanelDon

cPanel Quality Assurance Analyst
Staff member
Nov 5, 2008
2,545
12
268
Houston, Texas, U.S.A.
cPanel Access Level
DataCenter Provider
Twitter
At performance of this command grep-H "/etc/*release/usr/local/cpanel/version to me informs grep: No match.
The command included two different paths separated by a space; as an alternative please use the following commands that will obtain the same information:
Code:
# cat /etc/*release
# cat /usr/local/cpanel/version && echo
 

cPanelDon

cPanel Quality Assurance Analyst
Staff member
Nov 5, 2008
2,545
12
268
Houston, Texas, U.S.A.
cPanel Access Level
DataCenter Provider
Twitter
The FreeBSD-specific correction in the "mysqlup" script is available in the latest EDGE build (42275) and will be in upcoming CURRENT and RELEASE builds of cPanel 11.25.

For additional reference information and to check the latest change log entries and build information please use the following two resources:
http://httpupdate.cpanel.net/#builds
http://changelog.cpanel.net/

Here is a quote of the relevant change log entry:
Edge 42275, 2009-12-21 14:14:27
Fixed mysqlup to handle versions newer than 5.01 on FreeBSD and not stop after deinstalling packages