質問編集履歴
1
mysqld.logエラー全文やmy.cnfを更新
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -5,24 +5,81 @@
|
|
|
5
5
|
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/mac名.pid).
|
|
6
6
|
```
|
|
7
7
|
|
|
8
|
-
/
|
|
8
|
+
/var/log/mysqld.log/mysqld.log でログを確認しましたが、特に原因になるようなものは見つからず。。。
|
|
9
9
|
```
|
|
10
|
-
2018-10-
|
|
10
|
+
2018-10-11T10:44:13.6NZ mysqld_safe Logging to '/var/log/mysqld.log'.
|
|
11
|
-
2018-10-
|
|
11
|
+
2018-10-11T10:44:13.6NZ mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
|
|
12
|
-
2018-10-
|
|
12
|
+
2018-10-11T10:44:13.355504Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
|
|
13
|
-
2018-10-
|
|
13
|
+
2018-10-11T10:44:13.356074Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
|
|
14
|
-
2018-10-
|
|
14
|
+
2018-10-11T10:44:13.356148Z 0 [Note] /usr/local/Cellar/mysql@5.7/5.7.23/bin/mysqld (mysqld 5.7.23) starting as process 9404 ...
|
|
15
|
-
2018-10-
|
|
15
|
+
2018-10-11T10:44:13.359806Z 0 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
|
|
16
|
-
2018-10-
|
|
16
|
+
2018-10-11T10:44:13.362055Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
|
17
|
-
2018-10-
|
|
17
|
+
2018-10-11T10:44:13.362144Z 0 [Note] InnoDB: Uses event mutexes
|
|
18
|
-
2018-10-
|
|
18
|
+
2018-10-11T10:44:13.362354Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
|
|
19
|
-
2018-10-
|
|
19
|
+
2018-10-11T10:44:13.362414Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
|
|
20
|
-
2018-10-
|
|
20
|
+
2018-10-11T10:44:13.362898Z 0 [Note] InnoDB: Number of pools: 1
|
|
21
|
-
2018-10-
|
|
21
|
+
2018-10-11T10:44:13.363033Z 0 [Note] InnoDB: Using CPU crc32 instructions
|
|
22
|
-
2018-10-
|
|
22
|
+
2018-10-11T10:44:13.365052Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
|
|
23
|
-
2018-10-
|
|
23
|
+
2018-10-11T10:44:13.383451Z 0 [Note] InnoDB: Completed initialization of buffer pool
|
|
24
|
-
2018-10-
|
|
24
|
+
2018-10-11T10:44:13.402392Z 0 [ERROR] [FATAL] InnoDB: Table flags are 0 in the data dictionary but the flags in file ./ibdata1 are 0x4800!
|
|
25
|
-
2018-10-11
|
|
25
|
+
2018-10-11 19:44:13 0x7fff8f9f5340 InnoDB: Assertion failure in thread 140735602971456 in file ut0ut.cc line 942
|
|
26
|
+
InnoDB: We intentionally generate a memory trap.
|
|
27
|
+
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
|
|
28
|
+
InnoDB: If you get repeated assertion failures or crashes, even
|
|
29
|
+
InnoDB: immediately after the mysqld startup, there may be
|
|
30
|
+
InnoDB: corruption in the InnoDB tablespace. Please refer to
|
|
31
|
+
InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html
|
|
32
|
+
InnoDB: about forcing recovery.
|
|
33
|
+
10:44:13 UTC - mysqld got signal 6 ;
|
|
34
|
+
This could be because you hit a bug. It is also possible that this binary
|
|
35
|
+
or one of the libraries it was linked against is corrupt, improperly built,
|
|
36
|
+
or misconfigured. This error can also be caused by malfunctioning hardware.
|
|
37
|
+
Attempting to collect some information that could help diagnose the problem.
|
|
38
|
+
As this is a crash and something is definitely wrong, the information
|
|
39
|
+
collection process might fail.
|
|
40
|
+
|
|
41
|
+
key_buffer_size=8388608
|
|
42
|
+
read_buffer_size=131072
|
|
43
|
+
max_used_connections=0
|
|
44
|
+
max_threads=151
|
|
45
|
+
thread_count=0
|
|
46
|
+
connection_count=0
|
|
47
|
+
It is possible that mysqld could use up to
|
|
48
|
+
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 68220 K bytes of memory
|
|
49
|
+
Hope that's ok; if not, decrease some variables in the equation.
|
|
50
|
+
|
|
51
|
+
Thread pointer: 0x0
|
|
52
|
+
Attempting backtrace. You can use the following information to find out
|
|
53
|
+
where mysqld died. If you see no messages after this, something went
|
|
54
|
+
terribly wrong...
|
|
55
|
+
stack_bottom = 0 thread_stack 0x40000
|
|
56
|
+
0 mysqld 0x00000001010e2d8e my_print_stacktrace + 58
|
|
57
|
+
1 mysqld 0x00000001010620b9 handle_fatal_signal + 700
|
|
58
|
+
2 libsystem_platform.dylib 0x00007fff56c32f5a _sigtramp + 26
|
|
59
|
+
3 mysqld 0x000000010192b32d _ZZL18innodb_show_statusP10handlertonP3THDPFbS2_PKcmS4_mS4_mEE13truncated_msg + 123453
|
|
60
|
+
4 libsystem_c.dylib 0x00007fff56a5d312 abort + 127
|
|
61
|
+
5 mysqld 0x00000001012d1019 _Z23ut_dbg_assertion_failedPKcS0_m + 161
|
|
62
|
+
6 mysqld 0x00000001012d3aea _ZN2ib5fatalD2Ev + 88
|
|
63
|
+
7 mysqld 0x00000001012d3b23 _ZN2ib5fatalD1Ev + 9
|
|
64
|
+
8 mysqld 0x000000010117bc6b _ZL18fil_node_open_fileP10fil_node_t + 2446
|
|
65
|
+
9 mysqld 0x00000001011853e7 _ZL23fil_node_prepare_for_ioP10fil_node_tP12fil_system_tP11fil_space_t + 191
|
|
66
|
+
10 mysqld 0x0000000101185acb _Z6fil_ioRK9IORequestbRK9page_id_tRK11page_size_tmmPvS8_ + 794
|
|
67
|
+
11 mysqld 0x000000010114c186 _ZL17buf_read_page_lowP7dberr_tbmmRK9page_id_tRK11page_size_tb + 384
|
|
68
|
+
12 mysqld 0x000000010114c2d6 _Z13buf_read_pageRK9page_id_tRK11page_size_t + 59
|
|
69
|
+
13 mysqld 0x00000001011381c8 _Z16buf_page_get_genRK9page_id_tRK11page_size_tmP11buf_block_tmPKcmP5mtr_tb + 953
|
|
70
|
+
14 mysqld 0x00000001012c0bf7 _Z31trx_rseg_get_n_undo_tablespacesPm + 262
|
|
71
|
+
15 mysqld 0x00000001012a487a _Z34innobase_start_or_create_for_mysqlv + 7007
|
|
72
|
+
16 mysqld 0x00000001011d5b7f _ZL13innobase_initPv + 3700
|
|
73
|
+
17 mysqld 0x0000000100b4836b _Z24ha_initialize_handlertonP13st_plugin_int + 79
|
|
74
|
+
18 mysqld 0x0000000100fb3503 _ZL17plugin_initializeP13st_plugin_int + 79
|
|
75
|
+
19 mysqld 0x0000000100fb300b _Z40plugin_register_builtin_and_init_core_sePiPPc + 653
|
|
76
|
+
20 mysqld 0x0000000101057b36 _Z11mysqld_mainiPPc + 2929
|
|
77
|
+
21 libdyld.dylib 0x00007fff569b1115 start + 1
|
|
78
|
+
22 ??? 0x0000000000000007 0x0 + 7
|
|
79
|
+
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
|
|
80
|
+
information that should help you find out what is causing the crash.
|
|
81
|
+
2018-10-11T10:44:13.6NZ mysqld_safe mysqld from pid file /usr/local/var/mysql/mac名 ended
|
|
82
|
+
|
|
26
83
|
```
|
|
27
84
|
|
|
28
85
|
/usr/local/etc/my.cnf
|
|
@@ -33,6 +90,9 @@
|
|
|
33
90
|
bind-address = 127.0.0.1
|
|
34
91
|
secure-file-priv = ""
|
|
35
92
|
socket = /tmp/mysql.sock
|
|
93
|
+
|
|
94
|
+
# エラーログ
|
|
95
|
+
log-error=/var/log/mysqld.log
|
|
36
96
|
```
|
|
37
97
|
|
|
38
98
|
以下のことは試しましたが、起動できません。
|