質問編集履歴
4
情報の更新
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -20,27 +20,27 @@
|
|
|
20
20
|
|
|
21
21
|
|
|
22
22
|
|
|
23
|
-
180719 1
|
|
23
|
+
180719 15:10:30 [Note] Plugin 'FEDERATED' is disabled.
|
|
24
24
|
|
|
25
|
-
180719 1
|
|
25
|
+
180719 15:10:30 InnoDB: The InnoDB memory heap is disabled
|
|
26
26
|
|
|
27
|
-
180719 1
|
|
27
|
+
180719 15:10:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
|
28
28
|
|
|
29
|
-
180719 1
|
|
29
|
+
180719 15:10:30 InnoDB: Compressed tables use zlib 1.2.8
|
|
30
30
|
|
|
31
|
-
180719 1
|
|
31
|
+
180719 15:10:30 InnoDB: Using Linux native AIO
|
|
32
32
|
|
|
33
|
-
180719 1
|
|
33
|
+
180719 15:10:30 InnoDB: Initializing buffer pool, size = 128.0M
|
|
34
34
|
|
|
35
|
-
180719 1
|
|
35
|
+
180719 15:10:30 InnoDB: Completed initialization of buffer pool
|
|
36
36
|
|
|
37
|
-
180719 1
|
|
37
|
+
180719 15:10:30 InnoDB: highest supported file format is Barracuda.
|
|
38
38
|
|
|
39
39
|
InnoDB: The log sequence number in ibdata files does not match
|
|
40
40
|
|
|
41
41
|
InnoDB: the log sequence number in the ib_logfiles!
|
|
42
42
|
|
|
43
|
-
180719 1
|
|
43
|
+
180719 15:10:30 InnoDB: Database was not shut down normally!
|
|
44
44
|
|
|
45
45
|
InnoDB: Starting crash recovery.
|
|
46
46
|
|
|
@@ -50,17 +50,19 @@
|
|
|
50
50
|
|
|
51
51
|
InnoDB: buffer...
|
|
52
52
|
|
|
53
|
-
180719 1
|
|
53
|
+
180719 15:10:30 InnoDB: Waiting for the background threads to start
|
|
54
54
|
|
|
55
|
-
180719 1
|
|
55
|
+
180719 15:10:31 InnoDB: 5.5.60 started; log sequence number 1626124
|
|
56
56
|
|
|
57
|
-
180719 1
|
|
57
|
+
180719 15:10:31 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
|
|
58
58
|
|
|
59
|
-
180719 1
|
|
59
|
+
180719 15:10:31 [Note] - '0.0.0.0' resolves to '0.0.0.0';
|
|
60
60
|
|
|
61
|
-
180719 1
|
|
61
|
+
180719 15:10:31 [Note] Server socket created on IP: '0.0.0.0'.
|
|
62
62
|
|
|
63
|
+
180719 15:10:31 [ERROR] /usr/libexec/mysql55/mysqld: Incorrect information in file: './mysql/proxies_priv.frm'
|
|
64
|
+
|
|
63
|
-
180719 1
|
|
65
|
+
180719 15:10:31 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect information in file: './mysql/proxies_priv.frm'
|
|
64
66
|
|
|
65
67
|
|
|
66
68
|
|
3
情報の更新
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -20,35 +20,47 @@
|
|
|
20
20
|
|
|
21
21
|
|
|
22
22
|
|
|
23
|
-
180719 14:
|
|
23
|
+
180719 14:55:50 [Note] Plugin 'FEDERATED' is disabled.
|
|
24
24
|
|
|
25
|
-
180719 14:
|
|
25
|
+
180719 14:55:50 InnoDB: The InnoDB memory heap is disabled
|
|
26
26
|
|
|
27
|
-
180719 14:
|
|
27
|
+
180719 14:55:50 InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
|
28
28
|
|
|
29
|
-
180719 14:
|
|
29
|
+
180719 14:55:50 InnoDB: Compressed tables use zlib 1.2.8
|
|
30
30
|
|
|
31
|
-
180719 14:
|
|
31
|
+
180719 14:55:50 InnoDB: Using Linux native AIO
|
|
32
32
|
|
|
33
|
-
180719 14:
|
|
33
|
+
180719 14:55:50 InnoDB: Initializing buffer pool, size = 128.0M
|
|
34
34
|
|
|
35
|
-
180719 14:
|
|
35
|
+
180719 14:55:50 InnoDB: Completed initialization of buffer pool
|
|
36
36
|
|
|
37
|
-
InnoDB:
|
|
37
|
+
180719 14:55:50 InnoDB: highest supported file format is Barracuda.
|
|
38
38
|
|
|
39
|
-
InnoDB:
|
|
39
|
+
InnoDB: The log sequence number in ibdata files does not match
|
|
40
40
|
|
|
41
|
-
|
|
41
|
+
InnoDB: the log sequence number in the ib_logfiles!
|
|
42
42
|
|
|
43
|
-
180719 14:
|
|
43
|
+
180719 14:55:50 InnoDB: Database was not shut down normally!
|
|
44
44
|
|
|
45
|
-
|
|
45
|
+
InnoDB: Starting crash recovery.
|
|
46
46
|
|
|
47
|
-
|
|
47
|
+
InnoDB: Reading tablespace information from the .ibd files...
|
|
48
48
|
|
|
49
|
+
InnoDB: Restoring possible half-written data pages from the doublewrite
|
|
49
50
|
|
|
51
|
+
InnoDB: buffer...
|
|
50
52
|
|
|
53
|
+
180719 14:55:50 InnoDB: Waiting for the background threads to start
|
|
54
|
+
|
|
55
|
+
180719 14:55:51 InnoDB: 5.5.60 started; log sequence number 1626124
|
|
56
|
+
|
|
57
|
+
180719 14:55:51 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
|
|
58
|
+
|
|
51
|
-
180719 14:
|
|
59
|
+
180719 14:55:51 [Note] - '0.0.0.0' resolves to '0.0.0.0';
|
|
60
|
+
|
|
61
|
+
180719 14:55:51 [Note] Server socket created on IP: '0.0.0.0'.
|
|
62
|
+
|
|
63
|
+
180719 14:55:51 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
|
|
52
64
|
|
|
53
65
|
|
|
54
66
|
|
2
情報の編集
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -20,49 +20,35 @@
|
|
|
20
20
|
|
|
21
21
|
|
|
22
22
|
|
|
23
|
-
|
|
23
|
+
180719 14:42:50 [Note] Plugin 'FEDERATED' is disabled.
|
|
24
24
|
|
|
25
|
+
180719 14:42:50 InnoDB: The InnoDB memory heap is disabled
|
|
26
|
+
|
|
27
|
+
180719 14:42:50 InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
|
28
|
+
|
|
29
|
+
180719 14:42:50 InnoDB: Compressed tables use zlib 1.2.8
|
|
30
|
+
|
|
31
|
+
180719 14:42:50 InnoDB: Using Linux native AIO
|
|
32
|
+
|
|
33
|
+
180719 14:42:50 InnoDB: Initializing buffer pool, size = 128.0M
|
|
34
|
+
|
|
35
|
+
180719 14:42:50 InnoDB: Completed initialization of buffer pool
|
|
36
|
+
|
|
37
|
+
InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
|
|
38
|
+
|
|
25
|
-
InnoDB:
|
|
39
|
+
InnoDB: than specified in the .cnf file 0 5242880 bytes!
|
|
40
|
+
|
|
41
|
+
180719 14:42:50 [ERROR] Plugin 'InnoDB' init function returned error.
|
|
42
|
+
|
|
43
|
+
180719 14:42:50 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
|
|
44
|
+
|
|
45
|
+
180719 14:42:50 [ERROR] Unknown/unsupported storage engine: InnoDB
|
|
46
|
+
|
|
47
|
+
180719 14:42:50 [ERROR] Aborting
|
|
26
48
|
|
|
27
49
|
|
|
28
50
|
|
|
29
|
-
180719 14:19:54 InnoDB: Unable to open the first data file
|
|
30
|
-
|
|
31
|
-
InnoDB: Error in opening ./ibdata1
|
|
32
|
-
|
|
33
|
-
180719 14:19:54 InnoDB: Operating system error number 11 in a file operation.
|
|
34
|
-
|
|
35
|
-
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
|
|
36
|
-
|
|
37
|
-
InnoDB: Some operating system error numbers are described at
|
|
38
|
-
|
|
39
|
-
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html
|
|
40
|
-
|
|
41
|
-
180719 14:19:54 InnoDB: Could not open or create data files.
|
|
42
|
-
|
|
43
|
-
180719 14:19:54 InnoDB: If you tried to add new data files, and it failed here,
|
|
44
|
-
|
|
45
|
-
180719 14:19:54 InnoDB: you should now edit innodb_data_file_path in my.cnf back
|
|
46
|
-
|
|
47
|
-
180719 14:19:54 InnoDB: to what it was, and remove the new ibdata files InnoDB created
|
|
48
|
-
|
|
49
|
-
180719 14:19:54 InnoDB: in this failed attempt. InnoDB only wrote those files full of
|
|
50
|
-
|
|
51
|
-
180719 14:19:54 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
|
|
52
|
-
|
|
53
|
-
180719 14:19:54 InnoDB: remove old data files which contain your precious data!
|
|
54
|
-
|
|
55
|
-
180719 14:19:54 [ERROR] Plugin 'InnoDB' init function returned error.
|
|
56
|
-
|
|
57
|
-
180719 14:19:54 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
|
|
58
|
-
|
|
59
|
-
180719 14:19:54 [ERROR] Unknown/unsupported storage engine: InnoDB
|
|
60
|
-
|
|
61
|
-
180719 14:19:54 [ERROR] Aborting
|
|
62
|
-
|
|
63
|
-
|
|
64
|
-
|
|
65
|
-
180719 14:
|
|
51
|
+
180719 14:42:50 [Note] /usr/libexec/mysql55/mysqld: Shutdown complete
|
|
66
52
|
|
|
67
53
|
|
|
68
54
|
|
1
情報の追記
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -17,6 +17,12 @@
|
|
|
17
17
|
```ここに言語名を入力
|
|
18
18
|
|
|
19
19
|
#sudo cat /var/log/mysqld.log
|
|
20
|
+
|
|
21
|
+
|
|
22
|
+
|
|
23
|
+
InnoDB: Check that you do not already have another mysqld process
|
|
24
|
+
|
|
25
|
+
InnoDB: using the same InnoDB data or log files.
|
|
20
26
|
|
|
21
27
|
|
|
22
28
|
|