MySQL Forums :: InnoDB :: Exclusive lock

Advanced Search

Exclusive lock
Posted by: András Berta ()
Date: November 11, 2016 02:39AM

Hi Everybody,

I have a mysql error and I didn't find the answer till now on the internet: "Wait on a lock was aborted due to a pending exclusive lock"
I have a lot of transaction in the same time. These based on an innodb table, that has a few triggers. These triggers read and write other innodb and myisam tables.
I know what is the "wait lock", but I don't have enough information about "exclusive lock". What should I do to terminate this error, because these transactions are not finishing and not updateing the rows in the this table.

I have a Windows Server 2012 R2 Standard and a MySQL 5.6.15 on it. The database is on an SSD drive and the logs are on a simple HDD.

This is my ini file:

log-bin = "E:/Log/mysqldblog/myCustomer/mysql-bin/log"
log-error = "E:/Log/mysqldblog/myCustomer/errorlog/error"
tmpdir ="E:/MySQLTEMP/"
join_buffer_size = 4M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M
innodb_log_buffer_size = 4M
max_allowed_packet = 100M
innodb_log_file_size = 256M
innodb_thread_concurrency = 16
event-scheduler = ON
max_sp_recursion_depth = 50
transaction-isolation = READ-COMMITTED
log-warnings = 0

I would apprisiate if somebody could help me to solve this problem.
Thanks in advence.

kind regards,

Options: ReplyQuote

Subject Views Written By Posted
Exclusive lock 527 András Berta 11/11/2016 02:39AM
Re: Exclusive lock 236 Peter Brawley 11/11/2016 04:59AM
Re: Exclusive lock 226 András Berta 12/01/2016 07:56AM
Re: Exclusive lock 202 Peter Brawley 12/01/2016 10:19AM

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.