Notices by ヒドロ???? (oh@v1x3n.net), page 45

【BOFU2017】妄想製造傘下【BGA】 https://youtu.be/iTZQsDgDKNk
譜面以外完璧では

migrate失敗しちゃったもんな

v2.6.1に上げた人へ、pgHeroでDuplicate Indexesって出てますか

本当にインスタンスが生きているのか、この先生きのこれるか不安

インスタンスが生きている実感が欲しいからふぁぼって欲しい

なぜ、生きている

祝:インスタンス復活

Duplicate Indexes

These indexes exist, but aren’t needed. Remove them with a migration for faster writes.
Details
On account_conversations

index_account_conversations_on_account_id (account_id)

is covered by

index_unique_conversations (account_id, conversation_id, participant_account_ids)

On account_pins

index_account_pins_on_account_id (account_id)

is covered by

index_account_pins_on_account_id_and_target_account_id (account_id, target_account_id)

mastodon@mastodon_production ERROR: relation "pg_stat_statements" does not exist at character 15

mastodon@mastodon_production ERROR: duplicate key value violates unique constraint "index_conversations_on_uri"

うーん

@ars42525 私には分からないですね……まだたまに何かが間違ったりするみたいです……

@ars42525 git reset --hardを通したらとりあえず蘇生した感じがします

@ars42525
(Webpacker can't find mastodon-ui.png in /home/mastodon/live/public/packs/manifest.json. Possible causes:
: 1. You want to set webpacker.yml value of compile to true for your environment
: unless you are using the `webpack -w` or the webpack-dev-server.
: 2. webpack has not yet re-run to reflect updates.
: 3. You have misconfigured Webpacker's config/webpacker.yml file.
: 4. Your webpack configuration is not creating a manifest.
: Your manifest contains:

Migrating to RemoveFauxRemoteAccountDuplicates (20181026034033)
== 20181026034033 RemoveFauxRemoteAccountDuplicates: migrating ================
== 20181026034033 RemoveFauxRemoteAccountDuplicates: migrated (0.0100s) =======

WARNING: you don't own a lock of type ExclusiveLock
rails aborted!
ActiveRecord::ConcurrentMigrationError:

Failed to release advisory lock

@ars42525 ActionView::Template::Error (Webpacker can't find
もしかするとこれなのでしょうか

弊インスタンスの人へ
フォローをエクスポートしろ……

AWSのスナップショットしかないゾ

migrateで死ぬとヤバいんだなあって……

最後のバックアップ2ヶ月前で草も生えない……