teratail
回答率
85.49%
質問するログイン新規登録
トップに関する質問 MariaDB 10.1 Galera Cluster が起動できない

編集履歴

質問編集履歴

5

情報を追加

2016/07/23 09:36

投稿

suzushin0619
suzushin0619

スコア10

test CHANGED
File without changes
test CHANGED
@@ -22,9 +22,17 @@
22
22
 
23
23
 
24
24
 
25
- 起動は以下のコマンドを用いています。
25
+ 具体的に、以下のように起動を試みておりますが、失敗となります。
26
+
26
-
27
+ ```ここに言語を入力
28
+
27
- `service mysql start --wsrep-new-cluster`
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

情報の修正

2016/07/23 09:36

投稿

suzushin0619
suzushin0619

スコア10

test CHANGED
File without changes
test CHANGED
@@ -184,9 +184,9 @@
184
184
 
185
185
  ```ここに言語を入力
186
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...
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 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 ...'
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 ptdb0 systemd[1]: mariadb.service: control process exited, code=exited status=1
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 ptdb0 systemd[1]: Failed to start MariaDB database server.
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 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)
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

情報の追加

2016/07/23 09:28

投稿

suzushin0619
suzushin0619

スコア10

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

内容修正

2016/07/23 09:26

投稿

suzushin0619
suzushin0619

スコア10

test CHANGED
File without changes
test CHANGED
@@ -32,15 +32,23 @@
32
32
 
33
33
  環境は以下になります。
34
34
 
35
- - CentOS Linux release 7.2.1511 (Core)
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
- - mysql Ver 15.1 Distrib 10.1.16-MariaDB, for Linux (x86_64) using readline 5.1
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

書式改善

2016/07/21 07:42

投稿

suzushin0619
suzushin0619

スコア10

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
- > 2016-07-21 11:37:20 140324149786752 [Note] InnoDB: Using mutexes to ref count buffer pool pages
127
+ handlersocket: initialized
128
128
 
129
- > 2016-07-21 11:37:20 140324149786752 [Note] InnoDB: The InnoDB memory heap is disabled
129
+ 2016-07-21 11:37:20 140324149786752 [Note] InnoDB: Using mutexes to ref count buffer pool pages
130
130
 
131
- > 2016-07-21 11:37:20 140324149786752 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
131
+ 2016-07-21 11:37:20 140324149786752 [Note] InnoDB: The InnoDB memory heap is disabled
132
132
 
133
- > 2016-07-21 11:37:20 140324149786752 [Note] InnoDB: Memory barrier is not used
133
+ 2016-07-21 11:37:20 140324149786752 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
134
134
 
135
- > 2016-07-21 11:37:20 140324149786752 [Note] InnoDB: Compressed tables use zlib 1.2.7
135
+ 2016-07-21 11:37:20 140324149786752 [Note] InnoDB: Memory barrier is not used
136
136
 
137
- > 2016-07-21 11:37:20 140324149786752 [Note] InnoDB: Using Linux native AIO
137
+ 2016-07-21 11:37:20 140324149786752 [Note] InnoDB: Compressed tables use zlib 1.2.7
138
138
 
139
- > 2016-07-21 11:37:20 140324149786752 [Note] InnoDB: Using SSE crc32 instructions
139
+ 2016-07-21 11:37:20 140324149786752 [Note] InnoDB: Using Linux native AIO
140
140
 
141
- > 2016-07-21 11:37:20 140324149786752 [Note] InnoDB: Initializing buffer pool, size = 30.0G
141
+ 2016-07-21 11:37:20 140324149786752 [Note] InnoDB: Using SSE crc32 instructions
142
142
 
143
- > 2016-07-21 11:37:21 140324149786752 [Note] InnoDB: Completed initialization of buffer pool
143
+ 2016-07-21 11:37:20 140324149786752 [Note] InnoDB: Initializing buffer pool, size = 30.0G
144
144
 
145
- > 2016-07-21 11:37:21 140324149786752 [Note] InnoDB: Highest supported file format is Barracuda.
145
+ 2016-07-21 11:37:21 140324149786752 [Note] InnoDB: Completed initialization of buffer pool
146
146
 
147
- > 2016-07-21 11:37:21 140324149786752 [Note] InnoDB: 128 rollback segment(s) are active.
147
+ 2016-07-21 11:37:21 140324149786752 [Note] InnoDB: Highest supported file format is Barracuda.
148
148
 
149
- > 2016-07-21 11:37:21 140324149786752 [Note] InnoDB: Waiting for purge to start
149
+ 2016-07-21 11:37:21 140324149786752 [Note] InnoDB: 128 rollback segment(s) are active.
150
150
 
151
- > 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
151
+ 2016-07-21 11:37:21 140324149786752 [Note] InnoDB: Waiting for purge to start
152
152
 
153
- > 2016-07-21 11:37:21 140324149786752 [Warning] InnoDB: Skipping buffer pool dump/restore during wsrep recovery.
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
- > 2016-07-21 11:37:21 140324149786752 [Note] Plugin 'FEEDBACK' is disabled.
155
+ 2016-07-21 11:37:21 140324149786752 [Warning] InnoDB: Skipping buffer pool dump/restore during wsrep recovery.
156
156
 
157
- > 2016-07-21 11:37:21 140324149786752 [Note] Server socket created on IP: '::'.
157
+ 2016-07-21 11:37:21 140324149786752 [Note] Plugin 'FEEDBACK' is disabled.
158
158
 
159
- > 2016-07-21 11:37:21 140324149786752 [Note] WSREP: Read WSREPXid from InnoDB: 00000000-0000-0000-0000-000000000000:-1
159
+ 2016-07-21 11:37:21 140324149786752 [Note] Server socket created on IP: '::'.
160
160
 
161
- > 2016-07-21 11:37:21 140324149786752 [Note] WSREP: Recovered position: 00000000-0000-0000-0000-000000000000:-1
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
- > handlersocket: terminated
165
+ handlersocket: terminated
166
+
167
+ ```