Danny, Wednesday, September 18, 2002, 1:08:23 PM, you wrote: DH> mysqld got signal 11; DH> This could be because you hit a bug. It is also possible that this binary DH> or one of the libraries it was linked against is corrupt, improperly built, DH> or misconfigured. This error can also be caused by malfunctioning hardware. DH> We will try our best to scrape up some info that will hopefully help DH> diagnose DH> the problem, but since we have already crashed, something is definitely DH> wrong DH> and this may fail.
[skip] thd->>query at 0x8728558 = SELECT DISTINCT job_headers.*, DH> job_threads.access_timeslot, job_threads.access_c DH> omments, job_threads.access_timeslot_details, DH> job_threads.date_of_inspection, job_threads.access_type, job DH> _threads.engineer_comments FROM job_headers, job_threads WHERE DH> job_threads.jid_ptr=job_headers.jid AND cmp DH> id=18874 thd->>thread_id=1 [skip] As far as I remember there was found and fixed the similar bug in 4.0.3. Could you provide output of SHOW CREATE TABLE for testing? -- 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