Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- log_lock_waits = on
- deadlock_timeout = 1s
- $ ag_ctl stop
- waiting for server to shut down.... done
- server stopped
- $ ag_ctl start
- server starting
- agens=# begin;
- BEGIN
- agens=# create (:n{id:1});
- GRAPH WRITE (INSERT VERTEX 1, INSERT EDGE 0)
- agens=# rollback;
- ROLLBACK
- agens=#
- agens=# create (:n{id:1});
- GRAPH WRITE (INSERT VERTEX 1, INSERT EDGE 0)
- LOG: process 3908 still waiting for ShareLock on transaction 1586 after 1001.058 ms
- DETAIL: Process holding the lock: 3906. Wait queue: 3908.
- CONTEXT: while inserting index tuple (0,7) in relation "n_id_idx"
- STATEMENT: create (:n{id:1});
- LOG: process 3908 acquired ShareLock on transaction 1586 after 4639.630 ms
- CONTEXT: while inserting index tuple (0,7) in relation "n_id_idx"
- STATEMENT: create (:n{id:1});
Add Comment
Please, Sign In to add comment