Fresh Installation fails because user email violates unique constraint (lemmy.ml)

submitted 1 year ago* (last edited 1 year ago) by db0@lemmy.ml to c/lemmy_support@lemmy.ml

2 comments fedilink hide all child comments

I am trying to install Lemmy, I am using a modified ansible role so that it deploys the DB on an external postgresql instead of a docker one.

Installation always fails with

lemmy_1     | thread 'main' panicked at 'couldnt create local user: DatabaseError(UniqueViolation, "duplicate key value violates unique constraint \"local_user_email_key\"")', crates/db_schema/src/impls/local_us
er.rs:157:8

The tables seem created and the admin user exists in them, so I'm not sure what else it's trying to create and has a duplicate email.

Earlier I also noticed this once, but I don't know if it's relevant

lemmy_1     | Error: LemmyError { message: None, inner: value too long for type character varying(20), context: "SpanTrace" }

This one only seems to appeared the one time.

I tried dropping and recreating the DB. same issue everytime.

you are viewing a single comment's thread
view the rest of the comments

[-] db0@lemmy.ml 1 points 1 year ago

I dropped the contraints manually to test, and it indeed seems to create the admin account 3 times for some reason!

[-] db0@lemmy.ml 1 points 1 year ago

Worse. Restarting the container, seems to keep recreating that user 3 times again. Then always fails with

lemmy_1     | Error: LemmyError { message: None, inner: value too long for type character varying(20), context: "SpanTrace" }

this post was submitted on 09 Jun 2023

1 points (100.0% liked)

Lemmy Support

4651 readers

1 users here now

Support / questions about Lemmy.

Matrix Space: #lemmy-space

founded 5 years ago

MODERATORS

dessalines@lemmy.ml