concurrently update a row in global table may cause live-lock

[actiontech-bot]

Raised by: helingyun Steps:

1. concurrently Query:

set autocommit = 0;
update test_global1 set k=k-1 where id = 1;
update test1 set k=k+1 where id = 666;
commit;

2. connection a updates data-node 1, and wait for data-node 2
3. connection b updates data-node 2, and wait for data-node 2
4. transaction timeout, and be rollback