Michael, Sunday, May 19, 2002, 12:56:00 PM, you wrote: MBV> Description:
MBV> Possible Bug in UPDATE in MySQL 4.0.1 MBV> The following is the message in the error log... MBV> Number of processes running now: 0 MBV> 020519 04:55:30 mysqld restarted MBV> 020519 4:55:30 InnoDB: Started MBV> /usr/local/mysql/bin/mysqld: ready for connections MBV> mysqld got signal 11; MBV> This could be because you hit a bug. It is also possible that this binary MBV> or one of the libraries it was linked against is corrupt, improperly MBV> built, MBV> or misconfigured. This error can also be caused by malfunctioning MBV> hardware. MBV> We will try our best to scrape up some info that will hopefully help MBV> diagnose MBV> the problem, but since we have already crashed, something is definitely MBV> wrong MBV> and this may fail. MBV> How-To-Repeat: MBV> Did this query on a database called 'medical' below text MBV> UPDATE `Physical Examination Report` SET `History of Present MBV> Illness`='moo\r\nfoo\r\nboo.' WHERE `ID Code of Appointment`=27 MBV> DUMP of medical database schema: MBV> This was done multiple times and caused the server to restart MBV> every time. MBV> Fix: MBV> Moved Database to a machine with MySQL 3.x (3.23.49) and the query MBV> worked without issue. I even tried this by simply copying the data MBV> directory over (tar.gz-ed the data directory, untared it on the other MBV> machine, and restarted the server) I tested you SQL statement and it works fine on my v4.0.1 Probably, SIG11 is cause by broken hardware. Please check it. BTW, if you use compound names for your tables and columns use --quote-names option of mysqldump. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ 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
