From: Jeffrey D. Adams
Date: April 29 1999 12:04pm
Subject: Trouble connecting to mysql under linuxppc
List-Archive: http://lists.mysql.com/mysql/2608
Message-Id: <199904291204.IAA02629@artin.umd.edu>

>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. Here is my glibc information:

[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

(PS: I am sending this from another machine, since sendmail is not configured on my mac.)
>How-To-Repeat:
>mysqld --skipt-grant
>mysqladmin version
...
>msqldadmin version 
(hangs, with zombie thread)

>Fix:


>Submitter-Id:	
>Originator:	
>Organization:
>MySQL support: none
>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