Paste #Tm2XXrsBR

2020-06-13 22:00:00 UTC:172.31.94.173(45666):ubuntu@bng:[1271]:ERROR: deadlock detected
2020-06-13 22:00:00 UTC:172.31.94.173(45666):ubuntu@bng:[1271]:DETAIL: Process 1271 waits for ShareLock on transaction 61679012; blocked by process 25962.
Process 25962 waits for ShareLock on transaction 61679000; blocked by process 1271.
Process 1271: EXECUTE qpsqlpstmt_1 (17182, 2370, 2122, 2442, 2, '', '{b9b91433-add9-4097-b5e0-c2adaef2958c}', NULL)
Process 25962: EXECUTE qpsqlpstmt_4 (17182, 2264, 2019, 2331, 6, '', '{51e9bbf2-466f-44bc-a00f-024335e3fa3e}', NULL)
2020-06-13 22:00:00 UTC:172.31.94.173(45666):ubuntu@bng:[1271]:HINT: See server log for query details.
2020-06-13 22:00:00 UTC:172.31.94.173(45666):ubuntu@bng:[1271]:CONTEXT: while locking tuple (532,23) in relation "rodadas"
SQL statement "SELECT s.id, r.proxima_cartela, s.cartela_aleatoria, r.valor_cartela, r.premio_fixo
FROM bng.salas s
INNER JOIN bng.rodadas r ON r.sala_id=s.id
INNER JOIN bng.pontos p ON p.sala_id=s.id
INNER JOIN bng.pdvs pdv ON pdv.ponto_id=p.id
WHERE pdv.deleted_user_id IS NULL AND pdv.ativo
AND p.deleted_user_id IS NULL AND p.ativo
AND s.deleted_user_id IS NULL AND s.ativo
AND pdv.id=v_pdv_id AND p.id=v_ponto_id AND r.id=v_rodada_id AND r.rodada_estado='aberta'
FOR UPDATE OF r"
PL/pgSQL function exe.comprar_cartelas(bigint,integer,integer,integer,integer,text,uuid,boolean) line 15 at SQL statement
2020-06-13 22:00:00 UTC:172.31.94.173(45666):ubuntu@bng:[1271]:STATEMENT: EXECUTE qpsqlpstmt_1 (17182, 2370, 2122, 2442, 2, '', '{b9b91433-add9-4097-b5e0-c2adaef2958c}', NULL)