teratail header banner
teratail header banner
質問するログイン新規登録

質問編集履歴

1

journalctl -xe と ystemctl status mysqld.service の結果を追加

2021/08/28 21:27

投稿

hase744
hase744

スコア57

title CHANGED
File without changes
body CHANGED
@@ -15,4 +15,48 @@
15
15
  2021-08-28T15:52:09.305635Z 0 [ERROR] [MY-010119] [Server] Aborting
16
16
  ```
17
17
  Too many arguments ってことはどこかに余計なことが書かれているんですかね
18
- どんな原因が考えられますか?
18
+ どんな原因が考えられますか?
19
+
20
+ 追記
21
+ ```command
22
+ [ec2-user@ip-10-0-0-24 ~]$ journalctl -xe
23
+ Aug 28 20:28:16 ip-10-0-0-24.ap-northeast-1.compute.internal sudo[30815]: ec2-user : TTY=pts/3 ; PWD=/home/ec2-user ; USER=root ; COMMAND=/sbin/service mysqld start
24
+ Aug 28 20:28:16 ip-10-0-0-24.ap-northeast-1.compute.internal sudo[30815]: pam_unix(sudo:session): session opened for user root by ec2-user(uid=0)
25
+ Aug 28 20:28:16 ip-10-0-0-24.ap-northeast-1.compute.internal systemd[1]: Starting MySQL Server...
26
+ -- Subject: Unit mysqld.service has begun start-up
27
+ -- Defined-By: systemd
28
+ -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
29
+ --
30
+ -- Unit mysqld.service has begun starting up.
31
+ Aug 28 20:28:18 ip-10-0-0-24.ap-northeast-1.compute.internal systemd[1]: mysqld.service: main process exited, code=exited, status=1/FAILURE
32
+ Aug 28 20:28:18 ip-10-0-0-24.ap-northeast-1.compute.internal systemd[1]: Failed to start MySQL Server.
33
+ -- Subject: Unit mysqld.service has failed
34
+ -- Defined-By: systemd
35
+ -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
36
+ --
37
+ -- Unit mysqld.service has failed.
38
+ --
39
+ -- The result is failed.
40
+ Aug 28 20:28:18 ip-10-0-0-24.ap-northeast-1.compute.internal systemd[1]: Unit mysqld.service entered failed state.
41
+ Aug 28 20:28:18 ip-10-0-0-24.ap-northeast-1.compute.internal systemd[1]: mysqld.service failed.
42
+ Aug 28 20:28:18 ip-10-0-0-24.ap-northeast-1.compute.internal sudo[30815]: pam_unix(sudo:session): session closed for user root
43
+ ```
44
+
45
+ ```command
46
+ [ec2-user@ip-10-0-0-24 ~]$ systemctl status mysqld.service
47
+ ● mysqld.service - MySQL Server
48
+ Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
49
+ Active: failed (Result: exit-code) since Sat 2021-08-28 20:28:18 UTC; 57min ago
50
+ Docs: man:mysqld(8)
51
+ http://dev.mysql.com/doc/refman/en/using-systemd.html
52
+ Process: 30852 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS (code=exited, status=1/FAILURE)
53
+ Process: 30829 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
54
+ Main PID: 30852 (code=exited, status=1/FAILURE)
55
+ Status: "Server startup in progress"
56
+
57
+ Aug 28 20:28:16 ip-10-0-0-24.ap-northeast-1.compute.internal systemd[1]: Starting MySQL Server...
58
+ Aug 28 20:28:18 ip-10-0-0-24.ap-northeast-1.compute.internal systemd[1]: mysqld.service: main process exited, code=exited, status=1/FAILURE
59
+ Aug 28 20:28:18 ip-10-0-0-24.ap-northeast-1.compute.internal systemd[1]: Failed to start MySQL Server.
60
+ Aug 28 20:28:18 ip-10-0-0-24.ap-northeast-1.compute.internal systemd[1]: Unit mysqld.service entered failed state.
61
+ Aug 28 20:28:18 ip-10-0-0-24.ap-northeast-1.compute.internal systemd[1]: mysqld.service failed.
62
+ ```