>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 <b>ClearTouchTM</b>. 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.DateInserted) 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: [EMAIL PROTECTED]
>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 [EMAIL PROTECTED]:/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-exceptions -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-thread-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-exceptions -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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
