this post was submitted on 23 Jun 2023
95 points (99.0% liked)

Lemmy

12524 readers
3 users here now

Everything about Lemmy; bugs, gripes, praises, and advocacy.

For discussion about the lemmy.ml instance, go to [email protected].

founded 4 years ago
MODERATORS
 

I have the application process enabled for people to join my instance, and I've gotten about 20 bots trying to join today when I had nobody trying to join for 5 days. I can tell because they are generic messages and I put a question in asking what 2+3 is and none of them have answered it at all, they just have a generic message.

Be careful out there, for all you small instance admins.

you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 4 points 1 year ago (1 children)

... How many comments would each of 5M bot accounts need to make to overflow an i32 db key ... I also think it looks as if someone is testing disruptive stuff. It may be kids playing, or it may be the chatbot army in preparation.

[–] [email protected] 2 points 1 year ago (1 children)

I'm not a Postgres expert but a quick look at the pgsql limits looks like it's 4 billion by default, which uh, makes sense if it's a 32 bit limit.

Soooo 5 million users would need to make.... 800 posts? ish? I mean, certainly doable if nobody caught it was happening until it was well into it.

[–] [email protected] 2 points 1 year ago

Aha that's a postgres default? I was looking into the code to see some of the DB structure. And i thought, well i made over 100 comments in 2 weeks so it wouldn't take too long until that 32-bit space is used up (in normal operation with some more users).