質問編集履歴

docker-compose logsの追記

2020/03/15 08:33

投稿

Pichan.

スコア4

title CHANGED Viewed

File without changes

body CHANGED Viewed

@@ -154,18 +154,50 @@
 ### 試したこと
-例）[試した記事](https://qiita.com/t-izaki/items/c6ef3239176f9c6697f2)この記事などの
-config.ymlにあるcircleciのrubyとmysqlのimageでのやり方なども試しましたが同じエラーがおこります。
 ローカル環境ではdocker-compose dowon させてからbuildしてdb:create migrate問題なくできます。
-config.ymlでのsleep後にdocker-compose psコマンドを入れてコンテナの状態なども確認しましたが全てのコンテナ立ち上がっていました。
+config.ymlでのsleep後にdocker-compose logsコマンドを入れてコンテナの状態です。
+RAILS_MASTER_KEYを渡せずwebサーバーでundefined method `[]' for nil:NilClassが出ています。
+devise.rbではomniauthの環境変数をcredentialsで渡している為です。
 ```
-docker-compose ps
-      Name                    Command               State                 Ports
----------------------------------------------------------------------------------------------
-project_chrome_1   /opt/bin/entry_point.sh          Up      0.0.0.0:4444->4444/tcp
-project_db_1       docker-entrypoint.sh mysql ...   Up      0.0.0.0:3306->3306/tcp, 33060/tcp
-project_nginx_1    /bin/sh -c /usr/sbin/nginx ...   Up      0.0.0.0:80->80/tcp
-project_web_1      bundle exec puma -C /app/c ...   Up      0.0.0.0:3000->3000/tcp
+#!/bin/bash -eo pipefail
+docker-compose logs
+Attaching to project_nginx_1, project_web_1, project_chrome_1, project_db_1
+web_1     | Puma starting in single mode...
+web_1     | * Version 3.12.4 (ruby 2.5.1-p57), codename: Llamas in Pajamas
+web_1     | * Min threads: 5, max threads: 5
+web_1     | * Environment: development
+web_1     | ! Unable to load application: NoMethodError: undefined method `[]' for nil:NilClass
+web_1     | bundler: failed to load command: puma (/usr/local/bundle/bin/puma)
+db_1      | 2020-03-15 08:15:59+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.29-1debian10 started.
+web_1     | NoMethodError: undefined method `[]' for nil:NilClass
+web_1     |   /app/config/initializers/devise.rb:305:in `block in <top (required)>'
+db_1      | 2020-03-15 08:15:59+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
+db_1      | 2020-03-15 08:15:59+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.29-1debian10 started.
+db_1      | 2020-03-15 08:15:59+00:00 [Note] [Entrypoint]: Initializing database files
+db_1      | 2020-03-15T08:15:59.597544Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
+web_1     |   /usr/local/bundle/gems/devise-4.7.1/lib/devise.rb:311:in `setup'
+db_1      | 2020-03-15T08:16:00.208657Z 0 [Warning] InnoDB: New log files created, LSN=45790
+web_1     |   /app/config/initializers/devise.rb:5:in `<top (required)>'
+db_1      | 2020-03-15T08:16:00.277089Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
+web_1     |   /usr/local/bundle/gems/activesupport-5.2.4.1/lib/active_support/dependencies.rb:285:in `load'
+db_1      | 2020-03-15T08:16:00.339860Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 3464bb45-6695-11ea-8dbb-0242ac120002.
+web_1     |   /usr/local/bundle/gems/activesupport-5.2.4.1/lib/active_support/dependencies.rb:285:in `block in load'
+db_1      | 2020-03-15T08:16:00.343072Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
+web_1     |   /usr/local/bundle/gems/activesupport-5.2.4.1/lib/active_support/dependencies.rb:257:in `load_dependency'
+db_1      | 2020-03-15T08:16:03.233002Z 0 [Warning] CA certificate ca.pem is self signed.
+web_1     |   /usr/local/bundle/gems/activesupport-5.2.4.1/lib/active_support/dependencies.rb:285:in `load'
+db_1      | 2020-03-15T08:16:03.863511Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
 ```
 ### 補足情報（FW/ツールのバージョンなど）

docker-compose.ymlでのlink設定追記、dadabase.ci.ymlのhost名をdbに変更

2020/03/15 08:33

投稿

Pichan.

スコア4

title CHANGED Viewed

File without changes

body CHANGED Viewed

@@ -87,8 +87,8 @@
       - .:/app
     ports:
       - "3000:3000"
-    # links:
+    links:
-    #   - db
+      - db
     depends_on:
       - db
       - chrome
@@ -115,7 +115,7 @@
   pool: 5
   username: 'root'
   port: 3306
-  host: '127.0.0.1'
+  host: 'db'
   database: ci_test
 ```
 circleci/config.yml

現状のエラー内容、config.ymlでのRAILS_MASTER_KEYの環境変数追加、databese.ci.ymlの変更

2020/03/15 02:25

投稿

Pichan.

スコア4

title CHANGED Viewed

File without changes

body CHANGED Viewed

@@ -1,8 +1,7 @@
 ### 前提・実現したいこと
 docker-compose環境にてrailsのアプリを作成しています。
 circleciでデーターベースのセットアップ事に
-rails aborted!b_1 ... done
-NoMethodError: undefined method `[]' for nil:NilClass
+Mysql2::Error: Can't connect to MySQL server on '127.0.0.1' (111 "Connection refused")
 と、エラーになりデーターベースが作成できません。
 ネットにあるcircleciの記事のやり方や同じようなエラーの解決策をいろいろ試してみましたがどれを試してもdb:createのところで同じエラーが起こります。
@@ -11,39 +10,39 @@
 ### 発生している問題・エラーメッセージ
+```
-```#!/bin/bash -eo pipefail
+#!/bin/bash -eo pipefail
-docker-compose run web bin/rails db:create db:migrate RAILS_ENV=test
+docker-compose run web bin/rails db:create db:migrate RAILS_ENV=test RAILS_MASTER_KEY=${RAILS_MASTER_KEY}
+Starting project_db_1 ...
 Starting project_chrome_1 ...
+Can't connect to MySQL server on '127.0.0.1' (111 "Connection refused")
-Starting project_db_1 ...
+Couldn't create 'ci_test' database. Please check your configuration.
-rails aborted!b_1 ... done
+rails aborted!
-NoMethodError: undefined method `[]' for nil:NilClass
-/app/config/initializers/devise.rb:305:in `block in <top (required)>'
+Mysql2::Error: Can't connect to MySQL server on '127.0.0.1' (111 "Connection refused")
-/usr/local/bundle/gems/devise-4.7.1/lib/devise.rb:311:in `setup'
-/app/config/initializers/devise.rb:5:in `<top (required)>'
-/usr/local/bundle/gems/activesupport-5.2.4.1/lib/active_support/dependencies.rb:285:in `load'
-/usr/local/bundle/gems/activesupport-5.2.4.1/lib/active_support/dependencies.rb:285:in `block in load'
-/usr/local/bundle/gems/activesupport-5.2.4.1/lib/active_support/dependencies.rb:257:in `load_dependency'
-/usr/local/bundle/gems/activesupport-5.2.4.1/lib/active_support/dependencies.rb:285:in `load'
-/usr/local/bundle/gems/railties-5.2.4.1/lib/rails/engine.rb:663:in `block in load_config_initializer'
-/usr/local/bundle/gems/activesupport-5.2.4.1/lib/active_support/notifications.rb:170:in `instrument'
-/usr/local/bundle/gems/railties-5.2.4.1/lib/rails/engine.rb:662:in `load_config_initializer'
-/usr/local/bundle/gems/railties-5.2.4.1/lib/rails/engine.rb:620:in `block (2 levels) in <class:Engine>'
-/usr/local/bundle/gems/railties-5.2.4.1/lib/rails/engine.rb:619:in `each'
+/usr/local/bundle/gems/mysql2-0.4.10/lib/mysql2/client.rb:89:in `connect'
-/usr/local/bundle/gems/railties-5.2.4.1/lib/rails/engine.rb:619:in `block in <class:Engine>'
-/usr/local/bundle/gems/railties-5.2.4.1/lib/rails/initializable.rb:32:in `instance_exec'
-/usr/local/bundle/gems/railties-5.2.4.1/lib/rails/initializable.rb:32:in `run'
-/usr/local/bundle/gems/railties-5.2.4.1/lib/rails/initializable.rb:61:in `block in run_initializers'
-/usr/local/bundle/gems/railties-5.2.4.1/lib/rails/initializable.rb:50:in `each'
-/usr/local/bundle/gems/railties-5.2.4.1/lib/rails/initializable.rb:50:in `tsort_each_child'
-/usr/local/bundle/gems/railties-5.2.4.1/lib/rails/initializable.rb:60:in `run_initializers'
-/usr/local/bundle/gems/railties-5.2.4.1/lib/rails/application.rb:361:in `initialize!'
+/usr/local/bundle/gems/mysql2-0.4.10/lib/mysql2/client.rb:89:in `initialize'
+/usr/local/bundle/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/mysql2_adapter.rb:22:in `new'
+/usr/local/bundle/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/mysql2_adapter.rb:22:in `mysql2_connection'
+/usr/local/bundle/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:830:in `new_connection'
+/usr/local/bundle/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:874:in `checkout_new_connection'
+/usr/local/bundle/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:853:in `try_to_checkout_new_connection'
+/usr/local/bundle/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:814:in `acquire_connection'
+/usr/local/bundle/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:538:in `checkout'
+/usr/local/bundle/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:382:in `connection'
+/usr/local/bundle/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:1033:in `retrieve_connection'
-/app/config/environment.rb:5:in `<top (required)>'
+/usr/local/bundle/gems/activerecord-5.2.4.1/lib/active_record/connection_handling.rb:118:in `retrieve_connection'
-/usr/local/bundle/gems/activesupport-5.2.4.1/lib/active_support/dependencies.rb:291:in `require'
+/usr/local/bundle/gems/activerecord-5.2.4.1/lib/active_record/connection_handling.rb:90:in `connection'
-/usr/local/bundle/gems/activesupport-5.2.4.1/lib/active_support/dependencies.rb:291:in `block in require'
+/usr/local/bundle/gems/activerecord-5.2.4.1/lib/active_record/tasks/mysql_database_tasks.rb:6:in `connection'
-/usr/local/bundle/gems/activesupport-5.2.4.1/lib/active_support/dependencies.rb:257:in `load_dependency'
+/usr/local/bundle/gems/activerecord-5.2.4.1/lib/active_record/tasks/mysql_database_tasks.rb:14:in `create'
-/usr/local/bundle/gems/activesupport-5.2.4.1/lib/active_support/dependencies.rb:291:in `require'
+/usr/local/bundle/gems/activerecord-5.2.4.1/lib/active_record/tasks/database_tasks.rb:119:in `create'
+/usr/local/bundle/gems/activerecord-5.2.4.1/lib/active_record/tasks/database_tasks.rb:139:in `block in create_current'
+/usr/local/bundle/gems/activerecord-5.2.4.1/lib/active_record/tasks/database_tasks.rb:316:in `block in each_current_configuration'
+/usr/local/bundle/gems/activerecord-5.2.4.1/lib/active_record/tasks/database_tasks.rb:313:in `each'
+/usr/local/bundle/gems/activerecord-5.2.4.1/lib/active_record/tasks/database_tasks.rb:313:in `each_current_configuration'
-/usr/local/bundle/gems/railties-5.2.4.1/lib/rails/application.rb:337:in `require_environment!'
+/usr/local/bundle/gems/activerecord-5.2.4.1/lib/active_record/tasks/database_tasks.rb:138:in `create_current'
-/usr/local/bundle/gems/railties-5.2.4.1/lib/rails/application.rb:520:in `block in run_tasks_blocks'
+/usr/local/bundle/gems/activerecord-5.2.4.1/lib/active_record/railties/databases.rake:29:in `block (2 levels) in <top (required)>'
 /usr/local/bundle/gems/railties-5.2.4.1/lib/rails/commands/rake/rake_command.rb:23:in `block in perform'
 /usr/local/bundle/gems/railties-5.2.4.1/lib/rails/commands/rake/rake_command.rb:20:in `perform'
 /usr/local/bundle/gems/railties-5.2.4.1/lib/rails/command.rb:48:in `invoke'
@@ -60,11 +59,11 @@
 /app/bin/spring:15:in `<top (required)>'
 bin/rails:3:in `load'
 bin/rails:3:in `<main>'
-Tasks: TOP => db:create => db:load_config => environment
+Tasks: TOP => db:create
 (See full trace by running task with --trace)
 Exited with code exit status 1
-CircleCI received exit code 1
 ```
 ### 該当のソースコード
@@ -113,11 +112,11 @@
 test:
   adapter: mysql2
   encoding: utf8mb4
-  host: db
-  username: root
-  password:
   pool: 5
+  username: 'root'
+  port: 3306
+  host: '127.0.0.1'
-  database: app_test
+  database: ci_test
 ```
 circleci/config.yml
 ```
@@ -144,7 +143,7 @@
           command: sleep 1
       - run:
           name: dbsetup
-          command: docker-compose run web bin/rails db:create db:migrate RAILS_ENV=test
+          command: docker-compose run web bin/rails db:create db:migrate RAILS_ENV=test RAILS_MASTER_KEY=${RAILS_MASTER_KEY}
       - run:
           name: RSpec test
           command: docker-compose run web bin/rspec
@@ -169,7 +168,6 @@
 project_web_1      bundle exec puma -C /app/c ...   Up      0.0.0.0:3000->3000/tcp
 ```
 ### 補足情報（FW/ツールのバージョンなど）
 rails 5.2