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.

  • Beto@lemmy.studio
    link
    fedilink
    English
    arrow-up
    1
    ·
    1 year ago

    This happened with me because I was adding an admin account explicitly to the hjson file. Once I removed that everything worked.

    • Divided by Zer0@lemmy.mlOP
      link
      fedilink
      English
      arrow-up
      2
      ·
      1 year ago

      I was doing that as well, but it wasn’t the problem. The problem was apparently caused by a too-long site name