0

I am using Heidi (MySQL client) to simulate the deadlock.

Scenario as below.

  1. A table say student with column name and ID #. Auto commit set to false.

  2. Process #A from client to modify the column data of name "Bob" to Tomcat. No commit from here

  3. Process #B from client to modify same column data of name "Bob" to Super. Then dead locks happen

How to prevent this issue except commit on the #2 above or set auto commit to true?

Shadow
  • 32,277
  • 10
  • 49
  • 61
Banana Tech
  • 319
  • 1
  • 4
  • 14
  • This is not a deadlock situation, as process #A can continue to do whatever it needs to do. If the lock held by process #A persists long enough, the lock wait timeout will lapse for process #B. – Shadow Mar 07 '22 at 08:38

0 Answers0