質問編集履歴
5
情報を追加
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -10,8 +10,12 @@
|
|
|
10
10
|
試しに`wsrep_on=off`にしたところ、単体のMariaDBとしては起動することはできます。
|
|
11
11
|
|
|
12
12
|
|
|
13
|
-
|
|
13
|
+
具体的に、以下のように起動を試みておりますが、失敗となります。
|
|
14
|
+
```ここに言語を入力
|
|
14
|
-
|
|
15
|
+
# service mysql start --wsrep-new-cluster
|
|
16
|
+
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.
|
|
17
|
+
[失敗]
|
|
18
|
+
```
|
|
15
19
|
|
|
16
20
|
|
|
17
21
|
環境は以下になります。
|
4
情報の修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -91,16 +91,16 @@
|
|
|
91
91
|
|
|
92
92
|
**journalctl -xe**
|
|
93
93
|
```ここに言語を入力
|
|
94
|
-
7月 23 18:23:31
|
|
95
|
-
7月 23 18:23:31
|
|
94
|
+
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
|
|
95
|
+
7月 23 18:23:31 db1 systemd[1]: Starting MariaDB database server...
|
|
96
96
|
-- Subject: Unit mariadb.service has begun start-up
|
|
97
97
|
-- Defined-By: systemd
|
|
98
98
|
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
|
|
99
99
|
--
|
|
100
100
|
-- Unit mariadb.service has begun starting up.
|
|
101
|
-
7月 23 18:23:36
|
|
101
|
+
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 ...'
|
|
102
|
-
7月 23 18:23:36
|
|
102
|
+
7月 23 18:23:36 db1 systemd[1]: mariadb.service: control process exited, code=exited status=1
|
|
103
|
-
7月 23 18:23:36
|
|
103
|
+
7月 23 18:23:36 db1 systemd[1]: Failed to start MariaDB database server.
|
|
104
104
|
-- Subject: Unit mariadb.service has failed
|
|
105
105
|
-- Defined-By: systemd
|
|
106
106
|
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
|
|
@@ -108,7 +108,7 @@
|
|
|
108
108
|
-- Unit mariadb.service has failed.
|
|
109
109
|
--
|
|
110
110
|
-- The result is failed.
|
|
111
|
-
7月 23 18:23:36
|
|
112
|
-
7月 23 18:23:36
|
|
113
|
-
7月 23 18:23:36
|
|
111
|
+
7月 23 18:23:36 db1 systemd[1]: Unit mariadb.service entered failed state.
|
|
112
|
+
7月 23 18:23:36 db1 systemd[1]: mariadb.service failed.
|
|
113
|
+
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)
|
|
114
114
|
```
|
3
情報の追加
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -85,4 +85,30 @@
|
|
|
85
85
|
2016-07-21 11:37:21 140324149786752 [Note] WSREP: Read WSREPXid from InnoDB: 00000000-0000-0000-0000-000000000000:-1
|
|
86
86
|
2016-07-21 11:37:21 140324149786752 [Note] WSREP: Recovered position: 00000000-0000-0000-0000-000000000000:-1
|
|
87
87
|
handlersocket: terminated
|
|
88
|
+
```
|
|
89
|
+
|
|
90
|
+
|
|
91
|
+
|
|
92
|
+
**journalctl -xe**
|
|
93
|
+
```ここに言語を入力
|
|
94
|
+
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
|
|
95
|
+
7月 23 18:23:31 ptdb0 systemd[1]: Starting MariaDB database server...
|
|
96
|
+
-- Subject: Unit mariadb.service has begun start-up
|
|
97
|
+
-- Defined-By: systemd
|
|
98
|
+
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
|
|
99
|
+
--
|
|
100
|
+
-- Unit mariadb.service has begun starting up.
|
|
101
|
+
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 ...'
|
|
102
|
+
7月 23 18:23:36 ptdb0 systemd[1]: mariadb.service: control process exited, code=exited status=1
|
|
103
|
+
7月 23 18:23:36 ptdb0 systemd[1]: Failed to start MariaDB database server.
|
|
104
|
+
-- Subject: Unit mariadb.service has failed
|
|
105
|
+
-- Defined-By: systemd
|
|
106
|
+
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
|
|
107
|
+
--
|
|
108
|
+
-- Unit mariadb.service has failed.
|
|
109
|
+
--
|
|
110
|
+
-- The result is failed.
|
|
111
|
+
7月 23 18:23:36 ptdb0 systemd[1]: Unit mariadb.service entered failed state.
|
|
112
|
+
7月 23 18:23:36 ptdb0 systemd[1]: mariadb.service failed.
|
|
113
|
+
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)
|
|
88
114
|
```
|
2
内容修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -15,11 +15,15 @@
|
|
|
15
15
|
|
|
16
16
|
|
|
17
17
|
環境は以下になります。
|
|
18
|
+
OS
|
|
19
|
+
`# cat /etc/redhat-release`
|
|
18
|
-
|
|
20
|
+
`CentOS Linux release 7.2.1511 (Core)`
|
|
21
|
+
DB
|
|
22
|
+
`# mysql -V`
|
|
19
|
-
|
|
23
|
+
`mysql Ver 15.1 Distrib 10.1.16-MariaDB, for Linux (x86_64) using readline 5.1`
|
|
20
24
|
|
|
21
25
|
|
|
22
|
-
/etc/my.cnf.d/server.cnf
|
|
26
|
+
**/etc/my.cnf.d/server.cnf**
|
|
23
27
|
```ここに言語を入力
|
|
24
28
|
[mysqld]
|
|
25
29
|
|
1
書式改善
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -59,24 +59,26 @@
|
|
|
59
59
|
|
|
60
60
|
|
|
61
61
|
**error.log**
|
|
62
|
+
```ここに言語を入力
|
|
62
63
|
|
|
63
|
-
|
|
64
|
+
handlersocket: initialized
|
|
64
|
-
|
|
65
|
+
2016-07-21 11:37:20 140324149786752 [Note] InnoDB: Using mutexes to ref count buffer pool pages
|
|
65
|
-
|
|
66
|
+
2016-07-21 11:37:20 140324149786752 [Note] InnoDB: The InnoDB memory heap is disabled
|
|
66
|
-
|
|
67
|
+
2016-07-21 11:37:20 140324149786752 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
|
67
|
-
|
|
68
|
+
2016-07-21 11:37:20 140324149786752 [Note] InnoDB: Memory barrier is not used
|
|
68
|
-
|
|
69
|
+
2016-07-21 11:37:20 140324149786752 [Note] InnoDB: Compressed tables use zlib 1.2.7
|
|
69
|
-
|
|
70
|
+
2016-07-21 11:37:20 140324149786752 [Note] InnoDB: Using Linux native AIO
|
|
70
|
-
|
|
71
|
+
2016-07-21 11:37:20 140324149786752 [Note] InnoDB: Using SSE crc32 instructions
|
|
71
|
-
|
|
72
|
+
2016-07-21 11:37:20 140324149786752 [Note] InnoDB: Initializing buffer pool, size = 30.0G
|
|
72
|
-
|
|
73
|
+
2016-07-21 11:37:21 140324149786752 [Note] InnoDB: Completed initialization of buffer pool
|
|
73
|
-
|
|
74
|
+
2016-07-21 11:37:21 140324149786752 [Note] InnoDB: Highest supported file format is Barracuda.
|
|
74
|
-
|
|
75
|
+
2016-07-21 11:37:21 140324149786752 [Note] InnoDB: 128 rollback segment(s) are active.
|
|
75
|
-
|
|
76
|
+
2016-07-21 11:37:21 140324149786752 [Note] InnoDB: Waiting for purge to start
|
|
76
|
-
|
|
77
|
+
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
|
|
77
|
-
|
|
78
|
+
2016-07-21 11:37:21 140324149786752 [Warning] InnoDB: Skipping buffer pool dump/restore during wsrep recovery.
|
|
78
|
-
|
|
79
|
+
2016-07-21 11:37:21 140324149786752 [Note] Plugin 'FEEDBACK' is disabled.
|
|
79
|
-
|
|
80
|
+
2016-07-21 11:37:21 140324149786752 [Note] Server socket created on IP: '::'.
|
|
80
|
-
|
|
81
|
+
2016-07-21 11:37:21 140324149786752 [Note] WSREP: Read WSREPXid from InnoDB: 00000000-0000-0000-0000-000000000000:-1
|
|
81
|
-
|
|
82
|
+
2016-07-21 11:37:21 140324149786752 [Note] WSREP: Recovered position: 00000000-0000-0000-0000-000000000000:-1
|
|
82
|
-
|
|
83
|
+
handlersocket: terminated
|
|
84
|
+
```
|