Rich, it was a bug. If inserts to several tables containing an auto-inc column are wrapped inside one LOCK TABLES, InnoDB will assert in lock0lock.c, line 2843.
Workaround: remove the LOCK TABLES if you can, or LOCK just one table at a time. I have fixed the bug to 3.23.48. You will get a patch to ha_innobase.cpp if you need. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB Rich wrote in message ... >v3.23.47 > >I have managed to Carsh the DB Server. > >I have a routine in my application which imports & exports a database. > >My Import does the following process, (all commands sent through >MyODBC). >1- Lock Table table1 write repeated for all tables in db. >2- Delete from table1 >3- insert data into table1 (using INSERT, SQL constructed from data in >an XML file) > >Repeat steps 2+3 for all tables. >But when it gets to the very first insert of the sceond table, the >server crashes with an assertion error, leaving my application to >complain theres no MySQL server. > >Console Monitor shows: >020117 14:27:57 InnoDB: Started >c:\mysql\bin\mysqld-max-nt: ready for connections >InnoDB: Assertion failure in thread 1136 in file >C:\get\innobase\lock\lock0lock.c line 2843 >InnoDB: We intentionally generate a memory trap. >InnoDB: Send a detailed bug report to [EMAIL PROTECTED] >InnoDB: Thread 1016 stopped in file C:\get\innobase\os\os0sync.c line >140 > >This procedure worked fine in MySQL v3.23.38 but since upgrading it >does not work. > >I have tried ammending the SQL commands to a file and sending the SQL >file through the server on the command line and there are no errors. >I have tried upgrading MyODBC still nothing. > >Has anyone had any similar errors? --------------------------------------------------------------------- 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