>Description:
When doing the following update I get a table crash.
>How-To-Repeat:
CREATE TABLE tester (
id int(11) auto_increment,
title varchar(100) default '',
PRIMARY KEY (id),
#If you comment out the following index, then the table is briefly marked as crashed
# but appears to recover although the update does not succeed
KEY ind5 (title),
#The fulltext index appears to be the root of this prob.
FULLTEXT KEY FT1 (title)
) TYPE=MyISAM;
insert into tester (title) values ('this is a test');
update tester set title='this is A test' where id=1;
check table tester;
>Fix:
No known workaround. Please advise if you are aware of one. Thanks.
>Submitter-Id: <submitter ID>
>Originator: Mark Maunder
>Organization:
SwiftCamel Software LTD
>MySQL support: none
>Synopsis: Table crash when doing update of record with fulltext index.
>Severity: critical
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-4.0.0-alpha (Source distribution)
>Server: /usr/bin/mysqladmin Ver 8.22 Distrib 4.0.0-alpha, for pc-linux-gnu on i686
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 4.0.0-alpha-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 8 hours 3 min 52 sec
Threads: 32 Questions: 18198 Slow queries: 295 Opens: 33 Flush tables: 1 Open
tables: 12 Queries per second avg: 0.627
>Environment:
System: Linux mark.swiftcamel.com 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 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/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.1 2.96-81)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Jul 28 17:24 /lib/libc.so.6 -> libc-2.2.2.so
-rwxr-xr-x 2 root root 1236396 Apr 6 2001 /lib/libc-2.2.2.so
-rw-r--r-- 1 root root 26350254 Apr 6 2001 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Apr 6 2001 /usr/lib/libc.so
lrwxrwxrwx 1 root root 10 Jul 28 17:44 /usr/lib/libc-client.a ->
c-client.a
Configure command: ./configure --prefix=/usr/local/mysql4
--localstatedir=/usr/local/mysql4/data
---------------------------------------------------------------------
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
