mysql upgrade fails

[hostingguy]

First off, when updating to the new mysql it installs an old version as a dependancy

Code: Select all

Then when it installs, it writes an error and mysql will no longer start.

[code]Stopping mysqld:  [  OK  ]
mysqld is alive
Stopping mysqld:  [  OK  ]
mysqld is alive
Stopping mysqld:  [  OK  ]
Starting mysqld:  [  OK  ]
id: cannot find name for group ID 4294967294

Complete!

Code: Select all

# service mysqld status
mysqld is stopped

# service mysqld start
MySQL Daemon failed to start.
Starting mysqld:                                           [FAILED]


# tail /var/log/mysqld.log
100519 10:00:30 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.90'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
100616  9:54:39 [Note] /usr/libexec/mysqld: Normal shutdown

100616  9:54:44  InnoDB: Starting shutdown...
100616  9:54:50  InnoDB: Shutdown completed; log sequence number 0 30163904
100616  9:54:50 [Note] /usr/libexec/mysqld: Shutdown complete

100616 09:54:53  mysqld ended

That was the last line in the mysql log file - you can see the date is off, and if I do a tail -f in another screen then it doesnt write here when trying to start.

Code: Select all

# sh -x /sbin/service mysqld start
+ . /etc/init.d/functions
++ TEXTDOMAIN=initscripts
++ umask 022
++ PATH=/sbin:/usr/sbin:/bin:/usr/bin
++ export PATH
++ '[' -z '' ']'
++ COLUMNS=80
++ '[' -z '' ']'
+++ /sbin/consoletype
++ CONSOLETYPE=pty
++ '[' -f /etc/sysconfig/i18n -a -z '' ']'
++ . /etc/profile.d/lang.sh
+++ sourced=0
+++ '[' -z '' -a -n en_US.UTF-8 ']'
+++ sourced=1
+++ '[' -n '' ']'
+++ '[' 1 = 1 ']'
+++ '[' -n en_US.UTF-8 ']'
+++ export LANG
+++ '[' -n '' ']'
+++ unset LC_ADDRESS
+++ '[' -n '' ']'
+++ unset LC_CTYPE
+++ '[' -n '' ']'
+++ unset LC_COLLATE
+++ '[' -n '' ']'
+++ unset LC_IDENTIFICATION
+++ '[' -n '' ']'
+++ unset LC_MEASUREMENT
+++ '[' -n '' ']'
+++ unset LC_MESSAGES
+++ '[' -n '' ']'
+++ unset LC_MONETARY
+++ '[' -n '' ']'
+++ unset LC_NAME
+++ '[' -n '' ']'
+++ unset LC_NUMERIC
+++ '[' -n '' ']'
+++ unset LC_PAPER
+++ '[' -n '' ']'
+++ unset LC_TELEPHONE
+++ '[' -n '' ']'
+++ unset LC_TIME
+++ '[' -n '' ']'
+++ unset LC_ALL
+++ '[' -n '' ']'
+++ unset LANGUAGE
+++ '[' -n '' ']'
+++ unset LINGUAS
+++ '[' -n '' ']'
+++ unset _XKB_CHARSET
+++ consoletype=pty
+++ '[' -z pty ']'
+++ '[' -n '' ']'
+++ '[' -n '' ']'
+++ '[' -n en_US.UTF-8 ']'
+++ case $LANG in
+++ '[' xterm = linux ']'
+++ unset SYSFONTACM SYSFONT
+++ unset sourced
+++ unset langfile
++ '[' -z '' ']'
++ '[' -f /etc/sysconfig/init ']'
++ . /etc/sysconfig/init
+++ BOOTUP=color
+++ GRAPHICAL=yes
+++ RES_COL=60
+++ MOVE_TO_COL='echo -en \033[60G'
+++ SETCOLOR_SUCCESS='echo -en \033[0;32m'
+++ SETCOLOR_FAILURE='echo -en \033[0;31m'
+++ SETCOLOR_WARNING='echo -en \033[0;33m'
+++ SETCOLOR_NORMAL='echo -en \033[0;39m'
+++ LOGLEVEL=3
+++ PROMPT=yes
+++ AUTOSWAP=no
++ '[' pty = serial ']'
++ '[' color '!=' verbose ']'
++ INITLOG_ARGS=-q
++ __sed_discard_ignored_files='/\(~\|\.bak\|\.orig\|\.rpmnew\|\.rpmorig\|\.rpmsave\)$/d'
++ basename /sbin/service
+ VERSION='service ver. 0.91'
++ basename /sbin/service
+ USAGE='Usage: service < option > | --status-all | [ service_name [ command | --full-restart ] ]'
+ SERVICE=
+ SERVICEDIR=/etc/init.d
+ OPTIONS=
+ '[' 2 -eq 0 ']'
+ cd /
+ '[' 2 -gt 0 ']'
+ case "${1}" in
+ '[' -z '' -a 2 -eq 1 -a mysqld = --status-all ']'
+ '[' 2 -eq 2 -a start = --full-restart ']'
+ '[' -z '' ']'
+ SERVICE=mysqld
+ shift
+ '[' 1 -gt 0 ']'
+ case "${1}" in
+ '[' -z mysqld -a 1 -eq 1 -a start = --status-all ']'
+ '[' 1 -eq 2 -a '' = --full-restart ']'
+ '[' -z mysqld ']'
+ OPTIONS=' start'
+ shift
+ '[' 0 -gt 0 ']'
+ '[' -x /etc/init.d/mysqld ']'
+ env -i LANG=en_US.UTF-8 PATH=/sbin:/usr/sbin:/bin:/usr/bin TERM=xterm /etc/init.d/mysqld start
MySQL Daemon failed to start.
Starting mysqld:                                           [FAILED]

Any ideas?

[crnunez]

Hello,
I have the same issue when I tried to upgrade mysql.
My current Mysql: mysql-5.1.59-1.el5.art


[root@ns ~]$ yum update mysupdate mysql mysql-libs mysql-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* atomic: www5.atomicorp.com
* base: mirror.steadfast.net
* centosplus: mirror.raystedman.net
* extras: centos.mirror.lstn.net
* updates: centos.mirror.lstn.net
Setting up Update Process
Resolving Dependencies
--> Running transaction check
---> Package mysql.x86_64 0:5.5.16-2.el5.art set to be updated
--> Processing Dependency: libmysqlclient.so.16 for package: php-mysql
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16) for package: php-mysql
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: php-mysql
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: php-mysql
---> Package mysql-libs.i386 0:5.5.16-2.el5.art set to be updated
---> Package mysql-libs.x86_64 0:5.5.16-2.el5.art set to be updated
---> Package mysql-server.x86_64 0:5.5.16-2.el5.art set to be updated
--> Running transaction check
--> Processing Dependency: libmysqlclient.so.16 for package: php-mysql
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16) for package: php-mysql
---> Package mysqlclient16.x86_64 0:5.1.57-1.el5.art set to be updated
--> Finished Dependency Resolution
php-mysql-5.3.8-1.el5.art.i386 from installed has depsolving problems
--> Missing Dependency: libmysqlclient.so.16 is needed by package php-mysql-5.3.8-1.el5.art.i386 (installed)
php-mysql-5.3.8-1.el5.art.i386 from installed has depsolving problems
--> Missing Dependency: libmysqlclient.so.16(libmysqlclient_16) is needed by package php-mysql-5.3.8-1.el5.art.i386 (installed)
Error: Missing Dependency: libmysqlclient.so.16(libmysqlclient_16) is needed by package php-mysql-5.3.8-1.el5.art.i386 (installed)
Error: Missing Dependency: libmysqlclient.so.16 is needed by package php-mysql-5.3.8-1.el5.art.i386 (installed)
You could try using --skip-broken to work around the problem
You could try running: package-cleanup --problems
package-cleanup --dupes
rpm -Va --nofiles --nodigest
The program package-cleanup is found in the yum-utils package.


Do you have any idea about this problem?