mysqld got signal 11 bug under FreeBSD 4.6 (using 4.0.3 binary)
am 12.09.2002 20:13:36 von Noor Dawod>Description:
After downloading and installing MySQL 4.0.3, I've downloaded and
installed Apache, mod_ssl and PHP, all latest versions. I particularly
made sure that PHP is linked against MySQL's new libraries in order to
use the new structures.
Then I set up php.ini file and httpd.conf. I also set up my.cnf to be
used by the new MySQL 4.0.3 that I've just installed. Next, was firing
mysqld_safe, which in turn start mysqld wonderfully. I turned off InnoDB
in my.cnf, so no InnoDB was used. Furthermore, I fired Apache and it
worked like a charm.
I tried then to access PHP's phpinfo() page, and it worked nicely. I
could see all the details of the newly compiled Apache, PHP and mod_ssl.
I then tried to access a Web application that I've written using PHP. At
first, all seemed wonderful and working, but then slowly I could see
sudden 'signal 11' errors in the error log of MySQL.
I tried tracing the query line that causes the problem, and I believe
that I've done so! A dump file with the query that causes a 'signal 11'
will be included in this bug report.
>How-To-Repeat:
To repeat the error, create a new DB and then import the following
tables and its corresponding data into it:
CREATE TABLE CrashDatabase;
USE CrashDatabase;
DROP TABLE IF EXISTS ArticleDescription;
CREATE TABLE ArticleDescription (
DescID bigint(20) unsigned NOT NULL auto_increment,
AID varchar(32) NOT NULL default '',
SortOrder smallint(5) unsigned NOT NULL default '0',
Title varchar(255) NOT NULL default '',
TitleColor varchar(6) NOT NULL default '',
Promo varchar(255) NOT NULL default '',
PromoColor varchar(6) NOT NULL default '',
Text longtext NOT NULL,
HotLinks varchar(50) default NULL,
Direction enum('Left','Right','Center') default NULL,
Justify enum('Y','N') NOT NULL default 'N',
AllowHTML enum('Y','N') NOT NULL default 'N',
ImageRef int(10) unsigned NOT NULL default '0',
Placement enum('Left','Right','Top','Bottom','Center') NOT NULL
default 'Right',
Anchor varchar(128) NOT NULL default '',
Target varchar(16) NOT NULL default '_blank',
URL varchar(128) NOT NULL default '',
PRIMARY KEY (DescID),
KEY SortOrder (SortOrder),
KEY Title (Title),
KEY Anchor (Anchor),
KEY AID (AID),
KEY Promo (Promo),
FULLTEXT KEY Text (Text)
) TYPE=MyISAM;
INSERT INTO ArticleDescription VALUES
(1, 'dea9c1741c15e82a7d298b05a0390441', 0, '', '', '', '', '', NULL,
NULL, 'N', 'N', 0, 'Right', '', '_blank', ''),
(2, 'dea9c1741c15e82a7d298b05a0390441', 1, 'Contact', '', '', '', 'Susan
McBurney\r\n(xxx) xxx-xxxx', NULL, 'Left', 'N', 'N', 0, 'Top', '',
'_blank', ''),
(3, 'dea9c1741c15e82a7d298b05a0390441', 2, 'Anaheim, CA. - July 31,
2001', '', '', '', 'For the 85% of teenagers with acne, as well as the
many adults who struggle with recurring outbreaks of acne lesions,
treatment can be as tedious and disappointing as the disease. But a new
photothermal technology currently being studied offers hope for a fast,
safe and effective approach to coping with acne and avoiding the
scarring associated with severe forms of the prevalent skin disease.
\r\n\r\nSpeaking yesterday at an educational session on lasers at the
American Academy of Dermatology meeting in Anaheim, California, Paul
Yamauchi, MD, PhD, discussed the enhanced green light wavelength behind
the platform technology used in the ClearTouchTM. Designed as a
light unit assembly upgrade kit for the SpaTouchTM PhotoEpilation
System, ClearTouch allows physicians to successfully treat acne on all
parts of the body, including the sensitive face area, without
significant side effects or patient downtime. \r\n\r\nReporting on
clinical study data of his international colleagues, Dr. Yamauchi noted
that nearly 100 patients worldwide have been treated with the ClearTouch
upgrade kit since it was first introduced outside the United States six
months ago. \r\n\r\n"Patients achieved acne clearance after only eight
treatments administered over four weeks," stated Dr. Yamauchi, a
dermatologist with Clinical Research Specialists in Santa Monica,
California. "Patients observed dramatic, visible improvement after only
one week of photothermal acne therapy, encouraging even the typically
non-compliant teenagers to continue their treatment."
\r\n\r\nTraditional acne remedies such as topical medications,
prescription creams and oral antibiotics carry potential side effects
and often require several weeks before patients begin to see signs of
improvement. Also, dermatologists are finding that over time the
bacteria that cause acne are becoming resistant to treatment with
certain antibiotics. \r\n\r\n"The ClearTouch upgrade kit represents
a new application for our SpaTouch platform technology, extending its
hair removal capabilities to an acne clearance system with just a snap
of a new light unit assembly," says Zion Azar, PhD, who invented the
flagship\'s innovative "laptop" design and proprietary technology.
"SpaTouch has long been recognized as one of the most affordable,
high-tech aesthetic solutions; now it is one of the most therapeutic
devices in the medical marketplace." Nearly 1,000 SpaTouch
PhotoEpilation Systems are currently in use worldwide. \r\n\r\nThe
ClearTouch acne clearance kit is not available for sale in the U.S. and
is marketed outside the U.S. by Comrax Ltd. \r\n\r\nEstablished in 1998,
Comrax is devoted to the development of unique medical and aesthetic
products employing proprietary, innovative light technology. Comrax\'s
Research and Development is based in the Rehovot Science Park in Israel
where its team works in close cooperation with medical practitioners in
a variety of specialties. Comrax\'s worldwide corporate headquarters is
located in Orangeburg, New York. \r\n\r\nFor more information, please
visit the Company\'s web site at www.comrax.com ', '2', 'Left', 'N',
'N', 0, 'Top', '', '_blank', '');
DROP TABLE IF EXISTS Articles;
CREATE TABLE Articles (
ArticleID bigint(20) unsigned NOT NULL auto_increment,
VortalCode varchar(20) NOT NULL default '',
AID varchar(32) NOT NULL default '',
Username varchar(12) NOT NULL default '',
Title varchar(255) NOT NULL default '',
Direction enum('Left','Right','Center') default NULL,
Justify enum('Y','N') NOT NULL default 'N',
SecondaryTitle text NOT NULL,
Text text NOT NULL,
HotLinks varchar(50) default NULL,
ThumbnailRef bigint(20) unsigned NOT NULL default '0',
ImageRef bigint(20) unsigned NOT NULL default '0',
URL varchar(128) NOT NULL default '',
Anchor varchar(128) NOT NULL default '',
Target varchar(16) NOT NULL default '_blank',
TTL smallint(5) unsigned NOT NULL default '0',
DateInserted datetime NOT NULL default '0000-00-00 00:00:00',
LastUpdate timestamp(14) NOT NULL,
Active enum('Y','N') NOT NULL default 'Y',
PRIMARY KEY (ArticleID),
UNIQUE KEY AID (AID),
KEY Username (Username),
KEY Title (Title),
KEY Anchor (Anchor),
KEY TTL (TTL),
KEY DateInserted (DateInserted),
KEY LastUpdate (LastUpdate),
KEY Active (Active),
FULLTEXT KEY SecondaryTitle (SecondaryTitle),
FULLTEXT KEY Text (Text),
KEY VortalCode (VortalCode)
) TYPE=MyISAM;
INSERT INTO Articles VALUES (1, 'comrax',
'dea9c1741c15e82a7d298b05a0390441', 'blah', 'Comrax Test Article',
'Left', 'N', '', '(July 31, 2001)', NULL, 28, 0, '', 'Full article...',
'_top', 0, '2002-09-05 12:40:07', 20020911225150, 'Y');
DROP TABLE IF EXISTS Departments;
CREATE TABLE Departments (
DeptID bigint(20) unsigned NOT NULL auto_increment,
ParentID bigint(20) unsigned NOT NULL default '0',
VortalCode char(20) NOT NULL default '',
DeptName char(40) NOT NULL default '',
SortOrder smallint(5) unsigned NOT NULL default '1',
LastUpdate timestamp(14) NOT NULL,
Active enum('Y','N') NOT NULL default 'Y',
PRIMARY KEY (DeptID),
KEY ParentID (ParentID),
KEY Active (Active),
KEY DeptName (DeptName),
KEY SortOrder (SortOrder),
KEY VortalCode (VortalCode)
) TYPE=MyISAM;
INSERT INTO Departments VALUES (1, 0, 'comrax', 'About Comrax', 1,
20020829183843, 'Y'),
(2, 1, 'comrax', 'Corporate Profile', 1, 20020829183855, 'Y'),
(3, 1, 'comrax', 'Contact Us', 1, 20020829183901, 'Y'),
(4, 1, 'comrax', 'Careers at Comrax', 1, 20020829183906, 'Y'),
(5, 0, 'comrax', 'News Room', 1, 20020829183918, 'Y'),
(6, 5, 'comrax', 'Press Releases', 1, 20020829183934, 'Y'),
(7, 5, 'comrax', 'In the News', 1, 20020829183939, 'Y'),
(8, 0, 'comrax', 'Products', 1, 20020829183947, 'Y'),
(9, 0, 'comrax', 'Clinical Applications', 1, 20020829184233, 'Y'),
(10, 8, 'comrax', 'SkinStation', 1, 20020829184012, 'Y'),
(11, 8, 'comrax', 'SPR', 1, 20020829184019, 'Y'),
(12, 8, 'comrax', 'ClearTouch', 1, 20020829184024, 'Y'),
(13, 8, 'comrax', 'XtremeClear', 1, 20020829184030, 'Y'),
(14, 8, 'comrax', 'SpaTouch', 1, 20020829184036, 'Y'),
(15, 9, 'comrax', 'LHE Technology', 1, 20020829184241, 'Y'),
(16, 9, 'comrax', 'Hair Removal', 1, 20020829184250, 'Y'),
(17, 9, 'comrax', 'Acne Phototherapy', 1, 20020829184256, 'Y'),
(18, 9, 'comrax', 'Skin Photorejuvenation', 1, 20020829184301, 'Y'),
(19, 0, 'comrax', 'Professionals', 1, 20020829184316, 'Y'),
(20, 19, 'comrax', 'Overview', 1, 20020829184326, 'Y'),
(21, 19, 'comrax', 'FAQ', 1, 20020829184333, 'Y'),
(22, 19, 'comrax', 'Clinical Studies', 1, 20020829184340, 'Y'),
(23, 19, 'comrax', 'Before and After', 1, 20020909160640, 'Y'),
(25, 19, 'comrax', 'Events and Workshops', 1, 20020829184403, 'Y'),
(26, 0, 'comrax', 'Consumers', 1, 20020829184412, 'Y'),
(27, 26, 'comrax', 'Overview', 1, 20020829184423, 'Y'),
(28, 26, 'comrax', 'FAQ', 1, 20020829184428, 'Y'),
(29, 26, 'comrax', 'Before and After', 1, 20020829184621, 'Y'),
(40, 36, 'comrax', 'Privacy Policy', 1, 20020909161217, 'Y'),
(31, 26, 'comrax', 'Useful Links', 1, 20020829184740, 'Y'),
(32, 0, 'comrax', 'Support', 1, 20020829184752, 'Y'),
(33, 32, 'comrax', 'Clinical', 1, 20020829184803, 'Y'),
(34, 32, 'comrax', 'Technical', 1, 20020829184809, 'Y'),
(35, 32, 'comrax', 'Marketing', 1, 20020829184815, 'Y'),
(36, 0, 'comrax', 'comrax', 1, 20020910172547, 'Y'),
(37, 36, 'comrax', 'Legal Notice', 1, 20020904111701, 'Y'),
(38, 36, 'comrax', 'Contact Us', 1, 20020904111716, 'Y'),
(39, 36, 'comrax', 'Thank You', 1, 20020909120747, 'Y');
DROP TABLE IF EXISTS DepartmentArticles;
CREATE TABLE DepartmentArticles (
DeptID bigint(20) unsigned NOT NULL default '0',
AID char(32) NOT NULL default '',
SortOrder bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (DeptID,AID),
KEY SortOrder (SortOrder),
KEY SortOrder_2 (SortOrder)
) TYPE=MyISAM;
INSERT INTO DepartmentArticles VALUES
(17, 'f445edc5a571dd6466ef1fe747d17909', 1),
(1, 'db3225a902746e34fdacede27542c6c4', 1),
(2, 'db3225a902746e34fdacede27542c6c4', 1),
(16, '03c0e2b38f15b4d833e86c99d85279a1', 1),
(6, '22e1c76bf4d04e43a0558902f0fb05b1', 1),
(6, '93e6feb1ec41a8a82e188c6f2b42d538', 2),
(6, 'dea9c1741c15e82a7d298b05a0390441', 3),
(6, '1938f80a4d2eb541c0b61d610f2f7417', 4),
(6, '962c1b23293d5b88297cb5216ab1fdf2', 7),
(6, 'c27bd0bbd7e59c489edce90c5fcfd3fe', 8),
(6, '1b9782520c9d4e17d1747e702b9560ef', 5),
(6, 'fa3a1a06807f5f162900fe416cfb3e8c', 6),
(38, 'f908519d34ef49eda3b853cc343534f8', 1),
(37, 'cc8ec480d1e3eb53edb708546dc10521', 1),
(40, 'eefa614c6f35df0095e0fcb618fb369a', 1),
(15, '1ceab5884ecce5bdf8153b96ea80a379', 1),
(4, '9ef7a1003993a107fb1f4db7e0de7a21', 1),
(3, 'f908519d34ef49eda3b853cc343534f8', 1),
(12, 'db6f7584e3a1e137d38e6f66ffa25c93', 1),
(14, '346eacecfaf45e7d6c66c80672c2d5b5', 1),
(25, 'e297977293991bd0922b442e108cfcab', 1),
(7, '49f5f5c98eeb05608a4d42e344f9ca07', 1),
(7, 'e88646556b4ce5bba29519a5834c3bfe', 2),
(7, '40835dee60be7ba0c93310669377baa9', 3),
(7, 'e57bcb427f765cf0e831de8dd77a8850', 4),
(39, '8165afb98db45e07fbb63ab2284d7d5b', 1),
(23, '56ca8dfb70e962aff9cf06737e0afe6a', 1),
(29, '56ca8dfb70e962aff9cf06737e0afe6a', 1),
(27, 'dc999ee013438069eeeec76bd1a6195b', 1),
(18, '8079ad0c0e3ac3250a1f817024d6eccc', 1);
If the above dump worked, then you'll have a new database called
'CrashDatabase'. Use the command-line 'mysql' utility to access this
database, then try issuing the following query:
Select Distinct
DepartmentArticles.AID,Articles.*,Unix_TimeStamp(Articles.Da teInserted)
As UnixDateInserted,Unix_TimeStamp(Articles.LastUpdate) As
UnixLastUpdate From Departments,DepartmentArticles,Articles Where
(Articles.Active='Y' And DepartmentArticles.AID=Articles.AID And
Departments.DeptID=DepartmentArticles.DeptID) Order BY
DepartmentArticles.SortOrder DESC;
In my server, issuing this query will produce the following 'signal 11'
error message in the error log:
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this
binary
or one of the libraries it was linked against is corrupt, improperly
built,
or misconfigured. This error can also be caused by malfunctioning
hardware.
We will try our best to scrape up some info that will hopefully help
diagnose
the problem, but since we have already crashed, something is definitely
wrong
and this may fail.
key_buffer_size=16773120
read_buffer_size=131072
sort_buffer_size=524280
max_used_connections=0
max_connections=100
threads_connected=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections
= 80379 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
020912 19:08:36 mysqld restarted
/disk3/usr/mysql-4.0.3-beta-unknown-freebsdelf4.6.2-i386/bin /mysqld:
ready for connections
my.cnf contents are as follows:
[client]
#password = your_password
port = 3307
socket = /disk3/usr/mysql/data/mysql.socket
# The MySQL server
[mysqld]
log
user = mysql4
port = 3307
socket = /disk3/usr/mysql/data/mysql.socket
basedir = /disk3/usr/mysql/
datadir = /disk3/usr/mysql/data/
skip-locking
skip-innodb
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = table_cache=64
set-variable = sort_buffer=512K
set-variable = net_buffer_length=8K
set-variable = myisam_sort_buffer_size=8M
log-bin
server-id = 1
# Point the following paths to different dedicated disks
tmpdir = /disk3/usr/mysql/data/tmp/
#log-update = /path-to-dedicated-directory/hostname
# Uncomment the following if you are using BDB tables
#set-variable = bdb_cache_size=4M
#set-variable = bdb_max_lock=10000
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /usr/local/mysql/var/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /usr/local/mysql/var/
#innodb_log_arch_dir = /usr/local/mysql/var/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#set-variable = innodb_buffer_pool_size=16M
#set-variable = innodb_additional_mem_pool_size=2M
# Set .._log_file_size to 25 % of buffer pool size
#set-variable = innodb_log_file_size=5M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#set-variable = innodb_lock_wait_timeout=50
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[mysqlhotcopy]
interactive-timeout
>Fix:
No fix is currently known.
>Submitter-Id: noor@comrax.com
>Originator: Noor Dawod
>Organization:
COMRAX Ltd.
Matam Advanced Technology Center
Haifa 31905, Israel
>MySQL support: none
>Synopsis: MySQL 4.0.3 crashes with a 'signal 11' under FreeBSD 4.6
>Severity: critical
>Priority: high
>Category: mysql
>Class:
>Release: mysql-4.0.3-beta (Official MySQL binary)
>Environment:
System: FreeBSD fw.comrax.com 4.6-STABLE FreeBSD 4.6-STABLE #1: Sun Jun
23 10:02:42 IDT 2002
root@fw.comrax.com:/disk2/FreeBSD/obj/disk2/FreeBSD/src/sys/ FIREWALL
i386
Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake
/usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.3 20010315 (release) [FreeBSD]
Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer'
CXX='gcc'
CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptio
ns -fno-rtti' LDFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1222264 Jun 23 10:11 /usr/lib/libc.a
lrwxr-xr-x 1 root wheel 9 Jun 23 10:11 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 520468 Feb 6 2000 /usr/lib/libc.so.3
-r--r--r-- 1 root wheel 579444 Jun 23 10:11 /usr/lib/libc.so.4
Configure command: ./configure --prefix=/usr/local/mysql
'--with-comment=Official MySQL
binary' --with-extra-charsets=complex --with-server-suffix= --enable-thr
ead-safe-client --enable-local-infile --enable-assembler --with-named-z-
libs=not-used --disable-shared 'CFLAGS=-O3 -fno-omit-frame-pointer'
CXX=gcc CC=gcc
'CXXFLAGS=-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptio
ns -fno-rtti'
Perl: This is perl, version 5.005_03 built for i386-freebsd
------------------------------------------------------------ ---------
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 bugs-thread12537@lists.mysql.com
To unsubscribe, e-mail