Martin, this bug in multi-table UPDATE on InnoDB tables was reported 3 weeks ago and Sinisa has fixed it to upcoming 4.0.11.
Regards, Heikki Innobase Oy sql query .................. Subject: Bug? Update on 3 tables crashes in InnoDB From: Martin Thoma Date: Mon, 17 Feb 2003 11:57:12 +0100 Can somebody confirm this please? Martin Subject: UPDATE over 3 tables crashes in InnoDB Description: I have 3 InnoDB-tables with about 6000 records each: customer 1:n orders 1:n invoices When trying to make the following update: update customer, orders, invoices set customer.locked=1 WHERE invoices.id=1234 AND invoices.order=orders.id AND orders.customer=customer.id; the database crashes with: mysqld-nt: ready for connections. Version: '4.0.10-gamma-nt' socket: '' port: 3302 030217 11:48:47 InnoDB: Assertion failure in thread 1428 in file D:\mysql-4.0.10-gpl\innobase\btr\btr0pcur.c line 203 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] InnoDB: Thread 1460 stopped in file D:\mysql-4.0.10-gpl\innobase\sync\sync0arr.c line 126 InnoDB: Thread 1164 stopped in file D:\mysql-4.0.10-gpl\innobase\os\os0sync.c line 150 How-To-Repeat: Build a table with 6000 customers, each with one order and one invoice. Then just repeat the UPDATE above. Fix: ???? Synopsis: Update over 3 tables crashes in InnoDB Submitter-Id: ???? Originator: martin thoma Organization: MySQL support: [none] Severity: [serious] Priority: [medium] Category: [mysqld] Class: [sw-bug] Release: 4.0.10-gamma Exectutable: [mysqld-nt] Environment: <AMD XP1800+, 512 MB, 80 GB HDD> System: <Win200 Prof.> Compiler: VC++ 6.0 Architecture: i --------------------------------------------------------------------- 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
