Re: Daemon crashing (I'm going nuts here)
The only thing I could suggest is that the version of MYSQL you have is not compatible with something else that is running, like PHP perhaps, or even the version of Linux/Kernel/C-libraries. You are experiencing very strange problems, and these types of things are typically caused by incompatibility issues between different software packages. At 11:48 AM 6/13/01 -0400, Walker, Brian wrote: I'm at wits end here, I've been through the documentation multiple times, asked questions on this list, but I still cannot get this server running. I've restarted the server and everything. The only thing I know is that the mysqld daemon crashes when I try to start it. I could not have another one running since I couldn't start the thing to begin with! Here is what happens: [root@www /usr]# bin/safe_mysqld --user=mysql [1] 26103 [root@www /usr]# Starting mysqld daemon with databases from /var/lib/mysql 010612 08:37:33 mysqld ended I have to press Ctrl-C to get a prompt back. Here's what the error log says: 010612 08:17:53 mysqld started 010612 8:17:53 Can't start server: Bind on TCP/IP port: Address already in use 010612 8:17:53 Do you already have another mysqld server running on port: 3306 ? 010612 8:17:53 Aborting 010612 8:17:53 /usr/sbin/mysqld: Shutdown Complete 010612 08:17:53 mysqld ended There is nothing using 3306 because I can telnet to it (per the manuals instruction on this error message) The one last thing I can think of is that something is outdated on my system when it comes to glibc and libc versions. Here is the output from mysqlbug. Let me know if something catches your eye. Release: mysql-3.23.38 (Official MySQL RPM) Environment: machine, os, target, libraries (multiple lines) System: Linux www.sfslsports.com 2.2.14C5 #1 Mon May 8 10:14:32 PDT 2000 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='egcs' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='egcs' CXXFLAGS='-O6 -fno-omit-frame-pointer \ -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Apr 27 17:33 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x 1 root root 4101836 Sep 5 2000 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 20273284 Sep 5 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Sep 5 2000 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berk\ eley-db --without-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ -\ -with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/\ lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' Any ideas? Brian Walker - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Daemon crashing (I'm going nuts here)
I'm at wits end here, I've been through the documentation multiple times, asked questions on this list, but I still cannot get this server running. I've restarted the server and everything. The only thing I know is that the mysqld daemon crashes when I try to start it. I could not have another one running since I couldn't start the thing to begin with! Here is what happens: [root@www /usr]# bin/safe_mysqld --user=mysql [1] 26103 [root@www /usr]# Starting mysqld daemon with databases from /var/lib/mysql 010612 08:37:33 mysqld ended I have to press Ctrl-C to get a prompt back. Here's what the error log says: 010612 08:17:53 mysqld started 010612 8:17:53 Can't start server: Bind on TCP/IP port: Address already in use 010612 8:17:53 Do you already have another mysqld server running on port: 3306 ? 010612 8:17:53 Aborting 010612 8:17:53 /usr/sbin/mysqld: Shutdown Complete 010612 08:17:53 mysqld ended There is nothing using 3306 because I can telnet to it (per the manuals instruction on this error message) The one last thing I can think of is that something is outdated on my system when it comes to glibc and libc versions. Here is the output from mysqlbug. Let me know if something catches your eye. Release: mysql-3.23.38 (Official MySQL RPM) Environment: machine, os, target, libraries (multiple lines) System: Linux www.sfslsports.com 2.2.14C5 #1 Mon May 8 10:14:32 PDT 2000 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='egcs' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='egcs' CXXFLAGS='-O6 -fno-omit-frame-pointer \ -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Apr 27 17:33 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x 1 root root 4101836 Sep 5 2000 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 20273284 Sep 5 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Sep 5 2000 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berk\ eley-db --without-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ -\ -with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/\ lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' Any ideas? Brian Walker - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Daemon crashing (I'm going nuts here)
Have you tried rebooting? I'm seeing the same problem with 3.23.38 (after stopping the server with mysqladmin and then trying to restart with safe_mysqld) but rebooting resets whatever it is that 3.23.38 is not properly clearing on the shutdown. Don't have this problem on another system running 3.23.37, so it's probably a new bug - but then the *.37 system is running from the binary tar, while the *.38 is from the official RPM, which you're also using. Whit On Wed, Jun 13, 2001 at 11:48:36AM -0400, Walker, Brian wrote: Here is what happens: [root@www /usr]# bin/safe_mysqld --user=mysql [1] 26103 [root@www /usr]# Starting mysqld daemon with databases from /var/lib/mysql 010612 08:37:33 mysqld ended I have to press Ctrl-C to get a prompt back. Here's what the error log says: 010612 08:17:53 mysqld started 010612 8:17:53 Can't start server: Bind on TCP/IP port: Address already in use 010612 8:17:53 Do you already have another mysqld server running on port: 3306 ? 010612 8:17:53 Aborting 010612 8:17:53 /usr/sbin/mysqld: Shutdown Complete 010612 08:17:53 mysqld ended Release: mysql-3.23.38 (Official MySQL RPM) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Daemon crashing (I'm going nuts here)
Walker, Brian wrote: I'm at wits end here, I've been through the documentation multiple times, asked questions on this list, but I still cannot get this server running. I've restarted the server and everything. The only thing I know is that the mysqld daemon crashes when I try to start it. I could not have another one running since I couldn't start the thing to begin with! There is nothing using 3306 because I can telnet to it (per the manuals instruction on this error message) Well, if you can telnet to 3306, then something is runnin on it. Are you sure it is not already running? what does ps -ef | grep mysqld show you? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php