Re: Possible SHOW DATABASE || TABLE bug in 3.23.33
Sinisa Milivojevic wrote: > > Greg Cope writes: > > >Description: > > SHOW DATABASE and SHOW TABLES and mysqlshow all return empty lists (i.e > > a nice list of blanks - no of blank lines > > equals number of databases / tables) > > > > >How-To-Repeat: > > Do a mysqlshow or SHOW DATABASES under mysql in version 3.23.33 > > > > >Fix: > > > > >Submitter-Id: > > >Originator:Greg Cope > > >Organization: > > > > >MySQL support: none > > >Synopsis: SHOW command possiblxky broken in 3.23.33 > > >Severity: non-critical > > >Priority: low > > >Category: mysql > > >Class: sw-bug > > >Release: mysql-3.23.33 (Source distribution) > > > > >Environment: > > > > System: Linux server1.totallyradio.com 2.2.17-14 #1 Mon Feb 5 18:48:50 > > EST 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/egcs-2.91.66/specs > > gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) > > Compilation info: CC='gcc' CFLAGS='-O3 -malign-double -ffast-math > > -funroll-all-loops -fno-rtti -fno-exceptions -march=pentiumpro > > -fomit-frame-pointer' CXX='c++' CXXFLAGS='-O3 -malign-double > > -ffast-math -funroll-all-loops -fno-rtti -fno-exceptions > > -march=pentiumpro -fomit-frame-pointer' LDFLAGS='' > > LIBC: > > lrwxrwxrwx1 root root 13 Feb 13 10:46 /lib/libc.so.6 > > -> libc-2.1.3.so > > -rwxr-xr-x1 root root 4101836 Jan 15 15:49 > > /lib/libc-2.1.3.so > > -rw-r--r--1 root root 20273324 Jan 15 15:49 /usr/lib/libc.a > > -rw-r--r--1 root root 178 Jan 15 15:49 /usr/lib/libc.so > > Configure command: ./configure --prefix=/usr/local/mysql-3.23.33 > > --enable-assembler --with-mysqld-ldflags=-all-static > > --with-mysqld-user=mysql --localstatedir=/var/lib/mysql > > --sysconfdir=/etc --with-extra-charsets=complex --datadir=/var/lib/mysql > > --localstatedir=/var/lib/mysql --infodir=/usr/info --mandir=/usr/man > > --without-debug --without-bench > > Perl: This is perl, version 5.005_03 built for i386-linux > > > > Hi! > > As there are so many reports, we shall investigate a problem. > > Regards, > > Sinisa Thanks for the reply. I've narrowed this down to a possible issue with the mysqld binary - as I've two versions of mysql on my machine - 3.23.32 and .33. If I fire up .32 everything is fine. If I fire up .33 everthing appears fine until you do a "SHOW" command. Both binaries are setup with the same configure line and hence share the same data dirs (althought not at the same time ;-) Thanks again. Greg > > __ _ _ ___ == MySQL AB > /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic > /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] >/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus > /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| > /*/^^^\*\^^^ > /*/ \*\Developers Team - 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
Re: Possible SHOW DATABASE || TABLE bug in 3.23.33
Greg Cope writes:
> >Description:
> SHOW DATABASE and SHOW TABLES and mysqlshow all return empty lists (i.e
> a nice list of blanks - no of blank lines
> equals number of databases / tables)
>
> >How-To-Repeat:
> Do a mysqlshow or SHOW DATABASES under mysql in version 3.23.33
>
> >Fix:
>
> >Submitter-Id:
> >Originator:Greg Cope
> >Organization:
>
> >MySQL support: none
> >Synopsis: SHOW command possiblxky broken in 3.23.33
> >Severity: non-critical
> >Priority: low
> >Category: mysql
> >Class: sw-bug
> >Release: mysql-3.23.33 (Source distribution)
>
> >Environment:
>
> System: Linux server1.totallyradio.com 2.2.17-14 #1 Mon Feb 5 18:48:50
> EST 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/egcs-2.91.66/specs
> gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
> Compilation info: CC='gcc' CFLAGS='-O3 -malign-double -ffast-math
> -funroll-all-loops -fno-rtti -fno-exceptions -march=pentiumpro
> -fomit-frame-pointer' CXX='c++' CXXFLAGS='-O3 -malign-double
> -ffast-math -funroll-all-loops -fno-rtti -fno-exceptions
> -march=pentiumpro -fomit-frame-pointer' LDFLAGS=''
> LIBC:
> lrwxrwxrwx1 root root 13 Feb 13 10:46 /lib/libc.so.6
> -> libc-2.1.3.so
> -rwxr-xr-x1 root root 4101836 Jan 15 15:49
> /lib/libc-2.1.3.so
> -rw-r--r--1 root root 20273324 Jan 15 15:49 /usr/lib/libc.a
> -rw-r--r--1 root root 178 Jan 15 15:49 /usr/lib/libc.so
> Configure command: ./configure --prefix=/usr/local/mysql-3.23.33
> --enable-assembler --with-mysqld-ldflags=-all-static
> --with-mysqld-user=mysql --localstatedir=/var/lib/mysql
> --sysconfdir=/etc --with-extra-charsets=complex --datadir=/var/lib/mysql
> --localstatedir=/var/lib/mysql --infodir=/usr/info --mandir=/usr/man
> --without-debug --without-bench
> Perl: This is perl, version 5.005_03 built for i386-linux
>
Hi!
As there are so many reports, we shall investigate a problem.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
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
Possible SHOW DATABASE || TABLE bug in 3.23.33
>Description: SHOW DATABASE and SHOW TABLES and mysqlshow all return empty lists (i.e a nice list of blanks - no of blank lines equals number of databases / tables) >How-To-Repeat: Do a mysqlshow or SHOW DATABASES under mysql in version 3.23.33 >Fix: >Submitter-Id: >Originator:Greg Cope >Organization: >MySQL support: none >Synopsis: SHOW command possiblxky broken in 3.23.33 >Severity: non-critical >Priority: low >Category: mysql >Class: sw-bug >Release: mysql-3.23.33 (Source distribution) >Environment: System: Linux server1.totallyradio.com 2.2.17-14 #1 Mon Feb 5 18:48:50 EST 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/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='-O3 -malign-double -ffast-math -funroll-all-loops -fno-rtti -fno-exceptions -march=pentiumpro -fomit-frame-pointer' CXX='c++' CXXFLAGS='-O3 -malign-double -ffast-math -funroll-all-loops -fno-rtti -fno-exceptions -march=pentiumpro -fomit-frame-pointer' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Feb 13 10:46 /lib/libc.so.6 -> libc-2.1.3.so -rwxr-xr-x1 root root 4101836 Jan 15 15:49 /lib/libc-2.1.3.so -rw-r--r--1 root root 20273324 Jan 15 15:49 /usr/lib/libc.a -rw-r--r--1 root root 178 Jan 15 15:49 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql-3.23.33 --enable-assembler --with-mysqld-ldflags=-all-static --with-mysqld-user=mysql --localstatedir=/var/lib/mysql --sysconfdir=/etc --with-extra-charsets=complex --datadir=/var/lib/mysql --localstatedir=/var/lib/mysql --infodir=/usr/info --mandir=/usr/man --without-debug --without-bench Perl: This is perl, version 5.005_03 built for i386-linux - 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
