DeadLockReport on projecteventstonew/DequeuedEventHandler.scala:95

[sentry-dev-app]

Probably very similar to #1664

Sentry Issue: RENKU-GRAPH-HK

PostgresErrorException: 
🔥  
🔥  Postgres ERROR 40P01 raised in DeadLockReport (deadlock.c:1146)
🔥  
🔥    Problem: �[36mDeadlock detected.�[0m
🔥     Detail: �[36mProcess 1735360 waits for ShareLock on transaction 3062809; blocked�[0m
🔥  �[36m           by process 1735388.
🔥  Process 1735388 waits for ShareLock on�[0m
🔥  �[36m           transaction 3062779; blocked by process 1735360.�[0m
🔥       Hint: �[36mSee server log for query details.�[0m
🔥  
🔥  The statement under consideration was defined
🔥    at /work/event-log/src/main/scala/io/renku/eventlog/events/consumers/statuschange/projecteventstonew/DequeuedEventHandler.scala:95
🔥  
🔥    �[32mUPDATE event evt�[0m
🔥    �[32mSET status = 'NEW',�[0m
🔥    �[32m    execution_date = ($1),�[0m
🔥    �[32m    message = NULL�[0m
🔥    �[32mFROM (�[0m
🔥    �[32m  SELECT event_id, e.project_id, status�[0m
🔥    �[32m  FROM event e�[0m
🔥    �[32m  JOIN project p ON e.project_id = p.project_id�[0m
🔥    �[32m    AND p.project_id = ($2)�[0m
🔥    �[32m    AND p.project_slug = ($3)�[0m
🔥    �[32m  WHERE status IN ('TRIPLES_GENERATED','TRANSFORMATION_NON_RECOVERABLE_FAILURE','GENERATION_RECOVERABLE_FAILURE','TRANSFORMATION_RECOVERABLE_FAILURE','TRIPLES_STORE','GENERATION_NON_RECOVERABLE_FAILURE','TRANSFORMING_TRIPLES','NEW')�[0m
🔥    �[32m  FOR UPDATE�[0m
🔥    �[32m) old_evt�[0m
🔥    �[32mWHERE evt.event_id = old_evt.event_id AND evt.project_id = old_evt.project_id�[0m
🔥    �[32mRETURNING old_evt.status�[0m
🔥  
🔥  and the arguments were provided
🔥    at /work/graph-commons/src/main/scala/io/renku/db/implicits.scala:29
🔥  
🔥    $1 timestamptz �[32m2023-08-16 17:47:44.797749Z AD�[0m
🔥    $2 int4       �[32m5653�[0m
🔥    $3 varchar    �[32meawagrs/lake-greifen-platform�[0m
🔥  
🔥  If this is an error you wish to trap and handle in your application, you can do
🔥  so with a SqlState extractor. For example:
🔥  
🔥    �[32mdoSomething.recoverWith { case SqlState.DeadlockDetected(ex) =>  ...}�[0m
🔥  

skunk.exception.PostgresErrorException: Deadlock detected.
    at skunk.net.protocol.Unroll.$anonfun$unroll$1(Unroll.scala:66)
    at flatMap @ fs2.Compiler$Target.flatMap(Compiler.scala:163)
    at flatMap @ skunk.net.BufferedMessageSocket$$anon$1.$anonfun$receive$1(BufferedMessageSocket.scala:150)
    at get @ skunk.util.Pool$.free$1(Pool.scala:156)
    at flatMap @ skunk.net.BufferedMessageSocket$$anon$1.receive(BufferedMessageSocket.scala:147)

EVENTS_STATUS_CHANGE processing event {"project":{"id":5653,"slug":"eawagrs/lake-greifen-platform"},"subCategory":"ProjectEventsToNew","categoryName":"EVENTS_STATUS_CHANGE"} of type PROJECT_EVENTS_TO_NEW failed