mysql wont start after upgrade

Installing, Configuring, Troubleshooting server daemons such as Web and Mail

mysql wont start after upgrade

Postby prezaeis » 2012/01/08 06:56:06

hi guys

I upgraded my mysql and php on centos 5.5 to the latest version
php seems to be working fine but my mysql will not start

typing:

service mysqld start

gives this error:

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

Accessing my site gives this error:

The mysqli error was: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2).

Iv tried yum update mysql and restarting, nothing seems to be working

i also checked the following 2 directories and i cannot find a mysql.sock file in either of them

/var/lib/mysql and
/tmp/

Can anyone help me? im desperate

i really appreciate it
prezaeis
 
Posts: 5
Joined: 2012/01/06 01:54:28

mysql wont start after upgrade

Postby pschaff » 2012/01/08 16:20:46

If you are going to replace a core package then you probably need to get support from the source from which you acquired the replacement. You don't even say where you got that version. I see mysql 5.5 packages from Remi and Atomic.


If more help is needed then please provide more information about your system by running "./getinfo.sh package" and showing us the output file, along with
Code: Select all
rpm -qa mysql\* | sort
pschaff
Retired Moderator
 
Posts: 18277
Joined: 2006/12/13 20:15:34
Location: Tidewater, Virginia, North America

Re: mysql wont start after upgrade

Postby prezaeis » 2012/01/09 05:06:54

hi

my apologies for not being clear in my original post

i have included the results of what you asked for, along with the content of my mysql.log file

1.

The getinfo.sh script outputs the following:

Code: Select all

Information for general problems.
[code]
== BEGIN uname -rmi ==
2.6.18-194.26.1.el5xen x86_64 x86_64
== END   uname -rmi ==

== BEGIN rpm -qa \*-release\* ==
centos-release-notes-5.5-0
epel-release-5-4
atomic-release-1.0-14.el5.art
webtatic-release-5-2
centos-release-5-5.el5.centos
rpmforge-release-0.5.2-2.el5.rf
remi-release-5-8.el5.remi
== END   rpm -qa \*-release\* ==

== BEGIN cat /etc/redhat-release ==
CentOS release 5.5 (Final)
== END   cat /etc/redhat-release ==

== BEGIN getenforce ==
Disabled
== END   getenforce ==

== BEGIN free -m ==
             total       used       free     shared    buffers     cached
Mem:          1536       1478         57          0         30        127
-/+ buffers/cache:       1320        215
Swap:         2047          0       2047
== END   free -m ==

== BEGIN rpm -qa yum\* rpm-\* python | sort ==
python-2.4.3-27.el5_5.3
rpm-build-4.4.2.3-20.el5_5.1
rpm-devel-4.4.2.3-20.el5_5.1
rpm-devel-4.4.2.3-20.el5_5.1
rpm-libs-4.4.2.3-20.el5_5.1
rpm-libs-4.4.2.3-20.el5_5.1
rpm-python-4.4.2.3-20.el5_5.1
yum-3.2.22-26.el5.centos
yum-fastestmirror-1.1.16-14.el5.centos.1
yum-metadata-parser-1.1.2-3.el5.centos
yum-updatesd-0.9-2.el5
== END   rpm -qa yum\* rpm-\* python | sort ==

== BEGIN ls /etc/yum.repos.d ==
atomic.repo
CentOS-Base.repo
CentOS-Media.repo
CentOS-Testing.repo
epel.repo
epel-testing.repo
kbsingh-CentOS-Extras.repo
mirrors-rpmforge
mirrors-rpmforge-extras
mirrors-rpmforge-testing
remi.repo
rpmforge.repo
webtatic.repo
== END   ls /etc/yum.repos.d ==

== BEGIN cat /etc/yum.conf ==
[main]
cachedir=/var/cache/yum
keepcache=0
debuglevel=2
logfile=/var/log/yum.log
distroverpkg=redhat-release
tolerant=1
exactarch=1
obsoletes=1
gpgcheck=1
plugins=1

# Note: yum-RHN-plugin doesn't honor this.
metadata_expire=1h

# Default.
# installonly_limit = 3

# PUT YOUR REPOS HERE OR IN separate files named file.repo
# in /etc/yum.repos.d
== END   cat /etc/yum.conf ==

== BEGIN yum repolist all ==
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * atomic: www7.atomicorp.com
 * base: mirror.de.leaseweb.net
 * centosplus: mirror.de.leaseweb.net
 * epel: mirror.de.leaseweb.net
 * extras: mirror.de.leaseweb.net
 * rpmforge: ftp-stud.fht-esslingen.de
 * updates: mirror.de.leaseweb.net
repo id                repo name                                 status
addons                 CentOS-5 - Addons                         enabled:      0
atomic                 CentOS / Red Hat Enterprise Linux 5 - ato enabled:    997
atomic-testing         CentOS / Red Hat Enterprise Linux 5 - ato disabled
base                   CentOS-5 - Base                           enabled:  3,566
c5-media               CentOS-5 - Media                          disabled
c5-testing             CentOS-5 Testing                          enabled:    913
centosplus             CentOS-5 - Plus                           enabled:     51
contrib                CentOS-5 - Contrib                        enabled:      0
epel                   Extra Packages for Enterprise Linux 5 - x enabled:  6,850
epel-debuginfo         Extra Packages for Enterprise Linux 5 - x disabled
epel-source            Extra Packages for Enterprise Linux 5 - x disabled
epel-testing           Extra Packages for Enterprise Linux 5 - T disabled
epel-testing-debuginfo Extra Packages for Enterprise Linux 5 - T disabled
epel-testing-source    Extra Packages for Enterprise Linux 5 - T disabled
extras                 CentOS-5 - Extras                         enabled:    266
kbs-CentOS-Extras      CentOS.Karan.Org-EL5 - Stable             enabled:      0
kbs-CentOS-Testing     CentOS.Karan.Org-EL5 - Testing            enabled:  1,102
remi                   Les RPM de remi pour Enterprise Linux 5 - disabled
remi-test              Les RPM de remi en test pour Enterprise L disabled
rpmforge               RHEL 5 - RPMforge.net - dag               enabled: 10,900
rpmforge-extras        RHEL 5 - RPMforge.net - extras            disabled
rpmforge-testing       RHEL 5 - RPMforge.net - testing           disabled
updates                CentOS-5 - Updates                        enabled:    534
webtatic               Webtatic Repository 5 - x86_64            disabled
webtatic-debuginfo     Webtatic Repository 5 - x86_64 - Debug    disabled
webtatic-source        Webtatic Repository 5 - x86_64            disabled
repolist: 25,179
== END   yum repolist all ==

== BEGIN egrep 'include|exclude' /etc/yum.repos.d/*.repo ==
/etc/yum.repos.d/CentOS-Base.repo:exclude=postfix
/etc/yum.repos.d/CentOS-Base.repo:exclude=postfix
/etc/yum.repos.d/CentOS-Base.repo:includepkgs=postfix
/etc/yum.repos.d/CentOS-Testing.repo:includepkgs=php*
== END   egrep 'include|exclude' /etc/yum.repos.d/*.repo ==

== BEGIN sed -n -e "/^\[/h; /priority *=/{ G; s/\n/ /; s/ity=/ity = /; p }" /etc/yum.repos.d/*.repo | sort -k3n ==
priority = 1 [atomic]
#priority = 1 [atomic-testing]
priority = 1 [atomic-testing]
== END   sed -n -e "/^\[/h; /priority *=/{ G; s/\n/ /; s/ity=/ity = /; p }" /etc/yum.repos.d/*.repo | sort -k3n ==

== BEGIN cat /etc/fstab ==
/dev/sda1      /                       ext3    defaults,usrquota,grpquota        1 1
tmpfs                   /dev/shm                tmpfs   defaults        0 0
devpts                  /dev/pts                devpts  gid=5,mode=620  0 0
sysfs                   /sys                    sysfs   defaults        0 0
proc                    /proc                   proc    defaults        0 0
/dev/sda2      swap                    swap    defaults        0 0
== END   cat /etc/fstab ==

== BEGIN df -h ==
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda1              99G   32G   62G  35% /
tmpfs                 768M     0  768M   0% /dev/shm
== END   df -h ==

== BEGIN fdisk -l ==
Disk /dev/sda1 doesn't contain a valid partition table
Disk /dev/sda2 doesn't contain a valid partition table

Disk /dev/sda1: 107.3 GB, 107374182400 bytes
255 heads, 63 sectors/track, 13054 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes


Disk /dev/sda2: 2147 MB, 2147483648 bytes
255 heads, 63 sectors/track, 261 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

== END   fdisk -l ==

== BEGIN blkid ==
/dev/sda1: UUID="c00c975d-e9fc-4955xxxxxxxxxx" TYPE="ext3"
/dev/sda2: TYPE="swap"
== END   blkid ==

== BEGIN cat /proc/mdstat ==
Personalities :
unused devices: <none>
== END   cat /proc/mdstat ==

== BEGIN pvs ==
== END   pvs ==

== BEGIN vgs ==
== END   vgs ==

== BEGIN lvs ==
== END   lvs ==

== BEGIN rpm -qa kernel\* | sort ==
kernel-devel-2.6.18-194.26.1.el5
kernel-headers-2.6.18-194.26.1.el5
kernel-xen-2.6.18-194.26.1.el5
kernel-xen-2.6.18-194.3.1.el5
kernel-xen-2.6.18-194.el5
== END   rpm -qa kernel\* | sort ==

== BEGIN lspci -nn ==
== END   lspci -nn ==

== BEGIN lsusb ==
== END   lsusb ==

== BEGIN rpm -qa kmod\* kmdl\* ==
== END   rpm -qa kmod\* kmdl\* ==

== BEGIN ifconfig -a ==
eth0      Link encap:Ethernet  HWaddr 00:16:xx:xx:xx:xx 
          inet addr:94.xxx.xxx.xxx  Bcast:94.xxx.xxx.xxx  Mask:255.255.255.0
          inet6 addr: fe80::216:xxxx:xxxx:e4e8/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:1579247 errors:0 dropped:0 overruns:0 frame:0
          TX packets:41374 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000
          RX bytes:128064969 (122.1 MiB)  TX bytes:6160924 (5.8 MiB)

lo        Link encap:Local Loopback 
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:376 errors:0 dropped:0 overruns:0 frame:0
          TX packets:376 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0
          RX bytes:18800 (18.3 KiB)  TX bytes:18800 (18.3 KiB)

sit0      Link encap:IPv6-in-IPv4 
          NOARP  MTU:1480  Metric:1
          RX packets:0 errors:0 dropped:0 overruns:0 frame:0
          TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0
          RX bytes:0 (0.0 b)  TX bytes:0 (0.0 b)

== END   ifconfig -a ==

== BEGIN brctl show ==
./getinfo.sh: line 87: brctl: command not found
== END   brctl show ==

== BEGIN route -n ==
Kernel IP routing table
Destination     Gateway         Genmask         Flags Metric Ref    Use Iface
94.xxx.xxx.0    0.0.0.0         255.255.255.0   U     0      0        0 eth0
169.254.0.0     0.0.0.0         255.255.0.0     U     0      0        0 eth0
0.0.0.0         94.249.191.1    0.0.0.0         UG    0      0        0 eth0
== END   route -n ==

== BEGIN cat /etc/resolv.conf ==
########### Automatically generated by OnApp (2.0.rc6)
domain
nameserver 94.xxx.xxx.xxx
nameserver 94.xxx.xxx.xxx
== END   cat /etc/resolv.conf ==

== BEGIN grep net /etc/nsswitch.conf ==
#networks:   nisplus [NOTFOUND=return] files
#netmasks:   nisplus [NOTFOUND=return] files     
netmasks:   files
networks:   files
netgroup:   nisplus
== END   grep net /etc/nsswitch.conf ==

== BEGIN chkconfig --list | grep -Ei 'network|wpa' ==
NetworkManager    0:off   1:off   2:off   3:off   4:off   5:off   6:off
network           0:off   1:off   2:on   3:on   4:on   5:on   6:off
wpa_supplicant    0:off   1:off   2:off   3:off   4:off   5:off   6:off
== END   chkconfig --list | grep -Ei 'network|wpa' ==
[/code]

2. My mysql log file outputs this:

[code]

120108 06:19:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108  6:19:17 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108  6:19:17 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108  6:19:17 InnoDB: The InnoDB memory heap is disabled
120108  6:19:17 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108  6:19:17 InnoDB: Compressed tables use zlib 1.2.3
120108  6:19:17 InnoDB: Using Linux native AIO
120108  6:19:17 InnoDB: Initializing buffer pool, size = 128.0M
120108  6:19:17 InnoDB: Completed initialization of buffer pool
120108  6:19:17 InnoDB: highest supported file format is Barracuda.
120108  6:19:17 InnoDB: 1.1.8 started; log sequence number 1595675
120108  6:19:17 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:19:17 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:22:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108  6:22:29 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108  6:22:29 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108  6:22:29 InnoDB: The InnoDB memory heap is disabled
120108  6:22:29 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108  6:22:29 InnoDB: Compressed tables use zlib 1.2.3
120108  6:22:29 InnoDB: Using Linux native AIO
120108  6:22:29 InnoDB: Initializing buffer pool, size = 128.0M
120108  6:22:29 InnoDB: Completed initialization of buffer pool
120108  6:22:29 InnoDB: highest supported file format is Barracuda.
120108  6:22:29 InnoDB: 1.1.8 started; log sequence number 1595675
120108  6:22:29 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:22:29 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:22:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108  6:22:39 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108  6:22:39 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108  6:22:39 InnoDB: The InnoDB memory heap is disabled
120108  6:22:39 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108  6:22:39 InnoDB: Compressed tables use zlib 1.2.3
120108  6:22:39 InnoDB: Using Linux native AIO
120108  6:22:39 InnoDB: Initializing buffer pool, size = 128.0M
120108  6:22:39 InnoDB: Completed initialization of buffer pool
120108  6:22:39 InnoDB: highest supported file format is Barracuda.
120108  6:22:39 InnoDB: 1.1.8 started; log sequence number 1595675
120108  6:22:39 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:22:39 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:27:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108  6:27:07 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108  6:27:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108  6:27:07 InnoDB: The InnoDB memory heap is disabled
120108  6:27:07 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108  6:27:07 InnoDB: Compressed tables use zlib 1.2.3
120108  6:27:07 InnoDB: Using Linux native AIO
120108  6:27:07 InnoDB: Initializing buffer pool, size = 128.0M
120108  6:27:07 InnoDB: Completed initialization of buffer pool
120108  6:27:07 InnoDB: highest supported file format is Barracuda.
120108  6:27:07  InnoDB: Waiting for the background threads to start
120108  6:27:08 InnoDB: 1.1.8 started; log sequence number 1595675
120108  6:27:08 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:27:08 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:29:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108  6:29:39 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108  6:29:39 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108  6:29:39 InnoDB: The InnoDB memory heap is disabled
120108  6:29:39 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108  6:29:39 InnoDB: Compressed tables use zlib 1.2.3
120108  6:29:39 InnoDB: Using Linux native AIO
120108  6:29:39 InnoDB: Initializing buffer pool, size = 128.0M
120108  6:29:39 InnoDB: Completed initialization of buffer pool
120108  6:29:39 InnoDB: highest supported file format is Barracuda.
120108  6:29:40  InnoDB: Waiting for the background threads to start
120108  6:29:41 InnoDB: 1.1.8 started; log sequence number 1595675
120108  6:29:41 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:29:41 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:30:12 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108  6:30:12 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108  6:30:12 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108  6:30:12 InnoDB: The InnoDB memory heap is disabled
120108  6:30:12 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108  6:30:12 InnoDB: Compressed tables use zlib 1.2.3
120108  6:30:12 InnoDB: Using Linux native AIO
120108  6:30:12 InnoDB: Initializing buffer pool, size = 128.0M
120108  6:30:12 InnoDB: Completed initialization of buffer pool
120108  6:30:12 InnoDB: highest supported file format is Barracuda.
120108  6:30:12 InnoDB: 1.1.8 started; log sequence number 1595675
120108  6:30:12 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:30:12 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:31:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108  6:31:45 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108  6:31:45 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108  6:31:45 InnoDB: The InnoDB memory heap is disabled
120108  6:31:45 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108  6:31:45 InnoDB: Compressed tables use zlib 1.2.3
120108  6:31:45 InnoDB: Using Linux native AIO
120108  6:31:45 InnoDB: Initializing buffer pool, size = 128.0M
120108  6:31:45 InnoDB: Completed initialization of buffer pool
120108  6:31:45 InnoDB: highest supported file format is Barracuda.
120108  6:31:45 InnoDB: 1.1.8 started; log sequence number 1595675
120108  6:31:45 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:31:45 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:36:38 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108  6:36:39 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108  6:36:39 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108  6:36:39 InnoDB: The InnoDB memory heap is disabled
120108  6:36:39 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108  6:36:39 InnoDB: Compressed tables use zlib 1.2.3
120108  6:36:39 InnoDB: Using Linux native AIO
120108  6:36:39 InnoDB: Initializing buffer pool, size = 128.0M
120108  6:36:39 InnoDB: Completed initialization of buffer pool
120108  6:36:39 InnoDB: highest supported file format is Barracuda.
120108  6:36:39  InnoDB: Waiting for the background threads to start
120108  6:36:40 InnoDB: 1.1.8 started; log sequence number 1595675
120108  6:36:40 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:36:40 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:40:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108  6:40:04 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108  6:40:04 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108  6:40:04 InnoDB: The InnoDB memory heap is disabled
120108  6:40:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108  6:40:04 InnoDB: Compressed tables use zlib 1.2.3
120108  6:40:04 InnoDB: Using Linux native AIO
120108  6:40:04 InnoDB: Initializing buffer pool, size = 128.0M
120108  6:40:04 InnoDB: Completed initialization of buffer pool
120108  6:40:04 InnoDB: highest supported file format is Barracuda.
120108  6:40:04 InnoDB: 1.1.8 started; log sequence number 1595675
120108  6:40:04 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:40:04 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:43:48 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108  6:43:48 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108  6:43:48 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108  6:43:48 InnoDB: The InnoDB memory heap is disabled
120108  6:43:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108  6:43:48 InnoDB: Compressed tables use zlib 1.2.3
120108  6:43:48 InnoDB: Using Linux native AIO
120108  6:43:48 InnoDB: Initializing buffer pool, size = 128.0M
120108  6:43:48 InnoDB: Completed initialization of buffer pool
120108  6:43:48 InnoDB: highest supported file format is Barracuda.
120108  6:43:48  InnoDB: Waiting for the background threads to start
120108  6:43:49 InnoDB: 1.1.8 started; log sequence number 1595675
120108  6:43:49 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:43:49 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:45:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108  6:45:54 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108  6:45:54 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108  6:45:54 InnoDB: The InnoDB memory heap is disabled
120108  6:45:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108  6:45:54 InnoDB: Compressed tables use zlib 1.2.3
120108  6:45:54 InnoDB: Using Linux native AIO
120108  6:45:54 InnoDB: Initializing buffer pool, size = 128.0M
120108  6:45:54 InnoDB: Completed initialization of buffer pool
120108  6:45:54 InnoDB: highest supported file format is Barracuda.
120108  6:45:54  InnoDB: Waiting for the background threads to start
120108  6:45:55 InnoDB: 1.1.8 started; log sequence number 1595675
120108  6:45:55 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:45:55 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120108 06:52:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120108  6:52:45 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120108  6:52:45 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120108  6:52:45 InnoDB: The InnoDB memory heap is disabled
120108  6:52:45 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120108  6:52:45 InnoDB: Compressed tables use zlib 1.2.3
120108  6:52:45 InnoDB: Using Linux native AIO
120108  6:52:45 InnoDB: Initializing buffer pool, size = 128.0M
120108  6:52:45 InnoDB: Completed initialization of buffer pool
120108  6:52:45 InnoDB: highest supported file format is Barracuda.
120108  6:52:45 InnoDB: 1.1.8 started; log sequence number 1595675
120108  6:52:45 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120108 06:52:45 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120109 04:46:10 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120109  4:46:10 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120109  4:46:10 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120109  4:46:10 InnoDB: The InnoDB memory heap is disabled
120109  4:46:10 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120109  4:46:10 InnoDB: Compressed tables use zlib 1.2.3
120109  4:46:10 InnoDB: Using Linux native AIO
120109  4:46:10 InnoDB: Initializing buffer pool, size = 128.0M
120109  4:46:10 InnoDB: Completed initialization of buffer pool
120109  4:46:10 InnoDB: highest supported file format is Barracuda.
120109  4:46:11  InnoDB: Waiting for the background threads to start
120109  4:46:12 InnoDB: 1.1.8 started; log sequence number 1595675
120109  4:46:12 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120109 04:46:12 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
[/code]

3. rpm -qa mysql\* | sort outputs:

[code]
mysql-5.5.19-1.el5.art
mysql-5.5.19-1.el5.art
mysqlclient15-5.0.90-1.el5.art
mysql-devel-5.5.19-1.el5.art
mysql-devel-5.5.19-1.el5.art
mysql-libs-5.5.19-1.el5.art
mysql-libs-5.5.19-1.el5.art
mysql-server-5.5.19-1.el5.art
mysql-server-5.5.19-1.el5.art
[/code]

4. Also when i run mysql_upgrade i get this error:
[code]
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed


Im so sorry about this hassle and i really appreciate ur help 8-)
prezaeis
 
Posts: 5
Joined: 2012/01/06 01:54:28

Re: mysql wont start after upgrade

Postby pschaff » 2012/01/10 16:51:30

As far as I can see your problem is related to the use of Atomic repo packages, and is not a CentOS issue per se. Unless someone else here can suggest a solution, all I can advise is to try to get help from Atomicorp forum or support.
pschaff
Retired Moderator
 
Posts: 18277
Joined: 2006/12/13 20:15:34
Location: Tidewater, Virginia, North America


Return to CentOS 5 - Server Support

Who is online

Users browsing this forum: Bing [Bot], Yahoo [Bot] and 1 guest