db0

joined 3 years ago
MODERATOR OF
piracy
sorted by: new top controversial old
Fresh Installation fails because user email violates unique constraint in c/[email protected]
[–] [email protected] 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" }
Fresh Installation fails because user email violates unique constraint in c/[email protected]
[–] [email protected] 1 points 1 year ago (1 children)

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

1
Fresh Installation fails because user email violates unique constraint (lemmy.ml)
submitted 1 year ago* (last edited 1 year ago) by [email protected] to c/[email protected]
2 comments fedilink
 

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.

9
Lemmy announced as the primary fallback of /r/piracy (www.reddit.com)
I'm the top mod of /r/piracy in reddit. Can I get a mod position? in c/[email protected]
[–] [email protected] 0 points 2 years ago (10 children)

Years of prime advice was nuked when you erased everything but the last 6 months of history.

You realize the alternative was to lose the subreddit to the reddit admins, yes?

I'm the top mod of /r/piracy in reddit. Can I get a mod position? in c/[email protected]
[–] [email protected] 0 points 2 years ago (12 children)

If I am going to redirect all the sizable community of reddit /r/piracy to a safe haven, I feel I have a responsibility to make sure that the destination is well run. The only way I can do that is to be a mod.

-2
I'm the top mod of /r/piracy in reddit. Can I get a mod position? (www.reddit.com)
 

Hey y'all, In the past I had arranged that /f/piracy in raddle.me would be the fallback forum for /r/piracy, but I recently noticed that raddle.me has disabled new user registrations and that would be a problem in case we need it.

And with reddit about to go public, it might be needed.

Instead of trying to spin up my own lemmy instance, I was thinking if I could get a mod position in this forum and specify it as the official /r/piracy fallback instead.

Feel free to PM me in reddit for verification.