#mastoadmins #mastoadmin #mastodev I have a question about a broken #Mastodon instance,maybe someone can help.The admin of https://embassy.social told me that he deleted many rows from the users table of his database because there were many users without toots or followers.Now the instance is broken in a way that no new user rows can be created,affecting federation in a way that no posts from users the instance hasn't seen before can arrive and following/getting followed by unknown users doesn't work,too.We were investigating this problem just now but we didn't find a solution to repair the instance.Here is the part of a log file,we get dozens of errors of this type per minute: https://paste.bka.li/view/c68f6cfd Maybe someone can help here?
I've just had an idea: it seems like the user id -99 is somehow hardcoded as 'representative' when the actual account is not found locally by username and domain - thus the name of the method. Maybe there is usually a dummy row with that id in the users table, which is being inserted on setup - and I deleted that one. It would have met my search criteria for the DELETE statement, as it wouldn't have any toots, follows, blocks etc since it is only a dummy record.
Can someone check with
SELECT * FROM users WHERE id=-99;
@thalon Tried it on my instance,found 0 results.
@nipos ich glaube ich hab es. Die Spur war gut, nur die table falsch. Es muss accounts sein, nicht users. Und dann hab ich noch etwas hilfreiches in live/db/seeds.rb gefunden. Da wird nämlich tatsächlich der Account -99 initialisiert. Das hab ich dann händisch auf der cli nachgeholt und jetzt findet Account.find(-99) wieder etwas.
@thalon Hab ich gerne gemacht.Und wenn es wieder mal Probleme gibt,einfach fragen.Ich bin zwar immer gestresst,aber wenn es irgendwie machbar ist,schau ich es mir an.
The social network of the future: No ads, no corporate surveillance, ethical design, and decentralization! Own your data with Mastodon!