Public bug reported:
Description:
Currently InnoDB has option innodb_print_all_deadlocks which tells InnoDB to
redirect information about all deadlocks into log file. Please implement
similar feature, but for "Lock wait timeout" errors. Print information about
both failed and blocking transactions.
Since blocking transaction is often multiple statement transaction, if
possible, print all statements. You may print all statements depending
if historical Performance Schema instrumentation for statements enabled
or not: in this case server already stored statements, participated in
the transaction.
How to repeat:
Ask your colleague to run high concurrent load which produces "Lock wait
timeout" errors, try to find reason for them.
TokuDB can do this if option tokudb_lock_timeout_debug is set
** Affects: mysql-server
Importance: Unknown
Status: Unknown
** Affects: percona-server
Importance: Undecided
Status: Confirmed
** Affects: percona-server/5.5
Importance: Undecided
Status: Confirmed
** Affects: percona-server/5.6
Importance: Undecided
Status: Confirmed
** Affects: percona-server/5.7
Importance: Undecided
Status: Confirmed
** Tags: i163411
** Also affects: percona-server/5.7
Importance: Undecided
Status: Confirmed
** Also affects: percona-server/5.5
Importance: Undecided
Status: New
** Also affects: percona-server/5.6
Importance: Undecided
Status: New
** Changed in: percona-server/5.6
Status: New => Confirmed
** Changed in: percona-server/5.5
Status: New => Confirmed
** Bug watch added: MySQL Bug System #84563
http://bugs.mysql.com/bug.php?id=84563
** Also affects: mysql-server via
http://bugs.mysql.com/bug.php?id=84563
Importance: Unknown
Status: Unknown
--
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1657737
Title:
Print locking transaction which cause "Lock wait timeout" errors into
log file
To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1657737/+subscriptions
--
Mailing list: https://launchpad.net/~enterprise-support
Post to : [email protected]
Unsubscribe : https://launchpad.net/~enterprise-support
More help : https://help.launchpad.net/ListHelp
