Today’s upgrade to latest failed: FAILED -------------------- Pups::ExecError: cd /var/www/discourse && su discourse -c 'bundle exec rake db:migrate' failed with return #<Process::Status: pid 3194 exit 1> Location of failure: /pups/lib/pups/exec_command.rb:112:in `spawn' exec failed with the params…

[画像] Duplicate data explorer key blocking rebuild support Hey all, Rare I ask for help, but I’m puzzled about how to resolve this. Just rebuilt my site and getting this: discourse-data-explorer is already at latest compatible version I, [2020-08-28T17:53:57.578920 #1] …

Thanks, but I can’t get into the app: ./launcher enter app Error response from daemon: Container 694b24a2a235e90456fb0ca770c86ac14bb914ad33ada8a18fc4777a1188d848 is not running root@gaoa-discourse:/var/discourse# And also: root@gaoa-discourse:/var/discourse# su - postgres No passwd entry for user…

So restart the container? ./launcher start app Then you want something like: ./launcher enter app then: su postgres -c 'psql discourse'

Thanks! Not sure why it wasn’t starting the first time I tried. It looks like I have a duplicate “10” id: 4374 | discourse-data-explorer | q:-10 | JSON | {"id":-10,"name":"Inactive Users with no posts","description":"analyze pre-Discourse signups.","sql":"SELECT\ n u.id,\n u.username_lo…

The numbers in the ID column are 4374 and 4114. Delete the highest numbered one. Do NOT run DELETE from plugin_store_rows WHERE id = 10!! or you will delete the wrong entry!

Ah, so this? DELETE from plugin_store_rows WHERE id = 4374;

Yes. You should see the correct column header in the plsql query output no?

Now that you mention it, yes. I’d scrolled down because the output is like this: [psql output]

Yep, also, in general consider running commands to see their impact before committing, see: [画像] PostgreSQL - TRANSACTIONS - Tutorialspoint Then if you find you have deleted 500 rows when you meant to hit just one, you have the chance to rollback without fear.

Success! :tada: Thanks for the guidance @merefield . My DELETE command was missing a closing semicolon (updated above).

[画像] omarfilip: My DELETE command was missing a closing semicolon (updated above). Oh yes, that gets me every time :wink:

アップグレード失敗: UniqueViolation: 重複キーの値が一意制約 "data_explorer_queries_pkey" に違反しています

サポートインストール

merefield (Robert) 2020 年 9 月 10 日午後 7:57 4

コンテナを再起動しますか？

./launcher start app

次に、以下のようなコマンドを実行します：

./launcher enter app

その後：

su postgres -c 'psql discourse'

「いいね！」 4

Modifying the database inside of a backup to remove a duplicate key tag so that it doesn't fail when restoring

Problem after Discourse update

Urgent, upgraded build failed UniqueViolation

トピック		返信	表示
Duplicate data explorer key blocking rebuild Support	6	1096	2020 年 10 月 5 日
Upgrade failed with "duplicate key value violates unique constraint" error Self-hosting	18	2498	2020 年 3 月 30 日
2.7.0.beta2 upgrade failed with ERROR: duplicate key Self-hosting	25	2286	2021 年 2 月 25 日
Upgrade fails while migrating Self-hosting	6	906	2022 年 12 月 31 日
Update failed - PG::UniqueViolation: ERROR Self-hosting	8	842	2021 年 11 月 14 日

アップグレード失敗: UniqueViolation: 重複キーの値が一意制約 "data_explorer_queries_pkey" に違反しています

関連トピック