Thank you for attempting to reproduce this. I've been unable to reproduce this as well - spent quite a few hours/days, even on some older versions.
I mimic'ed the deadlock, down to the exact table (w/ partitions), exact statements, same order, same locks/lock states by the preceding statements in the transactions (i.e., the statements holding the locks leading to the deadlock), the number of innodb_current_row_lock_waits, etc. No matter what I've tried, innodb_current_row_lock_waits remains the same.
It's so minor, I'm hanging up trying to reproduce this.
Hi Nilnandan,
Thank you for attempting to reproduce this. I've been unable to reproduce this as well - spent quite a few hours/days, even on some older versions.
I mimic'ed the deadlock, down to the exact table (w/ partitions), exact statements, same order, same locks/lock states by the preceding statements in the transactions (i.e., the statements holding the locks leading to the deadlock), the number of innodb_ current_ row_lock_ waits, etc. No matter what I've tried, innodb_ current_ row_lock_ waits remains the same.
It's so minor, I'm hanging up trying to reproduce this.
Thanks again. :)
Best wishes,
Chris