Rails 7 load_async queries public schema when invoking queries on the async thread pool

[patbenatar]

Steps to reproduce

Create a Rails 7 app with load_async enabled (config.active_record.async_query_executor = :global_thread_pool). Switch into a tenant schema. Use load_async to load an AR relation.

Expected behavior

Whether the query is invoked async or sync, the records returned should be from the tenant schema.

Actual behavior

The records returned when the query is invoked async are from the public schema.

System configuration

• Database: Postgres 13

• Apartment version: 7d7c73c

• Apartment config (in config/initializers/apartment.rb or so):

  • use_schemas: default, so true

• Rails (or ActiveRecord) version: 7.0.2.3

• Ruby version: 3.1.1

[lifelenz]

This appears to fix it:
https://gist.github.com/lifelenz/7821a758c470ee735192fad0bd68474e

[patbenatar]

@mnovelo is this fixed on main?

[mnovelo]

@patbenatar this is not, nor do we have tests to verify whether it's needed. I'll look into it

[github-actions]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.

[mnovelo]

Now that I'm done with school I have more time to look into this

[patbenatar]

@mnovelo that'd be awesome!

[mnovelo]

This wasn't addressed in v3.2.0, but I hope to add such support in v4.0.0. Your help would be greatly appreciated! #312