MySQL Forums
Forum List  »  InnoDB

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:

[mysqld]
port=3306
basedir="C:/MySQL/mysql-5.6.15-winx64/"
datadir="C:/DB/myCustomer/data"
innodb_data_home_dir="C:/DB/myCustomer/innodb/"
log-bin = "E:/Log/mysqldblog/myCustomer/mysql-bin/log"
log-error = "E:/Log/mysqldblog/myCustomer/errorlog/error"
tmpdir ="E:/MySQLTEMP/"
innodb_buffer_pool_size=1024M
join_buffer_size = 4M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M
innodb_log_buffer_size = 4M
innodb_flush_log_at_trx_commit=1
max_allowed_packet = 100M
tmp_table_size=64M
max_heap_table_size=64M
innodb_log_file_size = 256M
innodb_thread_concurrency = 16
federated=1
default-storage-engine=INNODB
event-scheduler = ON
max_sp_recursion_depth = 50
character-set-server=utf8
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
binlog_format=mixed
transaction-isolation = READ-COMMITTED
log-warnings = 0

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

kind regards,
András

Options: ReplyQuote


Subject
Views
Written By
Posted
Exclusive lock
2222
November 11, 2016 02:39AM
872
November 11, 2016 04:59AM
880
December 01, 2016 07:56AM
774
December 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.