#mastoadmins #mastoadmin #mastodev I have a question about a broken #Mastodon instance,maybe someone can help.The admin of 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: 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.
@nipos

Can someone check with
SELECT * FROM users WHERE id=-99;

@nipos

@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 Ah,sehr schoen.Wenn man weiss,wonach man suchen muss,ist es manchmal erstaunlich einfach.Freut mich,dass es wieder richtig funktioniert 🎉

Follow

@nipos Danke dir auf jeden Fall für die Hilfe!

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

@thalon
Uih, hast Du es wieder hinbekommen? 😍 Du bist mein Held! 😘
@nipos

Sign in to participate in the conversation
Embassy of Awesomeness

The social network of the future: No ads, no corporate surveillance, ethical design, and decentralization! Own your data with Mastodon!