I believe both the production and dev sites have that index:
[91] pry(main)> PluginStoreRow.connection.indexes(“plugin_store_rows”)
=> [#<ActiveRecord::ConnectionAdapters::IndexDefinition:0x00005556a36241d0
@columns=[“plugin_name”, “key”],
@comment=nil,
@lengths={},
@name=“index_plugin_store_rows_on_plugin_name_and_key”,
@opclasses={},
@orders={},
@table=“plugin_store_rows”,
@type=nil,
@unique=true,
@using=:btree,
@where=nil>]
I removed them with:
PluginStoreRow.find(< id >).destroy
After removing the duplicates, I made a backup and was able to successfully restore to a clean install. So I’ve determined that’s the issue with backups failing. I’ll move this to a new Data Explorer bug topic tomorrow. Wish I could repro it though.