teratail
回答率
85.47%
質問するログイン新規登録
トップに関する質問CircleCI/MySQLに任意create databaseされない！？

編集履歴

質問編集履歴

3

MySQLのバージョンを5.7に変更することにしました。

2019/07/24 15:20

投稿

Zeiniku2424
Zeiniku2424

スコア8

test CHANGED
@@ -1 +1 @@
1
- CircleCIでMySQLに接続してSpring BootアプリのCIを回したい！
1
+ CircleCI/MySQLに任意create databaseされない！？
test CHANGED
@@ -24,7 +24,7 @@
24
24
 
25
25
  |FW|Spring Boot 2.1.6|
26
26
 
27
- |DB|MySQL 8.0|
27
+ |DB|MySQL 5.7|
28
28
 
29
29
  |DB ドライバ | JDBC |
30
30
 
@@ -160,24 +160,24 @@
160
160
 
161
161
  - run:
162
162
 
163
+ name: Show Database
164
+
165
+ command: |
166
+
167
+ sudo apt-get install default-mysql-client
168
+
169
+ mysql -h 127.0.0.1 -u root -e 'show databases;'
170
+
171
+
172
+
173
+ - run:
174
+
163
175
  name: Migrate DB
164
176
 
165
177
  command: mvn flyway:migrate -Dflyway.url=jdbc:mysql://127.0.0.1:3306/chicago -Dflyway.user=root -Dflyway.password=
166
178
 
167
179
 
168
180
 
169
- - run:
170
-
171
- name: Show Database
172
-
173
- command: |
174
-
175
- sudo apt-get install default-mysql-client
176
-
177
- mysql -h 127.0.0.1 -u root -e 'show databases;'
178
-
179
-
180
-
181
181
  # run tests!
182
182
 
183
183
  - run: mvn integration-test
@@ -186,151 +186,37 @@
186
186
 
187
187
 
188
188
 
189
- ## 発生しているエラー
189
+ ## 課題
190
-
190
+
191
- Migrate DBのステップで次のエラーが生じているようです。
191
+ `Show Database`のステップでデータベース一覧を表示したところ、
192
-
193
- ログを見る限りだとMySQLコンテナにデータベースを発見できないor使用できない状況のようです。
194
192
 
195
193
  ```
196
194
 
197
- [INFO]
198
-
199
- [INFO] ----------------------< com.uruk:chicago-spring >-----------------------
200
-
201
- [INFO] Building chicago-spring 0.0.1-SNAPSHOT
202
-
203
- [INFO] --------------------------------[ jar ]---------------------------------
204
-
205
- [INFO]
206
-
207
- [INFO] --- flyway-maven-plugin:5.2.4:migrate (default-cli) @ chicago-spring ---
208
-
209
- [INFO] Flyway Community Edition 5.2.4 by Boxfuse
210
-
211
- [INFO] ------------------------------------------------------------------------
212
-
213
- [INFO] BUILD FAILURE
195
+ +--------------------+
214
-
215
- [INFO] ------------------------------------------------------------------------
196
+
216
-
217
- [INFO] Total time: 2.752 s
197
+ | Database |
218
-
219
- [INFO] Finished at: 2019-07-24T13:53:04Z
198
+
220
-
221
- [INFO] ------------------------------------------------------------------------
222
-
223
- [ERROR] Failed to execute goal org.flywaydb:flyway-maven-plugin:5.2.4:migrate (default-cli) on project chicago-spring: org.flywaydb.core.internal.exception.FlywaySqlException:
224
-
225
- [ERROR] Unable to obtain connection from database (jdbc:mysql://127.0.0.1:3306/chicago) for user 'root': Unknown database 'chicago'
226
-
227
- [ERROR] ---------------------------------------------------------------------------------------------------------------------------
228
-
229
- [ERROR] SQL State : 42000
199
+ +--------------------+
230
-
200
+
231
- [ERROR] Error Code : 1049
201
+ | information_schema |
232
-
233
- [ERROR] Message : Unknown database 'chicago'
202
+
234
-
235
- [ERROR]
236
-
237
- [ERROR] -> [Help 1]
238
-
239
- [ERROR]
240
-
241
- [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
242
-
243
- [ERROR] Re-run Maven using the -X switch to enable full debug logging.
244
-
245
- [ERROR]
246
-
247
- [ERROR] For more information about the errors and possible solutions, please read the following articles:
248
-
249
- [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException
250
-
251
- Exited with code 1
203
+ | circle_test |
204
+
205
+ | mysql |
206
+
207
+ | performance_schema |
208
+
209
+ | sys |
210
+
211
+ +--------------------+
252
212
 
253
213
  ```
254
214
 
255
-
256
-
257
- また、エラーなのかわからないのですがContainer circleci/mysql:8.0-ramのステップは以下のログを出力して灰色になっています。
258
-
259
-
260
-
261
- ```Initializing database
262
-
263
- 2019-07-24T13:52:52.757914Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
264
-
265
- 2019-07-24T13:52:52.758005Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server in progress as process 40
266
-
267
- 2019-07-24T13:52:52.759501Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
268
-
269
- 2019-07-24T13:52:52.759519Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
270
-
271
- 2019-07-24T13:52:54.250203Z 5 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
272
-
273
- 2019-07-24T13:52:54.882324Z 0 [System] [MY-013170] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server has completed
274
-
275
- Database initialized
276
-
277
- MySQL init process in progress...
278
-
279
- 2019-07-24T13:52:55.462248Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
280
-
281
- 2019-07-24T13:52:55.462338Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17) starting as process 161
282
-
283
- 2019-07-24T13:52:55.464725Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
284
-
285
- 2019-07-24T13:52:55.464745Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
286
-
287
- 2019-07-24T13:52:55.841740Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
288
-
289
- 2019-07-24T13:52:55.849451Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
290
-
291
- 2019-07-24T13:52:55.867016Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.17' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server - GPL.
292
-
293
- 2019-07-24T13:52:55.949226Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock'
294
-
295
- Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
296
-
297
- Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
298
-
299
- Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
300
-
301
- Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
302
-
303
-
304
-
305
- 2019-07-24T13:52:58.710605Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.17) MySQL Community Server - GPL.
306
-
307
-
308
-
309
- MySQL init process done. Ready for start up.
310
-
311
-
312
-
313
- 2019-07-24T13:52:59.054386Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
314
-
315
- 2019-07-24T13:52:59.054501Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17) starting as process 7
316
-
317
- 2019-07-24T13:52:59.057659Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
318
-
319
- 2019-07-24T13:52:59.057686Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
320
-
321
- 2019-07-24T13:52:59.441213Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
322
-
323
- 2019-07-24T13:52:59.446079Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
324
-
325
- 2019-07-24T13:52:59.465685Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.17' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
326
-
327
- 2019-07-24T13:52:59.557754Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
328
-
329
-
330
-
331
- Job was canceled
332
-
333
- ```
215
+ と表示されました。
216
+
217
+ 想定ではこの中に`config.yml`で指定した`chicago`というデータベースが存在するはずですが、存在しません。
218
+
219
+ どのように設定すれば`chicago`を生成できるでしょうか？
334
220
 
335
221
 
336
222
 

2

より正確な情報へ修正しました。

2019/07/24 15:20

投稿

Zeiniku2424
Zeiniku2424

スコア8

test CHANGED
File without changes
test CHANGED
@@ -40,7 +40,7 @@
40
40
 
41
41
  |:--|:--:|
42
42
 
43
- |DB名|test_db|
43
+ |DB名|chicago|
44
44
 
45
45
  |ユーザー名|user|
46
46
 
@@ -54,6 +54,14 @@
54
54
 
55
55
  ```yml
56
56
 
57
+ # Java Maven CircleCI 2.0 configuration file
58
+
59
+ #
60
+
61
+ # Check https://circleci.com/docs/2.0/language-java/ for more details
62
+
63
+ #
64
+
57
65
  version: 2
58
66
 
59
67
  jobs:
@@ -66,21 +74,19 @@
66
74
 
67
75
  - image: circleci/openjdk:8-jdk
68
76
 
69
- # CI用の環境設定
70
-
71
77
  environment:
72
78
 
73
- MYSQL_HOST: 127.0.0.1
79
+ MYSQL_HOST: jdbc:mysql://127.0.0.1:3306
74
80
 
75
81
  MYSQL_ROOT_PASSWORD: password
76
82
 
77
83
  MYSQL_ALLOW_EMPTY_PASSWORD: true
78
84
 
79
- MYSQL_DATABASE: test_db
85
+ MYSQL_DATABASE: chicago
80
-
86
+
81
- MYSQL_USER: user
87
+ MYSQL_USER: root
82
-
88
+
83
- MYSQL_PASSWORD: password
89
+ MYSQL_PASSWORD:
84
90
 
85
91
 
86
92
 
@@ -142,23 +148,33 @@
142
148
 
143
149
 
144
150
 
145
- # Flywayでマイグレーションを実施
151
+ - save_cache:
152
+
153
+ paths:
154
+
155
+ - ~/.m2
156
+
157
+ key: v1-dependencies-{{ checksum "pom.xml" }}
158
+
159
+
146
160
 
147
161
  - run:
148
162
 
149
163
  name: Migrate DB
150
164
 
151
- command: mvn flyway:migrate　-Dflyway.url=127.0.0.1:3306 -Dflyway.user=user -Dflyway.password=password
165
+ command: mvn flyway:migrate -Dflyway.url=jdbc:mysql://127.0.0.1:3306/chicago -Dflyway.user=root -Dflyway.password=
152
-
153
-
154
-
155
- - save_cache:
166
+
156
-
167
+
168
+
157
- paths:
169
+ - run:
170
+
158
-
171
+ name: Show Database
172
+
159
- - ~/.m2
173
+ command: |
174
+
160
-
175
+ sudo apt-get install default-mysql-client
176
+
161
- key: v1-dependencies-{{ checksum "pom.xml" }}
177
+ mysql -h 127.0.0.1 -u root -e 'show databases;'
162
178
 
163
179
 
164
180
 
@@ -174,17 +190,23 @@
174
190
 
175
191
  Migrate DBのステップで次のエラーが生じているようです。
176
192
 
177
-
193
+ ログを見る限りだとMySQLコンテナにデータベースを発見できないor使用できない状況のようです。
178
194
 
179
195
  ```
180
196
 
181
- #!/bin/bash -eo pipefail
197
+ [INFO]
182
-
198
+
183
- mvn flyway:migrate　-Dflyway.url=127.0.0.1:3306 -Dflyway.user=root
199
+ [INFO] ----------------------< com.uruk:chicago-spring >-----------------------
184
-
200
+
185
- [INFO] Scanning for projects...
201
+ [INFO] Building chicago-spring 0.0.1-SNAPSHOT
202
+
186
-
203
+ [INFO] --------------------------------[ jar ]---------------------------------
204
+
205
+ [INFO]
206
+
187
- Downloading from central: https://repo.maven.apache.org/maven2/flyway/migrate%E3%80%80-Dflyway.url=127.0.0.1/maven-metadata.xml
207
+ [INFO] --- flyway-maven-plugin:5.2.4:migrate (default-cli) @ chicago-spring ---
208
+
209
+ [INFO] Flyway Community Edition 5.2.4 by Boxfuse
188
210
 
189
211
  [INFO] ------------------------------------------------------------------------
190
212
 
@@ -192,16 +214,30 @@
192
214
 
193
215
  [INFO] ------------------------------------------------------------------------
194
216
 
195
- [INFO] Total time: 0.689 s
217
+ [INFO] Total time: 2.752 s
196
-
218
+
197
- [INFO] Finished at: 2019-07-23T14:15:41Z
219
+ [INFO] Finished at: 2019-07-24T13:53:04Z
198
220
 
199
221
  [INFO] ------------------------------------------------------------------------
200
222
 
201
- [ERROR] Error resolving version for plugin 'flyway:migrate　-Dflyway.url=127.0.0.1' from the repositories [local (/home/circleci/.m2/repository), central (https://repo.maven.apache.org/maven2)]: Plugin not found in any plugin repository -> [Help 1]
223
+ [ERROR] Failed to execute goal org.flywaydb:flyway-maven-plugin:5.2.4:migrate (default-cli) on project chicago-spring: org.flywaydb.core.internal.exception.FlywaySqlException:
224
+
225
+ [ERROR] Unable to obtain connection from database (jdbc:mysql://127.0.0.1:3306/chicago) for user 'root': Unknown database 'chicago'
226
+
227
+ [ERROR] ---------------------------------------------------------------------------------------------------------------------------
228
+
229
+ [ERROR] SQL State : 42000
230
+
231
+ [ERROR] Error Code : 1049
232
+
233
+ [ERROR] Message : Unknown database 'chicago'
202
234
 
203
235
  [ERROR]
204
236
 
237
+ [ERROR] -> [Help 1]
238
+
239
+ [ERROR]
240
+
205
241
  [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
206
242
 
207
243
  [ERROR] Re-run Maven using the -X switch to enable full debug logging.
@@ -210,7 +246,7 @@
210
246
 
211
247
  [ERROR] For more information about the errors and possible solutions, please read the following articles:
212
248
 
213
- [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/PluginVersionResolutionException
249
+ [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException
214
250
 
215
251
  Exited with code 1
216
252
 
@@ -222,82 +258,80 @@
222
258
 
223
259
 
224
260
 
261
+ ```Initializing database
262
+
263
+ 2019-07-24T13:52:52.757914Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
264
+
265
+ 2019-07-24T13:52:52.758005Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server in progress as process 40
266
+
267
+ 2019-07-24T13:52:52.759501Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
268
+
269
+ 2019-07-24T13:52:52.759519Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
270
+
271
+ 2019-07-24T13:52:54.250203Z 5 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
272
+
273
+ 2019-07-24T13:52:54.882324Z 0 [System] [MY-013170] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server has completed
274
+
275
+ Database initialized
276
+
277
+ MySQL init process in progress...
278
+
279
+ 2019-07-24T13:52:55.462248Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
280
+
281
+ 2019-07-24T13:52:55.462338Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17) starting as process 161
282
+
283
+ 2019-07-24T13:52:55.464725Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
284
+
285
+ 2019-07-24T13:52:55.464745Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
286
+
287
+ 2019-07-24T13:52:55.841740Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
288
+
289
+ 2019-07-24T13:52:55.849451Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
290
+
291
+ 2019-07-24T13:52:55.867016Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.17' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server - GPL.
292
+
293
+ 2019-07-24T13:52:55.949226Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock'
294
+
295
+ Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
296
+
297
+ Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
298
+
299
+ Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
300
+
301
+ Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
302
+
303
+
304
+
305
+ 2019-07-24T13:52:58.710605Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.17) MySQL Community Server - GPL.
306
+
307
+
308
+
309
+ MySQL init process done. Ready for start up.
310
+
311
+
312
+
313
+ 2019-07-24T13:52:59.054386Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
314
+
315
+ 2019-07-24T13:52:59.054501Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17) starting as process 7
316
+
317
+ 2019-07-24T13:52:59.057659Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
318
+
319
+ 2019-07-24T13:52:59.057686Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
320
+
321
+ 2019-07-24T13:52:59.441213Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
322
+
323
+ 2019-07-24T13:52:59.446079Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
324
+
325
+ 2019-07-24T13:52:59.465685Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.17' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
326
+
327
+ 2019-07-24T13:52:59.557754Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
328
+
329
+
330
+
331
+ Job was canceled
332
+
225
333
  ```
226
334
 
227
- Initializing database
228
-
229
- 2019-07-23T14:15:27.733643Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
230
-
231
- 2019-07-23T14:15:27.733696Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server in progress as process 35
232
-
233
- 2019-07-23T14:15:27.734512Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
234
-
235
- 2019-07-23T14:15:27.734521Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
236
-
237
- 2019-07-23T14:15:28.600625Z 5 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
238
-
239
- 2019-07-23T14:15:29.177705Z 0 [System] [MY-013170] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server has completed
240
-
241
- Database initialized
242
-
243
- MySQL init process in progress...
244
-
245
- 2019-07-23T14:15:30.428995Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
246
-
247
- 2019-07-23T14:15:30.429077Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17) starting as process 162
248
-
249
- 2019-07-23T14:15:30.431518Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
250
-
251
- 2019-07-23T14:15:30.431533Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
252
-
253
- 2019-07-23T14:15:30.775069Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
254
-
255
- 2019-07-23T14:15:30.776013Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
256
-
257
- 2019-07-23T14:15:30.791131Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.17' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server - GPL.
258
-
259
- 2019-07-23T14:15:30.888163Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock'
260
-
261
- Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
262
-
263
- Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
264
-
265
- Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
266
-
267
- Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
268
-
269
-
270
-
271
- 2019-07-23T14:15:33.672962Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.17) MySQL Community Server - GPL.
272
-
273
-
274
-
275
- MySQL init process done. Ready for start up.
276
-
277
-
278
-
279
- 2019-07-23T14:15:34.007207Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
280
-
281
- 2019-07-23T14:15:34.007319Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17) starting as process 6
282
-
283
- 2019-07-23T14:15:34.011274Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
284
-
285
- 2019-07-23T14:15:34.011294Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
286
-
287
- 2019-07-23T14:15:34.316535Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
288
-
289
- 2019-07-23T14:15:34.317556Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
290
-
291
- 2019-07-23T14:15:34.331627Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.17' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
292
-
293
- 2019-07-23T14:15:34.465747Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
294
-
295
-
296
-
297
- Job was canceled
298
-
299
- ```
300
-
301
335
 
302
336
 
303
337
  うまくお伝えできたか不安ですが、ご教示をお願いします。

1

mavenのバージョンを記載しました。

2019/07/24 14:03

投稿

Zeiniku2424
Zeiniku2424

スコア8

test CHANGED
File without changes
test CHANGED
@@ -30,7 +30,7 @@
30
30
 
31
31
  |マイグレーションツール|Flyway|
32
32
 
33
- |ライブラリツール|maven|
33
+ |ライブラリツール|maven 3.6.1 |
34
34
 
35
35
 
36
36