Rosa Gutierrez

Ah! I tried reading as you said you were getting the error on reading too, but testing writing, this works fine 😕 ```ruby >> ActiveRecord::Base.connected_to_many(ApplicationRecord, ActiveStorage::Record, role: :writing, shard: :shard_two)...

> I attach a PDF file and not a PNG. I tried with a PNG, and it works fine for me too! 🤯 Oh wow! Great catch! 🔍 💯 Going...

Aha! I can indeed reproduce with a PDF file: ```ruby class Dog < ApplicationRecord has_one_attached :photo def attach_test_photo photo.attach(io: File.open("/tmp/sample.pdf"), filename: "sample.pdf") end end ``` And then: ```ruby >> ActiveRecord::Base.connected_to_many(ApplicationRecord,...

Ok, I found the reason why this happens with a PDF and not with a PNG. The reason is that, when attaching the blob, [this method gets called](https://github.com/rails/rails/blob/9ffd264e016ee5501b19286c2f48d952e910e96c/activestorage/app/models/active_storage/blob/analyzable.rb#L37-L43). The `analyzer_class`...

🤔 You're enqueuing the jobs sequentially, no? And the ones enqueued first are these: ``` TestSqJobs::SemiUrgentPriorityJobA, TestSqJobs::SemiUrgentPriorityJobB, TestSqJobs::SemiUrgentPriorityJobC, ``` So they're going to be run before ``` TestSqJobs::UrgentPriorityJobA, TestSqJobs::UrgentPriorityJobB, TestSqJobs::UrgentPriorityJobC,...

Ah, I see what you mean. Yes, there's a bug there in the order of queues when they use prefixes. The order is the one returned from the DB from...

Within the same wildcard name, `urgent_A, urgent_B, urgent_C`, the selection would be non-deterministic, it'll depend on the order the DB returns the queue names from `SELECT queue_name FROM solid_queue_ready_executions WHERE...

The fix for this was released in version 1.0.2, thanks again for the report!

Hey @yjchieng, thanks for opening this issue! 🙏 I think it depends a lot on your app. A brand new Rails app seems to use around 74.6MB memory for me...

There might also be something else going on because the only changes from version 0.7.0 to 0.8.2 were for the installing part of Solid Queue; nothing was changed besides the...