List:General Discussion« Previous MessageNext Message »
From:martin Date:September 19 2000 11:36am
Subject:myisamchk can't repair table
View as plain text  
	I tried to use a FULLTEXT index (Name,Descr) in the following table

  CREATE TABLE Product (
  product_id int(10) unsigned NOT NULL auto_increment,
  shop_id int(11) DEFAULT '0' NOT NULL,
  category_id int(10) unsigned DEFAULT '0' NOT NULL,
  Name varchar(255) DEFAULT '' NOT NULL,
  Descr text DEFAULT '' NOT NULL,
  Tax_Class int(11),
  Brand varchar(255) DEFAULT '' NOT NULL,
  Link varchar(255) DEFAULT '' NOT NULL,
  Img_File varchar(15),
  Img_X int(11),
  Img_Y int(11),
  Text1 varchar(255) DEFAULT '' NOT NULL,
  Text2 varchar(255) DEFAULT '' NOT NULL,
  Text3 varchar(255) DEFAULT '' NOT NULL,
  Text4 varchar(255) DEFAULT '' NOT NULL,
  Text5 varchar(255) DEFAULT '' NOT NULL,
  Text6 varchar(255) DEFAULT '' NOT NULL,
  select1 tinyint(3) unsigned DEFAULT '0' NOT NULL,
  select2 tinyint(3) unsigned DEFAULT '0' NOT NULL,
  select3 tinyint(3) unsigned DEFAULT '0' NOT NULL,
  select4 tinyint(3) unsigned DEFAULT '0' NOT NULL,
  Changed timestamp(14),
  Created timestamp(14),
  PRIMARY KEY (product_id),
  KEY GroupID (category_id),
  KEY shop_id (shop_id,Text1),
  KEY Name (Name,Descr(1))

It has somehow been corrupted and I'm not able to repair it:

bsdbox# myisamchk -r Product.MYI
- recovering MyISAM-table 'Product.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
myisamchk: error: Can`t use repair_by_sort with FULLTEXT key
myisamchk: error: 9 when closing MyISAM-table 'Product.MYI'

bsdbox# myisamchk -o Product.MYI
- recovering MyISAM-table 'Product.MYI'
Data records: 0
Segmentation fault (core dumped)
bsdbox# rm Product.TMD

bsdbox# myisamchk -r -k 0 Product.MYI
- recovering MyISAM-table 'Product.MYI'
Data records: 0
Segmentation fault (core dumped)

How can I get rid of the FULLTEXT index so I can repair the table?
none known execpt restoring from backup

>Submitter-Id:	<submitter ID>
>Originator:	Martin Nilsson
>Organization:  Filex AB
>MySQL support: [none]
>Synopsis:	<myisamcheck failure on FULLTEXT>
>Category:	mysql
>Release:	mysql-3.23.24-beta (Source distribution)
>Server: /usr/local/bin/mysqladmin  Ver 8.8 Distrib 3.23.24-beta, for
> unknown-freebsdelf3.5 on i386
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.24-beta-log
Protocol version	10
Connection		Localhost via UNIX socket
UNIX socket		/tmp/mysql.sock
Uptime:			1 hour 4 min 38 sec

Threads: 8  Questions: 69  Slow queries: 0  Opens: 12  Flush tables: 1  Open tables: 8
Queries per second avg: 0.018
System: FreeBSD 3.5-STABLE FreeBSD 3.5-STABLE #0: Mon Aug 28 09:20:12 CEST
2000     root@stripped:/usr/src/sys/compile/SERVER  i386

Some paths:  /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: gcc version
Compilation info: CC='gcc'  CFLAGS=''  CXX='c++'  CXXFLAGS=''  LDFLAGS=''
-r--r--r--  1 root  wheel  1052884 28 Aug 09:07 /usr/lib/libc.a
lrwxr-xr-x  1 root  wheel  9 28 Aug 09:07 /usr/lib/ ->
-r--r--r--  1 root  wheel  521297 28 Aug 09:07 /usr/lib/
Configure command: ./configure  --enable-assembler --without-debug
Perl: This is perl, version 5.005_03 built for i386-freebsd
myisamchk can't repair tablemartin19 Sep