nono.31
Oban - Caching Ecto Statements ETS Table memory leak -> OOM
Hello
- We’re using Oban.Pro 1.14
- we have 23 queues
- we use partitioning
- we use uniqueness
- we use local limits
- we use global limits
- we use rate limits
- we use DynamicCron heavily (1800+ cron entries)
- we have multiple nodes
- we process millions of jobs a day
We are having an issue where our Ecto.Repo ETS table is slowly growing until we get an OOM (currently reaching our limit of 8GB).
Our Repo is mainly used for Oban.
I am trying to dig deeper into this to try to isolate where this can come from, but it seems related to internals of Oban ![]()
Here we are using 105MB after a few hours:
Some of the ETS table details at this point:
- has 16178 references to the
oban_jobstable - has 12 reference to
name: "ecto_*
You can find a small portion of it at https://gist.githubusercontent.com/mathieurousseau/6e6529da36bc09927fb9227ed4acbebf/raw/72f46766b6acf9aede031d820e70df59577afd10/gistfile1.txt
Something I have isolated:
- The leader ecto ets table does not grow if it does not process any jobs (probably only taking care of main Oban business and the Cron)
What can I provide to help with this investigation?
Is there some obvious configuration that you know could mitigate this? (using prepare: :unamed on ecto configuration did not change anything)
Thanks.
Mathieu
Most Liked
benwilson512
What version of Ecto are you using? I seem to recall some isssue in Ecto related to this that was fixed at one point.
sorentwo
As indicated, this is fundamentally an Ecto issue. There are improvements in more recent versions of Pro to compensate for this issue by disabling prepared statements for highly dynamic queries.
Aside from upgrading Ecto and Pro, you could disable prepared statements for all Repo queries with prepare: :unnamed (double check the options in the Ecto docs).
sorentwo
No assistance is needed. The Ecto cache (what is stored in ETS) is separate from prepared statements, and there’s no way to disable it as far as I can tell. The high cardinality of partitioned queries appears to cause the table growth, and that’s not a trivial fix on the Oban/Pro side.
We plan on overhauling those queries for reduced cardinality, speed, and flexibility in Pro v1.6. A cardinality fix may be possible as a v1.5 patch.
Popular in Questions
Other popular topics
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #blog-post
- #graphql
- #genstage
- #ai
- #websockets
- #supervisor
- #advent-of-code
- #elixirconf-us
- #distillery
- #processes
- #forms
- #api
- #metaprogramming
- #security
- #performance









