Closed alecslupu closed 11 years ago
Apparently the problem is here : https://github.com/rails/rails/blob/master/activerecord/lib/active_record/tasks/mysql_database_tasks.rb#L81
if i return configuration there will not longer throw that exception, but ... will return this instead:
Couldn't create database for {"host"=>"localhost", "adapter"=>"mysql2", "encoding"=>"utf8", "database"=>"App_test", "pool"=>5, "username"=>"root", "password"=>"****", "socket"=>"/tmp/mysql.sock"}, {:charset=>"utf8", :collation=>"utf8_unicode_ci"}
(If you set the charset manually, make sure you have a matching collation)
My databases.yml file
development:
host: localhost
adapter: mysql2
encoding: utf8
database: App_development
pool: 5
username: root
password: ***(my real password)
socket: /tmp/mysql.sock
# Warning: The database defined as "test" will be erased and
# re-generated from your development database when you run "rake".
# Do not set this db to the same as development or production.
test:
host: localhost
adapter: mysql2
encoding: utf8
database: App_test
pool: 5
username: root
password: ***(my real password)
socket: /tmp/mysql.sock
production:
host: localhost
adapter: mysql2
encoding: utf8
database: App_production
pool: 5
username: root
password: ***(my real password)
socket: /tmp/mysql.sock
@alecslupu I have tested this with master and i don't get error while creating database. I think there is some problem in your mysql configuration. Can you verify that you can connect to mysql from terminal
@prathamesh-sonpatki I have copied the config from a rails 3.2.x project, however the problem occurs when using mysql2 gem. When using mysql class, there is no problem apparently. If you could tell me what i can do in order to help you fixing the problem ... It would be great. I have ran the tests from active_record tests and the bug still occurs.
@prathamesh-sonpatki Maybe this can help you ... I have replaced my realproject name with *\ as i'd like to be private .
[ alecslupu ~/Sites/***/rails4/rails/activerecord ] git status
# On branch master
nothing to commit (working directory clean)
[ alecslupu ~/Sites/***/***/rails/activerecord ] bundle exec rake test_mysql2
/Users/alecslupu/.rvm/rubies/ruby-1.9.3-p125-gcdata/bin/ruby -w -I"lib:test" -I"/Users/alecslupu/.gems/gems/rake-10.1.0/lib" "/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/rake_test_loader.rb" "test/cases/adapter_test.rb" "test/cases/adapters/mysql2/active_schema_test.rb" "test/cases/adapters/mysql2/bind_parameter_test.rb" "test/cases/adapters/mysql2/case_sensitivity_test.rb" "test/cases/adapters/mysql2/connection_test.rb" "test/cases/adapters/mysql2/enum_test.rb" "test/cases/adapters/mysql2/explain_test.rb" "test/cases/adapters/mysql2/reserved_word_test.rb" "test/cases/adapters/mysql2/schema_migrations_test.rb" "test/cases/adapters/mysql2/schema_test.rb" "test/cases/adapters/mysql2/sql_types_test.rb" "test/cases/aggregations_test.rb" "test/cases/ar_schema_test.rb" "test/cases/associations/association_scope_test.rb" "test/cases/associations/belongs_to_associations_test.rb" "test/cases/associations/callbacks_test.rb" "test/cases/associations/cascaded_eager_loading_test.rb" "test/cases/associations/eager_load_includes_full_sti_class_test.rb" "test/cases/associations/eager_load_nested_include_test.rb" "test/cases/associations/eager_singularization_test.rb" "test/cases/associations/eager_test.rb" "test/cases/associations/extension_test.rb" "test/cases/associations/has_and_belongs_to_many_associations_test.rb" "test/cases/associations/has_many_associations_test.rb" "test/cases/associations/has_many_through_associations_test.rb" "test/cases/associations/has_one_associations_test.rb" "test/cases/associations/has_one_through_associations_test.rb" "test/cases/associations/inner_join_association_test.rb" "test/cases/associations/inverse_associations_test.rb" "test/cases/associations/join_dependency_test.rb" "test/cases/associations/join_model_test.rb" "test/cases/associations/nested_through_associations_test.rb" "test/cases/associations_test.rb" "test/cases/attribute_methods/read_test.rb" "test/cases/attribute_methods/serialization_test.rb" "test/cases/attribute_methods_test.rb" "test/cases/autosave_association_test.rb" "test/cases/base_test.rb" "test/cases/batches_test.rb" "test/cases/binary_test.rb" "test/cases/bind_parameter_test.rb" "test/cases/calculations_test.rb" "test/cases/callbacks_test.rb" "test/cases/clone_test.rb" "test/cases/coders/yaml_column_test.rb" "test/cases/column_alias_test.rb" "test/cases/column_definition_test.rb" "test/cases/column_test.rb" "test/cases/connection_adapters/abstract_adapter_test.rb" "test/cases/connection_adapters/connection_handler_test.rb" "test/cases/connection_adapters/connection_specification_test.rb" "test/cases/connection_adapters/quoting_test.rb" "test/cases/connection_adapters/schema_cache_test.rb" "test/cases/connection_management_test.rb" "test/cases/connection_pool_test.rb" "test/cases/connection_specification/resolver_test.rb" "test/cases/core_test.rb" "test/cases/counter_cache_test.rb" "test/cases/custom_locking_test.rb" "test/cases/database_statements_test.rb" "test/cases/date_time_test.rb" "test/cases/defaults_test.rb" "test/cases/dirty_test.rb" "test/cases/disconnected_test.rb" "test/cases/dup_test.rb" "test/cases/explain_subscriber_test.rb" "test/cases/explain_test.rb" "test/cases/finder_respond_to_test.rb" "test/cases/finder_test.rb" "test/cases/fixture_set/file_test.rb" "test/cases/fixtures_test.rb" "test/cases/forbidden_attributes_protection_test.rb" "test/cases/habtm_destroy_order_test.rb" "test/cases/hot_compatibility_test.rb" "test/cases/i18n_test.rb" "test/cases/inheritance_test.rb" "test/cases/integration_test.rb" "test/cases/invalid_connection_test.rb" "test/cases/invalid_date_test.rb" "test/cases/invertible_migration_test.rb" "test/cases/json_serialization_test.rb" "test/cases/locking_test.rb" "test/cases/log_subscriber_test.rb" "test/cases/migration/change_schema_test.rb" "test/cases/migration/change_table_test.rb" "test/cases/migration/column_attributes_test.rb" "test/cases/migration/column_positioning_test.rb" "test/cases/migration/columns_test.rb" "test/cases/migration/command_recorder_test.rb" "test/cases/migration/create_join_table_test.rb" "test/cases/migration/index_test.rb" "test/cases/migration/logger_test.rb" "test/cases/migration/references_index_test.rb" "test/cases/migration/references_statements_test.rb" "test/cases/migration/rename_table_test.rb" "test/cases/migration/table_and_index_test.rb" "test/cases/migration_test.rb" "test/cases/migrator_test.rb" "test/cases/mixin_test.rb" "test/cases/modules_test.rb" "test/cases/multiparameter_attributes_test.rb" "test/cases/multiple_db_test.rb" "test/cases/nested_attributes_test.rb" "test/cases/persistence_test.rb" "test/cases/pooled_connections_test.rb" "test/cases/primary_keys_test.rb" "test/cases/query_cache_test.rb" "test/cases/quoting_test.rb" "test/cases/readonly_test.rb" "test/cases/reaper_test.rb" "test/cases/reflection_test.rb" "test/cases/relation/where_chain_test.rb" "test/cases/relation/where_test.rb" "test/cases/relation_test.rb" "test/cases/relations_test.rb" "test/cases/reload_models_test.rb" "test/cases/result_test.rb" "test/cases/sanitize_test.rb" "test/cases/schema_dumper_test.rb" "test/cases/scoping/default_scoping_test.rb" "test/cases/scoping/named_scoping_test.rb" "test/cases/scoping/relation_scoping_test.rb" "test/cases/serialization_test.rb" "test/cases/serialized_attribute_test.rb" "test/cases/statement_cache_test.rb" "test/cases/store_test.rb" "test/cases/tasks/database_tasks_test.rb" "test/cases/tasks/mysql_rake_test.rb" "test/cases/tasks/postgresql_rake_test.rb" "test/cases/tasks/sqlite_rake_test.rb" "test/cases/timestamp_test.rb" "test/cases/transaction_callbacks_test.rb" "test/cases/transaction_isolation_test.rb" "test/cases/transactions_test.rb" "test/cases/unconnected_test.rb" "test/cases/validations/association_validation_test.rb" "test/cases/validations/i18n_generate_message_validation_test.rb" "test/cases/validations/i18n_validation_test.rb" "test/cases/validations/presence_validation_test.rb" "test/cases/validations/uniqueness_validation_test.rb" "test/cases/validations_test.rb" "test/cases/xml_serialization_test.rb" "test/cases/yaml_serialization_test.rb"
Using mysql2
/Users/alecslupu/.gems/gems/mysql2-0.3.13/lib/mysql2/client.rb:58:in `connect': Unknown database 'rails4' (Mysql2::Error)
from /Users/alecslupu/.gems/gems/mysql2-0.3.13/lib/mysql2/client.rb:58:in `initialize'
from /Users/alecslupu/Sites/***/rails4/rails/activerecord/lib/active_record/connection_adapters/mysql2_adapter.rb:18:in `new'
from /Users/alecslupu/Sites/***/rails4/rails/activerecord/lib/active_record/connection_adapters/mysql2_adapter.rb:18:in `mysql2_connection'
from /Users/alecslupu/Sites/***/rails4/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:435:in `new_connection'
from /Users/alecslupu/Sites/***/rails4/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:445:in `checkout_new_connection'
from /Users/alecslupu/Sites/***/rails4/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in `acquire_connection'
from /Users/alecslupu/Sites/***/rails4/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:351:in `block in checkout'
from /Users/alecslupu/.rvm/rubies/ruby-1.9.3-p125-gcdata/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
from /Users/alecslupu/Sites/***/rails4/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:350:in `checkout'
from /Users/alecslupu/Sites/***/rails4/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:265:in `block in connection'
from /Users/alecslupu/.rvm/rubies/ruby-1.9.3-p125-gcdata/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
from /Users/alecslupu/Sites/***/rails4/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:264:in `connection'
from /Users/alecslupu/Sites/***/rails4/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:541:in `retrieve_connection'
from /Users/alecslupu/Sites/***/rails4/rails/activerecord/lib/active_record/connection_handling.rb:79:in `retrieve_connection'
from /Users/alecslupu/Sites/***/rails4/rails/activerecord/lib/active_record/connection_handling.rb:53:in `connection'
from /Users/alecslupu/Sites/***/rails4/rails/activerecord/test/cases/helper.rb:27:in `<top (required)>'
from /Users/alecslupu/Sites/***/rails4/rails/activerecord/test/cases/adapter_test.rb:1:in `require'
from /Users/alecslupu/Sites/***/rails4/rails/activerecord/test/cases/adapter_test.rb:1:in `<top (required)>'
from /Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/rake_test_loader.rb:15:in `require'
from /Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/rake_test_loader.rb:15:in `block in <main>'
from /Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/rake_test_loader.rb:4:in `select'
from /Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/rake_test_loader.rb:4:in `<main>'
rake aborted!
Command failed with status (1): [ruby -w -I"lib:test" -I"/Users/alecslupu/.gems/gems/rake-10.1.0/lib" "/Users/alecslupu/.gems/gems/rake-10.1.0/lib/rake/rake_test_loader.rb" "test/cases/adapter_test.rb" "test/cases/adapters/mysql2/active_schema_test.rb" "test/cases/adapters/mysql2/bind_parameter_test.rb" "test/cases/adapters/mysql2/case_sensitivity_test.rb" "test/cases/adapters/mysql2/connection_test.rb" "test/cases/adapters/mysql2/enum_test.rb" "test/cases/adapters/mysql2/explain_test.rb" "test/cases/adapters/mysql2/reserved_word_test.rb" "test/cases/adapters/mysql2/schema_migrations_test.rb" "test/cases/adapters/mysql2/schema_test.rb" "test/cases/adapters/mysql2/sql_types_test.rb" "test/cases/aggregations_test.rb" "test/cases/ar_schema_test.rb" "test/cases/associations/association_scope_test.rb" "test/cases/associations/belongs_to_associations_test.rb" "test/cases/associations/callbacks_test.rb" "test/cases/associations/cascaded_eager_loading_test.rb" "test/cases/associations/eager_load_includes_full_sti_class_test.rb" "test/cases/associations/eager_load_nested_include_test.rb" "test/cases/associations/eager_singularization_test.rb" "test/cases/associations/eager_test.rb" "test/cases/associations/extension_test.rb" "test/cases/associations/has_and_belongs_to_many_associations_test.rb" "test/cases/associations/has_many_associations_test.rb" "test/cases/associations/has_many_through_associations_test.rb" "test/cases/associations/has_one_associations_test.rb" "test/cases/associations/has_one_through_associations_test.rb" "test/cases/associations/inner_join_association_test.rb" "test/cases/associations/inverse_associations_test.rb" "test/cases/associations/join_dependency_test.rb" "test/cases/associations/join_model_test.rb" "test/cases/associations/nested_through_associations_test.rb" "test/cases/associations_test.rb" "test/cases/attribute_methods/read_test.rb" "test/cases/attribute_methods/serialization_test.rb" "test/cases/attribute_methods_test.rb" "test/cases/autosave_association_test.rb" "test/cases/base_test.rb" "test/cases/batches_test.rb" "test/cases/binary_test.rb" "test/cases/bind_parameter_test.rb" "test/cases/calculations_test.rb" "test/cases/callbacks_test.rb" "test/cases/clone_test.rb" "test/cases/coders/yaml_column_test.rb" "test/cases/column_alias_test.rb" "test/cases/column_definition_test.rb" "test/cases/column_test.rb" "test/cases/connection_adapters/abstract_adapter_test.rb" "test/cases/connection_adapters/connection_handler_test.rb" "test/cases/connection_adapters/connection_specification_test.rb" "test/cases/connection_adapters/quoting_test.rb" "test/cases/connection_adapters/schema_cache_test.rb" "test/cases/connection_management_test.rb" "test/cases/connection_pool_test.rb" "test/cases/connection_specification/resolver_test.rb" "test/cases/core_test.rb" "test/cases/counter_cache_test.rb" "test/cases/custom_locking_test.rb" "test/cases/database_statements_test.rb" "test/cases/date_time_test.rb" "test/cases/defaults_test.rb" "test/cases/dirty_test.rb" "test/cases/disconnected_test.rb" "test/cases/dup_test.rb" "test/cases/explain_subscriber_test.rb" "test/cases/explain_test.rb" "test/cases/finder_respond_to_test.rb" "test/cases/finder_test.rb" "test/cases/fixture_set/file_test.rb" "test/cases/fixtures_test.rb" "test/cases/forbidden_attributes_protection_test.rb" "test/cases/habtm_destroy_order_test.rb" "test/cases/hot_compatibility_test.rb" "test/cases/i18n_test.rb" "test/cases/inheritance_test.rb" "test/cases/integration_test.rb" "test/cases/invalid_connection_test.rb" "test/cases/invalid_date_test.rb" "test/cases/invertible_migration_test.rb" "test/cases/json_serialization_test.rb" "test/cases/locking_test.rb" "test/cases/log_subscriber_test.rb" "test/cases/migration/change_schema_test.rb" "test/cases/migration/change_table_test.rb" "test/cases/migration/column_attributes_test.rb" "test/cases/migration/column_positioning_test.rb" "test/cases/migration/columns_test.rb" "test/cases/migration/command_recorder_test.rb" "test/cases/migration/create_join_table_test.rb" "test/cases/migration/index_test.rb" "test/cases/migration/logger_test.rb" "test/cases/migration/references_index_test.rb" "test/cases/migration/references_statements_test.rb" "test/cases/migration/rename_table_test.rb" "test/cases/migration/table_and_index_test.rb" "test/cases/migration_test.rb" "test/cases/migrator_test.rb" "test/cases/mixin_test.rb" "test/cases/modules_test.rb" "test/cases/multiparameter_attributes_test.rb" "test/cases/multiple_db_test.rb" "test/cases/nested_attributes_test.rb" "test/cases/persistence_test.rb" "test/cases/pooled_connections_test.rb" "test/cases/primary_keys_test.rb" "test/cases/query_cache_test.rb" "test/cases/quoting_test.rb" "test/cases/readonly_test.rb" "test/cases/reaper_test.rb" "test/cases/reflection_test.rb" "test/cases/relation/where_chain_test.rb" "test/cases/relation/where_test.rb" "test/cases/relation_test.rb" "test/cases/relations_test.rb" "test/cases/reload_models_test.rb" "test/cases/result_test.rb" "test/cases/sanitize_test.rb" "test/cases/schema_dumper_test.rb" "test/cases/scoping/default_scoping_test.rb" "test/cases/scoping/named_scoping_test.rb" "test/cases/scoping/relation_scoping_test.rb" "test/cases/serialization_test.rb" "test/cases/serialized_attribute_test.rb" "test/cases/statement_cache_test.rb" "test/cases/store_test.rb" "test/cases/tasks/database_tasks_test.rb" "test/cases/tasks/mysql_rake_test.rb" "test/cases/tasks/postgresql_rake_test.rb" "test/cases/tasks/sqlite_rake_test.rb" "test/cases/timestamp_test.rb" "test/cases/transaction_callbacks_test.rb" "test/cases/transaction_isolation_test.rb" "test/cases/transactions_test.rb" "test/cases/unconnected_test.rb" "test/cases/validations/association_validation_test.rb" "test/cases/validations/i18n_generate_message_validation_test.rb" "test/cases/validations/i18n_validation_test.rb" "test/cases/validations/presence_validation_test.rb" "test/cases/validations/uniqueness_validation_test.rb" "test/cases/validations_test.rb" "test/cases/xml_serialization_test.rb" "test/cases/yaml_serialization_test.rb" ]
Tasks: TOP => test_mysql2
(See full trace by running task with --trace)
[ alecslupu ~/Sites/***/rails4/rails/activerecord ]
And my gem list ...
[ alecslupu ~/Sites/***/rails4/rails/activerecord ] gem list
*** LOCAL GEMS ***
actionmailer (4.0.0)
actionpack (4.0.0)
activemodel (4.0.0)
activerecord (4.0.0)
activerecord-deprecated_finders (1.0.3)
activesupport (4.0.0)
arel (4.0.0)
atomic (1.1.10)
builder (3.1.4)
bundler (1.3.5)
erubis (2.7.0)
hike (1.2.3)
i18n (0.6.4)
mail (2.5.4)
mime-types (1.23)
minitest (4.7.5)
multi_json (1.7.7)
polyglot (0.3.3)
rack (1.5.2)
rack-test (0.6.2)
rails (4.0.0)
railties (4.0.0)
rake (10.0.4)
rubygems-bundler (1.1.1)
rvm (1.11.3.7)
sprockets (2.10.0)
sprockets-rails (2.0.0)
thor (0.18.1)
thread_safe (0.1.0)
tilt (1.4.1)
treetop (1.4.14)
tzinfo (0.3.37)
[ alecslupu ~/Sites/***/rails4/rails/activerecord ] bundle list
Gems included by the bundle:
* actionmailer (4.1.0.beta)
* actionpack (4.1.0.beta)
* actionview (4.1.0.beta)
* activemodel (4.1.0.beta)
* activerecord (4.1.0.beta)
* activesupport (4.1.0.beta)
* arel (4.0.0)
* atomic (1.1.10)
* bcrypt-ruby (3.1.1)
* benchmark-ips (1.2.0)
* builder (3.1.4)
* bundler (1.3.5)
* coffee-rails (4.0.0)
* coffee-script (2.2.0)
* coffee-script-source (1.6.3)
* columnize (0.3.6)
* dalli (2.6.4)
* debugger (1.6.1)
* debugger-linecache (1.2.0)
* debugger-ruby_core_source (1.2.3)
* erubis (2.7.0)
* execjs (1.4.0)
* hike (1.2.3)
* i18n (0.6.4)
* jquery-rails (2.2.2)
* json (1.8.0)
* kindlerb (0.1.1)
* mail (2.5.4)
* metaclass (0.0.1)
* mime-types (1.23)
* mini_portile (0.5.1)
* minitest (5.0.6)
* mocha (0.14.0)
* multi_json (1.7.7)
* mustache (0.99.4)
* mysql (2.9.1)
* mysql2 (0.3.13)
* nokogiri (1.6.0)
* pg (0.15.1)
* polyglot (0.3.3)
* racc (1.4.9)
* rack (1.5.2)
* rack-cache (1.2)
* rack-test (0.6.2)
* rails (4.1.0.beta 34b8953)
* railties (4.1.0.beta)
* rake (10.1.0)
* rdoc (3.12.2)
* redcarpet (2.2.2)
* ruby-prof (0.11.3)
* sdoc (0.3.20)
* sprockets (2.10.0)
* sprockets-rails (2.0.0)
* sqlite3 (1.3.7)
* thor (0.18.1)
* thread_safe (0.1.0)
* tilt (1.4.1)
* treetop (1.4.14)
* turbolinks (1.3.0)
* tzinfo (0.3.37)
* uglifier (2.1.2)
* w3c_validators (1.2)
* yajl-ruby (1.1.0)
[ alecslupu ~/Sites/***/rails4/rails/activerecord ]
@alecslupu I don't think its a bug. Can you upload your app to github ? Thanks.
@prathamesh-sonpatki My application is a new one, so no gems installed, nor other configs/ as you can see, i have added in a comment the full stack of activerecord test results. I will purge my gems, and i will try to see if i can reproduce it.
@prathamesh-sonpatki I have added you as a contributor to a private repo...
@prathamesh-sonpatki Apparently is not a rails / activerecord bug. Using mysql2 version 0.3.12 the application works perfectly. When using mysql2 0.3.13, the app breaks (0.3.13 has been released on july 17) ... @brianmario, You might wanna check this ?
After @prathamesh-sonpatki had an eye on my application, he found out that i had a problem in my database.yml . My problem seemed to be the existence of socket parameter in my database config file.
Can be closed if not a rails issue ...
Yup.
Hello! my database name is stripped away from config when i reach mysql connect method inside the gem. I get this error on my first install of rails 4.0.0 in a new project.
Env:
Backtrace