3.22.32 hangs on count().

[Eddie]

I am having a strange issue with MySQL. I just installed it on my Zaurus
and loaded a few of my databases in it. All very small.

When I do a count withoout a where, it hangs. It does this on all my
databases I have loaded. Example below.

_______________ _______________ _______________ _______________ ___________
mysql Ver 9.38 Distrib 3.22.32, for unknown-linux-gnu (armv4l)

Connection id: 8
Current database: survey
Current user: root@localhost
Server version 3.22.32-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 40 min 2 sec

Threads: 5 Questions: 44 Slow queries: 0 Opens: 15 Flush tables: 1 Open tables: 8
--------------
mysql> select count(*) from master where per <> 20;
+----------+
| count(*) |
+----------+
| 2 |
+----------+
1 row in set (0.01 sec)

mysql> select count(*) from master;
(hangs here forever with ony 2 records in the master table)
---------------------------------------------------------

I don't have the compile enviroment so I can't upgrade to 4.1.

How can I debug this problem. I don't see anything out of the norm in the
error log.
Thanks
-Eddie

[Aggro]

Eddie wrote:

I don't have the compile enviroment so I can't upgrade to 4.1.
Can you upgrade to 3.23?

http://downloads.mysql.com/archives.php?p=mysql-3.23
How can I debug this problem. I don't see anything out of the norm in the
error log.

Does check table show any warnings or errors? ( Unlikely, since the
other select count(*) worked with you, but worth to check anyway. ):
check table master;

Does it work if you give the command in this way: (same as without
where, since 1 is always true):
select count(*) from master where 1;