|
[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]
|
[PLUG] centos mysql problem
|
I'm running Centos 5.x, everything was running just fine and today
I find out mysql is not running at all and I cannot start it as a
service.
Yesterday, yum updated the following:
=====================================
Sep 16 06:03:10 Installed: kernel-2.6.18-164.el5.i686
Sep 16 06:03:12 Updated: kernel-headers-2.6.18-164.el5.i386
Sep 16 06:03:17 Updated: openssl-0.9.8e-12.el5.i686
Sep 16 06:03:18 Updated: nspr-4.7.5-1.el5_4.i386
Sep 16 06:03:19 Updated: mysql-5.0.77-3.el5.i386
Sep 16 06:03:19 Updated: openssh-4.3p2-36.el5.i386
Sep 16 06:03:19 Updated: lftp-3.7.11-4.el5.i386
Sep 16 06:03:20 Updated: openssh-clients-4.3p2-36.el5.i386
Sep 16 06:03:21 Updated: 1:nfs-utils-1.0.9-42.el5.i386
Sep 16 06:03:22 Updated: mysql-server-5.0.77-3.el5.i386
Sep 16 06:03:22 Updated: openssh-server-4.3p2-36.el5.i386
Sep 16 06:03:23 Updated: fetchmail-6.3.6-1.1.el5_3.1.i386
Sep 16 06:03:25 mysql-server: ts_done name in te is nfs-utils
should be mysql-server
Sep 16 06:04:00 openssh-server: ts_done name in te is mysql-server
should be openssh-server
Sep 16 06:04:03 mysql: ts_done name in te is openssh-server should
be mysql
Sep 16 06:04:04 lftp: ts_done name in te is mysql should be lftp
Sep 16 06:04:04 fetchmail: ts_done name in te is lftp should be
fetchmail
Sep 16 06:04:04 openssl: ts_done name in te is fetchmail should be
openssl
here's the mysqld log:
======================
090905 23:42:05 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: xxxx
Source distribution
090916 6:03:25 [Note] /usr/libexec/mysqld: Normal shutdown
090916 6:03:25 InnoDB: Starting shutdown...
090916 6:03:29 InnoDB: Shutdown completed; log sequence number 0
318719237
090916 6:03:29 [Note] /usr/libexec/mysqld: Shutdown complete
090916 06:03:29 mysqld ended
090916 06:03:30 mysqld started
/usr/libexec/mysqld: error while loading shared libraries:
librt.so.1: cannot open shared object file: No such file or
directory
090916 06:03:30 mysqld ended
090917 09:54:09 mysqld started
/usr/libexec/mysqld: error while loading shared libraries:
librt.so.1: cannot open shared object file: No such file or
directory
090917 09:54:09 mysqld ended
090917 09:57:55 mysqld started
/usr/libexec/mysqld: error while loading shared libraries:
librt.so.1: cannot open shared object file: No such file or
directory
090917 09:57:55 mysqld ended
090917 09:59:01 mysqld started
/usr/libexec/mysqld: error while loading shared libraries:
librt.so.1: cannot open shared object file: No such file or
directory
090917 09:59:01 mysqld ended
090917 10:02:35 mysqld started
/usr/libexec/mysqld: error while loading shared libraries:
librt.so.1: cannot open shared object file: No such file or
directory
090917 10:02:35 mysqld ended
090917 10:11:27 mysqld started
/usr/libexec/mysqld: error while loading shared libraries:
librt.so.1: cannot open shared object file: No such file or
directory
090917 10:11:27 mysqld ended
090917 10:20:10 mysqld started
/usr/libexec/mysqld: error while loading shared libraries:
librt.so.1: cannot open shared object file: No such file or
directory
090917 10:20:10 mysqld ended
090917 10:26:38 mysqld started
090917 10:26:38 [Warning] option 'max_join_size': unsigned value
18446744073709551615 adjusted to 4294967295
090917 10:26:38 [Warning] option 'max_join_size': unsigned value
18446744073709551615 adjusted to 4294967295
090917 10:26:39 InnoDB: Started; log sequence number 0 318719237
090917 10:26:39 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: xxxx
Source distribution
090917 10:30:07 mysqld started
/usr/libexec/mysqld: error while loading shared libraries:
librt.so.1: cannot open shared object file: No such file or
directory
090917 10:30:07 mysqld ended
090917 10:30:28 mysqld started
/usr/libexec/mysqld: error while loading shared libraries:
librt.so.1: cannot open shared object file: No such file or
directory
090917 10:30:28 mysqld ended
090917 10:33:27 mysqld started
/usr/libexec/mysqld: error while loading shared libraries:
librt.so.1: cannot open shared object file: No such file or
directory
090917 10:33:27 mysqld ended
090917 10:34:07 mysqld started
090917 10:34:07 [Warning] option 'max_join_size': unsigned value
18446744073709551615 adjusted to 4294967295
090917 10:34:07 [Warning] option 'max_join_size': unsigned value
18446744073709551615 adjusted to 4294967295
090917 10:34:07 InnoDB: Started; log sequence number 0 318719237
090917 10:34:07 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: xxxx
Source distribution
So, obviously, MySQL cannot find a file called 'librt.so.1' even
though it's clearly there at:
/lib/librt.so.1
I can start mysql with:
mysqld_safe
but it refuses to run as a service
What do I need to do to repair:
service mysqld start
--
Sean C. Sheridan
I'm running Centos 5.x, everything was running just fine and today I find
out mysql is not running at all and I cannot start it as a service.
Yesterday, yum updated the following:
=====================================
Sep 16 06:03:10 Installed: kernel-2.6.18-164.el5.i686
Sep 16 06:03:12 Updated: kernel-headers-2.6.18-164.el5.i386
Sep 16 06:03:17 Updated: openssl-0.9.8e-12.el5.i686
Sep 16 06:03:18 Updated: nspr-4.7.5-1.el5_4.i386
Sep 16 06:03:19 Updated: mysql-5.0.77-3.el5.i386
Sep 16 06:03:19 Updated: openssh-4.3p2-36.el5.i386
Sep 16 06:03:19 Updated: lftp-3.7.11-4.el5.i386
Sep 16 06:03:20 Updated: openssh-clients-4.3p2-36.el5.i386
Sep 16 06:03:21 Updated: 1:nfs-utils-1.0.9-42.el5.i386
Sep 16 06:03:22 Updated: mysql-server-5.0.77-3.el5.i386
Sep 16 06:03:22 Updated: openssh-server-4.3p2-36.el5.i386
Sep 16 06:03:23 Updated: fetchmail-6.3.6-1.1.el5_3.1.i386
Sep 16 06:03:25 mysql-server: ts_done name in te is nfs-utils should be mysql-server
Sep 16 06:04:00 openssh-server: ts_done name in te is mysql-server should be openssh-server
Sep 16 06:04:03 mysql: ts_done name in te is openssh-server should be mysql
Sep 16 06:04:04 lftp: ts_done name in te is mysql should be lftp
Sep 16 06:04:04 fetchmail: ts_done name in te is lftp should be fetchmail
Sep 16 06:04:04 openssl: ts_done name in te is fetchmail should be openssl
here's the mysqld log:
======================
090905 23:42:05 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: xxxx Source distribution
090916 6:03:25 [Note] /usr/libexec/mysqld: Normal shutdown
090916 6:03:25 InnoDB: Starting shutdown...
090916 6:03:29 InnoDB: Shutdown completed; log sequence number 0 318719237
090916 6:03:29 [Note] /usr/libexec/mysqld: Shutdown complete
090916 06:03:29 mysqld ended
090916 06:03:30 mysqld started
/usr/libexec/mysqld: error while loading shared libraries: librt.so.1: cannot open shared object file: No such file or directory
090916 06:03:30 mysqld ended
090917 09:54:09 mysqld started
/usr/libexec/mysqld: error while loading shared libraries: librt.so.1: cannot open shared object file: No such file or directory
090917 09:54:09 mysqld ended
090917 09:57:55 mysqld started
/usr/libexec/mysqld: error while loading shared libraries: librt.so.1: cannot open shared object file: No such file or directory
090917 09:57:55 mysqld ended
090917 09:59:01 mysqld started
/usr/libexec/mysqld: error while loading shared libraries: librt.so.1: cannot open shared object file: No such file or directory
090917 09:59:01 mysqld ended
090917 10:02:35 mysqld started
/usr/libexec/mysqld: error while loading shared libraries: librt.so.1: cannot open shared object file: No such file or directory
090917 10:02:35 mysqld ended
090917 10:11:27 mysqld started
/usr/libexec/mysqld: error while loading shared libraries: librt.so.1: cannot open shared object file: No such file or directory
090917 10:11:27 mysqld ended
090917 10:20:10 mysqld started
/usr/libexec/mysqld: error while loading shared libraries: librt.so.1: cannot open shared object file: No such file or directory
090917 10:20:10 mysqld ended
090917 10:26:38 mysqld started
090917 10:26:38 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
090917 10:26:38 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
090917 10:26:39 InnoDB: Started; log sequence number 0 318719237
090917 10:26:39 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: xxxx Source distribution
090917 10:30:07 mysqld started
/usr/libexec/mysqld: error while loading shared libraries: librt.so.1: cannot open shared object file: No such file or directory
090917 10:30:07 mysqld ended
090917 10:30:28 mysqld started
/usr/libexec/mysqld: error while loading shared libraries: librt.so.1: cannot open shared object file: No such file or directory
090917 10:30:28 mysqld ended
090917 10:33:27 mysqld started
/usr/libexec/mysqld: error while loading shared libraries: librt.so.1: cannot open shared object file: No such file or directory
090917 10:33:27 mysqld ended
090917 10:34:07 mysqld started
090917 10:34:07 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
090917 10:34:07 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
090917 10:34:07 InnoDB: Started; log sequence number 0 318719237
090917 10:34:07 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: xxxx Source distribution
So, obviously, MySQL cannot find a file called 'librt.so.1' even though it's clearly there at:
/lib/librt.so.1
I can start mysql with:
mysqld_safe
but it refuses to run as a service
What do I need to do to repair:
service mysqld start
--
Sean C. Sheridan
___________________________________________________________________________
Philadelphia Linux Users Group -- http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion -- http://lists.phillylinux.org/mailman/listinfo/plug
|