>Description:
I have an instance of MySQL v.4.0.1 Max with 11 children spawned running on
a Linux (RedHat 7.0 guiness, 2.2.16-22) personal laptop (Dell Inspiron 5000e)
and when I do a simple update on a table that is Full Text enabled, MySQL
and all its children crash.
I have absolutly no clue why it does that. I never had any problem before.
>How-To-Repeat:
Create the following table:
CREATE TABLE pmn_archive (
oid INT UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT,
mesg_id VARCHAR(255) NOT NULL,
subject VARCHAR(255),
sender VARCHAR(255),
email VARCHAR(255),
mdate DATETIME,
reference VARCHAR(255) NOT NULL,
idx INT DEFAULT '1' NOT NULL,
header TEXT,
url VARCHAR(255),
title VARCHAR(255),
description TEXT,
data TEXT,
size INT,
since DATETIME,
last DATETIME,
FULLTEXT(url,title,description,data,sender,email),
status for thread purpose
UNIQUE(mesg_id),
PRIMARY KEY(oid)
);
Add the following data:
INSERT IGNORE INTO pmn_archive
(mdate,reference,subject,idx,since,header,last,mesg_id,email,sender)
VALUES(FROM_UNIXTIME(819511140),'','Simple message
test','1',FROM_UNIXTIME(1025153882),'Return-Path: <[EMAIL PROTECTED]>
Date: Wed, 20 Dec 95 19:59 CST
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc:
Subject: Simple message test
',FROM_UNIXTIME(1025153882),'tgGtI1MTTcZTKycABjwMBg','[EMAIL PROTECTED]','[EMAIL PROTECTED]
');
The, do the following update:
UPDATE
pmn_archive
SET
data='This is a dummy test for a very simple message This drive scripts are located
in dev List Email Message Shoudl their be any problems pls do hesitate to contact me
Thanks Moi je pense ca Oui mais je ne suis pas d accord Ah Bah dommage M enfin
pourquoi tant de haine Mon titre est M E D I A S N E W S M E D I A S C O M Mon url est
http cgi deguest jp u medias mailing list jp et LA JE GUEULE Best Regards Jacques
Deguest jack deguest jp ',
description='This dummy test for very simple message. This drive scripts are located
~/dev/List/Email/Message Shoudl their any problems, pls, hesitate contact ;-) Thanks,
Moi, pense Oui,',
url='/1995-12-21-.html',
last=FROM_UNIXTIME(819511140),
title='Simple message test
',
size='582'
WHERE oid='1'
If I do a ps auxwww I get:
sh /usr/bin/mysqld_safe --user=mysql --log=/var/log/mysqld.log
--pid-file=/var/run/mysqld.pid
mysql 27857 0.0 4.5 49908 17624 pts/19 S 17:57 0:00 /usr/sbin/mysqld-max
--basedir=/usr --datadir=/u/serv/mysql --user=mysql --pid-file=/var/run/mysqld.pid
--skip-locking --log=/var/log/mysqld.log
mysql 27859 0.0 4.5 49908 17624 pts/19 S 17:57 0:00 /usr/sbin/mysqld-max
--basedir=/usr --datadir=/u/serv/mysql --user=mysql --pid-file=/var/run/mysqld.pid
--skip-locking --log=/var/log/mysqld.log
mysql 27860 0.0 4.5 49908 17624 pts/19 S 17:57 0:00 /usr/sbin/mysqld-max
--basedir=/usr --datadir=/u/serv/mysql --user=mysql --pid-file=/var/run/mysqld.pid
--skip-locking --log=/var/log/mysqld.log
mysql 27861 0.0 4.5 49908 17624 pts/19 S 17:57 0:00 /usr/sbin/mysqld-max
--basedir=/usr --datadir=/u/serv/mysql --user=mysql --pid-file=/var/run/mysqld.pid
--skip-locking --log=/var/log/mysqld.log
mysql 27862 0.0 4.5 49908 17624 pts/19 S 17:57 0:00 /usr/sbin/mysqld-max
--basedir=/usr --datadir=/u/serv/mysql --user=mysql --pid-file=/var/run/mysqld.pid
--skip-locking --log=/var/log/mysqld.log
mysql 27863 0.0 4.5 49908 17624 pts/19 S 17:57 0:00 /usr/sbin/mysqld-max
--basedir=/usr --datadir=/u/serv/mysql --user=mysql --pid-file=/var/run/mysqld.pid
--skip-locking --log=/var/log/mysqld.log
mysql 27864 0.0 4.5 49908 17624 pts/19 S 17:57 0:00 /usr/sbin/mysqld-max
--basedir=/usr --datadir=/u/serv/mysql --user=mysql --pid-file=/var/run/mysqld.pid
--skip-locking --log=/var/log/mysqld.log
mysql 27865 0.0 4.5 49908 17624 pts/19 S 17:57 0:00 /usr/sbin/mysqld-max
--basedir=/usr --datadir=/u/serv/mysql --user=mysql --pid-file=/var/run/mysqld.pid
--skip-locking --log=/var/log/mysqld.log
mysql 27866 0.0 4.5 49908 17624 pts/19 S 17:57 0:00 /usr/sbin/mysqld-max
--basedir=/usr --datadir=/u/serv/mysql --user=mysql --pid-file=/var/run/mysqld.pid
--skip-locking --log=/var/log/mysqld.log
mysql 27867 0.0 4.5 49908 17624 pts/19 S 17:57 0:00 /usr/sbin/mysqld-max
--basedir=/usr --datadir=/u/serv/mysql --user=mysql --pid-file=/var/run/mysqld.pid
--skip-locking --log=/var/log/mysqld.log
mysql 27868 0.0 4.5 49908 17624 pts/19 S 17:57 0:00 /usr/sbin/mysqld-max
--basedir=/usr --datadir=/u/serv/mysql --user=mysql --pid-file=/var/run/mysqld.pid
--skip-locking --log=/var/log/mysqld.log
mysql 27883 0.0 4.5 49908 17624 pts/19 S 18:00 0:00 /usr/sbin/mysqld-max
--basedir=/usr --datadir=/u/serv/mysql --user=mysql --pid-file=/var/run/mysqld.pid
--skip-locking --log=/var/log/mysqld.log
Once I run the query, such as:
mysql -uuser -ppassword -A < script.sql
All the instance of MySQL die.
>Fix:
I have no clue whatsoever.
>Submitter-Id: <submitter ID>
>Originator: Jacques Deguest <[EMAIL PROTECTED]>
>Organization:
CYPANGO
>MySQL support: none
>Synopsis: <MySQL crash on update of Full Text enabled table>
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mysql-4.0.1-alpha-max (Official MySQL-max binary)
>Environment:
System: Linux azarias.paris.deguest.net 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='-O3 -mpentium ' CXX='gcc' CXXFLAGS='-O3
-mpentium -felide-constructors' LDFLAGS='-static'
LIBC:
lrwxrwxrwx 1 root root 14 Dec 23 2000 /lib/libc.so.6 ->
libc-2.1.92.so
-rwxr-xr-x 1 root root 4776568 Aug 31 2000 /lib/libc-2.1.92.so
-rw-r--r-- 1 root root 22607104 Aug 31 2000 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Aug 31 2000 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr '--with-comment=Official MySQL-max
binary' --with-extra-charsets=complex --with-server-suffix=-max
--enable-thread-safe-client --enable-assembler --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --disable-shared --with-berkeley-db --with-innodb
---------------------------------------------------------------------
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
