List:General Discussion« Previous MessageNext Message »
From:<sinisa Date:November 27 1999 1:54pm
Subject:Re: possible problem with nested sorts (follow -up)
View as plain text  
localuser@stripped writes:
 > > Hi!
 > > 
 > > Run isamchk or myisamchk with -r, or -o option on tables in question
 > > and try again.
 > > 
 > > If it persists, do try binary version. If it persists, please report
 > > your glibc version and subversion.
 > > 
 > > Sinisa
 > 
 > Did the first two with no change. Using the glibc installed with
 > Red Hat 6.1 (2.1.2).
 > 
 > Let me know if you need anything else.
 > 
 > 
 > >How-To-Repeat:
 > 	
 > >Fix:
 > 	
 > 
 > >Submitter-Id:	<submitter ID>
 > >Originator:	localuser
 > >Organization:
 >  
 > >MySQL support: none
 > >Synopsis:	possible problem with nested sorts (follow -up)
 > >Severity:	serious
 > >Priority:	medium
 > >Category:	mysql
 > >Class:		sw-bug
 > >Release:	mysql-3.22.27 (TCX binary)
 > 
 > >Environment:
 > white box, PII 450 X 2, 256 MB RAM, pretty much a generic Red Hat 6.1
 > System: Linux localhost 2.2.13 #2 SMP Thu Oct 21 19:50:25 PDT 1999 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='-O6 -mpentium -fomit-frame-pointer'  CXX='gcc' 
CXXFLAGS='-O6 -mpentium -fomit-frame-pointer -felide-constructors'  LDFLAGS='-static'
 > Configure command: ./configure  --prefix=/usr/local/mysql '--with-comment=TCX
binary' --enable-assembler --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --disable-shared
 > Perl: This is perl, version 5.005_03 built for i386-linux
 > 

Hi!

Your glibc and MySQL versions are OK. 

Could you please repost your problem, a small mysqldump of the table
which could help us reproduce a problem, and the problematic query
result output .

Sinisa

+----------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___     ==  mysql@stripped            |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic          |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sinisa@stripped|
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaka, Cyprus             |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                             |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                            |
|             /*/             \*\                Developers Team       |
+----------------------------------------------------------------------+
Thread
possible problem with nested sorts (follow -up)localuser27 Nov
  • Re: possible problem with nested sorts (follow -up)sinisa27 Nov