質問編集履歴

1

具体的にエラーの出る状況を追記

2019/09/27 16:21

投稿

YOJI4910
YOJI4910

スコア7

test CHANGED
File without changes
test CHANGED
@@ -8,7 +8,7 @@
8
8
 
9
9
  ### 発生している問題・エラーメッセージ
10
10
 
11
-
11
+ db:reset後にdb:migrateしようとしてエラー
12
12
 
13
13
  ```bash
14
14
 
@@ -32,95 +32,9 @@
32
32
 
33
33
  /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:187:in `block (2 levels) in execute'
34
34
 
35
- /usr/local/bundle/gems/activesupport-5.2.3/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
36
-
37
- /usr/local/bundle/gems/activesupport-5.2.3/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
38
-
39
- /usr/local/bundle/gems/activesupport-5.2.3/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
40
-
41
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:186:in `block in execute'
42
-
43
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:581:in `block (2 levels) in log'
44
-
45
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `block in log'
46
-
47
- /usr/local/bundle/gems/activesupport-5.2.3/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
48
-
49
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:571:in `log'
50
-
51
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:185:in `execute'
52
-
53
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/connection_adapters/mysql/database_statements.rb:28:in `execute'
54
-
55
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:196:in `execute_and_free'
56
-
57
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:793:in `column_definitions'
58
-
59
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/schema_statements.rb:113:in `columns'
60
-
61
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/connection_adapters/schema_cache.rb:69:in `columns'
62
-
63
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/connection_adapters/schema_cache.rb:75:in `columns_hash'
64
-
65
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/model_schema.rb:466:in `load_schema!'
66
-
67
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/attributes.rb:234:in `load_schema!'
68
-
69
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/attribute_decorators.rb:51:in `load_schema!'
70
-
71
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/model_schema.rb:459:in `block in load_schema'
72
-
73
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/model_schema.rb:456:in `load_schema'
74
-
75
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/model_schema.rb:336:in `columns_hash'
76
-
77
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/relation/query_methods.rb:1072:in `arel_column'
78
-
79
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/relation/query_methods.rb:1165:in `block in preprocess_order_args'
80
-
81
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/relation/query_methods.rb:1161:in `map!'
82
-
83
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/relation/query_methods.rb:1161:in `preprocess_order_args'
84
-
85
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/relation/query_methods.rb:300:in `order!'
86
-
87
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/relation/query_methods.rb:295:in `order'
88
-
89
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/querying.rb:12:in `order'
90
-
91
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/schema_migration.rb:48:in `all_versions'
92
-
93
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/migration.rb:1059:in `get_all_versions'
94
-
95
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/migration.rb:1241:in `load_migrated'
96
-
97
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/migration.rb:1362:in `with_advisory_lock'
98
-
99
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/migration.rb:1210:in `migrate'
100
-
101
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/migration.rb:1036:in `up'
102
-
103
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/migration.rb:1011:in `migrate'
104
-
105
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/tasks/database_tasks.rb:172:in `migrate'
106
-
107
- /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/railties/databases.rake:60:in `block (2 levels) in <main>'
108
-
109
- /usr/local/bundle/gems/railties-5.2.3/lib/rails/commands/rake/rake_command.rb:23:in `block in perform'
110
-
111
- /usr/local/bundle/gems/railties-5.2.3/lib/rails/commands/rake/rake_command.rb:20:in `perform'
112
-
113
- /usr/local/bundle/gems/railties-5.2.3/lib/rails/command.rb:48:in `invoke'
35
+ /usr/local/bundle/gems/activesupport-5ndex.rb:92:in `register'
114
-
36
+
115
- /usr/local/bundle/gems/railties-5.2.3/lib/rails/commands.rb:18:in `<main>'
37
+ 〜 (文字数制限のため中略) 〜
116
-
117
- /usr/local/bundle/gems/bootsnap-1.4.5/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:22:in `require'
118
-
119
- /usr/local/bundle/gems/bootsnap-1.4.5/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:22:in `block in require_with_bootsnap_lfi'
120
-
121
- /usr/local/bundle/gems/bootsnap-1.4.5/lib/bootsnap/load_path_cache/loaded_features_index.rb:92:in `register'
122
-
123
- /usr/local/bundle/gems/bootsnap-1.4.5/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:21:in `require_with_bootsnap_lfi'
124
38
 
125
39
  /usr/local/bundle/gems/bootsnap-1.4.5/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:30:in `require'
126
40
 
@@ -162,6 +76,122 @@
162
76
 
163
77
  ```
164
78
 
79
+
80
+
81
+ Rootページ(localhost:3000)にアクセスしてエラー(エラー画面になって表示されない)
82
+
83
+ ```bash
84
+
85
+ $docker-compose logs
86
+
87
+ =>
88
+
89
+ web_1 | Started GET "/" for 172.19.0.1 at 2019-09-27 16:17:10 +0000
90
+
91
+ web_1 | Cannot render console from 172.19.0.1! Allowed networks: 127.0.0.1, ::1, 127.0.0.0/127.255.255.255
92
+
93
+ web_1 | (9.7ms) SET NAMES utf8, @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ',STRICT_ALL_TABLES'), ',NO_AUTO_VALUE_ON_ZERO'), @@SESSION.sql_auto_is_null = 0, @@SESSION.wait_timeout = 2147483
94
+
95
+ web_1 | ↳ /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/log_subscriber.rb:98
96
+
97
+ web_1 | (4.0ms) SELECT `schema_migrations`.`version` FROM `schema_migrations` ORDER BY `schema_migrations`.`version` ASC
98
+
99
+ web_1 | ↳ /usr/local/bundle/gems/activerecord-5.2.3/lib/active_record/log_subscriber.rb:98
100
+
101
+ web_1 |
102
+
103
+ web_1 | ActiveRecord::StatementInvalid (Mysql2::Error: Tablespace is missing for table `app_name_development`.`schema_migrations`.: SELECT `schema_migrations`.`version` FROM `schema_migrations` ORDER BY `schema_migrations`.`version` ASC):
104
+
105
+ web_1 |
106
+
107
+ web_1 | mysql2 (0.5.2) lib/mysql2/client.rb:131:in `_query'
108
+
109
+ web_1 | mysql2 (0.5.2) lib/mysql2/client.rb:131:in `block in query'
110
+
111
+ web_1 | mysql2 (0.5.2) lib/mysql2/client.rb:130:in `handle_interrupt'
112
+
113
+ web_1 | mysql2 (0.5.2) lib/mysql2/client.rb:130:in `query'
114
+
115
+ web_1 | activerecord (5.2.3) lib/active_record/connection_adapters/abstract_mysql_adapter.rb:187:in `block (2 levels) in execute'
116
+
117
+ web_1 | activesupport (5.2.3) lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
118
+
119
+ web_1 | activesupport (5.2.3) lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
120
+
121
+ web_1 | activesupport (5.2.3) lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
122
+
123
+ web_1 | activerecord (5.2.3) lib/active_record/connection_adapters/abstract_mysql_adapter.rb:186:in `block in execute'
124
+
125
+ web_1 | activerecord (5.2.3) lib/active_record/connection_adapters/abstract_adapter.rb:581:in `block (2 levels) in log'
126
+
127
+ web_1 | /usr/local/lib/ruby/2.6.0/monitor.rb:230:in `mon_synchronize'
128
+
129
+ web_1 | activerecord (5.2.3) lib/active_record/connection_adapters/abstract_adapter.rb:580:in `block in log'
130
+
131
+ web_1 | activesupport (5.2.3) lib/active_support/notifications/instrumenter.rb:23:in `instrument'
132
+
133
+ web_1 | activerecord (5.2.3) lib/active_record/connection_adapters/abstract_adapter.rb:571:in `log'
134
+
135
+ web_1 | activerecord (5.2.3) lib/active_record/connection_adapters/abstract_mysql_adapter.rb:185:in `execute'
136
+
137
+ web_1 | activerecord (5.2.3) lib/active_record/connection_adapters/mysql/database_statements.rb:28:in `execute'
138
+
139
+ web_1 | activerecord (5.2.3) lib/active_record/connection_adapters/abstract_mysql_adapter.rb:196:in `execute_and_free'
140
+
141
+ web_1 | activerecord (5.2.3) lib/active_record/connection_adapters/mysql/database_statements.rb:33:in `exec_query'
142
+
143
+ web_1 | activerecord (5.2.3) lib/active_record/connection_adapters/abstract/database_statements.rb:478:in `select'
144
+
145
+ web_1 | activerecord (5.2.3) lib/active_record/connection_adapters/abstract/database_statements.rb:70:in `select_all'
146
+
147
+ web_1 | activerecord (5.2.3) lib/active_record/connection_adapters/abstract/query_cache.rb:104:in `block in select_all'
148
+
149
+ web_1 | activerecord (5.2.3) lib/active_record/connection_adapters/abstract/query_cache.rb:127:in `block in cache_sql'
150
+
151
+ web_1 | /usr/local/lib/ruby/2.6.0/monitor.rb:230:in `mon_synchronize'
152
+
153
+ 〜 (文字数制限のため中略) 〜
154
+
155
+ web_1 | activesupport (5.2.3) lib/active_support/tagged_logging.rb:28:in `tagged'
156
+
157
+ web_1 | activesupport (5.2.3) lib/active_support/tagged_logging.rb:71:in `tagged'
158
+
159
+ web_1 | railties (5.2.3) lib/rails/rack/logger.rb:26:in `call'
160
+
161
+ web_1 | sprockets-rails (3.2.1) lib/sprockets/rails/quiet_assets.rb:13:in `call'
162
+
163
+ web_1 | actionpack (5.2.3) lib/action_dispatch/middleware/remote_ip.rb:81:in `call'
164
+
165
+ web_1 | actionpack (5.2.3) lib/action_dispatch/middleware/request_id.rb:27:in `call'
166
+
167
+ web_1 | rack (2.0.7) lib/rack/method_override.rb:22:in `call'
168
+
169
+ web_1 | rack (2.0.7) lib/rack/runtime.rb:22:in `call'
170
+
171
+ web_1 | activesupport (5.2.3) lib/active_support/cache/strategy/local_cache_middleware.rb:29:in `call'
172
+
173
+ web_1 | actionpack (5.2.3) lib/action_dispatch/middleware/executor.rb:14:in `call'
174
+
175
+ web_1 | actionpack (5.2.3) lib/action_dispatch/middleware/static.rb:127:in `call'
176
+
177
+ web_1 | rack (2.0.7) lib/rack/sendfile.rb:111:in `call'
178
+
179
+ web_1 | railties (5.2.3) lib/rails/engine.rb:524:in `call'
180
+
181
+ web_1 | puma (3.12.1) lib/puma/configuration.rb:227:in `call'
182
+
183
+ web_1 | puma (3.12.1) lib/puma/server.rb:660:in `handle_request'
184
+
185
+ web_1 | puma (3.12.1) lib/puma/server.rb:474:in `process_client'
186
+
187
+ web_1 | puma (3.12.1) lib/puma/server.rb:334:in `block in run'
188
+
189
+ web_1 | puma (3.12.1) lib/puma/thread_pool.rb:135:in `block in spawn_thread'
190
+
191
+ ```
192
+
193
+
194
+
165
195
 
166
196
 
167
197
  ### 該当のソースコード