MySQL Forums
Forum List  »  General

Re: InnoDB deadlock on concurrent inserts
Posted by: Heikki Tuuri
Date: December 01, 2004 01:20PM

Hi!

Please post the complete SHOW INNODB STATUS output.

The described deadlock can happen in the first insert to the table after a mysqld startup, since InnoDB must first init its internal auto-inc counter.

Best regards,

Heikki
Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php

Order MySQL support from http://www.mysql.com/support/index.html

Options: ReplyQuote


Subject
Written By
Posted
Re: InnoDB deadlock on concurrent inserts
December 01, 2004 01:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.