[GitHub] [airflow] eitanme commented on issue #23361: Scheduler crashes with psycopg2.errors.DeadlockDetected exception

[GitBox <gi...@apache.org>]

eitanme commented on issue #23361:
URL: https://github.com/apache/airflow/issues/23361#issuecomment-1173989183

   Just to follow up here on the deadlock issue I saw which, I think, is unrelated to the load issues associated with the new GridView though I'm happy to hear those will be fixed in 2.3.3.
   
   Since I was only running one scheduler, I tried setting `use_row_level_locking` to false and have not seen the `psycopg2.errors.DeadlockDetected: deadlock detected` error since. I also experience the problem on both 2.2.4 and 2.3.2 and 2.2.4 didn't have the GridView.
   
   Not sure if this helps and I'll try toggling the setting back once 2.3.3 is released to see if that has an impact, but wanted to give an update.
   
   Also of note, I was experiencing this with only one `LocalExecutor` scheduler when many tasks were kicked off at the same time so I don't think my issue has to do with multi-scheduler interaction. It's more related to overall task load.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org