dimitarvp
Hey everybody, in our CI we regularly get this message while MIX_ENV=test mix ecto.migrate is executing:
%Postgrex.Query{columns: nil, name: “ecto_512389”, param_formats: nil, param_oids: nil, param_types: nil, ref: reference<0.3268973948.3458203652.198652>, result_formats: nil, result_oids: nil, result_types: nil, statement: “stripped”, types: nil} uses unknown oid
20031causing bootstrap
(The statement above is an UPDATE with a condition.)
I also regularly get the message when I drop and re-create my local test DB and then run migrations on it.
I poked around the net but the idea of Postgres OIDs doesn’t seem to apply to our app at all. I grep-ed all our migrations but couldn’t find anything about OIDs either.
Anybody has an idea? It’s a warning that doesn’t break anything but since it occurs regularly, it piqued my interest.
Where Next?
Trending in Questions
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
Build Elixir applications with speed and confidence.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #code-sync
- #discussion
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #ai
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #blog-post
- #elixirconf-us
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #security
- #elixirconf-eu
- #api
- #forms
- #hex
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Elixir, Erlang & BEAM conferences from Code Sync - join us in 2026!
Master modern tools, write cleaner code, and tackle real-world challenges.
Bringing learning, work and compliance together since 1987.
**Building the future of software with AI, trust, and human connection.**
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
Showing Posts 1 to 10- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
sanswork
Not sure if you’ve seen it in your searches already but the postgrex readme has some discussion about their use of oids and some considerations around ints that might be relevant?
dimitarvp
I did, but it says absolutely nothing to me. The only thing OID-related to our DB is the fact that PG still gives OIDs to our tables (automatically) but we haven’t configured any table to use OIDs inside them.
sanswork
Any way you can post the contents of statement with maybe the data stripped but the query intact?
dimitarvp
Come to think of it, it’s not something compromising anyway:
josevalim
Any chance you have migrations or anything changing the DB schema running as you run your suite?
dimitarvp
It’s possible. There are quite a few of them and I am not quite caught up with them just yet.
For now I am aware that we add, remove and add values to enums on several places. No materialized views or views of any kind. No stored procedures.
josevalim
That may be the root cause. If you change the database structure, then whatever Postgres has cached will fail. But this should only happen if they are changed while the suite runs.
dimitarvp
I am not excluding possible races. I happen to see the message only while migrating a freshly created test DB though, not during
mix test. (Not sure if you implied that by saying “suite”.)Is the error message serious? I honestly can’t say even after searching for PG OIDs for a while.
josevalim
Right, so it is happening because you are doing queries while you run your migrations. So Postgrex needs to update the cached data as it goes.
dimitarvp
Does that mean that Postgrex is simply rebooting its supervision tree? Because if it caches types as a performance optimization technique, I am guessing it will have to reboot something after they change?