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	1524	February 20, 2021
Restore fails with "hotlinked_media_status" already exists Support	7	43	November 14, 2024
Error during upgrading from Beta 3.1.x to latest Installation	3	805	January 20, 2023
Upgrades failing on migration with unique constraint violation Support	5	939	November 8, 2019
Restored Site - URLS need to be corrected, any ideas? Support	11	113	April 11, 2025

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

Related topics