>Description:
I have found the error. On Linux RedHat 7.0 with kernel 2.2.17-14
all 'show' commands doesn't works. They display empty tables.
>How-To-Repeat:
Install RedHat 7.0 on Intel platform, apply all updates from RedHat
(up to March, 01 2001), compile kernel 2.2.17-14 from kernel-sources
package, then compile MySQL from RPM supplied by www.mysql.com.
Compiling went OK and MySQL can be installed. By we will always
get such strange results for 'show' commands:
$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 3.23.33-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql> show databases;
+----------+
| Database |
+----------+
| |
| |
| |
| |
| |
| |
| |
| |
+----------+
8 rows in set (0.00 sec)
mysql> use UNEXISTANT;
ERROR 1049: Unknown database 'UNEXISTANT'
mysql> use mysql;
Database changed
mysql> show tables;
Empty set (0.00 sec)
As we can see, there are AVAILABLE databases, but 'show databases'
doesn't displays anything. We can make 'use' with correct names,
can't with unexistant, but the tables in database can't be reached.
BTW, I have found the dependence of number in line ('8 rows in set)
above - it corresponds to number of entries in /var/lib/mysql/
directory:
$ ls -a /var/lib/mysql/
. Phantom.log Phantom.tsk.ru.pid mysql.sock
.. Phantom.tsk.ru.err mysql test
There are total 8 files (with '.' and '..' entries). We can create
one more file by peforming 'touch /var/lib/mysql/asdf' and here are
new mysql report:
mysql> show databases;
+----------+
| Database |
+----------+
| |
| |
| |
| |
| |
| |
| |
| |
| |
+----------+
9 rows in set (0.00 sec)
Very strange, isn't it ?..
And what is more, I _have_ tried to undefine the HAVE_READDIR_R in
config.h . The same results...
I have tried to compile OLD MySQL (version 3.22.32), it works
with absolutelly the same problems.
>Fix:
I doesn't know how to correct this. I'll be very thankful if someone
help me...
>Submitter-Id: <submitter ID>
>Originator: [EMAIL PROTECTED]
>Organization:
none
>MySQL support: none
>Synopsis: The bug with empty 'show databases' results. Linux RedHat 7.0 i386
>Severity: critical
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.33 (Official MySQL RPM)
>Server: /usr/bin/mysqladmin Ver 8.15 Distrib 3.23.33, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.33-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 13 min 1 sec
Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0
Queries per second avg: 0.016
>Environment:
System: Linux Phantom.tsk.ru 2.2.17-14 #1 Tue Mar 6 03:05:11 TSK 2001 i686 unknown
Architecture: i686
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/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.0)
Compilation info: CC='egcs' CFLAGS=' -O6' CXX='egcs' CXXFLAGS=' -O6
-felide-constructors -fno-exceptions -fno-rtti' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 11 Mar 5 17:37 /lib/libc.so.6 -> libc-2.2.so
-rwxr-xr-x 1 root root 5155229 Jan 11 07:09 /lib/libc-2.2.so
-rw-r--r-- 1 root root 24498288 Jan 11 06:35 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Jan 11 06:35 /usr/lib/libc.so
lrwxrwxrwx 1 root root 10 Mar 6 00:23 /usr/lib/libc-client.a ->
c-client.a
Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --with-charset=koi8_ru --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 --without-berkeley-db
'--with-comment=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