Re: MySQL 4.0.1 crashes when updating a field with fulltext index
Mike Wexler writes: Description: mysql crashes with the following stack trace: 0x807db7f handle_segfault__Fi + 383 0x823d60a pthread_sighandler + 154 0x8204407 _mi_compare_text + 71 0x821bb96 _mi_ft_cmp + 158 0x820bb01 mi_update + 721 0x80d07ef update_row__9ha_myisamPCcPc + 67 0x80b0439 mysql_update__FP3THDP13st_table_listRt4List1Z4ItemT2P4ItemP8st_orderUl15enum_duplicates13thr_lock_type + 2473 0x8086da7 mysql_execute_command__Fv + 5723 0x808a222 mysql_parse__FP3THDPcUi + 270 0x8084e17 dispatch_command__F19enum_server_commandP3THDPcUi + 1319 0x808a654 do_command__FP3THD + 88 0x8084256 handle_one_connection__FPv + 546 When executing: UPDATE test.user SET realname='bar' WHERE userid='312362' Hi! I have tested your case and it worked just fine in 4.0.2. This was a bug that was reported few weeks ago and fixed meanwhile. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.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
Re: MySQL 4.0.1 crashes when updating a field with fulltext index
Thanks. When is 4.0.2 due? I reported it (in less detail) 2 weeks ago, but didn't here anything back. So I created a test case, etc. Sinisa Milivojevic wrote: Mike Wexler writes: Description: mysql crashes with the following stack trace: 0x807db7f handle_segfault__Fi + 383 0x823d60a pthread_sighandler + 154 0x8204407 _mi_compare_text + 71 0x821bb96 _mi_ft_cmp + 158 0x820bb01 mi_update + 721 0x80d07ef update_row__9ha_myisamPCcPc + 67 0x80b0439 mysql_update__FP3THDP13st_table_listRt4List1Z4ItemT2P4ItemP8st_orderUl15enum_duplicates13thr_lock_type + 2473 0x8086da7 mysql_execute_command__Fv + 5723 0x808a222 mysql_parse__FP3THDPcUi + 270 0x8084e17 dispatch_command__F19enum_server_commandP3THDPcUi + 1319 0x808a654 do_command__FP3THD + 88 0x8084256 handle_one_connection__FPv + 546 When executing: UPDATE test.user SET realname='bar' WHERE userid='312362' Hi! I have tested your case and it worked just fine in 4.0.2. This was a bug that was reported few weeks ago and fixed meanwhile. - 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: MySQL 4.0.1 crashes when updating a field with fulltext index
Mike Wexler writes: Thanks. When is 4.0.2 due? I reported it (in less detail) 2 weeks ago, but didn't here anything back. So I created a test case, etc. Should be soon. We have few more features to finish and test. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.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
Re: MySQL 4.0.1 crashes when updating a field with fulltext index
Which features are planned, but not implemented for 4.0.2? I assume they are featured either listed at http://www.mysql.com/doc/N/u/Nutshell_Future_features.html or are very small features, right? When are the new, text .frm files going to be introduced? Sinisa Milivojevic wrote: Mike Wexler writes: Thanks. When is 4.0.2 due? I reported it (in less detail) 2 weeks ago, but didn't here anything back. So I created a test case, etc. Should be soon. We have few more features to finish and test. - 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
MySQL 4.0.1 crashes when updating a field with fulltext index
Description:
mysql crashes with the following stack trace:
0x807db7f handle_segfault__Fi + 383
0x823d60a pthread_sighandler + 154
0x8204407 _mi_compare_text + 71
0x821bb96 _mi_ft_cmp + 158
0x820bb01 mi_update + 721
0x80d07ef update_row__9ha_myisamPCcPc + 67
0x80b0439
mysql_update__FP3THDP13st_table_listRt4List1Z4ItemT2P4ItemP8st_orderUl15enum_duplicates13thr_lock_type
+ 2473
0x8086da7 mysql_execute_command__Fv + 5723
0x808a222 mysql_parse__FP3THDPcUi + 270
0x8084e17 dispatch_command__F19enum_server_commandP3THDPcUi +
1319
0x808a654 do_command__FP3THD + 88
0x8084256 handle_one_connection__FPv + 546
When executing:
UPDATE test.user SET realname='bar' WHERE userid='312362'
Note that test.user has a fulltext index and realname is a field that
is part of the fulltext index.
How-To-Repeat:
Create the following table in database test:
-- MySQL dump 8.19
--
-- Host: utility1Database: tums
-
-- Server version 4.0.1-alpha-log
--
-- Table structure for table 'user'
--
DROP TABLE IF EXISTS user;
CREATE TABLE user (
userid int(10) unsigned NOT NULL auto_increment,
name varchar(64) NOT NULL default '',
passwd varchar(64) default NULL,
email varchar(64) NOT NULL default '',
active enum('Y','N') default 'Y',
homedir varchar(64) default NULL,
pwtype int(10) unsigned NOT NULL default '0',
realname varchar(64) default NULL,
address varchar(128) default NULL,
city varchar(64) default NULL,
state varchar(32) default NULL,
zip varchar(16) default NULL,
country varchar(16) default NULL,
homePhone varchar(20) default NULL,
workPhone varchar(20) default NULL,
pastOrders tinyint(1) default '0',
uid smallint(2) unsigned default NULL,
gid smallint(2) unsigned default NULL,
shell varchar(64) default NULL,
address2 text,
PRIMARY KEY (userid),
UNIQUE KEY email (email),
UNIQUE KEY uniqueName (name),
KEY name (name),
FULLTEXT KEY realname (realname,email,name),
KEY realname_2 (realname)
) TYPE=MyISAM PACK_KEYS=1;
/*!4 ALTER TABLE user DISABLE KEYS */;
--
-- Dumping data for table 'user'
--
LOCK TABLES user WRITE;
INSERT INTO user VALUES
(312362,'[EMAIL PROTECTED]','xxwnyPLtjWEg6','[EMAIL PROTECTED]','Y','',1,NULL,'PO Box
243','Topock','AZ','86436','US',NULL,NULL,0,NULL,NULL,NULL,NULL);
/*!4 ALTER TABLE user ENABLE KEYS */;
UNLOCK TABLES;
execute
UPDATE test.user SET realname='bar' WHERE userid='312362'
and watch mysql crash.
Fix:
Submitter-Id: submitter ID
Originator:Mike Wexler
Organization:
MySQL support: licence
Synopsis: 4.01 crashes when updating field in fulltext index
Severity: critical
Priority: high
Category: mysql
Class: sw-bug
Release: mysql-4.0.1-alpha (Official MySQL RPM)
Environment:
System: Linux noritake.tias.com 2.4.2-2smp #1 SMP Sun Apr 8 20:21:34 EDT 2001 i686
unknown
Architecture: i686
Some paths: /usr/bin/mh/perl /usr/bin/mh/make /usr/bin/mh/gmake /usr/bin/mh/gcc
/usr/bin/mh/cc
GCC: Reading specs from /usr/bin/mh/../lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-85)
Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc'
CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors
-fno-exceptions -fno-rtti -mpentium' LDFLAGS=''
LIBC:
lrwxrwxrwx1 root root 13 Jan 29 16:56 /lib/libc.so.6 - libc-2.2.4.so
-rwxr-xr-x1 root root 5723311 Dec 8 06:04 /lib/libc-2.2.4.so
-rw-r--r--1 root root 27314296 Dec 8 06:02 /usr/lib/libc.a
-rw-r--r--1 root root 178 Dec 8 06:02 /usr/lib/libc.so
Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --without-berkeley-db --with-innodb
--enable-assembler --with-mysqld-user=mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/
--with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin
--sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql
--infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --with-embedded-server
--enable-thread-safe-client '--with-comment=Official MySQL RPM'
-
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: MySQL 4.0.1 crashes when updating a field with fulltext index
On Tuesday 29 January 2002 08:44 pm, Mike Wexler wrote: Description: mysql crashes with the following stack trace: 0x807db7f handle_segfault__Fi + 383 0x823d60a pthread_sighandler + 154 0x8204407 _mi_compare_text + 71 0x821bb96 _mi_ft_cmp + 158 0x820bb01 mi_update + 721 0x80d07ef update_row__9ha_myisamPCcPc + 67 0x80b0439 mysql_update__FP3THDP13st_table_listRt4List1Z4ItemT2P4ItemP8st_orderUl15enum_duplicates13thr_lock_type + 2473 0x8086da7 mysql_execute_command__Fv + 5723 0x808a222 mysql_parse__FP3THDPcUi + 270 0x8084e17 dispatch_command__F19enum_server_commandP3THDPcUi + 1319 0x808a654 do_command__FP3THD + 88 0x8084256 handle_one_connection__FPv + 546 Mike: Thanks for a good bug report. I have forwarded the message to Sergei - he should be contacting you shortly for more info if he needs it... -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - 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
