db0

joined 3 years ago
MODERATOR OF
piracy
sorted by: new top controversial old
current lemmy status in c/memes@lemmy.ml
[–] db0@lemmy.ml 6 points 2 years ago

https://lemmy.dbzer0.com for generative ai, neurodivergence, and anarchism and copylefts

New official /r/piracy fallback community in c/piracy@lemmy.ml
[–] db0@lemmy.ml 11 points 2 years ago (1 children)

I think it's ok to have both. Eventually this will be implemented which will make this moot: https://github.com/LemmyNet/lemmy/issues/818

But also, I think lemmy won't be able to handle the load well and they won't hear my advice on how to prepare, so I think it's better I take responsibility for the community I've been nurturing for the past 10 years, myself

Fresh Installation fails because user email violates unique constraint in c/lemmy_support@lemmy.ml
[–] db0@lemmy.ml 1 points 2 years ago

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

2
Fresh Installation fails because user email violates unique constraint (lemmy.ml)
submitted 2 years ago* (last edited 2 years ago) by db0@lemmy.ml to c/lemmy_support@lemmy.ml
1 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.

How much money does Lemmy.ml need to temporarily boost their servers? in c/lemmy@lemmy.ml
[–] db0@lemmy.ml 1 points 2 years ago

Even if you choose Hetzner, it won't even know it has anything to do with piracy because it will be just hosting the DB, and nobody will know where your DB is. That fear is overblown.

Likewise believe me a dedicated server is night and day from a VPS.

Piracy on FHMY in c/piracy@lemmy.ml
How much money does Lemmy.ml need to temporarily boost their servers? in c/lemmy@lemmy.ml
[–] db0@lemmy.ml 1 points 2 years ago (2 children)

Do you have the frontend a DB serving in the same VPS? If so it would be a great time to split them. Likewise if you DB is running in a VPS, you're likely suffering from significant steal from the hypervisor so you would benefit from switching to a dedicated box. My API calls saw a speedup of 10x just from switching from a VPS DB to a Dedicated Box DB.

I just checked OVH VPS offers and they're shit! Even at 70 Eur dedicated on hetzner, you would gain more than double those resources without steal. I would recommend switching your DB ASAP for immediate massive gains.

If you're wondering why you should listen to me, I built and run https://aihorde.net and are handling about 5K concurrent connections currently.

Piracy on FHMY in c/piracy@lemmy.ml
[–] db0@lemmy.ml 1 points 2 years ago (1 children)

yes I know.

Piracy on FHMY in c/piracy@lemmy.ml
[–] db0@lemmy.ml 2 points 2 years ago (3 children)

@dessalines@lemmy.ml can a user from a different instance be a mod in a community in lemmy.ml? Would be nice to have mod access from elsewhere in case lemmy.ml goes down.

11
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/piracy@lemmy.ml
[–] db0@lemmy.ml 0 points 3 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/piracy@lemmy.ml
[–] db0@lemmy.ml 0 points 3 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.

-1
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.