# 16551个上传中有1个未迁移到S3。数据库'default'的S3迁移失败。 **URL:** \ **Category:** Self-hosting\ **Tags:** cdn, s3\ **Created:** [2023 年2 月 21 日 11:56 UTC](https://meta.discourse.org/t/1-of-16551-uploads-are-not-migrated-to-s3-s3-migration-failed-for-db-default/255772 "2023-02-21T11:56:04Z")\ **Posts on this page:** 1\ **Showing post:** 16
作者： ![pawelorzech](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pawelorzech/32/251878_2.png) [@pawelorzech](https://meta.discourse.org/u/pawelorzech)\ 发布日期： [2023 年5 月 7 日 01:16 UTC](https://meta.discourse.org/t/1-of-16551-uploads-are-not-migrated-to-s3-s3-migration-failed-for-db-default/255772/16 "2023-05-07T01:16:56Z")
我今天又试了一次——进行了全新安装，然后从备份恢复。到处都是同样的错误。无法看到缺少了哪 1 个媒体文件，这个 `1 of 16545 uploads are not migrated to S3. S3 migration failed for db 'default'.` 还会继续困扰我。 顶一下这个帖子，也许有人能帮忙…… 更多信息。这发生在 Discourse (在 Docker 中)： ```plaintext root@forum-app:/var/www/discourse# rake uploads:missing -------------------------------------------------------------------------------- WARNING! WARNING! WARNING! -------------------------------------------------------------------------------- default has uploads on S3! validating without inventory is likely to take an enormous amount of time. We recommend you run SKIP_EXTERNAL=1 rake uploads:missing to skip validating if on a multisite. rake aborted! PG::SyntaxError: ERROR: syntax error at end of input LINE 1: INSERT INTO verified_ids VALUES ^ /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rack-mini-profiler-3.1.0/lib/patches/db/pg.rb:56:in `exec' /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rack-mini-profiler-3.1.0/lib/patches/db/pg.rb:56:in `exec' /var/www/discourse/lib/file_store/s3_store.rb:423:in `list_missing' /var/www/discourse/lib/file_store/s3_store.rb:303:in `list_missing_uploads' /var/www/discourse/lib/tasks/uploads.rake:277:in `list_missing_uploads' /var/www/discourse/lib/tasks/uploads.rake:270:in `block (2 levels) in
' /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rails_multisite-4.0.1/lib/rails_multisite/connection_management.rb:80:in `with_connection' /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rails_multisite-4.0.1/lib/rails_multisite/connection_management.rb:90:in `each_connection' /var/www/discourse/lib/tasks/uploads.rake:255:in `block in
' /var/www/discourse/lib/tasks/uploads.rake:281:in `block in
' /usr/local/bin/bundle:25:in `load' /usr/local/bin/bundle:25:in `
' Tasks: TOP => uploads:missing_files (See full trace by running task with --trace) ``` 和 ```plaintext root@forum-app:/var/www/discourse# rake uploads:missing_files -------------------------------------------------------------------------------- WARNING! WARNING! WARNING! -------------------------------------------------------------------------------- default has uploads on S3! validating without inventory is likely to take an enormous amount of time. We recommend you run SKIP_EXTERNAL=1 rake uploads:missing to skip validating if on a multisite. rake aborted! PG::SyntaxError: ERROR: syntax error at end of input LINE 1: INSERT INTO verified_ids VALUES ^ /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rack-mini-profiler-3.1.0/lib/patches/db/pg.rb:56:in `exec' /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rack-mini-profiler-3.1.0/lib/patches/db/pg.rb:56:in `exec' /var/www/discourse/lib/file_store/s3_store.rb:423:in `list_missing' /var/www/discourse/lib/file_store/s3_store.rb:303:in `list_missing_uploads' /var/www/discourse/lib/tasks/uploads.rake:277:in `list_missing_uploads' /var/www/discourse/lib/tasks/uploads.rake:270:in `block (2 levels) in
' /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rails_multisite-4.0.1/lib/rails_multisite/connection_management.rb:80:in `with_connection' /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rails_multisite-4.0.1/lib/rails_multisite/connection_management.rb:90:in `each_connection' /var/www/discourse/lib/tasks/uploads.rake:255:in `block in
' /usr/local/bin/bundle:25:in `load' /usr/local/bin/bundle:25:in `
' Tasks: TOP => uploads:missing_files (See full trace by running task with --trace) ``` 然后： ```plaintext root@forum-app:/var/www/discourse# rake posts:missing_uploads Looking for missing uploads on: default 0 post uploads are missing. root@forum-app:/var/www/discourse# ``` 还有——重头戏——_rake uploads:migrate\_to\_s3 --trace_ ```plaintext root@forum-app:/var/www/discourse# rake uploads:migrate_to_s3 --trace ** Invoke uploads:migrate_to_s3 (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute uploads:migrate_to_s3 Please note that migrating to S3 is currently not reversible! [CTRL+c] to cancel, [ENTER] to continue Migrating uploads to S3 for 'default'... Uploading files to S3... - Listing local files => 3 files - Listing S3 files ................... => 18784 files - Syncing files to S3 ... Updating the URLs in the database... Removing old optimized images... Flagging all posts containing lightboxes for rebake... 10116 posts were flagged for a rebake rake aborted! FileStore::ToS3MigrationError: 1 of 17210 uploads are not migrated to S3. S3 migration failed for db 'default'. /var/www/discourse/lib/file_store/to_s3_migration.rb:138:in `raise_or_log' /var/www/discourse/lib/file_store/to_s3_migration.rb:79:in `migration_successful?' /var/www/discourse/lib/file_store/to_s3_migration.rb:389:in `migrate_to_s3' /var/www/discourse/lib/file_store/to_s3_migration.rb:65:in `migrate' /var/www/discourse/lib/tasks/uploads.rake:127:in `migrate_to_s3' /var/www/discourse/lib/tasks/uploads.rake:106:in `block in migrate_to_s3_all_sites' /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rails_multisite-4.0.1/lib/rails_multisite/connection_management.rb:80:in `with_connection' /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rails_multisite-4.0.1/lib/rails_multisite/connection_management.rb:90:in `each_connection' /var/www/discourse/lib/tasks/uploads.rake:104:in `migrate_to_s3_all_sites' /var/www/discourse/lib/tasks/uploads.rake:100:in `block in
' /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/task.rb:281:in `block in execute' /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/task.rb:281:in `each' /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/task.rb:281:in `execute' /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/task.rb:219:in `block in invoke_with_call_chain' /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/task.rb:199:in `synchronize' /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/task.rb:199:in `invoke_with_call_chain' /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/task.rb:188:in `invoke' /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/application.rb:160:in `invoke_task' /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/application.rb:116:in `block (2 levels) in top_level' /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/application.rb:116:in `each' /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/application.rb:116:in `block in top_level' /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/application.rb:125:in `run_with_threads' /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/application.rb:110:in `top_level' /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/application.rb:83:in `block in run' /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/application.rb:186:in `standard_exception_handling' /var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/lib/rake/application.rb:80:in `run' bin/rake:13:in `' /usr/local/lib/ruby/gems/3.2.0/gems/bundler-2.4.4/lib/bundler/cli/exec.rb:58:in `load' /usr/local/lib/ruby/gems/3.2.0/gems/bundler-2.4.4/lib/bundler/cli/exec.rb:58:in `kernel_load' /usr/local/lib/ruby/gems/3.2.0/gems/bundler-2.4.4/lib/bundler/cli/exec.rb:23:in `run' /usr/local/lib/ruby/gems/3.2.0/gems/bundler-2.4.4/lib/bundler/cli.rb:491:in `exec' /usr/local/lib/ruby/gems/3.2.0/gems/bundler-2.4.4/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run' /usr/local/lib/ruby/gems/3.2.0/gems/bundler-2.4.4/lib/bundler/vendor/thor/lib/thor/invocation.rb:127:in `invoke_command' /usr/local/lib/ruby/gems/3.2.0/gems/bundler-2.4.4/lib/bundler/vendor/thor/lib/thor.rb:392:in `dispatch' /usr/local/lib/ruby/gems/3.2.0/gems/bundler-2.4.4/lib/bundler/cli.rb:34:in `dispatch' /usr/local/lib/ruby/gems/3.2.0/gems/bundler-2.4.4/lib/bundler/vendor/thor/lib/thor/base.rb:485:in `start' /usr/local/lib/ruby/gems/3.2.0/gems/bundler-2.4.4/lib/bundler/cli.rb:28:in `start' /usr/local/lib/ruby/gems/3.2.0/gems/bundler-2.4.4/exe/bundle:45:in `block in ' /usr/local/lib/ruby/gems/3.2.0/gems/bundler-2.4.4/lib/bundler/friendly_errors.rb:117:in `with_friendly_errors' /usr/local/lib/ruby/gems/3.2.0/gems/bundler-2.4.4/exe/bundle:33:in `' /usr/local/bin/bundle:25:in `load' /usr/local/bin/bundle:25:in `
' Tasks: TOP => uploads:migrate_to_s3 root@forum-app:/var/www/discourse# ``` --- _[View the full topic](https://meta.discourse.org/t/1-of-16551-uploads-are-not-migrated-to-s3-s3-migration-failed-for-db-default/255772)._