質問編集履歴
5
情報を追加
test
CHANGED
File without changes
|
test
CHANGED
@@ -22,9 +22,17 @@
|
|
22
22
|
|
23
23
|
|
24
24
|
|
25
|
-
|
25
|
+
具体的に、以下のように起動を試みておりますが、失敗となります。
|
26
|
+
|
26
|
-
|
27
|
+
```ここに言語を入力
|
28
|
+
|
27
|
-
|
29
|
+
# service mysql start --wsrep-new-cluster
|
30
|
+
|
31
|
+
Starting mysql (via systemctl): Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
|
32
|
+
|
33
|
+
[失敗]
|
34
|
+
|
35
|
+
```
|
28
36
|
|
29
37
|
|
30
38
|
|
4
情報の修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -184,9 +184,9 @@
|
|
184
184
|
|
185
185
|
```ここに言語を入力
|
186
186
|
|
187
|
-
7月 23 18:23:31
|
188
|
-
|
189
|
-
7月 23 18:23:31
|
187
|
+
7月 23 18:23:31 db1 polkitd[947]: Registered Authentication Agent for unix-process:17364:34048626 (system bus name :1.288 [/usr/bin/pkttyagent --notify-fd 5 --fallback], object path /org/freedesktop/PolicyKit1/AuthenticationAgent, loca
|
188
|
+
|
189
|
+
7月 23 18:23:31 db1 systemd[1]: Starting MariaDB database server...
|
190
190
|
|
191
191
|
-- Subject: Unit mariadb.service has begun start-up
|
192
192
|
|
@@ -198,11 +198,11 @@
|
|
198
198
|
|
199
199
|
-- Unit mariadb.service has begun starting up.
|
200
200
|
|
201
|
-
7月 23 18:23:36
|
201
|
+
7月 23 18:23:36 db1 sh[17372]: WSREP: Failed to recover position: '2016-07-23 18:23:32 140580170864768 [Note] /usr/sbin/mysqld (mysqld 10.1.16-MariaDB) starting as process 17445 ...'
|
202
|
-
|
202
|
+
|
203
|
-
7月 23 18:23:36
|
203
|
+
7月 23 18:23:36 db1 systemd[1]: mariadb.service: control process exited, code=exited status=1
|
204
|
-
|
204
|
+
|
205
|
-
7月 23 18:23:36
|
205
|
+
7月 23 18:23:36 db1 systemd[1]: Failed to start MariaDB database server.
|
206
206
|
|
207
207
|
-- Subject: Unit mariadb.service has failed
|
208
208
|
|
@@ -218,10 +218,10 @@
|
|
218
218
|
|
219
219
|
-- The result is failed.
|
220
220
|
|
221
|
-
7月 23 18:23:36
|
222
|
-
|
223
|
-
7月 23 18:23:36
|
224
|
-
|
225
|
-
7月 23 18:23:36
|
221
|
+
7月 23 18:23:36 db1 systemd[1]: Unit mariadb.service entered failed state.
|
222
|
+
|
223
|
+
7月 23 18:23:36 db1 systemd[1]: mariadb.service failed.
|
224
|
+
|
225
|
+
7月 23 18:23:36 db1 polkitd[947]: Unregistered Authentication Agent for unix-process:17364:34048626 (system bus name :1.288, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale ja_JP.UTF-8) (disconnected from bus)
|
226
226
|
|
227
227
|
```
|
3
情報の追加
test
CHANGED
File without changes
|
test
CHANGED
@@ -173,3 +173,55 @@
|
|
173
173
|
handlersocket: terminated
|
174
174
|
|
175
175
|
```
|
176
|
+
|
177
|
+
|
178
|
+
|
179
|
+
|
180
|
+
|
181
|
+
|
182
|
+
|
183
|
+
**journalctl -xe**
|
184
|
+
|
185
|
+
```ここに言語を入力
|
186
|
+
|
187
|
+
7月 23 18:23:31 ptdb0 polkitd[947]: Registered Authentication Agent for unix-process:17364:34048626 (system bus name :1.288 [/usr/bin/pkttyagent --notify-fd 5 --fallback], object path /org/freedesktop/PolicyKit1/AuthenticationAgent, loca
|
188
|
+
|
189
|
+
7月 23 18:23:31 ptdb0 systemd[1]: Starting MariaDB database server...
|
190
|
+
|
191
|
+
-- Subject: Unit mariadb.service has begun start-up
|
192
|
+
|
193
|
+
-- Defined-By: systemd
|
194
|
+
|
195
|
+
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
|
196
|
+
|
197
|
+
--
|
198
|
+
|
199
|
+
-- Unit mariadb.service has begun starting up.
|
200
|
+
|
201
|
+
7月 23 18:23:36 ptdb0 sh[17372]: WSREP: Failed to recover position: '2016-07-23 18:23:32 140580170864768 [Note] /usr/sbin/mysqld (mysqld 10.1.16-MariaDB) starting as process 17445 ...'
|
202
|
+
|
203
|
+
7月 23 18:23:36 ptdb0 systemd[1]: mariadb.service: control process exited, code=exited status=1
|
204
|
+
|
205
|
+
7月 23 18:23:36 ptdb0 systemd[1]: Failed to start MariaDB database server.
|
206
|
+
|
207
|
+
-- Subject: Unit mariadb.service has failed
|
208
|
+
|
209
|
+
-- Defined-By: systemd
|
210
|
+
|
211
|
+
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
|
212
|
+
|
213
|
+
--
|
214
|
+
|
215
|
+
-- Unit mariadb.service has failed.
|
216
|
+
|
217
|
+
--
|
218
|
+
|
219
|
+
-- The result is failed.
|
220
|
+
|
221
|
+
7月 23 18:23:36 ptdb0 systemd[1]: Unit mariadb.service entered failed state.
|
222
|
+
|
223
|
+
7月 23 18:23:36 ptdb0 systemd[1]: mariadb.service failed.
|
224
|
+
|
225
|
+
7月 23 18:23:36 ptdb0 polkitd[947]: Unregistered Authentication Agent for unix-process:17364:34048626 (system bus name :1.288, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale ja_JP.UTF-8) (disconnected from bus)
|
226
|
+
|
227
|
+
```
|
2
内容修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -32,15 +32,23 @@
|
|
32
32
|
|
33
33
|
環境は以下になります。
|
34
34
|
|
35
|
-
|
35
|
+
OS
|
36
36
|
|
37
|
+
`# cat /etc/redhat-release`
|
38
|
+
|
39
|
+
`CentOS Linux release 7.2.1511 (Core)`
|
40
|
+
|
41
|
+
DB
|
42
|
+
|
43
|
+
`# mysql -V`
|
44
|
+
|
37
|
-
|
45
|
+
`mysql Ver 15.1 Distrib 10.1.16-MariaDB, for Linux (x86_64) using readline 5.1`
|
38
46
|
|
39
47
|
|
40
48
|
|
41
49
|
|
42
50
|
|
43
|
-
/etc/my.cnf.d/server.cnf
|
51
|
+
**/etc/my.cnf.d/server.cnf**
|
44
52
|
|
45
53
|
```ここに言語を入力
|
46
54
|
|
1
書式改善
test
CHANGED
File without changes
|
test
CHANGED
@@ -120,44 +120,48 @@
|
|
120
120
|
|
121
121
|
**error.log**
|
122
122
|
|
123
|
+
```ここに言語を入力
|
123
124
|
|
124
125
|
|
125
|
-
> handlersocket: initialized
|
126
126
|
|
127
|
-
|
127
|
+
handlersocket: initialized
|
128
128
|
|
129
|
-
|
129
|
+
2016-07-21 11:37:20 140324149786752 [Note] InnoDB: Using mutexes to ref count buffer pool pages
|
130
130
|
|
131
|
-
|
131
|
+
2016-07-21 11:37:20 140324149786752 [Note] InnoDB: The InnoDB memory heap is disabled
|
132
132
|
|
133
|
-
|
133
|
+
2016-07-21 11:37:20 140324149786752 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
134
134
|
|
135
|
-
|
135
|
+
2016-07-21 11:37:20 140324149786752 [Note] InnoDB: Memory barrier is not used
|
136
136
|
|
137
|
-
|
137
|
+
2016-07-21 11:37:20 140324149786752 [Note] InnoDB: Compressed tables use zlib 1.2.7
|
138
138
|
|
139
|
-
|
139
|
+
2016-07-21 11:37:20 140324149786752 [Note] InnoDB: Using Linux native AIO
|
140
140
|
|
141
|
-
|
141
|
+
2016-07-21 11:37:20 140324149786752 [Note] InnoDB: Using SSE crc32 instructions
|
142
142
|
|
143
|
-
|
143
|
+
2016-07-21 11:37:20 140324149786752 [Note] InnoDB: Initializing buffer pool, size = 30.0G
|
144
144
|
|
145
|
-
|
145
|
+
2016-07-21 11:37:21 140324149786752 [Note] InnoDB: Completed initialization of buffer pool
|
146
146
|
|
147
|
-
|
147
|
+
2016-07-21 11:37:21 140324149786752 [Note] InnoDB: Highest supported file format is Barracuda.
|
148
148
|
|
149
|
-
|
149
|
+
2016-07-21 11:37:21 140324149786752 [Note] InnoDB: 128 rollback segment(s) are active.
|
150
150
|
|
151
|
-
|
151
|
+
2016-07-21 11:37:21 140324149786752 [Note] InnoDB: Waiting for purge to start
|
152
152
|
|
153
|
-
|
153
|
+
2016-07-21 11:37:21 140324149786752 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.30-76.3 started; log sequence number 1617266
|
154
154
|
|
155
|
-
|
155
|
+
2016-07-21 11:37:21 140324149786752 [Warning] InnoDB: Skipping buffer pool dump/restore during wsrep recovery.
|
156
156
|
|
157
|
-
|
157
|
+
2016-07-21 11:37:21 140324149786752 [Note] Plugin 'FEEDBACK' is disabled.
|
158
158
|
|
159
|
-
|
159
|
+
2016-07-21 11:37:21 140324149786752 [Note] Server socket created on IP: '::'.
|
160
160
|
|
161
|
-
|
161
|
+
2016-07-21 11:37:21 140324149786752 [Note] WSREP: Read WSREPXid from InnoDB: 00000000-0000-0000-0000-000000000000:-1
|
162
162
|
|
163
|
+
2016-07-21 11:37:21 140324149786752 [Note] WSREP: Recovered position: 00000000-0000-0000-0000-000000000000:-1
|
164
|
+
|
163
|
-
|
165
|
+
handlersocket: terminated
|
166
|
+
|
167
|
+
```
|