Ruby on Rails
Monday, July 28, 2014
On Sunday, July 27, 2014 8:12:14 PM UTC+2, Special Agent Dale Cooper wrote:
I was testing my app (with rspec) when I noticed that rake test:prepare throws an odd FATAL: database "postgres" does not exist error. Stranger still, my tests run just fine regardless.However, whenever I use rake test:prepare --trace (after using rake db:migrate) I get this error and receive a similar error when attempting rake db:create RAILS_ENV=test and also rake db:drop RAILS_ENV=test as well. Any idea what I may be overlooking?Here is the error in question:
** Invoke test:prepare (first_time)
** Invoke db:test:prepare (first_time)
** Invoke environment (first_time)
** Execute environment
** Invoke db:load_config (first_time)
** Execute db:load_config
** Execute db:test:prepare
** Invoke db:test:load (first_time)
** Invoke db:test:purge (first_time)
** Invoke environment
** Invoke db:load_config
** Execute db:test:purge
rake aborted!
PG::Error: FATAL: database "postgres" does not exist
/Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/activerecord-4.0.8/lib/ active_record/connection_ adapters/postgresql_adapter. rb:855:in `initialize' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/activerecord-4.0.8/lib/ active_record/connection_ adapters/postgresql_adapter. rb:855:in `new' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/activerecord-4.0.8/lib/ active_record/connection_ adapters/postgresql_adapter. rb:855:in `connect' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/activerecord-4.0.8/lib/ active_record/connection_ adapters/postgresql_adapter. rb:556:in `initialize' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/activerecord-4.0.8/lib/ active_record/connection_ adapters/postgresql_adapter. rb:41:in `new' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/activerecord-4.0.8/lib/ active_record/connection_ adapters/postgresql_adapter. rb:41:in `postgresql_connection' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/activerecord-4.0.8/lib/ active_record/connection_ adapters/abstract/connection_ pool.rb:440:in `new_connection' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/activerecord-4.0.8/lib/ active_record/connection_ adapters/abstract/connection_ pool.rb:450:in `checkout_new_connection' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/activerecord-4.0.8/lib/ active_record/connection_ adapters/abstract/connection_ pool.rb:421:in `acquire_connection' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/activerecord-4.0.8/lib/ active_record/connection_ adapters/abstract/connection_ pool.rb:356:in `block in checkout' /Users/dalecooper/.rvm/rubies/ruby-2.0.0-p481/lib/ruby/2.0. 0/monitor.rb:211:in `mon_synchronize' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/activerecord-4.0.8/lib/ active_record/connection_ adapters/abstract/connection_ pool.rb:355:in `checkout' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/activerecord-4.0.8/lib/ active_record/connection_ adapters/abstract/connection_ pool.rb:265:in `block in connection' /Users/dalecooper/.rvm/rubies/ruby-2.0.0-p481/lib/ruby/2.0. 0/monitor.rb:211:in `mon_synchronize' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/activerecord-4.0.8/lib/ active_record/connection_ adapters/abstract/connection_ pool.rb:264:in `connection' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/activerecord-4.0.8/lib/ active_record/connection_ adapters/abstract/connection_ pool.rb:546:in `retrieve_connection' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/activerecord-4.0.8/lib/ active_record/connection_ handling.rb:79:in `retrieve_connection' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/activerecord-4.0.8/lib/ active_record/connection_ handling.rb:53:in `connection' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/activerecord-4.0.8/lib/ active_record/tasks/ postgresql_database_tasks.rb: 8:in `connection' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/activerecord-4.0.8/lib/ active_record/tasks/ postgresql_database_tasks.rb: 30:in `drop' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/activerecord-4.0.8/lib/ active_record/tasks/ postgresql_database_tasks.rb: 43:in `purge' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/activerecord-4.0.8/lib/ active_record/tasks/database_ tasks.rb:137:in `purge' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/activerecord-4.0.8/lib/ active_record/railties/ databases.rake:365:in `block (3 levels) in <top (required)>' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ task.rb:240:in `call' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ task.rb:240:in `block in execute' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ task.rb:235:in `each' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ task.rb:235:in `execute' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ task.rb:179:in `block in invoke_with_call_chain' /Users/dalecooper/.rvm/rubies/ruby-2.0.0-p481/lib/ruby/2.0. 0/monitor.rb:211:in `mon_synchronize' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ task.rb:172:in `invoke_with_call_chain' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ task.rb:201:in `block in invoke_prerequisites' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ task.rb:199:in `each' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ task.rb:199:in `invoke_prerequisites' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ task.rb:178:in `block in invoke_with_call_chain' /Users/dalecooper/.rvm/rubies/ruby-2.0.0-p481/lib/ruby/2.0. 0/monitor.rb:211:in `mon_synchronize' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ task.rb:172:in `invoke_with_call_chain' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ task.rb:165:in `invoke' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/activerecord-4.0.8/lib/ active_record/railties/ databases.rake:371:in `block (3 levels) in <top (required)>' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ task.rb:240:in `call' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ task.rb:240:in `block in execute' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ task.rb:235:in `each' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ task.rb:235:in `execute' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ task.rb:179:in `block in invoke_with_call_chain' /Users/dalecooper/.rvm/rubies/ruby-2.0.0-p481/lib/ruby/2.0. 0/monitor.rb:211:in `mon_synchronize' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ task.rb:172:in `invoke_with_call_chain' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ task.rb:201:in `block in invoke_prerequisites' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ task.rb:199:in `each' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ task.rb:199:in `invoke_prerequisites' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ task.rb:178:in `block in invoke_with_call_chain' /Users/dalecooper/.rvm/rubies/ruby-2.0.0-p481/lib/ruby/2.0. 0/monitor.rb:211:in `mon_synchronize' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ task.rb:172:in `invoke_with_call_chain' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ task.rb:165:in `invoke' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ application.rb:150:in `invoke_task' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ application.rb:106:in `block (2 levels) in top_level' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ application.rb:106:in `each' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ application.rb:106:in `block in top_level' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ application.rb:115:in `run_with_threads' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ application.rb:100:in `top_level' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ application.rb:78:in `block in run' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ application.rb:176:in `standard_exception_handling' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/lib/rake/ application.rb:75:in `run' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/ gems/rake-10.3.2/bin/rake:33: in `<top (required)>' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/bin/ rake:23:in `load' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/bin/ rake:23:in `<main>' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/bin/ ruby_executable_hooks:15:in `eval' /Users/dalecooper/.rvm/gems/ruby-2.0.0-p481@rails_4_0/bin/ ruby_executable_hooks:15:in `<main>'
`Tasks: TOP => db:test:load => db:test:purge`Here is what my test environment looks like (according to my gemfile):
gem 'rails', '4.0.8'
gem 'pg', '0.15.1'
group :development, :test do
gem 'rspec-rails', '2.13.1'
end
group :test do
gem 'selenium-webdriver', '2.35.1'
gem 'capybara', '2.1.0'
endand here is what my database.yml file looks like :
development:
adapter: postgresql
endoding: unicode
database: myapp_development
pool: 5
timeout: 5000
hostname: localhost
test:
adapter: postgresql
endoding: unicode
database: myapp_test
pool: 5
timeout: 5000
hostname: localhost
production:
adapter: postgresql
database: myapp_production
pool: 5
timeout: 5000
First, the correct syntax to run the above command is:
bin/rake db:test:prepare (depending on your installation, you should run it as bundle exec rake db:test:prepare)
and rake test:prepare as you stated
You can also use:
rake db:setup
It will create the database, load the schema and initialize it with the seed.
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/3203460a-7988-495e-b5da-5ff21754d43a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment