Trying to import a discourse backup ~ 3GB from version v1.3.0.beta5 +97 to latest-release +87. During the import the following sql issue [2015-04-21 08:34:05] psql:/var/www/discourse/tmp/restores/default/2015-04-21-083104/dump.sql:3781134: ERROR: could not create unique index "post_timings_unique" [2015-04-21 08:34:05] DETAIL: Key (topic_id, post_number, user_id)=(13868, 7, 6580) is duplicated. [2015-04-21 08:34:05] EXCEPTION: psql failed [2015-04-21 08:34:05] /var/www/discourse/lib/backup_restore/restorer.rb:217:in `restore_dump'

Your database may still contain old data. Destroy the Discourse container, then backup and delete /var/discourse/shared/standalone. Re-bootstrap and you should end up with a pristine, completely empty Discourse instance that should be able to import your backup. :slight_smile:

This new server has a clean discourse setup however it is perhaps possible from previous failed imports when the versions were initially further out. Will look into this. Thanks

If all else fails, you can delete that line from the import. (I suggest using nano or other terminal editor, NOT a gui editor, to do this, as the import dump.sql file can be large.)

I am the one with the problem. When editing the file, I get this. Trying to delete the line, I get this error when running the restore. The restore fails fairly quickly, right after starting to unzip, and before any text dump [2015-05-03 11:10:16] Marking restore as running... [2015-05-03 11:10:16] Making sure /var/www/discourse/tmp/restores/default/2015-05-03-111015 exists... [2015-05-03 11:10:16] Copying archive to tmp directory... [2015-05-03 11:11:15] Unzipping archive... [2015-05-03 11:13:05] Extracting metadata file... [2015-05-03 11:13:07] Validating metadata... [2015-05-03 11:13:07] Current version: 20150422160235 [2015-05-03 11:13:08] EXCEPTION: undefined method `[]' for nil:NilClass [2015-05-03 11:13:08] /var/www/discourse/lib/backup_restore/restorer.rb:176:in `validate_metadata' /var/www/discourse/lib/backup_restore/restorer.rb:35:in `run' /var/www/discourse/lib/backup_restore/backup_restore.rb:161:in `block in start!' /var/www/discourse/lib/backup_restore/backup_restore.rb:158:in `fork' /var/www/discourse/lib/backup_restore/backup_restore.rb:158:in `start!' /var/www/discourse/lib/backup_restore/backup_restore.rb:17:in `restore!' /var/www/discourse/app/controllers/admin/backups_controller.rb:74:in `restore' I do the following. I have renamed the backup to “original-cocos2d-forum-2015-05-01-041307.tar.gz” I then create a new folder: “mkdir cocos2d-forum-2015-05-01-041307” I unzip the original backup: “tar -xvzf original-cocos2d-forum-2015-05-01-041307.tar.gz -C cocos2d-forum-2015-05-01-041307” I switch to the folder, and fire up nano: “nano dump.sql” I goto the line by using Ctrl+_ and enter line 3864981. I edit the line from: “CREATE UNIQUE INDEX post_timings_unique ON post_timings USING btree (topic_id, post_number, user_id);” to “-- CREATE UNIQUE INDEX post_timings_unique ON post_timings USING btree (topic_id, post_number, user_id);” I Ctrl+O and Ctrl+X out of nano I switch back to backups/default folder, and create a tar.gz: “tar -cvzf cocos2d-forum-2015-05-01-041307.tar.gz cocos2d-forum-2015-05-01-041307” In FileZilla, it then looks like this [תמונה] I really hope you can help me. Cheers Lars

Try this to re-package your backup: tar -cvzf cocos2d-forum-2015-05-01-041307.tar.gz -C cocos2d-forum-2015-05-01-041307 .

The output log when compressing is slightly different, but the error is the same :frowning:

What’s the output of this command? tar -tzf cocos2d-forum-2015-05-01-041307.tar.gz

[תמונה] elberet: tar -tzf cocos2d-forum-2015-05-01-041307.tar.gz One gazillion lines, starting with root@forum:/var/discourse/shared/standalone/backups/default# tar -tzf cocos2d-forum-2015-05-01-041307.tar.gz ./ ./meta.json ./dump.sql ./uploads/ ./uploads/default/ ./uploads/default/5458/ ./uploads/default/5458/0c96160dc144e324.jpg ./uploads/default/3376/ ./uploads/default/3376/8e2243ed0572a63e.png ./uploads/default/3291/ ./uploads/default/3291/3f1ac78a77f0d55f.png ./uploads/default/2090/

That looks about right. Are you sure you actually restored that re-packaged backup and not the older version? And just to make sure, what’s the content of cocos2d-forum-2015-05-01-041307/meta.json?

meta.json is 47 bytes. A single line {“source”:“discourse”,“version”:20150422160235} Edit: Unless there is something tricky in the backup system, I am 99.9% certain it was the right file EditEdit: Not sure if it matters, but the original backup came from var/docker. The new install is located in var/discourse The original backup loads though, until the error in line 3.9Million

SQL Error during import

Product Support Self-hosting

Bahlsen (Bahlsen) 3 במאי,‏ 2015,‏ 3:20pm 14

Arghhh …

Made a new filename, which showed up in Admin->Backups, but same error …

נושא		תגובות	צפיות
Error restoring backup "key is duplicated" Self-hosting	7	2018	30 באוגוסט,‏ 2017
Failed to restore DB Self-hosting	9	1503	17 באוקטובר,‏ 2019
Modifying the database inside of a backup to remove a duplicate key tag so that it doesn't fail when restoring Self-hosting	28	1920	30 באוגוסט,‏ 2023
Backup restoration fails Self-hosting backups	16	592	16 ביוני,‏ 2026
Index_users_on_username_lower error during database restore: import failed Product Support	4	1484	17 בפברואר,‏ 2020

SQL Error during import

נושאים קשורים