Guest User

Untitled

a guest
Jan 21st, 2019
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.76 KB | None | 0 0
  1. log_lock_waits = on
  2. deadlock_timeout = 1s
  3.  
  4. $ ag_ctl stop
  5. waiting for server to shut down.... done
  6. server stopped
  7. $ ag_ctl start
  8. server starting
  9.  
  10. agens=# begin;
  11. BEGIN
  12. agens=# create (:n{id:1});
  13. GRAPH WRITE (INSERT VERTEX 1, INSERT EDGE 0)
  14. agens=# rollback;
  15. ROLLBACK
  16. agens=#
  17.  
  18. agens=# create (:n{id:1});
  19. GRAPH WRITE (INSERT VERTEX 1, INSERT EDGE 0)
  20.  
  21. LOG: process 3908 still waiting for ShareLock on transaction 1586 after 1001.058 ms
  22. DETAIL: Process holding the lock: 3906. Wait queue: 3908.
  23. CONTEXT: while inserting index tuple (0,7) in relation "n_id_idx"
  24. STATEMENT: create (:n{id:1});
  25. LOG: process 3908 acquired ShareLock on transaction 1586 after 4639.630 ms
  26. CONTEXT: while inserting index tuple (0,7) in relation "n_id_idx"
  27. STATEMENT: create (:n{id:1});
Add Comment
Please, Sign In to add comment