Clojurians Log v2
Clojure programming
Channels
Apps
datomic
Ask questions on the official Q&A site at https://ask.datomic.com!
yubrshen 2020-11-01T02:55:38.251700Z
What's the meaning of the following error message, and how can I investigate and fix it?
:db.error/lookup-ref-attr-not-unique Attribute values not unique: :user/email(ns grok.db.add-user
(:require [grok.db.core :as SUT]
[grok.db.schema :refer [schema]]
[datomic.api :as d]))
(def sample-user
{:user/id (d/squuid)
:user/email "<mailto:test@test.com|test@test.com>"
:user/password "password12345"})
(defn fresh-db []
(let [db-uri (str "datomic:mem://" (gensym))
conn (SUT/create-conn db-uri)]
(d/transact conn schema)
(d/transact conn [sample-user])
conn))
(def conn (fresh-db))
conn
(d/entity (d/db conn) [:user/email "<mailto:test@test.com|test@test.com>"])[
;; ## User
;; - id (uuid)
;; - full-name (string)
;; - username (string)
;; - email (string => unique)
;; - password (string => hashed)
;; - token (string)
{:db/ident :user/id
:db/valueType :db.type/uuid
:db/cardinality :db.cardinality/one
:db/unique :db.unique/identity
:db/doc "ID of the User"}
{:db/ident :user/email
:db/valueType :db.type/string
:db/cardinality :db.cardinality/one
:db/doc "Email of the User"}
{:db/ident :user/password
:db/valueType :db.type/string
:db/cardinality :db.cardinality/one
:db/doc "Hashed Password of the User"}
](defn create-conn [db-uri]
(when db-uri
(d/create-database db-uri)
(let [conn (d/connect db-uri)]
conn)))2. Unhandled clojure.lang.Compiler$CompilerException
Error compiling test/grok/db/add_user.clj at (21:1)
#:clojure.error{:phase :compile-syntax-check,
:line 21,
:column 1,
:source
"/home/yshen/programming/clojure/learn-immutable-stack-with-live-coding-ankie/grok/server/test/grok/db/add_user.clj"}
Compiler.java: 7648 clojure.lang.Compiler/load
REPL: 1 user/eval19658
REPL: 1 user/eval19658
Compiler.java: 7177 clojure.lang.Compiler/eval
Compiler.java: 7132 clojure.lang.Compiler/eval
core.clj: 3214 clojure.core/eval
core.clj: 3210 clojure.core/eval
interruptible_eval.clj: 87 nrepl.middleware.interruptible-eval/evaluate/fn/fn
AFn.java: 152 clojure.lang.AFn/applyToHelper
AFn.java: 144 clojure.lang.AFn/applyTo
core.clj: 665 clojure.core/apply
core.clj: 1973 clojure.core/with-bindings*
core.clj: 1973 clojure.core/with-bindings*
RestFn.java: 425 clojure.lang.RestFn/invoke
interruptible_eval.clj: 87 nrepl.middleware.interruptible-eval/evaluate/fn
main.clj: 437 clojure.main/repl/read-eval-print/fn
main.clj: 437 clojure.main/repl/read-eval-print
main.clj: 458 clojure.main/repl/fn
main.clj: 458 clojure.main/repl
main.clj: 368 clojure.main/repl
RestFn.java: 137 clojure.lang.RestFn/applyTo
core.clj: 665 clojure.core/apply
core.clj: 660 clojure.core/apply
regrow.clj: 20 refactor-nrepl.ns.slam.hound.regrow/wrap-clojure-repl/fn
RestFn.java: 1523 clojure.lang.RestFn/invoke
interruptible_eval.clj: 84 nrepl.middleware.interruptible-eval/evaluate
interruptible_eval.clj: 56 nrepl.middleware.interruptible-eval/evaluate
interruptible_eval.clj: 152 nrepl.middleware.interruptible-eval/interruptible-eval/fn/fn
AFn.java: 22 clojure.lang.AFn/run
session.clj: 202 nrepl.middleware.session/session-exec/main-loop/fn
session.clj: 201 nrepl.middleware.session/session-exec/main-loop
AFn.java: 22 clojure.lang.AFn/run
Thread.java: 834 java.lang.Thread/run
1. Caused by datomic.impl.Exceptions$IllegalArgumentExceptionInfo
:db.error/lookup-ref-attr-not-unique Attribute values not unique: :user/email
{:cognitect.anomalies/category :cognitect.anomalies/incorrect,
:cognitect.anomalies/message "Attribute values not unique: :user/email",
:db/error :db.error/lookup-ref-attr-not-unique}
error.clj: 79 datomic.error/arg
error.clj: 74 datomic.error/arg
error.clj: 77 datomic.error/arg
error.clj: 74 datomic.error/arg
db.clj: 590 datomic.db/resolve-lookup-ref
db.clj: 569 datomic.db/resolve-lookup-ref
db.clj: 610 datomic.db/extended-resolve-id
db.clj: 606 datomic.db/extended-resolve-id
db.clj: 621 datomic.db/resolve-id
db.clj: 614 datomic.db/resolve-id
db.clj: 2295 datomic.db.Db/entity
api.clj: 171 datomic.api/entity
api.clj: 169 datomic.api/entity
add_user.clj: 21 grok.db.add-user/eval19672
add_user.clj: 21 grok.db.add-user/eval19672
Compiler.java: 7177 clojure.lang.Compiler/eval
Compiler.java: 7636 clojure.lang.Compiler/load
REPL: 1 user/eval19658
REPL: 1 user/eval19658
Compiler.java: 7177 clojure.lang.Compiler/eval
Compiler.java: 7132 clojure.lang.Compiler/eval
core.clj: 3214 clojure.core/eval
core.clj: 3210 clojure.core/eval
interruptible_eval.clj: 87 nrepl.middleware.interruptible-eval/evaluate/fn/fn
AFn.java: 152 clojure.lang.AFn/applyToHelper
AFn.java: 144 clojure.lang.AFn/applyTo
core.clj: 665 clojure.core/apply
core.clj: 1973 clojure.core/with-bindings*
core.clj: 1973 clojure.core/with-bindings*
RestFn.java: 425 clojure.lang.RestFn/invoke
interruptible_eval.clj: 87 nrepl.middleware.interruptible-eval/evaluate/fn
main.clj: 437 clojure.main/repl/read-eval-print/fn
main.clj: 437 clojure.main/repl/read-eval-print
main.clj: 458 clojure.main/repl/fn
main.clj: 458 clojure.main/repl
main.clj: 368 clojure.main/repl
RestFn.java: 137 clojure.lang.RestFn/applyTo
core.clj: 665 clojure.core/apply
core.clj: 660 clojure.core/apply
regrow.clj: 20 refactor-nrepl.ns.slam.hound.regrow/wrap-clojure-repl/fn
RestFn.java: 1523 clojure.lang.RestFn/invoke
interruptible_eval.clj: 84 nrepl.middleware.interruptible-eval/evaluate
interruptible_eval.clj: 56 nrepl.middleware.interruptible-eval/evaluate
interruptible_eval.clj: 152 nrepl.middleware.interruptible-eval/interruptible-eval/fn/fn
AFn.java: 22 clojure.lang.AFn/run
session.clj: 202 nrepl.middleware.session/session-exec/main-loop/fn
session.clj: 201 nrepl.middleware.session/session-exec/main-loop
AFn.java: 22 clojure.lang.AFn/run
Thread.java: 834 java.lang.Thread/run
Jakub Holý 2020-11-01T21:49:50.261600Z
I guess "lookup ref attr not declared as :db/unique" would be a more helpful error message.
yubrshen 2020-11-02T02:10:54.264Z
It's strange that once I added :db/unique to the existing schema without transacting, but just evaluate the schema definition, it works for retrieving the user by email address.
But later, when I actually transacted the updated schema, then I run into trouble of "Error: {:db/error :db.error/unique-without-index, :attribute :user/email}"
favila 2020-11-01T03:26:14.254500Z
The schema for :user/email does not include a :db/unique constraint, therefore you cannot use this attribute for lookups as you do in your d/entity call
favila 2020-11-01T03:27:35.255500Z
Thus “lookup ref attr not unique” in the error message
yubrshen 2020-11-01T03:33:14.255700Z
@favila Thanks for the quick and effective help!
yubrshen 2020-11-01T18:53:44.261300Z
How do I fix this error?
"Error: {:db/error :db.error/unique-without-index, :attribute :user/email}"
The error happened when I added more entities to the schema and did (d/transact conn schema) again to update the schema.
This is a consequence of my prior error referred in https://clojurians.slack.com/archives/C03RZMDSH/p1604199338251700 where I had to change my schema to add :db/unique constraint to :user/email
I wouldn't mind to start from scratch with a new database. But I have not learned how to do that yet.
But if it were in a production system, when I modify my schema, what's the proper way to correct and update?
favila 2020-11-02T12:18:59.275200Z
Are you using cloud or on prem? You cite cloud docs but this sounds like an on-prem problem. (Cloud indexs all values by default)
favila 2020-11-02T12:20:01.276300Z
On on-prem, there is a :db/index true
yubrshen 2020-11-02T15:09:55.278200Z
I'm using on-prem, actually just dev one. I'll take look of :db/index tree @favila Thanks for the pointer!
favila 2020-11-02T15:10:36.278500Z
https://docs.datomic.com/on-prem/schema.html#altering-schema-attributes
favila 2020-11-02T15:10:59.278700Z
> All alterations happen synchronously, except for adding an AVET index. If you want to know when the AVET index is available, call https://docs.datomic.com/on-prem/javadoc/datomic/Connection.html#syncSchema(long). In order to add :db/unique, you must first have an AVET index including that attribute.
favila 2020-11-02T15:11:02.278900Z
(quote from the docs)
yubrshen 2020-11-02T15:25:04.279100Z
@favila Yes, the following worked:
(def tx-add-index @(d/transact conn [{:db/id :user/email
:db/index true}]))
(def tx-fix @(d/transact conn [{:db/id :user/email
:db/unique :db.unique/identity}]))conn is a connection to the on-prem (dev) database.
Thanks again for your coaching!Jakub Holý 2020-11-01T21:53:24.261800Z
I wish there was a catalog of datomic errors with explanations and guidance. Searching the net for "datomic unique-wirhout-index&t" yields nothing :-(
favila 2020-11-01T21:56:29.263100Z
You need a value index before you can make a value unique. See the docs on schema changes, it has a table of all legal transitions