Skip to content

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

Open
@actiontech-bot

Description

@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;

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

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions