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
