teratail header banner
teratail header banner
質問するログイン新規登録

質問編集履歴

3

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

2019/07/24 15:20

投稿

Zeiniku2424
Zeiniku2424

スコア8

title CHANGED
@@ -1,1 +1,1 @@
1
- CircleCIMySQLに接続してSpring BootアプリのCIを回したい!
1
+ CircleCI/MySQLに任意create databaseされない!
body CHANGED
@@ -11,7 +11,7 @@
11
11
  |:--|:--:|
12
12
  |Java ver| Java 8|
13
13
  |FW|Spring Boot 2.1.6|
14
- |DB|MySQL 8.0|
14
+ |DB|MySQL 5.7|
15
15
  |DB ドライバ | JDBC |
16
16
  |マイグレーションツール|Flyway|
17
17
  |ライブラリツール|maven 3.6.1 |
@@ -79,92 +79,35 @@
79
79
  key: v1-dependencies-{{ checksum "pom.xml" }}
80
80
 
81
81
  - run:
82
- name: Migrate DB
83
- command: mvn flyway:migrate -Dflyway.url=jdbc:mysql://127.0.0.1:3306/chicago -Dflyway.user=root -Dflyway.password=
84
-
85
- - run:
86
82
  name: Show Database
87
83
  command: |
88
84
  sudo apt-get install default-mysql-client
89
85
  mysql -h 127.0.0.1 -u root -e 'show databases;'
90
86
 
87
+ - run:
88
+ name: Migrate DB
89
+ command: mvn flyway:migrate -Dflyway.url=jdbc:mysql://127.0.0.1:3306/chicago -Dflyway.user=root -Dflyway.password=
90
+
91
91
  # run tests!
92
92
  - run: mvn integration-test
93
93
  ```
94
94
 
95
- ## 発生しているエラー
95
+ ## 課題
96
- Migrate DBのステップで次のエラが生じているようです。
96
+ `Show Database`のステップでタベース一覧を表示したところ、
97
- ログを見る限りだとMySQLコンテナにデータベースを発見できないor使用できない状況のようです。
98
97
  ```
99
- [INFO]
100
- [INFO] ----------------------< com.uruk:chicago-spring >-----------------------
101
- [INFO] Building chicago-spring 0.0.1-SNAPSHOT
102
- [INFO] --------------------------------[ jar ]---------------------------------
103
- [INFO]
104
- [INFO] --- flyway-maven-plugin:5.2.4:migrate (default-cli) @ chicago-spring ---
105
- [INFO] Flyway Community Edition 5.2.4 by Boxfuse
106
- [INFO] ------------------------------------------------------------------------
107
- [INFO] BUILD FAILURE
98
+ +--------------------+
108
- [INFO] ------------------------------------------------------------------------
109
- [INFO] Total time: 2.752 s
99
+ | Database |
110
- [INFO] Finished at: 2019-07-24T13:53:04Z
111
- [INFO] ------------------------------------------------------------------------
112
- [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:
113
- [ERROR] Unable to obtain connection from database (jdbc:mysql://127.0.0.1:3306/chicago) for user 'root': Unknown database 'chicago'
114
- [ERROR] ---------------------------------------------------------------------------------------------------------------------------
115
- [ERROR] SQL State : 42000
100
+ +--------------------+
116
- [ERROR] Error Code : 1049
101
+ | information_schema |
117
- [ERROR] Message : Unknown database 'chicago'
118
- [ERROR]
119
- [ERROR] -> [Help 1]
120
- [ERROR]
121
- [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
122
- [ERROR] Re-run Maven using the -X switch to enable full debug logging.
123
- [ERROR]
124
- [ERROR] For more information about the errors and possible solutions, please read the following articles:
125
- [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException
126
- Exited with code 1
102
+ | circle_test |
103
+ | mysql |
104
+ | performance_schema |
105
+ | sys |
106
+ +--------------------+
127
107
  ```
108
+ と表示されました。
109
+ 想定ではこの中に`config.yml`で指定した`chicago`というデータベースが存在するはずですが、存在しません。
110
+ どのように設定すれば`chicago`を生成できるでしょうか?
128
111
 
129
- また、エラーなのかわからないのですがContainer circleci/mysql:8.0-ramのステップは以下のログを出力して灰色になっています。
130
-
131
- ```Initializing database
132
- 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.
133
- 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
134
- 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.
135
- 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.
136
- 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.
137
- 2019-07-24T13:52:54.882324Z 0 [System] [MY-013170] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server has completed
138
- Database initialized
139
- MySQL init process in progress...
140
- 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.
141
- 2019-07-24T13:52:55.462338Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17) starting as process 161
142
- 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.
143
- 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.
144
- 2019-07-24T13:52:55.841740Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
145
- 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.
146
- 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.
147
- 2019-07-24T13:52:55.949226Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock'
148
- Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
149
- Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
150
- Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
151
- Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
152
-
153
- 2019-07-24T13:52:58.710605Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.17) MySQL Community Server - GPL.
154
-
155
- MySQL init process done. Ready for start up.
156
-
157
- 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.
158
- 2019-07-24T13:52:59.054501Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17) starting as process 7
159
- 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.
160
- 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.
161
- 2019-07-24T13:52:59.441213Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
162
- 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.
163
- 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.
164
- 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
165
-
166
- Job was canceled
167
- ```
168
-
169
112
  うまくお伝えできたか不安ですが、ご教示をお願いします。
170
113
  不足等あれば何なりとお申し付けください。

2

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

2019/07/24 15:20

投稿

Zeiniku2424
Zeiniku2424

スコア8

title CHANGED
File without changes
body CHANGED
@@ -19,27 +19,30 @@
19
19
  また、CIでのMySQLの設定は以下の通りにしたいと思っています。
20
20
  |||
21
21
  |:--|:--:|
22
- |DB名|test_db|
22
+ |DB名|chicago|
23
23
  |ユーザー名|user|
24
24
  |パスワード|password|
25
25
  |URL|127.0.0.1|
26
26
 
27
27
  ## CircleCIの設定ファイル
28
28
  ```yml
29
+ # Java Maven CircleCI 2.0 configuration file
30
+ #
31
+ # Check https://circleci.com/docs/2.0/language-java/ for more details
32
+ #
29
33
  version: 2
30
34
  jobs:
31
35
  build:
32
36
  docker:
33
37
  # specify the version you desire here
34
38
  - image: circleci/openjdk:8-jdk
35
- # CI用の環境設定
36
39
  environment:
37
- MYSQL_HOST: 127.0.0.1
40
+ MYSQL_HOST: jdbc:mysql://127.0.0.1:3306
38
41
  MYSQL_ROOT_PASSWORD: password
39
42
  MYSQL_ALLOW_EMPTY_PASSWORD: true
40
- MYSQL_DATABASE: test_db
43
+ MYSQL_DATABASE: chicago
41
- MYSQL_USER: user
44
+ MYSQL_USER: root
42
- MYSQL_PASSWORD: password
45
+ MYSQL_PASSWORD:
43
46
 
44
47
  - image: circleci/mysql:8.0-ram
45
48
 
@@ -70,81 +73,95 @@
70
73
  name: Wait for DB
71
74
  command: dockerize -wait tcp://127.0.0.1:3306 -timeout 120s
72
75
 
73
- # Flywayでマイグレーションを実施
74
- - run:
75
- name: Migrate DB
76
- command: mvn flyway:migrate -Dflyway.url=127.0.0.1:3306 -Dflyway.user=user -Dflyway.password=password
77
-
78
76
  - save_cache:
79
77
  paths:
80
78
  - ~/.m2
81
79
  key: v1-dependencies-{{ checksum "pom.xml" }}
82
80
 
81
+ - run:
82
+ name: Migrate DB
83
+ command: mvn flyway:migrate -Dflyway.url=jdbc:mysql://127.0.0.1:3306/chicago -Dflyway.user=root -Dflyway.password=
84
+
85
+ - run:
86
+ name: Show Database
87
+ command: |
88
+ sudo apt-get install default-mysql-client
89
+ mysql -h 127.0.0.1 -u root -e 'show databases;'
90
+
83
91
  # run tests!
84
92
  - run: mvn integration-test
85
93
  ```
86
94
 
87
95
  ## 発生しているエラー
88
96
  Migrate DBのステップで次のエラーが生じているようです。
89
-
97
+ ログを見る限りだとMySQLコンテナにデータベースを発見できないor使用できない状況のようです。
90
98
  ```
91
- #!/bin/bash -eo pipefail
99
+ [INFO]
92
- mvn flyway:migrate -Dflyway.url=127.0.0.1:3306 -Dflyway.user=root
100
+ [INFO] ----------------------< com.uruk:chicago-spring >-----------------------
93
- [INFO] Scanning for projects...
101
+ [INFO] Building chicago-spring 0.0.1-SNAPSHOT
102
+ [INFO] --------------------------------[ jar ]---------------------------------
103
+ [INFO]
94
- Downloading from central: https://repo.maven.apache.org/maven2/flyway/migrate%E3%80%80-Dflyway.url=127.0.0.1/maven-metadata.xml
104
+ [INFO] --- flyway-maven-plugin:5.2.4:migrate (default-cli) @ chicago-spring ---
105
+ [INFO] Flyway Community Edition 5.2.4 by Boxfuse
95
106
  [INFO] ------------------------------------------------------------------------
96
107
  [INFO] BUILD FAILURE
97
108
  [INFO] ------------------------------------------------------------------------
98
- [INFO] Total time: 0.689 s
109
+ [INFO] Total time: 2.752 s
99
- [INFO] Finished at: 2019-07-23T14:15:41Z
110
+ [INFO] Finished at: 2019-07-24T13:53:04Z
100
111
  [INFO] ------------------------------------------------------------------------
101
- [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]
112
+ [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:
113
+ [ERROR] Unable to obtain connection from database (jdbc:mysql://127.0.0.1:3306/chicago) for user 'root': Unknown database 'chicago'
114
+ [ERROR] ---------------------------------------------------------------------------------------------------------------------------
115
+ [ERROR] SQL State : 42000
116
+ [ERROR] Error Code : 1049
117
+ [ERROR] Message : Unknown database 'chicago'
102
118
  [ERROR]
119
+ [ERROR] -> [Help 1]
120
+ [ERROR]
103
121
  [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
104
122
  [ERROR] Re-run Maven using the -X switch to enable full debug logging.
105
123
  [ERROR]
106
124
  [ERROR] For more information about the errors and possible solutions, please read the following articles:
107
- [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/PluginVersionResolutionException
125
+ [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException
108
126
  Exited with code 1
109
127
  ```
110
128
 
111
129
  また、エラーなのかわからないのですがContainer circleci/mysql:8.0-ramのステップは以下のログを出力して灰色になっています。
112
130
 
113
- ```
114
- Initializing database
115
- 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.
116
- 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
117
- 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.
118
- 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.
119
- 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.
120
- 2019-07-23T14:15:29.177705Z 0 [System] [MY-013170] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server has completed
131
+ ```Initializing database
132
+ 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.
133
+ 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
134
+ 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.
135
+ 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.
136
+ 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.
137
+ 2019-07-24T13:52:54.882324Z 0 [System] [MY-013170] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server has completed
121
138
  Database initialized
122
139
  MySQL init process in progress...
123
- 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.
124
- 2019-07-23T14:15:30.429077Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17) starting as process 162
125
- 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.
126
- 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.
127
- 2019-07-23T14:15:30.775069Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
128
- 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.
129
- 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.
130
- 2019-07-23T14:15:30.888163Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock'
140
+ 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.
141
+ 2019-07-24T13:52:55.462338Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17) starting as process 161
142
+ 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.
143
+ 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.
144
+ 2019-07-24T13:52:55.841740Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
145
+ 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.
146
+ 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.
147
+ 2019-07-24T13:52:55.949226Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock'
131
148
  Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
132
149
  Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
133
150
  Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
134
151
  Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
135
152
 
136
- 2019-07-23T14:15:33.672962Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.17) MySQL Community Server - GPL.
153
+ 2019-07-24T13:52:58.710605Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.17) MySQL Community Server - GPL.
137
154
 
138
155
  MySQL init process done. Ready for start up.
139
156
 
140
- 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.
141
- 2019-07-23T14:15:34.007319Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17) starting as process 6
142
- 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.
143
- 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.
144
- 2019-07-23T14:15:34.316535Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
145
- 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.
146
- 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.
147
- 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
157
+ 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.
158
+ 2019-07-24T13:52:59.054501Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17) starting as process 7
159
+ 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.
160
+ 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.
161
+ 2019-07-24T13:52:59.441213Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
162
+ 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.
163
+ 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.
164
+ 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
148
165
 
149
166
  Job was canceled
150
167
  ```

1

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

2019/07/24 14:03

投稿

Zeiniku2424
Zeiniku2424

スコア8

title CHANGED
File without changes
body CHANGED
@@ -14,7 +14,7 @@
14
14
  |DB|MySQL 8.0|
15
15
  |DB ドライバ | JDBC |
16
16
  |マイグレーションツール|Flyway|
17
- |ライブラリツール|maven|
17
+ |ライブラリツール|maven 3.6.1 |
18
18
 
19
19
  また、CIでのMySQLの設定は以下の通りにしたいと思っています。
20
20
  |||