ottojimb
Hi!
When I’m running my tests with semaphoreci, I’m getting the following:
ArgumentError{message: \"query %Postgrex.Query{columns: [\\\"id\\\", \\\"name\\\", \\\"internal\\\", \\\"inserted_at\\\", \\\"updated_at\\\"], name: \\\"ecto_616034\\\", param_formats: [:binary], param_oids: [25], param_types: [Postgrex.Extensions.Raw], ref: #Reference<0.0.1.107309>, result_formats: [:binary, :binary, :binary, :binary, :binary], result_oids: [23, 1043, 16, 1184, 1184], result_types: [Postgrex.Extensions.Int4, Postgrex.Extensions.Raw, Postgrex.Extensions.Bool, Ecto.Adapters.Postgres.TimestampTZ, Ecto.Adapters.Postgres.TimestampTZ], statement: \\\"SELECT r0.\\\\\\\"id\\\\\\\", r0.\\\\\\\"name\\\\\\\", r0.\\\\\\\"internal\\\\\\\", r0.\\\\\\\"inserted_at\\\\\\\", r0.\\\\\\\"updated_at\\\\\\\" FROM \\\\\\\"roles\\\\\\\" AS r0 WHERE (r0.\\\\\\\"name\\\\\\\" = $1)\\\", types: {Ecto.Adapters.Postgres.TypeModule, 35356751}} has invalid types for the connection\"}", status: "error"}
The tests are running ok on the local machine, but it happens every time on semaphoreci.
I’m using docker-compose with the “postgres” image.
Any suggestion is greatly appreciated.
Thanks.
Otto
Where Next?
Trending in Questions
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
We build reliable cloud platforms for business-critical systems.
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
- #discussion
- #code-sync
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ai
- #ecto-query
- #elixirconf-us
- #blog-post
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #elixirconf-eu
- #api
- #forms
- #metaprogramming
- #hex
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
Catch errors, track performance, monitor hosts and more.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Elixir, Erlang & BEAM conferences from Code Sync - join us in 2026!
Practical resources that improve the lives of professional developers.
Bringing learning, work and compliance together since 1987.
Producing high quality Elixir screencasts since 2017.
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 5- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
NobbZ
Which postgres image do you use? Please specify the full name, including tag.
Also its hard to say without seeing more code. Can you please try to reproduce the bug in a minified project or link to your current one if it is open source? Please make sure to link to a recent build log as well then.
ottojimb
Thanks for answer.
Is hard to reproduce the bug in a minified project, it’s an umbrella app with micro services on rabbitmq.
The images I tried:
mdillon/postgis:9.1
postgres/9.6
The full log: elixir.log
Thank you again.
OvermindDL1
Hmm, that usually happens when you hop servers on a single Repo, you are not doing that on the CI are you?
ottojimb
The phoenix app is using the other 2 apps (users, core) through the umbrella. But testing on local, it doesn’t happen. It is the compose configuration
If you refers about run queries from another machines/databases, it’s doesn’t happen.
Thank you!
OvermindDL1
Huh, that is really confusing, that error really indicates that the server connection got swapped, it cached type information from the old one but the new one does not have it because it was already cached in ecto. The postgresql testing server does not get restarted or reset or anything like that at any point during the entire testing run?