princemaple
Different IDs getting conflicts
Ok this is… more than weird
It’s also consistent during insert_all with conflicts. I’m trying to back fill some missing data from backup, but can’t because the db thinks they are already there…
I can’t have 20+ uuids with conflicts, right? That’d be too luck. I checked they are totally different from what’s coming back from the db. Repo.all(from x in X, where: x.id in ^my_ids) I get these 20+ results with totally different ids, but consistent!
Trending in Questions
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
Producing high quality Elixir screencasts since 2017.
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
- #elixirconf-us
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #metaprogramming
- #hex
- #performance
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.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Develop your skills with books, videos, and courses.
Bringing learning, work and compliance together since 1987.
The deployment platform built for Elixir: PaaS ease, VPS control.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
First 10 of 23 Posts
dimitarvp
Can you show us what does
v()do?garrison
It’s an iex helper that returns the last line, essentially. I actually didn’t know about this one because I never use iex
princemaple
Yup. The screenshot is a remote iex. v() simply refers to the previous return value.
princemaple
Sorry if it’s confusing. The tldr for this is: If I `Repo.get X, “abc”` I would expect an entry of X with id abc to be returned. Here it’s giving me something different.
Same thing during insert_all, it thinks something with a different id conflicts with the entry am trying to insert.
princemaple
You can also do v(-2) to get the second last result.
And v(line_number) to get a specific line.
jswanner
@princemaple,
odd question, but just making sure…
Is
idthe primary key field on the schema?garrison
That is certainly odd! I think you need to do some more debugging here, though. There’s not really anything for us to go off of.
Is
idthe primary key? What is theidin the actual database? What is the DB schema? Could there be something weird going on with autogenerate? The changeset? Etc.princemaple
Yes
haha
jswanner
On slack you said this was a remote console, are you seeing the same behavior locally? Have you checked the generated query, or tried via
psql(or other db client)?princemaple
Yes id is pk
I also suspected something with ecto or auto generate, hence the test at the top, about uuid dumping and loading. All seems good. It almost seems a pg problem but that would be too crazy to be true.