Canadian Lumberer wrote:
>
> Hi,
>
> I hope to be helpful for further investigation of the problem.
>
> On Wed, Mar 07, 2001 at 08:20:16AM +0700, Eugene Lineitzev wrote:
> > >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.
> In my case error appeared in RedHat 6.2 with kernel 2.2.18. And on RedHat 7.0
> sources from www.mysql.com compliled and work pretty well.
>
> > >How-To-Repeat:
> > $ mysql
> > 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
> On my RH 6.2 there is another dependancy. show databases returns number of
> entries in the directory without . and ..
>
> Moreover, show tables returns very nice list of tables' names. All names are
> truncated in the first 4 characters (tables_priv -> es_priv). Perhaps it's
> interesting to know that my data folder is /data.
>
> > 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=''
> Another common moment is on RH 6.2 I compiled it with egcs and libstdc++ was
> not installed.
If this helps my problems are on:
Redhat 6.2 I've libstdc++-2.9.0-30 and it has the above bug on kernel
2.2.17 and 2.4.2 complie with gcc -v of
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release).
SUSE 7.0 libstdc is not install - bug still apears gcc is gcc version
2.95.2 19991024, Kernel 2.2.16
greg
> On RH7.0 I compiled with gcc and libstdc++ was installed.
>
> It looks like we have problems with either egcs or libstdc and company.
My experience does not suggest this but I am opne to any ideas !
>
> Hope it helps MySQL developers.
So do I
Greg
>
> Best regards,
> Lumberer.
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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