MySQL Forums
Forum List  »  InnoDB

Re: locking problems
Posted by: Heikki Tuuri
Date: February 13, 2005 04:21AM

Mike,

probably some other user has updated/deleted the end of the PRIMARY index. Therefore this insert is blocked:

------- TRX HAS BEEN WAITING 12 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 0 page no 6768 n bits 128 index `PRIMARY` of table `zeiterfa/Zeiterfassung` trx id 0 13974162 lock_mode X insert intention waiting
Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; 1-byte offs TRUE; info bits 0
0: len 9; hex 73757072656d756d00; asc supremum ;;

That insert is holding the auto-inc lock. The other trx is waiting for that auto-inc lock.

http://dev.mysql.com/doc/mysql/en/innodb-next-key-locking.html

Best regards,

Heikki
Oracle Corp./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

Options: ReplyQuote


Subject
Views
Written By
Posted
3866
February 09, 2005 10:47AM
Re: locking problems
2580
February 13, 2005 04:21AM
2644
February 15, 2005 10:06AM
2462
February 15, 2005 02:09PM


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.