質問編集履歴
5
内容の修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -126,13 +126,7 @@
|
|
|
126
126
|
|
|
127
127
|
```sql
|
|
128
128
|
|
|
129
|
-
2019-11-15T21:33:53.682473Z 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.
|
|
130
129
|
|
|
131
|
-
2019-11-15T21:33:53.684573Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.18) starting as process 10360
|
|
132
|
-
|
|
133
|
-
2019-11-15T21:33:53.689512Z 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.
|
|
134
|
-
|
|
135
|
-
2019-11-15T21:33:53.728189Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
|
|
136
130
|
|
|
137
131
|
2019-11-15T21:33:53.865985Z 1 [ERROR] [MY-013090] [InnoDB] Unsupported redo log format (0). The redo log was created before MySQL 5.7.9
|
|
138
132
|
|
|
@@ -144,7 +138,21 @@
|
|
|
144
138
|
|
|
145
139
|
2019-11-15T21:33:54.286356Z 0 [ERROR] [MY-010119] [Server] Aborting
|
|
146
140
|
|
|
141
|
+
```
|
|
142
|
+
|
|
143
|
+
というエラーログが出たので調べてみた結果、 /var/lib/mysql/ファイルのib_logfile0 と ib_logfile1がRedo logsなので消去しろとのことだったので実行しました。
|
|
144
|
+
|
|
145
|
+
その後にまた sudo service mysqld start を実行したら次のようなエラーログが出ました。
|
|
146
|
+
|
|
147
|
+
```sql
|
|
148
|
+
|
|
149
|
+
2019-11-15T22:28:51.776034Z 1 [ERROR] [MY-013168] [InnoDB] Cannot upgrade server earlier than 5.7 to 8.0
|
|
150
|
+
|
|
151
|
+
2019-11-15T22:28:56.780697Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
|
|
152
|
+
|
|
147
|
-
2019-11-15T2
|
|
153
|
+
2019-11-15T22:28:56.781401Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
|
|
154
|
+
|
|
155
|
+
2019-11-15T22:28:56.782225Z 0 [ERROR] [MY-010119] [Server] Aborting
|
|
148
156
|
|
|
149
157
|
|
|
150
158
|
|
4
内容の修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -122,7 +122,33 @@
|
|
|
122
122
|
|
|
123
123
|
```
|
|
124
124
|
|
|
125
|
-
としてみ
|
|
125
|
+
としてみたところ
|
|
126
|
+
|
|
127
|
+
```sql
|
|
128
|
+
|
|
129
|
+
2019-11-15T21:33:53.682473Z 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.
|
|
130
|
+
|
|
131
|
+
2019-11-15T21:33:53.684573Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.18) starting as process 10360
|
|
132
|
+
|
|
133
|
+
2019-11-15T21:33:53.689512Z 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.
|
|
134
|
+
|
|
135
|
+
2019-11-15T21:33:53.728189Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
|
|
136
|
+
|
|
137
|
+
2019-11-15T21:33:53.865985Z 1 [ERROR] [MY-013090] [InnoDB] Unsupported redo log format (0). The redo log was created before MySQL 5.7.9
|
|
138
|
+
|
|
139
|
+
2019-11-15T21:33:53.866297Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
|
|
140
|
+
|
|
141
|
+
2019-11-15T21:33:54.285345Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
|
|
142
|
+
|
|
143
|
+
2019-11-15T21:33:54.285833Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
|
|
144
|
+
|
|
145
|
+
2019-11-15T21:33:54.286356Z 0 [ERROR] [MY-010119] [Server] Aborting
|
|
146
|
+
|
|
147
|
+
2019-11-15T21:33:54.288408Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.18) MySQL Community Server - GPL.
|
|
148
|
+
|
|
149
|
+
|
|
150
|
+
|
|
151
|
+
```
|
|
126
152
|
|
|
127
153
|
このようになってしまった際の解決法をどなたかご存じでしたら宜しくお願いします。
|
|
128
154
|
|
3
内容の修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -118,11 +118,11 @@
|
|
|
118
118
|
|
|
119
119
|
```sql
|
|
120
120
|
|
|
121
|
-
$ less /var/log/mysqld.log
|
|
121
|
+
$ sudo less /var/log/mysqld.log
|
|
122
122
|
|
|
123
123
|
```
|
|
124
124
|
|
|
125
|
-
としてみましたが、
|
|
125
|
+
としてみましたが、直近のログはありませんでした。
|
|
126
126
|
|
|
127
127
|
このようになってしまった際の解決法をどなたかご存じでしたら宜しくお願いします。
|
|
128
128
|
|
2
具体的な説明の追加
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -114,6 +114,16 @@
|
|
|
114
114
|
|
|
115
115
|
と出てきます。
|
|
116
116
|
|
|
117
|
+
|
|
118
|
+
|
|
119
|
+
```sql
|
|
120
|
+
|
|
121
|
+
$ less /var/log/mysqld.log
|
|
122
|
+
|
|
123
|
+
```
|
|
124
|
+
|
|
125
|
+
としてみましたが、これも許可がありませんと出てきます。
|
|
126
|
+
|
|
117
127
|
このようになってしまった際の解決法をどなたかご存じでしたら宜しくお願いします。
|
|
118
128
|
|
|
119
129
|
バージョン自体はしっかりとアップグレードされているようです。
|
1
環境の説明
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -1,3 +1,5 @@
|
|
|
1
|
+
MyCentOSを使っています。操作はputtyでしております。
|
|
2
|
+
|
|
1
3
|
MySqlを5.6から8.0に次の手順でバージョンアップしたら起動ができなくなりました。
|
|
2
4
|
|
|
3
5
|
|