>Description:
I am running mysql on a powermac 7200 running linux. I can start it
with safe_mysqld --skip-grant or mysqld --skip-grant. Three threads
appear. I can perform one operation. Then the middle numbered thread
becomes a zombie, and I cannot connect again:
ps aux
...
root 4079 0.0 0.0 0 0 p2 SW 21:21 0:00 ./sql/mysqld --skip-grant
root 4080 0.0 1.9 5416 1216 p2 S 23:25 0:00 ./sql/mysqld --skip-grant
root 4081 0.0 1.9 5416 1216 p2 S 23:25 0:00 ./sql/mysqld --skip-grant
>[root@localhost mysql-3.22.21]# mysqladmin version
mysqladmin Ver 7.11 Distrib 3.22.21, for unknown-linux-gnu on powerpc
TCX Datakonsult AB, by Monty
Server version 3.22.21
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 1 min 15 sec
Threads: 1 Questions: 1 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 0
ps aux
...
root 3855 0.0 1.0 2916 672 p2 T 23:22 0:00 mysqladmin version
root 4079 0.0 0.0 0 0 p2 SW 21:21 0:00 ./sql/mysqld --skip-grant
root 4080 0.0 0.0 0 0 p2 Z 23:25 0:00 (mysqld <zombie>)
root 4081 0.0 2.0 5432 1272 p2 S 23:25 0:00 ./sql/mysqld --skip-grant
I can't run mysql_install_db for the same reason, I suppose, it seems
it installs a few files and then quits. If I run it a few times it
succeds in installing everything, I think. I have the most recent
glibc:
[jda@localhost ~]$ rpm -qa | grep glibc
glibc-0.961212-1h
glibc-devel-0.961212-1h
glibc-info-0.961212-1h
glibc-static-0.961212-1h
>How-To-Repeat:
>mysqld --skipt-grant
>mysqladmin version
...
>msqldadmin version
(hangs, with zombie thread)
>Fix:
>Submitter-Id: <submitter ID>
>Originator:
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis: Can't connect to server (zombie thread)
>Severity: critical
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.22.21 (Source distribution)
>Environment:
System: Linux localhost.localdomain 2.1.125 #25 Wed Oct 14 13:40:58 EST 1998 ppc unknown
Architecture: ppc
Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from
/opt/egcs/lib/gcc-lib/powerpc-unknown-linux-gnulibc1/egcs-2.90.25/specs
gcc version egcs-2.90.25 980302 (egcs-1.0.2 prerelease)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
Configure command: ./configure --with-low-memory
Perl: This is perl, version 5.004_01
