# Trouble restoring from backup **URL:** https://meta.discourse.org/t/trouble-restoring-from-backup/74067 **Category:** Support **Created:** [November 14, 2017, 8:25pm UTC](https://meta.discourse.org/t/trouble-restoring-from-backup/74067 "2017-11-14T20:25:51Z") **Posts on this page:** 12 **Page:** 1
### Author: ![David\_Foster](https://avatars.discourse-cdn.com/v4/letter/d/fbc32d/32.png) [@David\_Foster](https://meta.discourse.org/u/David_Foster) #### Post date: [November 14, 2017, 8:25pm UTC](https://meta.discourse.org/t/trouble-restoring-from-backup/74067/1 "2017-11-14T20:25:51Z")
Hoes it going.. trying to test a restoration.. and it keeps failing on me. some quick notes, both production and test env are the same, ubuntu 16.04, docker version 17.09.0-ce, build afdb6d4 and both discourses have been pulled from git on the same day.. when trying to do a restore here is the log… ``` ERROR: function restore.raise_users_email_readonly() does not exist EXCEPTION: psql failed /var/www/discourse/lib/backup_restore/restorer.rb:279:in `restore_dump' /var/www/discourse/lib/backup_restore/restorer.rb:42:in `run' script/discourse:113:in `restore' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/thor-0.19.4/lib/thor/command.rb:27:in `run' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/thor-0.19.4/lib/thor/invocation.rb:126:in `invoke_command' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/thor-0.19.4/lib/thor.rb:369:in `dispatch' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/thor-0.19.4/lib/thor/base.rb:444:in `start' script/discourse:269:in `' /usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.0/lib/bundler/cli/exec.rb:75:in `load' /usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.0/lib/bundler/cli/exec.rb:75:in `kernel_load' /usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.0/lib/bundler/cli/exec.rb:28:in `run' /usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.0/lib/bundler/cli.rb:424:in `exec' /usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.0/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run' /usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.0/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command' /usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.0/lib/bundler/vendor/thor/lib/thor.rb:387:in `dispatch' /usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.0/lib/bundler/cli.rb:27:in `dispatch' /usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.0/lib/bundler/vendor/thor/lib/thor/base.rb:466:in `start' /usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.0/lib/bundler/cli.rb:18:in `start' /usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.0/exe/bundle:30:in `block in ' /usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.0/lib/bundler/friendly_errors.rb:122:in `with_friendly_errors' /usr/local/lib/ruby/gems/2.4.0/gems/bundler-1.16.0/exe/bundle:22:in `' /usr/local/bin/bundle:23:in `load' /usr/local/bin/bundle:23:in `
' ``` Thanks for any help! ---
### Author: ![dax](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/dax/32/244677_2.png) [@dax](https://meta.discourse.org/u/dax) #### Post date: [November 14, 2017, 9:06pm UTC](https://meta.discourse.org/t/trouble-restoring-from-backup/74067/2 "2017-11-14T21:06:26Z")
Stupid question…have you enabled the site setting `allow restore`? ---
### Author: ![David\_Foster](https://avatars.discourse-cdn.com/v4/letter/d/fbc32d/32.png) [@David\_Foster](https://meta.discourse.org/u/David_Foster) #### Post date: [November 14, 2017, 9:18pm UTC](https://meta.discourse.org/t/trouble-restoring-from-backup/74067/3 "2017-11-14T21:18:38Z")
figured it out. turns out I upgraded docker on the test environment, but it needed a reboot to truly be running that version of docker.. Thanks thought! ---
### Author: ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman) #### Post date: [November 14, 2017, 9:57pm UTC](https://meta.discourse.org/t/trouble-restoring-from-backup/74067/4 "2017-11-14T21:57:55Z")
@tgxworld, could this be related to any of the new email stuff like this: [Merge pull request #5292 from tgxworld/drop\_email\_column · discourse/discourse@36ba0df · GitHub](https://github.com/discourse/discourse/commit/36ba0dfde34c1f353c9f54aca76e9a9c23e3675a)? ---
### Author: ![David\_Foster](https://avatars.discourse-cdn.com/v4/letter/d/fbc32d/32.png) [@David\_Foster](https://meta.discourse.org/u/David_Foster) #### Post date: [November 14, 2017, 11:22pm UTC](https://meta.discourse.org/t/trouble-restoring-from-backup/74067/5 "2017-11-14T23:22:35Z")
its failing again. was able to successfully do the restore once, but not it is failing with the same error. so something in there is acting up. Even with a clean new dev environment, repeating the exact steps from that successful restore..failing ---
### Author: ![tgxworld](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/tgxworld/32/106117_2.png) [@tgxworld](https://meta.discourse.org/u/tgxworld) #### Post date: [November 14, 2017, 11:58pm UTC](https://meta.discourse.org/t/trouble-restoring-from-backup/74067/6 "2017-11-14T23:58:47Z")
Can you provide me with the full log output? ---
### Author: ![David\_Foster](https://avatars.discourse-cdn.com/v4/letter/d/fbc32d/32.png) [@David\_Foster](https://meta.discourse.org/u/David_Foster) #### Post date: [November 15, 2017, 12:56am UTC](https://meta.discourse.org/t/trouble-restoring-from-backup/74067/7 "2017-11-15T00:56:18Z")
``` [2017-11-15 00:53:00] 'david.foster' has started the restore! [2017-11-15 00:53:00] Marking restore as running... [2017-11-15 00:53:00] Making sure /var/www/discourse/tmp/restores/default/2017-11-15-005300 exists... [2017-11-15 00:53:00] Copying archive to tmp directory... [2017-11-15 00:53:00] Unzipping archive, this may take a while... [2017-11-15 00:53:00] Extracting metadata file... [2017-11-15 00:53:00] Validating metadata... [2017-11-15 00:53:00] Current version: 20171113175414 [2017-11-15 00:53:00] Restored version: 20171107020512 [2017-11-15 00:53:00] Extracting dump file... [2017-11-15 00:53:00] Restoring dump file... (can be quite long) [2017-11-15 00:53:05] ERROR: function restore.raise_users_email_readonly() does not exist [2017-11-15 00:53:05] EXCEPTION: psql failed [2017-11-15 00:53:05] /var/www/discourse/lib/backup_restore/restorer.rb:279:in `restore_dump' /var/www/discourse/lib/backup_restore/restorer.rb:42:in `run' /var/www/discourse/lib/backup_restore/backup_restore.rb:163:in `block in start!' /var/www/discourse/lib/backup_restore/backup_restore.rb:160:in `fork' /var/www/discourse/lib/backup_restore/backup_restore.rb:160:in `start!' /var/www/discourse/lib/backup_restore/backup_restore.rb:19:in `restore!' /var/www/discourse/app/controllers/admin/backups_controller.rb:101:in `restore' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_controller/metal/basic_implicit_render.rb:4:in `send_action' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/abstract_controller/base.rb:186:in `process_action' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_controller/metal/rendering.rb:30:in `process_action' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/abstract_controller/callbacks.rb:20:in `block in process_action' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.4/lib/active_support/callbacks.rb:131:in `run_callbacks' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/abstract_controller/callbacks.rb:19:in `process_action' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_controller/metal/rescue.rb:20:in `process_action' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_controller/metal/instrumentation.rb:32:in `block in process_action' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.4/lib/active_support/notifications.rb:166:in `block in instrument' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.4/lib/active_support/notifications/instrumenter.rb:21:in `instrument' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.4/lib/active_support/notifications.rb:166:in `instrument' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_controller/metal/instrumentation.rb:30:in `process_action' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_controller/metal/params_wrapper.rb:252:in `process_action' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.4/lib/active_record/railties/controller_runtime.rb:22:in `process_action' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/abstract_controller/base.rb:124:in `process' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionview-5.1.4/lib/action_view/rendering.rb:30:in `process' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/rack-mini-profiler-0.10.5/lib/mini_profiler/profiling_methods.rb:102:in `block in profile_method' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_controller/metal.rb:189:in `dispatch' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_controller/metal.rb:253:in `dispatch' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/routing/route_set.rb:49:in `dispatch' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/routing/route_set.rb:31:in `serve' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/routing/mapper.rb:16:in `block in ' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/routing/mapper.rb:46:in `serve' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/journey/router.rb:50:in `block in serve' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/journey/router.rb:33:in `each' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/journey/router.rb:33:in `serve' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/routing/route_set.rb:834:in `call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/rack-protection-2.0.0/lib/rack/protection/frame_options.rb:31:in `call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/omniauth-1.6.1/lib/omniauth/strategy.rb:189:in `call!' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/omniauth-1.6.1/lib/omniauth/strategy.rb:167:in `call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/omniauth-1.6.1/lib/omniauth/strategy.rb:189:in `call!' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/omniauth-1.6.1/lib/omniauth/strategy.rb:167:in `call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/omniauth-1.6.1/lib/omniauth/strategy.rb:189:in `call!' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/omniauth-1.6.1/lib/omniauth/strategy.rb:167:in `call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/omniauth-1.6.1/lib/omniauth/strategy.rb:189:in `call!' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/omniauth-1.6.1/lib/omniauth/strategy.rb:167:in `call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/omniauth-1.6.1/lib/omniauth/strategy.rb:189:in `call!' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/omniauth-1.6.1/lib/omniauth/strategy.rb:167:in `call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/omniauth-1.6.1/lib/omniauth/strategy.rb:189:in `call!' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/omniauth-1.6.1/lib/omniauth/strategy.rb:167:in `call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/omniauth-1.6.1/lib/omniauth/builder.rb:63:in `call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/conditional_get.rb:38:in `call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/head.rb:12:in `call' /var/www/discourse/lib/middleware/anonymous_cache.rb:149:in `call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/session/abstract/id.rb:232:in `context' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/session/abstract/id.rb:226:in `call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/middleware/cookies.rb:613:in `call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/middleware/callbacks.rb:26:in `block in call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.4/lib/active_support/callbacks.rb:97:in `run_callbacks' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/middleware/callbacks.rb:24:in `call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/middleware/debug_exceptions.rb:59:in `call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/middleware/show_exceptions.rb:31:in `call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/logster-1.2.8/lib/logster/middleware/reporter.rb:31:in `call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/rack/logger.rb:36:in `call_app' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/rack/logger.rb:26:in `call' /var/www/discourse/config/initializers/100-quiet_logger.rb:16:in `call' /var/www/discourse/config/initializers/100-silence_logger.rb:29:in `call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/middleware/remote_ip.rb:79:in `call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/middleware/request_id.rb:25:in `call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/method_override.rb:22:in `call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/runtime.rb:22:in `call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.4/lib/action_dispatch/middleware/executor.rb:12:in `call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/sendfile.rb:111:in `call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/rack-mini-profiler-0.10.5/lib/mini_profiler/profiler.rb:282:in `call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/message_bus-2.0.8/lib/message_bus/rack/middleware.rb:63:in `call' /var/www/discourse/lib/middleware/request_tracker.rb:110:in `call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/engine.rb:522:in `call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/railtie.rb:185:in `public_send' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/railties-5.1.4/lib/rails/railtie.rb:185:in `method_missing' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/urlmap.rb:68:in `block in call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/urlmap.rb:53:in `each' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/urlmap.rb:53:in `call' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/unicorn-5.3.1/lib/unicorn/http_server.rb:606:in `process_client' /var/www/discourse/lib/scheduler/defer.rb:87:in `process_client' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/unicorn-5.3.1/lib/unicorn/http_server.rb:702:in `worker_loop' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/unicorn-5.3.1/lib/unicorn/http_server.rb:549:in `spawn_missing_workers' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/unicorn-5.3.1/lib/unicorn/http_server.rb:142:in `start' /var/www/discourse/vendor/bundle/ruby/2.4.0/gems/unicorn-5.3.1/bin/unicorn:126:in `' /var/www/discourse/vendor/bundle/ruby/2.4.0/bin/unicorn:23:in `load' /var/www/discourse/vendor/bundle/ruby/2.4.0/bin/unicorn:23:in `
' [2017-11-15 00:53:05] Trying to rollback... [2017-11-15 00:53:05] There was no need to rollback [2017-11-15 00:53:05] Notifying 'david.foster' of the end of the restore... [2017-11-15 00:53:13] Cleaning stuff up... [2017-11-15 00:53:13] Removing tmp '/var/www/discourse/tmp/restores/default/2017-11-15-005300' directory... [2017-11-15 00:53:13] Unpausing sidekiq... [2017-11-15 00:53:13] Marking restore as finished... [2017-11-15 00:53:13] Finished! ``` ---
### Author: ![noisegratte](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/noisegratte/32/76500_2.png) [@noisegratte](https://meta.discourse.org/u/noisegratte) #### Post date: [November 20, 2017, 3:18pm UTC](https://meta.discourse.org/t/trouble-restoring-from-backup/74067/8 "2017-11-20T15:18:16Z")
Hi @tgxworld, I have the same issue when I try to restore in v1.9.0.beta14 +281 ☹ ---
### Author: ![David\_Foster](https://avatars.discourse-cdn.com/v4/letter/d/fbc32d/32.png) [@David\_Foster](https://meta.discourse.org/u/David_Foster) #### Post date: [November 27, 2017, 9:21pm UTC](https://meta.discourse.org/t/trouble-restoring-from-backup/74067/10 "2017-11-27T21:21:42Z")
fixed it…real easy enter into the container with ./launcher enter app and run these commands su discourse RAILS\_ENV=production bundle exec rake db:migrate Thats it! I was all good to go working backups/restoring no data loss after that. ---
### Author: ![zogstrip](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/zogstrip/32/512781_2.png) [@zogstrip](https://meta.discourse.org/u/zogstrip) #### Post date: [January 31, 2018, 7:52pm UTC](https://meta.discourse.org/t/trouble-restoring-from-backup/74067/11 "2018-01-31T19:52:08Z")
@noisegratte is it still happening? ---
### Author: ![noisegratte](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/noisegratte/32/76500_2.png) [@noisegratte](https://meta.discourse.org/u/noisegratte) #### Post date: [January 31, 2018, 8:20pm UTC](https://meta.discourse.org/t/trouble-restoring-from-backup/74067/12 "2018-01-31T20:20:21Z")
I just did a new backup with an updated version of Discourse, and it solved the problem. ---
### Author: ![zogstrip](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/zogstrip/32/512781_2.png) [@zogstrip](https://meta.discourse.org/u/zogstrip) #### Post date: [January 31, 2018, 8:20pm UTC](https://meta.discourse.org/t/trouble-restoring-from-backup/74067/13 "2018-01-31T20:20:51Z")