String can't be coerced into Integer, when running rake db:create in test environment

Question

I am trying to create a Test database using rake db:create, It gives me the following error, I have recently upgraded from rails 3.2.17 to 3.2.22.5.

RAILS_ENV=test rake db:create --trace

** Invoke db:create (first_time)
** Invoke db:load_config (first_time)
** Execute db:load_config
** Invoke rails_env (first_time)
** Execute rails_env
** Execute db:create
String can't be coerced into Integer
/data/rvm_installtion/.rvm/gems/ruby-2.4.3@waltz/gems/activesupport3.2.22.5/lib/active_support/core_ext/enumerable.rb:60:in `+'
/data/rvm_installtion/.rvm/gems/ruby-2.4.3@waltz/gems/activesupport3.2.22.5/lib/active_support/core_ext/enumerable.rb:60:in `sum'
/data/rvm_installtion/.rvm/gems/ruby-2.4.3@waltz/gems/activesupport3.2.22.5/lib/active_support/core_ext/enumerable.rb:60:in `sum'
/data/rvm_installtion/.rvm/gems/ruby-2.4.3@waltz/gems/activerecord3.2.22.5/lib/active_record/connection_adapters/postgresql_adapter.rb:747:in `create_database'
/data/rvm_installtion/.rvm/gems/ruby-2.4.3@waltz/gems/activerecord3.2.22.5/lib/active_record/railties/databases.rake144:in `rescue in create_database'
/data/rvm_installtion/.rvm/gems/ruby-2.4.3@waltz/gems/activerecord3.2.22.5/lib/active_record/railties/databases.rake:84:in `create_database'
/data/rvm_installtion/.rvm/gems/ruby-2.4.3@waltz/gems/activerecord3.2.22.5/lib/active_record/railties/databases.rake:62:in `block (3 levels) in <top (required)>'
/data/rvm_installtion/.rvm/gems/ruby-2.4.3@waltz/gems/activerecord3.2.22.5/lib/active_record/railties/databases.rake:62:in `each'
/data/rvm_installtion/.rvm/gems/ruby-2.4.3@waltz/gems/activerecord3.2.22.5/lib/active_record/railties/databases.rake:62:in `block (2 levels) in <top (required)>'
/data/rvm_installtion/.rvm/gems/ruby2.4.3@waltz/gems/rake10.5.0/lib/rake/task.rb:240:in `block in execute'
/data/rvm_installtion/.rvm/gems/ruby-2.4.3@waltz/gems/rake10.5.0/lib/rake/task.rb:235:in `each'
/data/rvm_installtion/.rvm/gems/ruby-2.4.3@waltz/gems/rake10.5.0/lib/rake/task.rb:235:in `execute'
/data/rvm_installtion/.rvm/gems/ruby-2.4.3@waltz/gems/rake10.5.0/lib/rake/task.rb:179:in `block in invoke_with_call_chain'
/data/rvm_installtion/.rvm/rubies/ruby-2.4.3/lib/ruby/2.4.0/monitor.rb:214:in `mon_synchronize'
/data/rvm_installtion/.rvm/gems/ruby-2.4.3@waltz/gems/rake-10.5.0/lib/rake/task.rb:172:in `invoke_with_call_chain'
/data/rvm_installtion/.rvm/gems/ruby-2.4.3@waltz/gems/rake-10.5.0/lib/rake/task.rb:165:in `invoke'
/data/rvm_installtion/.rvm/gems/ruby-2.4.3@waltz/gems/rake-10.5.0/lib/rake/application.rb:150:in `invoke_task'
/data/rvm_installtion/.rvm/gems/ruby-2.4.3@waltz/gems/rake-10.5.0/lib/rake/application.rb:106:in `block (2 levels) in top_level'
/data/rvm_installtion/.rvm/gems/ruby-2.4.3@waltz/gems/rake-10.5.0/lib/rake/application.rb:106:in `each'
/data/rvm_installtion/.rvm/gems/ruby-2.4.3@waltz/gems/rake-10.5.0/lib/rake/application.rb:106:in `block in top_level'
/data/rvm_installtion/.rvm/gems/ruby-2.4.3@waltz/gems/rake-10.5.0/lib/rake/application.rb:115:in `run_with_threads'
/data/rvm_installtion/.rvm/gems/ruby-2.4.3@waltz/gems/rake-10.5.0/lib/rake/application.rb:100:in `top_level'
/data/rvm_installtion/.rvm/gems/ruby-2.4.3@waltz/gems/rake-10.5.0/lib/rake/application.rb:78:in `block in run'
/data/rvm_installtion/.rvm/gems/ruby-2.4.3@waltz/gems/rake-10.5.0/lib/rake/application.rb:176:in `standard_exception_handling'
/data/rvm_installtion/.rvm/gems/ruby-2.4.3@waltz/gems/rake-10.5.0/lib/rake/application.rb:75:in `run'
/data/rvm_installtion/.rvm/gems/ruby-2.4.3@waltz/gems/rake-10.5.0/bin/rake:33:in `<top (required)>'
/data/rvm_installtion/.rvm/gems/ruby-2.4.3@waltz/bin/rake:23:in `load'
/data/rvm_installtion/.rvm/gems/ruby-2.4.3@waltz/bin/rake:23:in `<main>'
/data/rvm_installtion/.rvm/gems/ruby-2.4.3@waltz/bin/ruby_executable_hooks:15:in `eval'
/data/rvm_installtion/.rvm/gems/ruby-2.4.3@waltz/bin/ruby_executable_hooks:15:in `<main>'
Couldn't create database for {"adapter"=>"postgresql", "encoding"=>"unicode", "pool"=>5, "username"=>"postgres", "host"=>"localhost", "database"=>"test_database_name"}

Please suggest. I am using Ruby 2.4.3 and Rails 3.2.22.5.

here is my database.yml file

DEFAULTS: &DEFAULTS
adapter: postgresql
encoding: unicode
pool: 5
username: postgres
host: localhost

development:
<<: *DEFAULTS
database: development

test: &test
<<: *DEFAULTS
database: test_2

staging:
<<: *test

production:
<<: *test

Thanks in Advance

please show us the `config/database.yml` and schema file. – Greg Jan 18 '18 at 10:20 — Greg, Jan 18 '18 at 10:20
@meta I have updated the database.yml file. – Rajesh Naik Rathod Jan 18 '18 at 13:25 — Rajesh Naik Rathod, Jan 18 '18 at 13:25

score 3 · Answer 1 · answered Jan 18 '18 at 17:36

3

Downgrade ruby version (e.g. 2.2)

It looks like rails 3.2 does not support ruby 2.4 (https://stackoverflow.com/a/23532476/299774)

answered Jan 18 '18 at 17:36

Greg

5,862
1
25
52

Can I Upgrade rails in that case? if yes which version will be best for ruby 2.4.3? – Rajesh Naik Rathod Jan 19 '18 at 07:00
Sure, if you can - go with the latest stable version. Or check the docs. I don't know if there are any quirks. – Greg Jan 19 '18 at 08:31

score 0 · Answer 2 · answered Mar 17 '21 at 19:36

This is terrible, but you can also add the following code to an initializer:

module ActiveRecord
  module ConnectionAdapters
    class PostgreSQLAdapter < AbstractAdapter
      def create_database(name, options = {})
        options = options.reverse_merge(:encoding => "utf8")

        option_string = options.symbolize_keys.map do |key, value|
          case key
          when :owner
            " OWNER = \"#{value}\""
          when :template
            " TEMPLATE = \"#{value}\""
          when :encoding
            " ENCODING = '#{value}'"
          when :tablespace
            " TABLESPACE = \"#{value}\""
          when :connection_limit
            " CONNECTION LIMIT = #{value}"
          else
            ""
          end
        end

        option_string = option_string.join("")

        execute "CREATE DATABASE #{quote_table_name(name)}#{option_string}"
      end
    end
  end
end

This alters the problematic code from activerecord3.2.22.5/lib/active_record/connection_adapters/postgresql_adapter.rb:747; everything else should work.

score 0 · Answer 3 · answered Jun 24 '22 at 20:43

config/initializers/postgresql_adapter.rb

require 'active_record/connection_adapters/postgresql_adapter'

class ActiveRecord::ConnectionAdapters::PostgreSQLAdapter
  def create_database(name, options = {})
    options = options.reverse_merge(:encoding => "utf8")

    option_string = options.symbolize_keys.sum('') do |key, value|
      case key
      when :owner
        " OWNER = \"#{value}\""
      when :template
        " TEMPLATE = \"#{value}\""
      when :encoding
        " ENCODING = '#{value}'"
      when :tablespace
        " TABLESPACE = \"#{value}\""
      when :connection_limit
        " CONNECTION LIMIT = #{value}"
      else
        ""
      end
    end

    execute "CREATE DATABASE #{quote_table_name(name)}#{option_string}"
  end
end

and then add line:

require File.expand_path('../config/initializers/postgresql_adapter', __FILE__)

into Rakefile

String can't be coerced into Integer, when running rake db:create in test environment

3 Answers3