Wrote a service transaction method, Shared read locks, then update and report to the Lock wait timeout exceeded; Try restarting transaction, spring to create a transaction but why mysql transaction table start two transactions?

Lock_trx_id lock_mode lock_type
106818701 X RECORD

421993180913264 S RECORD