This is a post is a very condensed version of my last 24hrs, although it hasn’t actually worked yet so i’m also hoping someone will post where it went wrong below this. My Discourse update failed due to a duplicate key, one of my tags is doubled up. To fix the update issue i needed to do a fresh Di…

[صورة] Drew: My Discourse update failed due to a duplicate key, one of my tags is doubled up. To fix the update issue i needed to do a fresh Discourse install Why? Why could you not fix this ‘online’ by restarting the app, entering the container, entering postgres and then dealing with the…

I wasn’t expecting the error so had already put the new version of Discourse onto my server. The duplicate key error was in the backup and not in the clean installed app, but i couldn’t restore the backup because it wanted the error fixed first. So i had to try and edit the tag inside the backup.

But you saw the error on update? Next time make your life easier and fix in place.

The app wasn’t running and i couldn’t reload it, so i updated to a fresh Discourse version in an attempt to fix that. Which meant that i didn’t have access to the database anywhere other than the backup. Certainly this is a niche case i’ve posted here, the better option would be to notice the issue…

No worries. At least you’ve shown it is possible, learned some new stuff and given others an additional option. Good work! :clap:

Thanks, although the original file was 128MB and the new one is 29MB, so i think rezipping on the server may have truncated the file due to its length. This process seems like it should work, but the file i ended up with could not be used to restore my discourse.

The path you took was more risky but surely doable? Maybe someone can chime in with some advice on this issue. You can presumably repeat this again from the backup so …

Is this problem resolved? It reads as if it’s a how-to, but it seems like your site is still broken. [صورة] Drew: This process seems like it should work, but the file i ended up with could not be used to restore my discourse. [صورة] Drew: The app wasn’t running and i couldn’t reload it …

Thanks for replying. [صورة] Jay Pfaffman: ./launcher start app to start the old container, was there a reaason that you couldn’t do that? It refused to start as we were a few upgrades behind, so i updated to the latest Discourse by creating a new one and uploading our old backup, but it reje…

[صورة] Jay Pfaffman: Is this problem resolved? It reads as if it’s a how-to I was hoping someone might see an error in it and correct me, so it would become a ‘how to’ guide.

تعديل قاعدة البيانات داخل نسخة احتياطية لإزالة وسم مفتاح مكرر لتجنب الفشل عند الاستعادة

الدعم تثبيت

merefield (Robert) 27 يوليو 2023، 12:48م 2

لماذا؟
لماذا لم تتمكن من إصلاح هذا “عبر الإنترنت” عن طريق إعادة تشغيل التطبيق، والدخول إلى الحاوية، والدخول إلى postgres ثم التعامل مع إدخال البيانات على الفور؟

الموضوع		الردود	مرات العرض
SQL Error during import Self-hosting	19	2369	3 مايو 2015
Can't restore due to corrupt indexes (with some clues on how to deal with corrupt indexes) Self-hosting	13	4764	5 فبراير 2020
Problems while updating from 3.0.0 to 3.0.1 Self-hosting	16	1259	14 يونيو 2023
Problem with restore Discourse from backup (3.4, quite large DB) Support	18	325	14 يناير 2025
Error restoring backup "key is duplicated" Self-hosting	8	1864	31 أغسطس 2017

تعديل قاعدة البيانات داخل نسخة احتياطية لإزالة وسم مفتاح مكرر لتجنب الفشل عند الاستعادة

الموضوعات ذات الصلة