ruby-on-rails – 运行heroku db时无法获取表信息：pull
发布时间：2020-12-17 03:22:15 所属栏目：百科 来源：网络整理
导读：我有一个在开发和生产中使用postgres的应用程序.我最近推到了heroku,一切都很好.我能够从heroku中提取数据库并且没有任何问题地向后推.然而今天,我试图将数据库从heroku中拉下来,我收到了这个错误 heroku db:pullLoaded Taps v0.3.24 Auto-detected local da
|
我有一个在开发和生产中使用postgres的应用程序.我最近推到了heroku,一切都很好.我能够从heroku中提取数据库并且没有任何问题地向后推.然而今天,我试图将数据库从heroku中拉下来,我收到了这个错误
heroku db:pull
Loaded Taps v0.3.24
Auto-detected local database: postgres://postgres:a@127.0.0.1/app_development?encoding=utf8
Warning: Data in the database 'postgres://postgres:a@127.0.0.1/app_development?encoding=utf8' will be overwritten and will not be recoverable.
! WARNING: Destructive Action
! This command will affect the app: app
! To proceed,type "app" or re-run this command with --confirm app
> app
Receiving schema
Unable to fetch tables information from http://heroku:osui59a24am79x@taps19.heroku.com. Please check the server log.
所以我在运行后运行heroku日志： james@james-Vostro-3550:~/Desktop/app$heroku logs 2012-09-25T10:08:32+00:00 app[web.1]: Started GET "/users" for X.X.X.X at 2012-09-25 10:08:32 +0000 2012-09-25T10:08:32+00:00 heroku[router]: GET app.herokuapp.com/users? dyno=web.1 queue=0 wait=0ms service=38ms status=200 bytes=10727 2012-09-25T10:08:32+00:00 app[web.1]: 2012-09-25T10:08:32+00:00 app[web.1]: 2012-09-25T10:08:32+00:00 app[web.1]: Started GET "/application.css" for X.X.X.X at 2012-09-25 10:08:32 +0000 2012-09-25T10:08:32+00:00 app[web.1]: 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/actionpack-3.2.6/lib/action_dispatch/middleware/debug_exceptions.rb:21:in `call' 2012-09-25T10:08:32+00:00 app[web.1]: ActionController::RoutingError (No route matches [GET] "/application.css"): 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/actionpack-3.2.6/lib/action_dispatch/middleware/show_exceptions.rb:56:in `call' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/railties-3.2.6/lib/rails/rack/logger.rb:26:in `call_app' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/railties-3.2.6/lib/rails/rack/logger.rb:16:in `call' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/actionpack-3.2.6/lib/action_dispatch/middleware/request_id.rb:22:in `call' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/rack-1.4.1/lib/rack/methodoverride.rb:21:in `call' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/rack-1.4.1/lib/rack/runtime.rb:17:in `call' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.6/lib/active_support/cache/strategy/local_cache.rb:72:in `call' 2012-09-25T10:08:32+00:00 heroku[router]: GET app.herokuapp.com/application.css dyno=web.1 queue=0 wait=0ms service=6ms status=404 bytes=728 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/rack-1.4.1/lib/rack/lock.rb:15:in `call' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/actionpack-3.2.6/lib/action_dispatch/middleware/static.rb:62:in `call' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/rack-cache-1.2/lib/rack/cache/context.rb:136:in `forward' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/rack-cache-1.2/lib/rack/cache/context.rb:245:in `fetch' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/rack-cache-1.2/lib/rack/cache/context.rb:185:in `lookup' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/rack-cache-1.2/lib/rack/cache/context.rb:66:in `call!' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/rack-cache-1.2/lib/rack/cache/context.rb:51:in `call' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/railties-3.2.6/lib/rails/engine.rb:479:in `call' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/railties-3.2.6/lib/rails/application.rb:220:in `call' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/railties-3.2.6/lib/rails/railtie/configurable.rb:30:in `method_missing' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/thin-1.4.1/lib/thin/connection.rb:78:in `catch' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/thin-1.4.1/lib/thin/connection.rb:80:in `block in pre_process' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/thin-1.4.1/lib/thin/connection.rb:53:in `process' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/thin-1.4.1/lib/thin/connection.rb:78:in `pre_process' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/thin-1.4.1/lib/thin/connection.rb:38:in `receive_data' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/eventmachine-0.12.10/lib/eventmachine.rb:256:in `run_machine' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/eventmachine-0.12.10/lib/eventmachine.rb:256:in `run' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/thin-1.4.1/lib/thin/backends/base.rb:63:in `start' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/thin-1.4.1/lib/thin/server.rb:159:in `start' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/thin-1.4.1/lib/thin/controllers/controller.rb:86:in `start' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/thin-1.4.1/lib/thin/runner.rb:185:in `run_command' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/thin-1.4.1/lib/thin/runner.rb:151:in `run!' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/thin-1.4.1/bin/thin:6:in `<top (required)>' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/bin/thin:19:in `load' 2012-09-25T10:08:32+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/bin/thin:19:in `<main>' 2012-09-25T10:08:32+00:00 app[web.1]: 2012-09-25T10:08:32+00:00 app[web.1]: 2012-09-25T10:08:32+00:00 heroku[router]: GET app.herokuapp.com/assets/admin-e0756c8b3550bb800d5f58837c42ec80.css dyno=web.1 queue=0 wait=0ms service=7ms status=200 bytes=1941 2012-09-25T10:08:32+00:00 app[web.1]: 2012-09-25T10:08:32+00:00 app[web.1]: 2012-09-25T10:08:32+00:00 app[web.1]: Started GET "/assets/admin-e0756c8b3550bb800d5f58837c42ec80.css" for X.X.X.X at 2012-09-25 10:08:32 +0000 2012-09-25T10:08:41+00:00 app[web.1]: 2012-09-25T10:08:41+00:00 app[web.1]: 2012-09-25T10:08:41+00:00 app[web.1]: Started GET "/projects" for X.X.X.X at 2012-09-25 10:08:41 +0000 2012-09-25T10:08:41+00:00 heroku[router]: GET app.herokuapp.com/projects dyno=web.1 queue=0 wait=0ms service=31ms status=304 bytes=0 2012-09-25T10:08:41+00:00 app[web.1]: Started GET "/application.css" for X.X.X.X at 2012-09-25 10:08:41 +0000 2012-09-25T10:08:41+00:00 app[web.1]: 2012-09-25T10:08:41+00:00 app[web.1]: 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/actionpack-3.2.6/lib/action_dispatch/middleware/debug_exceptions.rb:21:in `call' 2012-09-25T10:08 :41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/actionpack-3.2.6/lib/action_dispatch/middleware/request_id.rb:22:in `call' 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/rack-1.4.1/lib/rack/lock.rb:15:in `call' 2012-09-25T10:08:41+00:00 app[web.1]: 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.6/lib/active_support/cache/strategy/local_cache.rb:72:in `call' 2012-09-25T10:08:41+00:00 app[web.1]: ActionController::RoutingError (No route matches [GET] "/application.css"): 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/rack-cache-1.2/lib/rack/cache/context.rb:185:in `lookup' 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/actionpack-3.2.6/lib/action_dispatch/middleware/show_exceptions.rb:56:in `call' 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/rack-cache-1.2/lib/rack/cache/context.rb:51:in `call' 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/railties-3.2.6/lib/rails/rack/logger.rb:26:in `call_app' 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/rack-cache-1.2/lib/rack/cache/context.rb:245:in `fetch' 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/railties-3.2.6/lib/rails/rack/logger.rb:16:in `call' 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/rack-1.4.1/lib/rack/runtime.rb:17:in `call' 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/railties-3.2.6/lib/rails/railtie/configurable.rb:30:in `method_missing' 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/rack-1.4.1/lib/rack/methodoverride.rb:21:in `call' 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/actionpack-3.2.6/lib/action_dispatch/middleware/static.rb:62:in `call' 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/rack-cache-1.2/lib/rack/cache/context.rb:136:in `forward' 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/railties-3.2.6/lib/rails/application.rb:220:in `call' 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/thin-1.4.1/lib/thin/server.rb:159:in `start' 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/thin-1.4.1/lib/thin/connection.rb:78:in `catch' 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/railties-3.2.6/lib/rails/engine.rb:479:in `call' 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/eventmachine-0.12.10/lib/eventmachine.rb:256:in `run_machine' 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/rack-cache-1.2/lib/rack/cache/context.rb:66:in `call!' 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/thin-1.4.1/lib/thin/connection.rb:80:in `block in pre_process' 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/thin-1.4.1/lib/thin/connection.rb:53:in `process' 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/thin-1.4.1/lib/thin/backends/base.rb:63:in `start' 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/thin-1.4.1/lib/thin/connection.rb:78:in `pre_process' 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/eventmachine-0.12.10/lib/eventmachine.rb:256:in `run' 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/thin-1.4.1/lib/thin/connection.rb:38:in `receive_data' 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/thin-1.4.1/lib/thin/runner.rb:151:in `run!' 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/thin-1.4.1/lib/thin/runner.rb:185:in `run_command' 2012-09-25T10:08:41+00:00 app[web.1]: 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/bin/thin:19:in `<main>' 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/thin-1.4.1/lib/thin/controllers/controller.rb:86:in `start' 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/gems/thin-1.4.1/bin/thin:6:in `<top (required)>' 2012-09-25T10:08:41+00:00 app[web.1]: vendor/bundle/ruby/1.9.1/bin/thin:19:in `load' 2012-09-25T10:08:41+00:00 app[web.1]: 2012-09-25T10:08:41+00:00 heroku[router]: GET app.herokuapp.com/application.css dyno=web.1 queue=0 wait=0ms service=9ms status=404 bytes=728 2012-09-25T10:11:00+00:00 heroku[run.1]: Awaiting client 2012-09-25T10:11:00+00:00 heroku[run.1]: Starting process with command `bundle exec rake db:migrate` 2012-09-25T10:11:00+00:00 heroku[run.1]: State changed from starting to up 2012-09-25T10:11:06+00:00 heroku[run.1]: Client connection closed. Sending SIGHUP to all processes 2012-09-25T10:11:07+00:00 heroku[run.1]: Process exited with status 1 2012-09-25T10:11:07+00:00 heroku[run.1]: State changed from up to complete 2012-09-25T10:08:23+00:00 heroku[web.1]: State changed from starting to up 2012-09-25T10:08:01+00:00 heroku[web.1]: Unidling 2012-09-25T10:08:01+00:00 heroku[web.1]: State changed from down to starting 我不知道在哪里寻找解决方案,所以希望有人可以提供帮助.我刚刚开始学习rails,所以在尝试帮助时请记住这一点. 提前致谢. 编辑： 我尝试了各种各样的： 似乎没什么用.让我生气！ 解决方法
我找到了某种解决方法.
我在heroku上的SHARED_DATABASE也遇到了同样的问题 ruby1.9.2 宝石： 第(0.11.0)页 heroku(2.32.4) heroku-api(0.3.5) 水龙头(0.3.24) heroku db：pull结束于： 无法从http://…@taps19.heroku.com获取表信息.请检查服务器日志. 我使用rvm和heroku db切换到ruby 1.8.7：pull工作正常. 我希望这有助于某人直到db：pull将使用ruby 1.9.2修复. （编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |