Upgrade fails on duplicate key error ("index post hotlinked media on post id and url md5")

axfelix · May 3, 2022, 4:09pm

seems to be something to do with this recent commit?

discourse/discourse/blob/19d2d55011f5808bcbc177119765557a2900dea1/db/migrate/20220428094026_create_post_hotlinked_media.rb

# frozen_string_literal: true

class CreatePostHotlinkedMedia < ActiveRecord::Migration[6.1]
  def change
    reversible do |dir|
      dir.up do
        execute <<~SQL
          CREATE TYPE hotlinked_media_status AS ENUM('downloaded', 'too_large', 'download_failed', 'upload_create_failed')
        SQL
      end
      dir.down do
        execute <<~SQL
          DROP TYPE hotlinked_media_status
        SQL
      end
    end

    create_table :post_hotlinked_media do |t|
      t.bigint :post_id, null: false
      t.string :url, null: false

This file has been truncated. show original

@david

Topic		Replies	Views
Urgent, upgraded build failed UniqueViolation installation	24	1400	February 20, 2021
Error during upgrading from Beta 3.1.x to latest installation	3	725	January 20, 2023
Upgrades failing on migration with unique constraint violation support	5	869	November 8, 2019
2.7.0.beta2 upgrade failed with ERROR: duplicate key installation	25	1956	February 25, 2021
Upgrade Issues: Failed Upgrade due to Duplicate Key, Failed Snapshot Restore installation	7	1494	April 25, 2023

Upgrade fails on duplicate key error ("index post hotlinked media on post id and url md5")

Related Topics