Hi,
I have got a table with an index and apparently it crashed and I cannot
get anymore results :-( with a MATCH AGAINST query. I have tried to
repair the table (which contains only 2 rows) with myisamchk but it
doesn't change anything (maybe I used the wrong options: I used -e and
-r)
One query returns "0" as a result (it seems obvious to me that it should
not). And the other one returns an error message (and "perror 127" gives
"127 = Record-file is crashed").
How can I repair this ? And shouldn't the first query give the same
error message as the second ? (it took some time to identify this).
Thanks for the help,
Jean-Cédric
mysql> select sujet,texte,motsclefs from documents;
+---------------------------+-------------------------------+-----------+
| sujet | texte | motsclefs
|
+---------------------------+-------------------------------+-----------+
| MySQL has now support | for full-text search | NULL
|
| Full-text search in MySQL | implements vector space model | NULL
|
+---------------------------+-------------------------------+-----------+
mysql> select sujet,texte,motsclefs, MATCH(sujet,texte,motsclefs)
AGAINST('implements vector') as x from documents;
+---------------------------+-------------------------------+-----------+------+
| sujet | texte | motsclefs
| x |
+---------------------------+-------------------------------+-----------+------+
| MySQL has now support | for full-text search | NULL
| 0 |
| Full-text search in MySQL | implements vector space model | NULL
| 0 |
+---------------------------+-------------------------------+-----------+------+
mysql> select sujet,texte,motsclefs from documents where
MATCH(sujet,texte,motsclefs) AGAINST('implements vector space');
ERROR 1030: Got error 127 from table handler
Other info
**********
The table is created by this script
CREATE TABLE documents (
id VARCHAR(255) NOT NULL PRIMARY KEY,
type VARCHAR( 10),
origine VARCHAR(255),
habilitation VARCHAR(255),
elaboration BOOL,
date DATE,
sujet VARCHAR(255),
auteur VARCHAR(255),
entite VARCHAR(255),
format VARCHAR( 10),
document MEDIUMBLOB,
motsclefs TEXT,
texte MEDIUMTEXT,
FULLTEXT(sujet, motsclefs, texte)
);
System: Linux zeus.rezal-mdm.com 2.2.16-22 #1 Tue Aug 22 16:49:06 EDT
2000 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='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686'
CXX='c++' CXXFLAGS='-O2
-march=i386 -mcpu=i686' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 11 Nov 26 22:28 /lib/libc.so.6
-> libc-2.2.so
-rwxr-xr-x 1 root root 4761074 Dec 15 14:39 /lib/libc-2.2.so
-rw-r--r-- 1 root root 22855536 Dec 15 14:37 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Dec 15 14:37 /usr/lib/libc.so
Configure command: ./configure i386-redhat-linux --prefix=/usr
--exec-prefix=/usr
--bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc
--datadir=/usr/share
--includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec
--localstatedir=/var
--sharedstatedir=/usr/com --mandir=/usr/share/man
--infodir=/usr/share/info --without-debug
--without-readline --enable-shared --with-extra-charsets=complex
--without-bench
--localstatedir=/var/lib/mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock
--with-mysqld-user=mysql --with-extra-charsets=all
--
Jean-Cédric COSTA [EMAIL PROTECTED]
Ecole des Mines de Paris (P 98) http://www.jean-cedric.com/
---------------------------------------------------------------------
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
