teratail
回答率
85.35%
teratail header banner
teratail header banner
質問するログイン新規登録
トップに関する質問mariadb5.5から10.3以上へアップデートしたい

編集履歴

質問編集履歴

3

修正

2020/09/29 07:42

投稿

takashiro7300
takashiro7300

スコア12

test CHANGED
File without changes
test CHANGED
@@ -58,49 +58,49 @@
58
58
 
59
59
  ● mariadb.service - MariaDB 10.5.5 database server
60
60
 
61
- Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
61
+ Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
62
62
 
63
- Drop-In: /etc/systemd/system/mariadb.service.d
63
+ Drop-In: /etc/systemd/system/mariadb.service.d
64
64
 
65
- mqmigrated-from-my.cnf-settings.conf
65
+ mqmigrated-from-my.cnf-settings.conf
66
66
 
67
- Active: failed (Result: exit-code) since 火 2020-09-29 15:11:28 JST; 22s ago
67
+ Active: failed (Result: exit-code) since 火 2020-09-29 15:11:28 JST; 19min ago
68
68
 
69
- Docs: man:mariadbd(8)
69
+ Docs: man:mariadbd(8)
70
70
 
71
- https://mariadb.com/kb/en/library/systemd/
71
+ https://mariadb.com/kb/en/library/systemd/
72
72
 
73
- Process: 7211 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=7)
73
+ Process: 7211 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=7)
74
74
 
75
- Process: 7119 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
75
+ Process: 7119 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
76
76
 
77
- Process: 7116 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
77
+ Process: 7116 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
78
78
 
79
- Main PID: 7211 (code=exited, status=7)
79
+ Main PID: 7211 (code=exited, status=7)
80
80
 
81
- Status: "MariaDB server is down"
81
+ Status: "MariaDB server is down"
82
82
 
83
83
 
84
84
 
85
- 9月 29 15:11:27 E-Learning.hogehoge.co.jp mariadbd[7211]: 2020-09-29 15:11:27 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
85
+ 9月 29 15:11:27 E-Learning.hogehoge.co.jp mariadbd[7211]: 2020-09-29 15:11:27 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
86
86
 
87
- 9月 29 15:11:27 E-Learning.hogehoge.co.jp mariadbd[7211]: 2020-09-29 15:11:27 0 [Note] InnoDB: 10.5.5 started; log sequence number 14871494016;...8990929
87
+ 9月 29 15:11:27 E-Learning.hogehoge.co.jp mariadbd[7211]: 2020-09-29 15:11:27 0 [Note] InnoDB: 10.5.5 started; log sequence number 14871494016; transaction id 198990929
88
88
 
89
- 9月 29 15:11:27 E-Learning.hogehoge.co.jp mariadbd[7211]: 2020-09-29 15:11:27 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
89
+ 9月 29 15:11:27 E-Learning.hogehoge.co.jp mariadbd[7211]: 2020-09-29 15:11:27 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
90
90
 
91
- 9月 29 15:11:27 E-Learning.hogehoge.co.jp mariadbd[7211]: 2020-09-29 15:11:27 0 [Note] Plugin 'FEEDBACK' is disabled.
91
+ 9月 29 15:11:27 E-Learning.hogehoge.co.jp mariadbd[7211]: 2020-09-29 15:11:27 0 [Note] Plugin 'FEEDBACK' is disabled.
92
92
 
93
- 9月 29 15:11:27 E-Learning.hogehoge.co.jp mariadbd[7211]: 2020-09-29 15:11:27 0 [ERROR] /usr/sbin/mariadbd: unknown variable 'innodb_file_forma...racuda'
93
+ 9月 29 15:11:27 E-Learning.hogehoge.co.jp mariadbd[7211]: 2020-09-29 15:11:27 0 [ERROR] /usr/sbin/mariadbd: unknown variable 'innodb_file_format_max=Barracuda'
94
94
 
95
- 9月 29 15:11:27 E-Learning.hogehoge.co.jp mariadbd[7211]: 2020-09-29 15:11:27 0 [ERROR] Aborting
95
+ 9月 29 15:11:27 E-Learning.hogehoge.co.jp mariadbd[7211]: 2020-09-29 15:11:27 0 [ERROR] Aborting
96
96
 
97
- 9月 29 15:11:28 E-Learning.hogehoge.co.jp systemd[1]: mariadb.service: main process exited, code=exited, status=7/NOTRUNNING
97
+ 9月 29 15:11:28 E-Learning.hogehoge.co.jp systemd[1]: mariadb.service: main process exited, code=exited, status=7/NOTRUNNING
98
98
 
99
- 9月 29 15:11:28 E-Learning.hogehoge.co.jp systemd[1]: Failed to start MariaDB 10.5.5 database server.
99
+ 9月 29 15:11:28 E-Learning.hogehoge.co.jp systemd[1]: Failed to start MariaDB 10.5.5 database server.
100
100
 
101
- 9月 29 15:11:28 E-Learning.hogehoge.co.jp systemd[1]: Unit mariadb.service entered failed state.
101
+ 9月 29 15:11:28 E-Learning.hogehoge.co.jp systemd[1]: Unit mariadb.service entered failed state.
102
102
 
103
- 9月 29 15:11:28 E-Learning.hogehoge.co.jp systemd[1]: mariadb.service failed.
103
+ 9月 29 15:11:28 E-Learning.hogehoge.co.jp systemd[1]: mariadb.service failed.
104
104
 
105
105
  Hint: Some lines were ellipsized, use -l to show in full.
106
106
 

2

修正と追記

2020/09/29 07:42

投稿

takashiro7300
takashiro7300

スコア12

test CHANGED
@@ -1 +1 @@
1
- mariadb5.5から10.3へアップデートしたい
1
+ mariadb5.5から10.3以上へアップデートしたい
test CHANGED
@@ -2,7 +2,7 @@
2
2
 
3
3
  このサーバではMoodleを動かしており、Moodleのアップデートに伴い
4
4
 
5
- mariadbを10.2.29以上にするため、10.3にしようと思っています。
5
+ mariadbを10.2.29以上にするため、10.3以上にしようと思っています。
6
6
 
7
7
 
8
8
 
@@ -109,3 +109,23 @@
109
109
 
110
110
 
111
111
  どうすれば、正常に起動できますでしょうか。
112
+
113
+
114
+
115
+ また、現在のmariadbのバージョンを
116
+
117
+ yum list installed | grep mariadb
118
+
119
+ で確認したところ、下記の通り、10.5.5になっているようでした。
120
+
121
+ [root@E-Learning html]# yum list installed | grep mariadb
122
+
123
+ MariaDB-client.x86_64 10.5.5-1.el7.centos @mariadb-main
124
+
125
+ MariaDB-common.x86_64 10.5.5-1.el7.centos @mariadb-main
126
+
127
+ MariaDB-compat.x86_64 10.5.5-1.el7.centos @mariadb-main
128
+
129
+ MariaDB-server.x86_64 10.5.5-1.el7.centos @mariadb-main
130
+
131
+ galera-4.x86_64 26.4.5-1.el7.centos @mariadb-main

1

誤字修正

2020/09/29 07:30

投稿

takashiro7300
takashiro7300

スコア12

test CHANGED
File without changes
test CHANGED
@@ -1,6 +1,6 @@
1
1
  CentOS7で、mariadb5.5を使っていました。
2
2
 
3
- このサーバではMoodleを動かしており、Moodleのアップデートに伴い、
3
+ このサーバではMoodleを動かしており、Moodleのアップデートに伴い
4
4
 
5
5
  mariadbを10.2.29以上にするため、10.3にしようと思っています。
6
6
 
@@ -82,25 +82,25 @@
82
82
 
83
83
 
84
84
 
85
- 9月 29 15:11:27 E-Learning.techvan.co.jp mariadbd[7211]: 2020-09-29 15:11:27 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
85
+ 9月 29 15:11:27 E-Learning.hogehoge.co.jp mariadbd[7211]: 2020-09-29 15:11:27 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
86
86
 
87
- 9月 29 15:11:27 E-Learning.techvan.co.jp mariadbd[7211]: 2020-09-29 15:11:27 0 [Note] InnoDB: 10.5.5 started; log sequence number 14871494016;...8990929
87
+ 9月 29 15:11:27 E-Learning.hogehoge.co.jp mariadbd[7211]: 2020-09-29 15:11:27 0 [Note] InnoDB: 10.5.5 started; log sequence number 14871494016;...8990929
88
88
 
89
- 9月 29 15:11:27 E-Learning.techvan.co.jp mariadbd[7211]: 2020-09-29 15:11:27 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
89
+ 9月 29 15:11:27 E-Learning.hogehoge.co.jp mariadbd[7211]: 2020-09-29 15:11:27 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
90
90
 
91
- 9月 29 15:11:27 E-Learning.techvan.co.jp mariadbd[7211]: 2020-09-29 15:11:27 0 [Note] Plugin 'FEEDBACK' is disabled.
91
+ 9月 29 15:11:27 E-Learning.hogehoge.co.jp mariadbd[7211]: 2020-09-29 15:11:27 0 [Note] Plugin 'FEEDBACK' is disabled.
92
92
 
93
- 9月 29 15:11:27 E-Learning.techvan.co.jp mariadbd[7211]: 2020-09-29 15:11:27 0 [ERROR] /usr/sbin/mariadbd: unknown variable 'innodb_file_forma...racuda'
93
+ 9月 29 15:11:27 E-Learning.hogehoge.co.jp mariadbd[7211]: 2020-09-29 15:11:27 0 [ERROR] /usr/sbin/mariadbd: unknown variable 'innodb_file_forma...racuda'
94
94
 
95
- 9月 29 15:11:27 E-Learning.techvan.co.jp mariadbd[7211]: 2020-09-29 15:11:27 0 [ERROR] Aborting
95
+ 9月 29 15:11:27 E-Learning.hogehoge.co.jp mariadbd[7211]: 2020-09-29 15:11:27 0 [ERROR] Aborting
96
96
 
97
- 9月 29 15:11:28 E-Learning.techvan.co.jp systemd[1]: mariadb.service: main process exited, code=exited, status=7/NOTRUNNING
97
+ 9月 29 15:11:28 E-Learning.hogehoge.co.jp systemd[1]: mariadb.service: main process exited, code=exited, status=7/NOTRUNNING
98
98
 
99
- 9月 29 15:11:28 E-Learning.techvan.co.jp systemd[1]: Failed to start MariaDB 10.5.5 database server.
99
+ 9月 29 15:11:28 E-Learning.hogehoge.co.jp systemd[1]: Failed to start MariaDB 10.5.5 database server.
100
100
 
101
- 9月 29 15:11:28 E-Learning.techvan.co.jp systemd[1]: Unit mariadb.service entered failed state.
101
+ 9月 29 15:11:28 E-Learning.hogehoge.co.jp systemd[1]: Unit mariadb.service entered failed state.
102
102
 
103
- 9月 29 15:11:28 E-Learning.techvan.co.jp systemd[1]: mariadb.service failed.
103
+ 9月 29 15:11:28 E-Learning.hogehoge.co.jp systemd[1]: mariadb.service failed.
104
104
 
105
105
  Hint: Some lines were ellipsized, use -l to show in full.
106
106