After reastart both db and its backup make pleroma return 500 error
Hey, So my instance on a Pi restarted unexpectedly. DB is sitting on an external haddrive. I got the following error. Also after restoring the DB from 24 hours earlier I got the same error: When looking in adminer it looks like the database is intact. But I don't see it working at all, including the name of the instance is not appearing in the login page:
pleroma-db | 2020-12-11 10:27:20.311 UTC [37] ERROR: column u1.locked does not exist at character 499
pleroma-db | 2020-12-11 10:27:20.311 UTC [37] STATEMENT: SELECT o0."id", o0."token", o0."refresh_token", o0."scopes", o0."valid_until", o0."user_id", o0."app_id", o0."inserted_at", o0."updated_at", u1."id", u1."bio", u1."raw_bio", u1."email", u1."name", u1."nickname", u1."password_hash", u1."keys", u1."public_key", u1."ap_id", u1."avatar", u1."local", u1."follower_address", u1."following_address", u1."tags", u1."last_refreshed_at", u1."last_digest_emailed_at", u1."banner", u1."background", u1."note_count", u1."follower_count", u1."following_count", u1."locked", u1."confirmation_pending", u1."password_reset_pending", u1."approval_pending", u1."registration_reason", u1."confirmation_token", u1."default_scope", u1."domain_blocks", u1."deactivated", u1."no_rich_text", u1."ap_enabled", u1."is_moderator", u1."is_admin", u1."show_role", u1."mastofe_settings", u1."uri", u1."hide_followers_count", u1."hide_follows_count", u1."hide_followers", u1."hide_follows", u1."hide_favorites", u1."unread_conversation_count", u1."pinned_activities", u1."email_notifications", u1."mascot", u1."emoji", u1."pleroma_settings_store", u1."fields", u1."raw_fields", u1."discoverable", u1."invisible", u1."allow_following_move", u1."skip_thread_containment", u1."actor_type", u1."also_known_as", u1."inbox", u1."shared_inbox", u1."accepts_chat_messages", u1."notification_settings", u1."blocks", u1."mutes", u1."muted_reblogs", u1."muted_notifications", u1."subscribers", u1."multi_factor_authentication_settings", u1."inserted_at", u1."updated_at" FROM "oauth_tokens" AS o0 INNER JOIN "users" AS u1 ON u1."id" = o0."user_id" WHERE (o0."token" = $1)
pleroma |
pleroma | 10:27:20.316 request_id=Fk-iqV48fNwab9r4AAUk [error] Internal server error: %Postgrex.Error{connection_id: 37, message: nil, postgres: %{code: :undefined_column, file: "parse_relation.c", line: "3349", message: "column u1.locked does not exist", pg_code: "42703", position: "499", routine: "errorMissingColumn", severity: "ERROR", unknown: "ERROR"}, query: "SELECT o0.\"id\", o0.\"token\", o0.\"refresh_token\", o0.\"scopes\", o0.\"valid_until\", o0.\"user_id\", o0.\"app_id\", o0.\"inserted_at\", o0.\"updated_at\", u1.\"id\", u1.\"bio\", u1.\"raw_bio\", u1.\"email\", u1.\"name\", u1.\"nickname\", u1.\"password_hash\", u1.\"keys\", u1.\"public_key\", u1.\"ap_id\", u1.\"avatar\", u1.\"local\", u1.\"follower_address\", u1.\"following_address\", u1.\"tags\", u1.\"last_refreshed_at\", u1.\"last_digest_emailed_at\", u1.\"banner\", u1.\"background\", u1.\"note_count\", u1.\"follower_count\", u1.\"following_count\", u1.\"locked\", u1.\"confirmation_pending\", u1.\"password_reset_pending\", u1.\"approval_pending\", u1.\"registration_reason\", u1.\"confirmation_token\", u1.\"default_scope\", u1.\"domain_blocks\", u1.\"deactivated\", u1.\"no_rich_text\", u1.\"ap_enabled\", u1.\"is_moderator\", u1.\"is_admin\", u1.\"show_role\", u1.\"mastofe_settings\", u1.\"uri\", u1.\"hide_followers_count\", u1.\"hide_follows_count\", u1.\"hide_followers\", u1.\"hide_follows\", u1.\"hide_favorites\", u1.\"unread_conversation_count\", u1.\"pinned_activities\", u1.\"email_notifications\", u1.\"mascot\", u1.\"emoji\", u1.\"pleroma_settings_store\", u1.\"fields\", u1.\"raw_fields\", u1.\"discoverable\", u1.\"invisible\", u1.\"allow_following_move\", u1.\"skip_thread_containment\", u1.\"actor_type\", u1.\"also_known_as\", u1.\"inbox\", u1.\"shared_inbox\", u1.\"accepts_chat_messages\", u1.\"notification_settings\", u1.\"blocks\", u1.\"mutes\", u1.\"muted_reblogs\", u1.\"muted_notifications\", u1.\"subscribers\", u1.\"multi_factor_authentication_settings\", u1.\"inserted_at\", u1.\"updated_at\" FROM \"oauth_tokens\" AS o0 INNER JOIN \"users\" AS u1 ON u1.\"id\" = o0.\"user_id\" WHERE (o0.\"token\" = $1)"}
pleroma |
pleroma | 10:27:20.319 request_id=Fk-iqV48fNwab9r4AAUk [info] Converted error Postgrex.Error to 500 response
What can I do about this? You can take a look at https://hayu.sh