>Description:
Possible Bug in UPDATE in MySQL 4.0.1
The following is the message in the error log...
Number of processes running now: 0
020519 04:55:30 mysqld restarted
020519 4:55:30 InnoDB: Started
/usr/local/mysql/bin/mysqld: ready for connections
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=402649088
record_buffer=268431360
sort_buffer=268435448
max_used_connections=0
max_connections=100
threads_connected=1
It is possible that mysqld could use up to
key_buffer_size + (record_buffer + sort_buffer)*max_connections = 2489963 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Stack range sanity check OK, backtrace follows:
0x807db7f
0x823d64a
0x8204447
0x821bbd6
0x820bb41
0x80d082f
0x80b0479
0x8086de7
0x808a262
0x8084e57
0x808a694
0x8084296
Stack trace seems successful - bottom reached
Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow
instr
uctions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x8423db0 = UPDATE `Physical Examination Report` SET
`History of P
resent Illness`='moo\r\nfoo\r\nboo.' WHERE `ID Code of Appointment`=27
thd->thread_id=7
Successfully dumped variables, if you ran with --log, take a look at the
details of what thread 7 did to cause the crash. In some cases of really
bad corruption, the values shown above may be invalid.
The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains
information that should help you find out what is causing the crash.
Number of processes running now: 0
020519 05:14:17 mysqld restarted
020519 5:14:17 InnoDB: Started
/usr/local/mysql/bin/mysqld: ready for connections
>How-To-Repeat:
Did this query on a database called 'medical' below text
UPDATE `Physical Examination Report` SET `History of Present
Illness`='moo\r\nfoo\r\nboo.' WHERE `ID Code of Appointment`=27
DUMP of medical database schema:
# phpMyAdmin MySQL-Dump
# version 2.2.6
# http://phpwizard.net/phpMyAdmin/
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: May 19, 2002 at 05:50 AM
# Server version: 4.00.01
# PHP Version: 4.0.5
# Database : `medical`
# --------------------------------------------------------
#
# Table structure for table `Appointment Types`
#
CREATE TABLE Appointment Types (
ID Code int(11) NOT NULL auto_increment,
Description mediumtext NOT NULL,
PRIMARY KEY (ID Code)
) TYPE=MyISAM COMMENT='Keeps Information unique to appointment type';
# --------------------------------------------------------
#
# Table structure for table `Appointments`
#
CREATE TABLE Appointments (
ID Code int(11) NOT NULL auto_increment,
Date of Appointment date default NULL,
ID Code of Patient int(11) default NULL,
ID Code of Doctor int(11) default NULL,
ID Code of Referer int(11) default NULL,
ID Code of Second Referer int(11) default NULL,
ID Code of Third Referer int(11) default NULL,
ID Code of Fourth Referer int(11) default NULL,
Type of Appointment int(11) default NULL,
Complete int(11) default NULL,
PRIMARY KEY (ID Code)
) TYPE=MyISAM COMMENT='Keeps track of what''s involved in the
appointment';
# --------------------------------------------------------
#
# Table structure for table `Doctors`
#
CREATE TABLE Doctors (
ID Code int(11) NOT NULL auto_increment,
First Name tinytext,
Middle Name tinytext,
Last Name tinytext,
Initials tinytext,
SSN tinytext,
Business Street tinytext,
Business City tinytext,
Business State tinytext,
Business Zip Code tinytext,
Business Phone Number tinytext,
Business Fax Number tinytext,
Business Email Address tinytext,
Home Street tinytext,
Home City tinytext,
Home State tinytext,
Home Zip Code tinytext,
Home Phone Number tinytext,
Home Fax Number tinytext,
Home Email Address tinytext,
PRIMARY KEY (ID Code)
) TYPE=MyISAM COMMENT='Keeps important data concerning the physicians that
work her';
# --------------------------------------------------------
#
# Table structure for table `Follow Up Report`
#
CREATE TABLE Follow Up Report (
Report Number int(11) NOT NULL auto_increment,
ID Code of Appointment int(11) default NULL,
ID Code of Patient int(11) default NULL,
Date of Exam date default NULL,
Date of Report date default NULL,
First Name of Doctor tinytext,
Middle Name of Doctor tinytext,
Last Name of Doctor tinytext,
Initials of Doctor tinytext NOT NULL,
First Name of Referer tinytext,
Middle Name of Referer tinytext,
Last Name of Referer tinytext,
Street Address of Referer tinytext,
City of Referer tinytext,
State of Referer tinytext,
Zip Code of Referer tinytext,
First Name of Patient tinytext,
Middle Name of Patient tinytext,
Last Name of Patient tinytext,
SSN of Patient int(11) default NULL,
DOB of Patient date default NULL,
History of Present Illness text,
Constitutional Symptoms text,
Eyes text,
Ears Nose Throat text,
Cardiovascular text,
Respiratory text,
Gastrointestinal text,
Genitourinary text,
Musculoskeletal text,
Integumentary text,
Neurological text,
Endorine text,
Hematologic text,
Weight tinytext,
Height tinytext,
BMI tinytext,
BP tinytext,
Pulse tinytext,
Resp tinytext,
General PE text,
Skin PE text,
Ear Nose Throat PE text,
Eyes PE text,
Head and Neck PE text,
Cardiovascular PE text,
Respiratory PE text,
Abdomen PE text,
Neurological PE text,
Extremities PE text,
Rectum PE text,
Impression text,
Recommended Tests text,
Prescriptions text,
Followup text,
Medication List text,
Current Problem text,
Current Status text,
Second Physician tinytext,
Third Physician tinytext,
Allergies List text,
PRIMARY KEY (Report Number)
) TYPE=MyISAM COMMENT='Records information from Follow Up Appointments';
# --------------------------------------------------------
#
# Table structure for table `Insurance Providers`
#
CREATE TABLE Insurance Providers (
Provider Number int(11) NOT NULL auto_increment,
Company Name tinytext,
Street Addres text,
City tinytext,
State tinytext,
Zip Code tinytext,
Phone Number tinytext,
Fax Number tinytext,
Email Address tinytext,
Home Page tinytext,
PRIMARY KEY (Provider Number),
FULLTEXT KEY Street Addres (Street Addres)
) TYPE=MyISAM COMMENT='Contact Information for Insurance Providers';
# --------------------------------------------------------
#
# Table structure for table `Patients`
#
CREATE TABLE Patients (
ID Code int(11) NOT NULL auto_increment,
First Name tinytext,
Middle Name tinytext,
Last Name tinytext,
SSN tinytext,
DOB date default NULL,
Home Street tinytext,
Home City tinytext,
Home State tinytext,
Home Zip Code tinytext,
Home Phone Number tinytext,
Home Fax Number tinytext,
Home Email Address tinytext,
Work Street tinytext,
Work City tinytext,
Work State tinytext,
Work Zip Code tinytext,
Work Phone Number tinytext,
Work Fax Number tinytext,
Work Email Address tinytext,
Preferred Doctor int(11) default NULL,
Second Doctor int(11) default NULL,
Third Doctor int(11) default NULL,
Fourth Doctor int(11) default NULL,
Typical Referer int(11) default NULL,
Medication List text,
Medical History text,
Surgical History text,
Smoker int(11) default NULL,
Smoker Usage text,
Drinker int(11) default NULL,
Drinker Usage text,
Social History text,
Father History text,
Mother History text,
Siblings History text,
Family History text,
Family Colorectal Cancer / Polyps int(11) default NULL,
Family Colorectal Cancer / Polyps Information text,
Family Peptic Ulcer Disease int(11) default NULL,
Family Peptic Ulcer Disease Information text,
Family Cirrhosis int(11) default NULL,
Family Cirrhosis Information text,
Family Breast / Ovarian / Uterine Cancer int(11) default NULL,
Family Breast / Ovarian / Uterine Cancer Information text,
Family Colitis int(11) default NULL,
Family Colitis Information text,
Allergies int(11) default NULL,
Allergies List text,
Chief Complaint text,
Chief Complaint Date of Onset text,
Chief Complaint Frequency text,
Chief Complaint Type text,
Chief Complaint Location / Radiation text,
Chief Complaint Duration text,
Chief Complaint Aggravating Factors text,
Chief Complaint Relieving Factors text,
Chief Complaint Relevant Work Up History text,
Occupation text,
Employer Name text,
Marital Status text,
Name of Spouse text,
Referral Source text,
Workers Comp int(11) default NULL,
No Fault int(11) default NULL,
Sex of Patient text,
General Health text,
Insurance Company 1 Provider ID Number int(11) default NULL,
Insurance Company 1 ID Number tinytext,
Insurance Company 1 Group Number tinytext,
Insurance Company 1 Subscriber tinytext,
Insurance Company 2 Provider ID Number int(11) default NULL,
Insurance Company 2 ID Number tinytext,
Insurance Company 2 Group Number tinytext,
Insurance Company 2 Subscriber tinytext,
Insurance Company 3 Provider ID Number int(11) default NULL,
Insurance Company 3 ID Number tinytext,
Insurance Company 3 Group Number tinytext,
Insurance Company 3 Subscriber tinytext,
PRIMARY KEY (ID Code),
FULLTEXT KEY Siblings History (Siblings History)
) TYPE=MyISAM COMMENT='Keeps profile of patients';
# --------------------------------------------------------
#
# Table structure for table `Physical Examination Report`
#
CREATE TABLE Physical Examination Report (
Report Number int(11) NOT NULL auto_increment,
ID Code of Appointment int(11) default NULL,
ID Code of Patient int(11) default NULL,
Date of Exam date default NULL,
Date of Report date default NULL,
First Name of Doctor tinytext,
Middle Name of Doctor tinytext,
Last Name of Doctor tinytext,
Initials of Doctor tinytext,
First Name of First Referer tinytext,
Middle Name of First Referer tinytext,
Last Name of First Referer tinytext,
Street Address of Referer tinytext,
City of Referer tinytext,
State of Referer tinytext,
Zip Code of Referer tinytext,
First Name of Patient tinytext,
Middle Name of Patient tinytext,
Last Name of Patient tinytext,
History of Present Illness text,
Constitutional Symptoms text,
Eyes text,
Ears Nose Throat text,
Cardiovascular text,
Respiratory text,
Gastrointestinal text,
Genitourinary text,
Musculoskeletal text,
Integumentary text,
Neurological text,
Endocrine text,
Hematologic text,
Past Medical History text,
Personal History text,
History of Father text,
History of Mother text,
History of Siblings text,
Family History text,
Weight tinytext,
Height tinytext,
BMI tinytext,
BP tinytext,
Pulse tinytext,
Resp tinytext,
General PE text,
Skin PE text,
Ears Nose Throat PE text,
Eyes PE text,
Head and Neck PE text,
Cardiovascular PE text,
Respiratory PE text,
Abdomen PE text,
Neurological PE text,
Extremities PE text,
Rectum PE text,
Impression text,
Recommended Tests text,
Prescriptions text,
Followup text,
Medication List text,
Medical History text,
Surgical History text,
Smoker Usage text,
Drinker Usage text,
Allergies List text,
Chief Complaint text,
Social History text,
Sex of Patient tinytext,
Family Colorectal Cancer / Polyps Information text,
Family Peptic Ulcer Disease Information text,
Family Cirrhosis Information text,
Family Breast / Ovarian / Uterine Cancer Information text,
Family Colitis Information text,
PRIMARY KEY (Report Number),
FULLTEXT KEY History of Present Illness (History of Present
Illness,Constitutional Symptoms)
) TYPE=MyISAM COMMENT='Records Data from Physical Examination';
# --------------------------------------------------------
#
# Table structure for table `Refering Doctors`
#
CREATE TABLE Refering Doctors (
ID Code int(11) NOT NULL auto_increment,
First Name tinytext,
Middle Name tinytext,
Last Name tinytext,
SSN tinytext,
Business Street tinytext,
Business City tinytext,
Business State tinytext,
Business Zip Code tinytext,
Business Phone Number tinytext,
Business Fax Number tinytext,
Business EMail Address tinytext,
Home Street tinytext,
Home City tinytext,
Home State tinytext,
Home Zip Code tinytext,
Home Phone Number tinytext,
Home Fax Number tinytext,
Home Email Address tinytext,
PRIMARY KEY (ID Code)
) TYPE=MyISAM COMMENT='Keeps information about the doctors that refer
patients to t';
This was done multiple times and caused the server to restart
every time.
>Fix:
Moved Database to a machine with MySQL 3.x (3.23.49) and the query
worked without issue. I even tried this by simply copying the data
directory over (tar.gz-ed the data directory, untared it on the other
machine, and restarted the server)
>Submitter-Id: <submitter ID>
>Originator:
>Organization:
<organization of PR author (multiple lines)>
>MySQL support: none
>Synopsis: Specific UPDATE query crashes MySQL 4.0.1 alpha
>Severity: critical
>Priority: low
>Category: mysql
>Class: sw-bug
>Release: mysql-4.0.1-alpha (Official MySQL binary)
>Environment:
<machine, os, target, libraries (multiple lines)>
System: Linux venezia 2.4.18 #3 SMP Tue Mar 12 05:19:55 EST 2002 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-slackware-linux/3.0.4/specs
Configured with: ../gcc-3.0.4/configure --prefix=/usr --enable-shared --with-gnu-ld
--enable-threads --verbose --target=i386-slackware-linux --host=i386-slackware-linux
Thread model: posix
gcc version 3.0.4
Compilation info: CC='gcc' CFLAGS='-O3 -mpentium ' CXX='gcc' CXXFLAGS='-O3
-mpentium -felide-constructors' LDFLAGS='-static'
LIBC:
lrwxrwxrwx 1 root root 13 Mar 10 04:37 /lib/libc.so.6 -> libc-2.2.5.so
-rwxr-xr-x 1 root root 4783716 May 25 2001 /lib/libc-2.2.3.so
-rwxr-xr-x 1 root root 1226664 Jan 24 19:17 /lib/libc-2.2.5.so
-rw-r--r-- 1 root root 25159498 Jan 24 18:45 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Jan 24 18:45 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official
MySQL binary' --with-extra-charsets=complex --with-server-suffix=
--enable-thread-safe-client --enable-assembler --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --disable-shared
---------------------------------------------------------------------
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
