Advertisement
Guest User

Untitled

a guest
Aug 22nd, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.38 KB | None | 0 0
  1. Parsed test spec with 3 sessions
  2.  
  3. starting permutation: s1-begin s1-assign-dist-tx-id s2-begin s2-assign-dist-tx-id s1-update-1 s2-update-2 s2-update-1 deadlock-checker-call s1-update-2 deadlock-checker-call s1-finish s2-finish
  4. step s1-begin:
  5. BEGIN;
  6.  
  7. step s1-assign-dist-tx-id:
  8. SELECT assign_distributed_transaction_id (1, 1, '2017-08-22 13:34:22.844055+03');
  9.  
  10. assign_distributed_transaction_id
  11.  
  12.  
  13. step s2-begin:
  14. BEGIN;
  15.  
  16. step s2-assign-dist-tx-id:
  17. SELECT assign_distributed_transaction_id (2, 1, '2017-08-22 13:34:22.844055+03');
  18.  
  19. assign_distributed_transaction_id
  20.  
  21.  
  22. step s1-update-1:
  23. UPDATE mx_deadlock_test SET some_val = 1 WHERE user_id = 1;
  24.  
  25. step s2-update-2:
  26. UPDATE mx_deadlock_test SET some_val = 2 WHERE user_id = 2;
  27.  
  28. step s2-update-1:
  29. UPDATE mx_deadlock_test SET some_val = 2 WHERE user_id = 1;
  30. <waiting ...>
  31. step deadlock-checker-call:
  32. SELECT check_distributed_deadlocks();
  33.  
  34. check_distributed_deadlocks
  35.  
  36. f
  37. step s1-update-2:
  38. UPDATE mx_deadlock_test SET some_val = 1 WHERE user_id = 2;
  39. <waiting ...>
  40. step deadlock-checker-call:
  41. SELECT check_distributed_deadlocks();
  42.  
  43. check_distributed_deadlocks
  44.  
  45. t
  46. step s1-update-2: <... completed>
  47. step s2-update-1: <... completed>
  48. error in steps s1-update-2 s2-update-1: ERROR: deadlock detected
  49. step s1-finish:
  50. COMMIT;
  51.  
  52. step s2-finish:
  53. COMMIT;
  54.  
  55. restore_isolation_tester_func
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement