List:General Discussion« Previous MessageNext Message »
From:quinn Date:November 18 2002 4:37pm
Subject:mysql from redhat8 will only run one process and remote connections die.
View as plain text  
>Description:
I just installed redhat8 this weekend and am using the rpm's provided by them.  when mysql
runs it will only run a single process.  and even worse... when I try and connect to port
3306 (even via telnet) the process is immediately killed and safe_mysqld restarts it.  it
logs the following to /var/log/mysqld.log

Number of processes running now: 1
mysqld process hanging, pid 32456 - killed
021118 11:32:44  mysqld restarted
/usr/libexec/mysqld: ready for connections


>How-To-Repeat:
any mysql command from a remote host will "hang" the process immediately.
even if I telnet to 3306 it immediately closes and reports the above error.
>Fix:


>Submitter-Id:	<submitter ID>
>Originator:	Kevin Quinn
>Organization:  BitWrench Incorporated
>MySQL support: none
>Synopsis:	redhat8 mysql install not allowing remote connections
>Severity:	critical
>Priority:	
>Category:	mysql
>Class:		
>Release:	mysql-3.23.52 (Source distribution)

>Environment:
	
System: Linux lug 2.4.18-14smp #1 SMP Wed Sep 4 12:34:47 EDT 2002 i686 i686 i386 GNU/Linux
Architecture: i686

Some paths:  /usr/local/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/3.2/specs
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
--infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking
--host=i386-redhat-linux --with-system-zlib --enable-__cxa_atexit
Thread model: posix
gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7)
Compilation info: CC='gcc'  CFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE
-D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE'  CXX='g++'  CXXFLAGS='-O2 -march=i386
-mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-rtti
-fno-exceptions'  LDFLAGS=''
LIBC: 
lrwxrwxrwx    1 root     root           14 Nov 16 22:13 /lib/libc.so.6 ->
libc-2.2.93.so
-rwxr-xr-x    1 root     root      1235468 Sep  5 19:12 /lib/libc-2.2.93.so
-rw-r--r--    1 root     root      2233342 Sep  5 18:59 /usr/lib/libc.a
-rw-r--r--    1 root     root          178 Sep  5 18:50 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin
--datadir=/usr/share --libdir=/usr/lib --mandir=/usr/share/man --infodir=/usr/share/info
--without-readline --without-debug --enable-shared --with-extra-charsets=complex
--with-bench --localstatedir=/var/lib/mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --with-mysqld-user=mysql
--with-extra-charsets=all --with-innodb --enable-local-infile --enable-large-files=yes
--enable-largefile=yes --with-berkeley-db --with-thread-safe-client 'CFLAGS=-O2
-march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE'
'CXXFLAGS=-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64
-D_LARGEFILE_SOURCE -fno-rtti -fno-exceptions'

Thread
mysql from redhat8 will only run one process and remote connections die.quinn18 Nov
  • Re: mysql from redhat8 will only run one process and remote connectionsdie.Joseph Bueno18 Nov
    • Re: mysql from redhat8 will only run one process and remoteconnections die.Adam Voigt18 Nov
  • Re: mysql from redhat8 will only run one process and remote connectionsdie.Kevin Quinn18 Nov