No database specified. Missing argument: database. (ArgumentError)

[databasecleaner]

No database specified. Missing argument: database. (ArgumentError)

[bmabey]

Did you see this similar issue?

#37

One suggestion would be to try to establish the connection yourself before DatabaseCleaner tries to. The thought behind it being that for some reason the regular Rails environment can establish a connection to the DB but for whatever reason DBCleaner is going about it a different way and is causing problems...

[thebaggage]

Hi bmabey,

Thanks for the quick response.

I did see that issue and attempted the solution. The database error was replaced by:

NOTICE:  there is no transaction in progress
      You have a nil object when you didn't expect it!
      You might have expected an instance of Array.
      The error occurred while evaluating nil.- (NoMethodError)
      /Users/john/.rvm/gems/ruby-1.9.2-p290/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/abstract_adapter.rb:190:in `decrement_open_transactions'
      /Users/john/.rvm/gems/ruby-1.9.2-p290/gems/database_cleaner-0.6.7/lib/database_cleaner/active_record/transaction.rb:20:in `clean'
      /Users/john/.rvm/gems/ruby-1.9.2-p290/gems/database_cleaner-0.6.7/lib/database_cleaner/base.rb:77:in `clean'
      /Users/john/.rvm/gems/ruby-1.9.2-p290/gems/cucumber-rails-1.0.2/lib/cucumber/rails/hooks/database_cleaner.rb:9:in `After'

Considering the 'nil' on the connection, I'm guessing this is a related issue? Still very stumped, if you have any suggestions I'd be very appreciative. Might also be worth mentioning:

(a) I'm using factory girl in cucumber
(b) I've tried switching db adapters to mysql - same issue
(c) I've tried creating a bare project with just cucumber/rspec/database_cleaner/factory_girl & running a very basic scenario - same issue
(d) Rails 3.1.0rc4, database_cleaner 0.6.7, cucumber 1.0.2, pg 0.11.0

[bmabey]

If you have a bare project that is reproducing the issue please push it to github and I'll see if I can figure it out.

[thebaggage]

Many thanks - really appreciate it.

Basic repo here: https://github.com/thebaggage/Database-Cleaner-Problem-Example

The scenario should pass all steps, but come back with 'failed' for the scenario, and the following error:

OTICE:  there is no transaction in progress
      You have a nil object when you didn't expect it!
      You might have expected an instance of Array.
      The error occurred while evaluating nil.- (NoMethodError)
      /Users/john/.rvm/gems/ruby-1.9.2-p290/gems/activerecord-3.1.0.rc6/lib/active_record/connection_adapters/abstract_adapter.rb:212:in `decrement_open_transactions'
      /Users/john/.rvm/gems/ruby-1.9.2-p290/gems/database_cleaner-0.6.7/lib/database_cleaner/active_record/transaction.rb:20:in `clean'
      /Users/john/.rvm/gems/ruby-1.9.2-p290/gems/database_cleaner-0.6.7/lib/database_cleaner/base.rb:77:in `clean'
      /Users/john/.rvm/gems/ruby-1.9.2-p290/gems/cucumber-rails-1.0.2/lib/cucumber/rails/hooks/database_cleaner.rb:9:in `After'

[thebaggage]

Hi again - thanks for the responses. In the end I just cleared out all my gems, installed them all again, and it worked. In short, a gem was broken...everything works fine now.

[thebaggage]

Nope - the problem is back...haven't changed a thing. Removing database_cleaner from my Gemfile fixes it, but then I can't use database_cleaner. I'm completely at a loss.

[windock]

Try replacing "default: &defaults" part in your database.yml file with another name. As I remember, DatabaseCleaner or some other gem tries to establish connection to "default" database, sees that line and thinks it is a database configuration, but since it doesn't see "database" definition, it throws "No database specified. Missing argument: database."

[windock]

Oh yes, here is that line in DatabaseCleaner::Base.db:
def db
@db || :default
end

[thebaggage]

rapturous applause
standing ovation
tickertape parade

Many thanks windock - I've spent almost two days on this...and yep, that was the issue. Much appreciated.

[windock]

I do think it causes too much frustration for everyone, I've spent 2 days previously on this also - lots of people use "default" block in database.yml I'd suggest to change DatabaseCleaner in a way not to connect to default database.

[thebaggage]

nods Very much second windock on this one. 'Defaults' is really common, and the conflict was a real s.o.b. to track down.

[bmabey]

Hi, I was going to look into this this morning but I am glad to see that it was figured out. I'll look into why the :default is in place and see if relacing it with a raise would be a better approach (it seems like it would based on this thread).

[ramontayag]

+1 for the raise. Just ran into this

[david-harkness]

+1 for the raise as well

[fosrias]

+1 for raise. Still an issue.

[bmabey]

@fosrias Would you mind pointing bundler to use ab066b1 of DatabaseCleaner to see if that resolves the issue for you?

[fosrias]

Worked like a charm. Thanks.