投稿2020/08/21 01:56
Docker上でRspecを走らせようとしたところエラーが発生してしまいました。
MySQLとの接続が上手くいっていないようです。
database.ymlとdocker-compose.ymlを見直しても問題があるようには見えず、コンテナとイメージを全て削除して再び起動してもエラーコードの内容は変わりませんでした。
アドバイス等ありましたら頂けると幸いです。
よろしくお願いします。
Ruby 2.5.1
Rails 5.2.4.3
Mac OS
#エラーコード
console
1~@yk golfour_aws % bundle exec rspec 2An error occurred while loading ./spec/system/training_posts_spec.rb. 3Failure/Error: ActiveRecord::Migration.maintain_test_schema! 4 5Mysql2::Error::ConnectionError: 6 Unknown MySQL server host 'db-test' (0) 7# ./spec/rails_helper.rb:28:in `<top (required)>' 8# ./spec/system/training_posts_spec.rb:1:in `require' 9# ./spec/system/training_posts_spec.rb:1:in `<top (required)>' 10No examples found. 11 12Finished in 0.00004 seconds (files took 2.88 seconds to load) 130 examples, 0 failures, 1 error occurred outside of examples
docker-compose.yml:
version: '3' services: db: image: mysql:8.0 command: --default-authentication-plugin=mysql_native_password environment: MYSQL_ROOT_PASSWORD: password MYSQL_DATABASE: golfour_development MYSQL_USER: yuki MYSQL_PASSWORD: password TZ: Asia/Tokyo volumes: - ./mysql/mysql_data:/var/lib/mysql - ./logs:/var/log/mysql - ./mysql/my.cnf:/etc/mysql/conf.d/my.cnf ports: - "4306:3306" db-test: image: mysql:8.0 command: --default-authentication-plugin=mysql_native_password environment: MYSQL_ROOT_PASSWORD: password MYSQL_DATABASE: golfour_test MYSQL_USER: yuki MYSQL_PASSWORD: password TZ: Asia/Tokyo volumes: - ./mysql/my.cnf:/etc/mysql/conf.d/my.cnf tmpfs: - /var/lib/mysql - /var/log/mysql ports: - "5306:3306" web: build: context: . dockerfile: Dockerfile command: /bin/sh -c "rm -f /workdir/tmp/pids/server.pid && bundle exec rails s -p 3000 -b '0.0.0.0'" tty: true stdin_open: true depends_on: - db - db-test ports: - "3000:3000" volumes: - .:/workdir
database.yml:
default: &default adapter: mysql2 encoding: utf8 pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %> development: <<: *default database: golfour_development username: yuki password: password host: db socket: /tmp/mysql.sock test: <<: *default database: golfour_test username: yuki password: password host: db-test socket: /tmp/mysql.sock production: <<: *default database: <%= ENV['DB_NAME'] %> username: <%= ENV['DB_USERNAME'] %> password: <%= ENV['DB_PASSWORD'] %> host: <%= ENV['DB_HOSTNAME'] %>
rails.helper:
# This file is copied to spec/ when you run 'rails generate rspec:install' require 'spec_helper' ENV['RAILS_ENV'] ||= 'test' require File.expand_path('../config/environment', __dir__) # Prevent database truncation if the environment is production abort("The Rails environment is running in production mode!") if Rails.env.production? require 'rspec/rails' # Add additional requires below this line. Rails is not loaded until this point! # Requires supporting ruby files with custom matchers and macros, etc, in # spec/support/ and its subdirectories. Files matching `spec/**/*_spec.rb` are # run as spec files by default. This means that files in spec/support that end # in _spec.rb will both be required and run as specs, causing the specs to be # run twice. It is recommended that you do not name files matching this glob to # end with _spec.rb. You can configure this pattern with the --pattern # option on the command line or in ~/.rspec, .rspec or `.rspec-local`. # # The following line is provided for convenience purposes. It has the downside # of increasing the boot-up time by auto-requiring all files in the support # directory. Alternatively, in the individual `*_spec.rb` files, manually # require only the support files necessary. # # Dir[Rails.root.join('spec', 'support', '**', '*.rb')].sort.each { |f| require f } # Checks for pending migrations and applies them before tests are run. # If you are not using ActiveRecord, you can remove these lines. begin ActiveRecord::Migration.maintain_test_schema! rescue ActiveRecord::PendingMigrationError => e puts e.to_s.strip exit 1 end RSpec.configure do |config| # Remove this line if you're not using ActiveRecord or ActiveRecord fixtures config.fixture_path = "#{::Rails.root}/spec/fixtures" # If you're not using ActiveRecord, or you'd prefer not to run each of your # examples within a transaction, remove the following line or assign false # instead of true. config.use_transactional_fixtures = true # You can uncomment this line to turn off ActiveRecord support entirely. # config.use_active_record = false # RSpec Rails can automatically mix in different behaviours to your tests # based on their file location, for example enabling you to call `get` and # `post` in specs under `spec/controllers`. # # You can disable this behaviour by removing the line below, and instead # explicitly tag your specs with their type, e.g.: # # RSpec.describe UsersController, type: :controller do # # ... # end # # The different available types are documented in the features, such as in # https://relishapp.com/rspec/rspec-rails/docs config.infer_spec_type_from_file_location! # Filter lines from Rails gems in backtraces. config.filter_rails_from_backtrace! # arbitrary gems may also be filtered via: # config.filter_gems_from_backtrace("gem name") end
回答2件
0
docker-composer up後に
docker psで"db", "db-test"いずれも起動していますか？
投稿2020/08/21 05:47
総合スコア424
0
ベストアンサー
たとえば、web から ping を実行してみるとどうでしょうか？
console
1root@3ac5aad020bf:/workdir# ping db-test 2PING db-test (172.31.0.2) 56(84) bytes of data. 364 bytes from test-docker-286284_db-test_1.test-docker-286284_default (172.31.0.2): icmp_seq=1 ttl=64 time=0.116 ms 464 bytes from test-docker-286284_db-test_1.test-docker-286284_default (172.31.0.2): icmp_seq=2 ttl=64 time=0.067 ms 564 bytes from test-docker-286284_db-test_1.test-docker-286284_default (172.31.0.2): icmp_seq=3 ttl=64 time=0.082 ms 664 bytes from test-docker-286284_db-test_1.test-docker-286284_default (172.31.0.2): icmp_seq=4 ttl=64 time=0.070 ms
こちらで質問欄のコードをすべて使い動作確認を行ったところ、
rspec は実行できました:
console
1root@385d4f318198:/workdir# bundle exec rspec 22020-08-21 06:36:20 WARN Selenium [DEPRECATION] Selenium::WebDriver::Chrome#driver_path= is deprecated. Use Selenium::WebDriver::Chrome::Service#driver_path= instead. 3. 4 5Finished in 0.07961 seconds (files took 1.63 seconds to load) 61 example, 0 failures
database.yml を次のように書き換えると:
diff
1- host: db-test 2+ host: db-not-exist
console
1root@385d4f318198:/workdir# bundle exec rspec 22020-08-21 06:36:52 WARN Selenium [DEPRECATION] Selenium::WebDriver::Chrome#driver_path= is deprecated. Use Selenium::WebDriver::Chrome::Service#driver_path= instead. 3 4An error occurred while loading ./spec/models/test_spec.rb. 5Failure/Error: ActiveRecord::Migration.maintain_test_schema! 6 7Mysql2::Error::ConnectionError: 8 Unknown MySQL server host 'db-not-exist' (-2) 9# /usr/local/bundle/gems/mysql2-0.5.3/lib/mysql2/client.rb:90:in `connect' 10# /usr/local/bundle/gems/mysql2-0.5.3/lib/mysql2/client.rb:90:in `initialize' 11# /usr/local/bundle/gems/activerecord-5.2.4.3/lib/active_record/connection_adapters/mysql2_adapter.rb:22:in `new' 12# /usr/local/bundle/gems/activerecord-5.2.4.3/lib/active_record/connection_adapters/mysql2_adapter.rb:22:in `mysql2_connection' 13# /usr/local/bundle/gems/activerecord-5.2.4.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:830:in `new_connection' 14# /usr/local/bundle/gems/activerecord-5.2.4.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:874:in `checkout_new_connection' 15# /usr/local/bundle/gems/activerecord-5.2.4.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:853:in `try_to_checkout_new_connection' 16# /usr/local/bundle/gems/activerecord-5.2.4.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:814:in `acquire_connection' 17# /usr/local/bundle/gems/activerecord-5.2.4.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:538:in `checkout' 18# /usr/local/bundle/gems/activerecord-5.2.4.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:382:in `connection' 19# /usr/local/bundle/gems/activerecord-5.2.4.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:1033:in `retrieve_connection' 20# /usr/local/bundle/gems/activerecord-5.2.4.3/lib/active_record/connection_handling.rb:118:in `retrieve_connection' 21# /usr/local/bundle/gems/activerecord-5.2.4.3/lib/active_record/connection_handling.rb:90:in `connection' 22# /usr/local/bundle/gems/activerecord-5.2.4.3/lib/active_record/migration.rb:583:in `load_schema_if_pending!' 23# /usr/local/bundle/gems/activerecord-5.2.4.3/lib/active_record/migration.rb:599:in `block in maintain_test_schema!' 24# /usr/local/bundle/gems/activerecord-5.2.4.3/lib/active_record/migration.rb:848:in `suppress_messages' 25# /usr/local/bundle/gems/activerecord-5.2.4.3/lib/active_record/migration.rb:604:in `method_missing' 26# /usr/local/bundle/gems/activerecord-5.2.4.3/lib/active_record/migration.rb:599:in `maintain_test_schema!' 27# ./spec/rails_helper.rb:93:in `<top (required)>' 28# ./spec/models/test_spec.rb:1:in `require' 29# ./spec/models/test_spec.rb:1:in `<top (required)>' 30No examples found. 31 32 33Finished in 0.00005 seconds (files took 2.5 seconds to load) 340 examples, 0 failures, 1 error occurred outside of examples
そのため、質問欄に提示されているコード自体は誤っていなさそうです
おそらく、次のようにすると実行できます:
console
1RAILS_ENV=development bundle exec rspec
ただし、開発で利用しているデータベース golfour_development を使うことになるので、
rspec の内容によっては golfour_development の状態が変化することに注意します
rspec は規定の動作では config/database.yml の test のデータベースを使って動作します
しかし、MySQL の公式イメージでは複数のデータベースを作成する手順をサポートしていません
参考:
もし、データベースを分けたい場合は、
何かしらの方法で自身で test のデータベースを作成する必要があります
例えば、次のような方法が考えられます:
Q&Aroot として接続するようにして rails db:create.sql や .sh として作成して、そのファイルが配置されているディレクトリーを /docker-entrypoint-initdb.d に volumes で bind マウントただし、開発で何度も使うデータは factory_bot で定義する、という習慣があれば、
個人的には上記の対応を行わなくても、それほど不便は感じません
参考: thoughtbot/factory_bot: A library for setting up Ruby objects as test data.
投稿2020/08/21 04:40
編集2020/08/21 06:47
総合スコア3272
あなたの回答
tips
プレビュー
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。
2020/08/21 05:52
2020/08/21 06:43
2020/08/21 09:10
2020/08/21 09:12