Andy Barringer comments

Results 6 comments of


                                            Andy Barringer

Some jobs failing due to ActiveRecord::Deadlocked when trying to create a ScheduledExecution

Here you go. Thanks for looking into it. Let me know if you need any more info. [latest_detected_deadlock.txt](https://github.com/basecamp/solid_queue/files/14465372/latest_detected_deadlock.txt)

Some jobs failing due to ActiveRecord::Deadlocked when trying to create a ScheduledExecution

Yep, here they are: solid_queue (0.2.1) 8.0.mysql_aurora.3.03.1 ``` dispatchers: - polling_interval: 1 batch_size: 500 ```

Some jobs failing due to ActiveRecord::Deadlocked when trying to create a ScheduledExecution

Ah! Haha, so easy to do. We'll be glad to test that fix with our situation. I'll watch for a new version. Thank you!

Some jobs failing due to ActiveRecord::Deadlocked when trying to create a ScheduledExecution

Hi, @rosa, we deployed that new version and thought it might have fixed it but unfortunately we got some more deadlocks today. Here's the latest deadlock log from the db,...

Some jobs failing due to ActiveRecord::Deadlocked when trying to create a ScheduledExecution

Thanks, @rosa. I haven't had a chance to look at it much myself before this, due to some other needed work in our project that's using this gem, but I'm...

Some jobs failing due to ActiveRecord::Deadlocked when trying to create a ScheduledExecution

Hi @rosa, I just realized I hadn't responded to you yet, I apologize for that. We ended up moving away from Solid Queue to using something else that was just...