linux一键安装包
37040

MySQL无法启动已解决 悬赏6积分

提问者祁顺志 答案数3 阅读数1368 发表时间2020-03-17 16:58:20

2018-04-08 17:31:16 140518391293760 [Note] InnoDB: Using mutexes to ref count buffer pool pages


2018-04-08 17:31:16 140518391293760 [Note] InnoDB: The InnoDB memory heap is disabled


2018-04-08 17:31:16 140518391293760 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins


2018-04-08 17:31:16 140518391293760 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier


2018-04-08 17:31:16 140518391293760 [Note] InnoDB: Compressed tables use zlib 1.2.3.4


2018-04-08 17:31:16 140518391293760 [Note] InnoDB: Using generic crc32 instructions


2018-04-08 17:31:16 140518391293760 [Note] InnoDB: Initializing buffer pool, size = 128.0M


2018-04-08 17:31:16 140518391293760 [Note] InnoDB: Completed initialization of buffer pool


2018-04-08 17:31:17 140518391293760 [Note] InnoDB: Highest supported file format is Barracuda.


2018-04-08 17:31:17 140518391293760 [Note] InnoDB: 128 rollback segment(s) are active.


2018-04-08 17:31:17 140518391293760 [Note] InnoDB: Waiting for purge to start


禅道版本:12.1

安装包类型:Linux安装包

操作系统:Windows 7

客户端浏览器:Chrome

设置备注
内容
答案列表
2020-03-17 17:31:33

日志时间都是18年的
看下有没有最近日期的日志。
另外服务器具体是什么系统?系统具体的版本号是多少?

2020/03/17
这就是最新的服务器时间不对,阿里云服务器
2020-03-17 17:31:56

可以联系下官网顶部的商务QQ,邀请加入技术交流群,将日志文件发我们下,方便确认问题。

2020/03/17
2018-04-08 17:31:16 140518391293760 [Note] InnoDB: Using mutexes to ref count buffer pool pages

2018-04-08 17:31:16 140518391293760 [Note] InnoDB: The InnoDB memory heap is disabled

2018-04-08 17:31:16 140518391293760 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2018-04-08 17:31:16 140518391293760 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier

2018-04-08 17:31:16 140518391293760 [Note] InnoDB: Compressed tables use zlib 1.2.3.4

2018-04-08 17:31:16 140518391293760 [Note] InnoDB: Using generic crc32 instructions

2018-04-08 17:31:16 140518391293760 [Note] InnoDB: Initializing buffer pool, size = 128.0M

2018-04-08 17:31:16 140518391293760 [Note] InnoDB: Completed initialization of buffer pool

2018-04-08 17:31:17 140518391293760 [Note] InnoDB: Highest supported file format is Barracuda.

2018-04-08 17:31:17 140518391293760 [Note] InnoDB: 128 rollback segment(s) are active.

2018-04-08 17:31:17 140518391293760 [Note] InnoDB: Waiting for purge to start

2018-04-08 17:31:17 140518391293760 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1600829
2018-04-08 17:31:17 140517927745280 [Note] InnoDB: Dumping buffer pool(s) not yet started
2018-04-08 17:31:17 140518391293760 [Note] Plugin 'FEEDBACK' is disabled.
2018-04-08 17:31:17 140518391293760 [Note] Server socket created on IP: '127.0.0.1'.
2018-04-08 17:31:17 140517992728320 [Warning] InnoDB: Cannot open table mysql/gtid_slave_pos from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2018-04-08 17:31:17 140517992728320 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1932: Table 'mysql.gtid_slave_pos' doesn't exist in engine
2018-04-08 17:31:17 140518391293760 [Note] /opt/zbox/run/mysql/mysqld: ready for connections.
Version: '10.1.22-MariaDB' socket: '/opt/zbox/tmp/mysql/mysql.sock' port: 3307 Source distribution

2018-04-08 18:09:05 140517992126208 [Note] /opt/zbox/run/mysql/mysqld: Normal shutdown

2018-04-08 18:09:05 140517992126208 [Note] Event Scheduler: Purging the queue. 0 events
2018-04-08 18:09:06 140517841041152 [Note] InnoDB: FTS optimize thread exiting.
2018-04-08 18:09:06 140517992126208 [Note] InnoDB: Starting shutdown...
2018-04-08 18:09:06 140517992126208 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2018-04-08 18:09:08 140517992126208 [Note] InnoDB: Shutdown completed; log sequence number 1600839
2018-04-08 18:09:08 140517992126208 [Note] /opt/zbox/run/mysql/mysqld: Shutdown complete

2018-04-13 10:30:55 140504566159168 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-04-13 10:30:55 140504566159168 [Note] InnoDB: The InnoDB memory heap is disabled
2018-04-13 10:30:55 140504566159168 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-04-13 10:30:55 140504566159168
[Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2018-04-13 10:30:55 140504566159168 [Note] InnoDB: Compressed tables use zlib 1.2.3.4
2018-04-13 10:30:55 140504566159168 [Note] InnoDB: Using generic crc32 instructions
2018-04-13 10:30:55 140504566159168 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-04-13 10:30:55 140504566159168 [Note] InnoDB: Completed initialization of buffer pool
2018-04-13 10:30:55 140504566159168 [Note] InnoDB: Highest supported file format is Barracuda.
2018-04-13 10:30:55 140504566159168 [Note] InnoDB: 128 rollback segment(s) are active.
2018-04-13 10:30:55 140504566159168 [Note] InnoDB: Waiting for purge to start
2018-04-13 10:30:55 140504566159168 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1600839
2018-04-13 10:30:55 140504101189376 [Note] InnoDB: Dumping buffer pool(s) not yet started
2018-04-13 10:30:55 140504566159168 [Note] Plugin 'FEEDBACK' is disabled.
2018-04-13 10:30:55 140504566159168 [Note] Server socket created on IP: '127.0.0.1'.
2018-04-13 10:30:55 140504566159168 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in use
2018-04-13 10:30:55 140504566159168 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2018-04-13 10:30:55 140504566159168 [ERROR] Aborting

2020-03-17 11:59:13 139972984727360 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-03-17 11:59:13 139972984727360 [Note] InnoDB: The InnoDB memory heap is disabled
2020-03-17 11:59:13 139972984727360 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-03-17 11:59:13 139972984727360 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2020-03-17 11:59:13 139972984727360 [Note] InnoDB: Compressed tables use zlib 1.2.3.4
2020-03-17 11:59:13 139972984727360 [Note] InnoDB: Using SSE crc32 instructions
2020-03-17 11:59:13 139972984727360 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-03-17 11:59:13 139972984727360 [Note] InnoDB: Completed initialization of buffer pool
2020-03-17 11:59:13 139972984727360 [Note] InnoDB: Highest supported file format is Barracuda.
2020-03-17 11:59:14 139972984727360 [Note] InnoDB: 128 rollback segment(s) are active.
2020-03-17 11:59:14 139972984727360 [Note] InnoDB: Waiting for purge to start
2020-03-17 11:59:14 139972984727360 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1600849
2020-03-17 11:59:14 139972525577984 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-03-17 11:59:14 139972984727360 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-17 11:59:14 139972984727360 [Note] Server socket created on IP: '127.0.0.1'.
2020-03-17 11:59:14 139972917901056 [Warning] InnoDB: Cannot open table mysql/gtid_slave_pos from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2020-03-17 11:59:14 139972917901056 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1932: Table 'mysql.gtid_slave_pos' doesn't exist in engine
2020-03-17 11:59:14 139972984727360 [Note] /opt/zbox/run/mysql/mysqld: ready for connections.
Version: '10.1.22-MariaDB' socket: '/opt/zbox/tmp/mysql/mysql.sock' port: 8089 Source distribution
2020-03-17 15:04:17 139972917700352 [Note] /opt/zbox/run/mysql/mysqld: Normal shutdown

2020-03-17 15:04:17 139972917700352 [Note] Event Scheduler: Purging the queue. 0 events
2020-03-17 15:04:17 139972438910720 [Note] InnoDB: FTS optimize thread exiting.
2020-03-17 15:04:17 139972917700352 [Note] InnoDB: Starting shutdown...
2020-03-17 15:04:17 139972917700352 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2020-03-17 15:04:18 139972917700352 [Note] InnoDB: Shutdown completed; log sequence number 1600859
2020-03-17 15:04:18 139972917700352 [Note] /opt/zbox/run/mysql/mysqld: Shutdown complete

2020-03-17 15:04:35 140071518734144 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-03-17 15:04:35 140071518734144 [Note] InnoDB: The InnoDB memory heap is disabled
2020-03-17 15:04:35 140071518734144 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-03-17 15:04:35 140071518734144 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2020-03-17 15:04:35 140071518734144 [Note] InnoDB: Compressed tables use zlib 1.2.3.4
2020-03-17 15:04:35 140071518734144 [Note] InnoDB: Using SSE crc32 instructions
2020-03-17 15:04:35 140071518734144 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-03-17 15:04:35 140071518734144 [Note] InnoDB: Completed initialization of buffer pool
2020-03-17 15:04:35 140071518734144 [Note] InnoDB: Highest supported file format is Barracuda.
2020-03-17 15:04:35 140071518734144 [Note] InnoDB: 128 rollback segment(s) are active.
2020-03-17 15:04:35 140071518734144 [Note] InnoDB: Waiting for purge to start
2020-03-17 15:04:35 140071518734144 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1600859
2020-03-17 15:04:35 140071059302144 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-03-17 15:04:35 140071518734144 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-17 15:04:35 140071518734144 [Note] Server socket created on IP: '127.0.0.1'.
2020-03-17 15:04:35 140071433996032 [Warning] InnoDB: Cannot open table mysql/gtid_slave_pos from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2020-03-17 15:04:35 140071433996032 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1932: Table 'mysql.gtid_slave_pos' doesn't exist in engine
2020-03-17 15:04:35 140071518734144 [Note] /opt/zbox/run/mysql/mysqld: ready for connections.
Version: '10.1.22-MariaDB' socket: '/opt/zbox/tmp/mysql/mysql.sock' port: 8089 Source distribution
2020-03-17 15:12:12 140071433795328 [Note] /opt/zbox/run/mysql/mysqld: Normal shutdown

2020-03-17 15:12:12 140071433795328 [Note] Event Scheduler: Purging the queue. 0 events
2020-03-17 15:12:12 140071042516736 [Note] InnoDB: FTS optimize thread exiting.
2020-03-17 15:12:12 140071433795328 [Note] InnoDB: Starting shutdown...
2020-03-17 15:12:13 140071433795328 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2020-03-17 15:12:14 140071433795328 [Note] InnoDB: Shutdown completed; log sequence number 1600869
2020-03-17 15:12:14 140071433795328 [Note] /opt/zbox/run/mysql/mysqld: Shutdown complete

2020-03-17 15:13:42 140614707337024 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-03-17 15:13:42 140614707337024 [Note] InnoDB: The InnoDB memory heap is disabled
2020-03-17 15:13:42 140614707337024 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-03-17 15:13:42 140614707337024 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2020-03-17 15:13:42 140614707337024 [Note] InnoDB: Compressed tables use zlib 1.2.3.4
2020-03-17 15:13:42 140614707337024 [Note] InnoDB: Using SSE crc32 instructions
2020-03-17 15:13:42 140614707337024 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-03-17 15:13:42 140614707337024 [Note] InnoDB: Completed initialization of buffer pool
2020-03-17 15:13:43 140614707337024 [Note] InnoDB: Highest supported file format is Barracuda.
2020-03-17 15:13:43 140614707337024 [Note] InnoDB: 128 rollback segment(s) are active.
2020-03-17 15:13:43 140614707337024 [Note] InnoDB: Waiting for purge to start
2020-03-17 15:13:43 140614707337024 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1600869
2020-03-17 15:13:43 140614175799040 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-03-17 15:13:43 140614707337024 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-17 15:13:43 140614707337024 [Note] Server socket created on IP: '127.0.0.1'.
2020-03-17 15:13:43 140614614763264 [Warning] InnoDB: Cannot open table mysql/gtid_slave_pos from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2020-03-17 15:13:43 140614614763264 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1932: Table 'mysql.gtid_slave_pos' doesn't exist in engine
2020-03-17 15:13:43 140614707337024 [Note] /opt/zbox/run/mysql/mysqld: ready for connections.
Version: '10.1.22-MariaDB' socket: '/opt/zbox/tmp/mysql/mysql.sock' port: 8089 Source distribution
2020-03-17 15:16:34 140614614562560 [Note] /opt/zbox/run/mysql/mysqld: Normal shutdown

2020-03-17 15:16:34 140614614562560 [Note] Event Scheduler: Purging the queue. 0 events
2020-03-17 15:16:34 140614024795904 [Note] InnoDB: FTS optimize thread exiting.
2020-03-17 15:16:34 140614614562560 [Note] InnoDB: Starting shutdown...
2020-03-17 15:16:35 140614614562560 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2020-03-17 15:16:36 140614614562560 [Note] InnoDB: Shutdown completed; log sequence number 1600879
2020-03-17 15:16:36 140614614562560 [Note] /opt/zbox/run/mysql/mysqld: Shutdown complete

2020-03-17 15:19:55 140357864699712 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-03-17 15:19:55 140357864699712 [Note] InnoDB: The InnoDB memory heap is disabled
2020-03-17 15:19:55 140357864699712 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-03-17 15:19:55 140357864699712 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2020-03-17 15:19:55 140357864699712 [Note] InnoDB: Compressed tables use zlib 1.2.3.4
2020-03-17 15:19:55 140357864699712 [Note] InnoDB: Using SSE crc32 instructions
2020-03-17 15:19:55 140357864699712 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-03-17 15:19:55 140357864699712 [Note] InnoDB: Completed initialization of buffer pool
2020-03-17 15:19:55 140357864699712 [Note] InnoDB: Highest supported file format is Barracuda.
2020-03-17 15:19:55 140357864699712 [Note] InnoDB: 128 rollback segment(s) are active.
2020-03-17 15:19:55 140357864699712 [Note] InnoDB: Waiting for purge to start
2020-03-17 15:19:55 140357864699712 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1600879
2020-03-17 15:19:55 140357414803200 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-03-17 15:19:55 140357864699712 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-17 15:19:55 140357864699712 [Note] Server socket created on IP: '127.0.0.1'.
2020-03-17 15:19:55 140357471393536 [Warning] InnoDB: Cannot open table mysql/gtid_slave_pos from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2020-03-17 15:19:55 140357471393536 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1932: Table 'mysql.gtid_slave_pos' doesn't exist in engine
2020-03-17 15:19:55 140357864699712 [Note] /opt/zbox/run/mysql/mysqld: ready for connections.
Version: '10.1.22-MariaDB' socket: '/opt/zbox/tmp/mysql/mysql.sock' port: 8089 Source distribution
2020-03-17 15:20:10 140357471192832 [Note] /opt/zbox/run/mysql/mysqld: Normal shutdown

2020-03-17 15:20:10 140357471192832 [Note] Event Scheduler: Purging the queue. 0 events
2020-03-17 15:20:10 140357398017792 [Note] InnoDB: FTS optimize thread exiting.
2020-03-17 15:20:10 140357471192832 [Note] InnoDB: Starting shutdown...
2020-03-17 15:20:11 140357471192832 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2020-03-17 15:20:12 140357471192832 [Note] InnoDB: Shutdown completed; log sequence number 1600889
2020-03-17 15:20:12 140357471192832 [Note] /opt/zbox/run/mysql/mysqld: Shutdown complete

2020-03-17 15:28:17 140166587750208 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-03-17 15:28:17 140166587750208 [Note] InnoDB: The InnoDB memory heap is disabled
2020-03-17 15:28:17 140166587750208 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-03-17 15:28:17 140166587750208 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2020-03-17 15:28:17 140166587750208 [Note] InnoDB: Compressed tables use zlib 1.2.3.4
2020-03-17 15:28:17 140166587750208 [Note] InnoDB: Using SSE crc32 instructions
2020-03-17 15:28:17 140166587750208 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-03-17 15:28:17 140166587750208 [Note] InnoDB: Completed initialization of buffer pool
2020-03-17 15:28:17 140166587750208 [Note] InnoDB: Highest supported file format is Barracuda.
2020-03-17 15:28:17 140166587750208 [Note] InnoDB: 128 rollback segment(s) are active.
2020-03-17 15:28:17 140166587750208 [Note] InnoDB: Waiting for purge to start
2020-03-17 15:28:17 140166587750208 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1600889
2020-03-17 15:28:17 140166056376064 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-03-17 15:28:17 140166587750208 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-17 15:28:17 140166587750208 [Note] Server socket created on IP: '127.0.0.1'.
2020-03-17 15:28:17 140166194550528 [Warning] InnoDB: Cannot open table mysql/gtid_slave_pos from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2020-03-17 15:28:17 140166194550528 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1932: Table 'mysql.gtid_slave_pos' doesn't exist in engine
2020-03-17 15:28:17 140166587750208 [Note] /opt/zbox/run/mysql/mysqld: ready for connections.
Version: '10.1.22-MariaDB' socket: '/opt/zbox/tmp/mysql/mysql.sock' port: 8089 Source distribution
2020-03-17 15:30:47 140166194349824 [Note] /opt/zbox/run/mysql/mysqld: Normal shutdown

2020-03-17 15:30:47 140166194349824 [Note] Event Scheduler: Purging the queue. 0 events
2020-03-17 15:30:47 140166039590656 [Note] InnoDB: FTS optimize thread exiting.
2020-03-17 15:30:47 140166194349824 [Note] InnoDB: Starting shutdown...
2020-03-17 15:30:47 140166194349824 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2020-03-17 15:30:48 140166194349824 [Note] InnoDB: Shutdown completed; log sequence number 1600899
2020-03-17 15:30:48 140166194349824 [Note] /opt/zbox/run/mysql/mysqld: Shutdown complete

2020-03-17 15:41:14 140389166225216 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-03-17 15:41:14 140389166225216 [Note] InnoDB: The InnoDB memory heap is disabled
2020-03-17 15:41:14 140389166225216 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-03-17 15:41:14 140389166225216 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2020-03-17 15:41:14 140389166225216 [Note] InnoDB: Compressed tables use zlib 1.2.3.4
2020-03-17 15:41:14 140389166225216 [Note] InnoDB: Using SSE crc32 instructions
2020-03-17 15:41:14 140389166225216 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-03-17 15:41:14 140389166225216 [Note] InnoDB: Completed initialization of buffer pool
2020-03-17 15:41:14 140389166225216 [Note] InnoDB: Highest supported file format is Barracuda.
2020-03-17 15:41:14 140389166225216 [Note] InnoDB: 128 rollback segment(s) are active.
2020-03-17 15:41:14 140389166225216 [Note] InnoDB: Waiting for purge to start
2020-03-17 15:41:14 140389166225216 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1600899
2020-03-17 15:41:14 140388631299840 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-03-17 15:41:14 140389166225216 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-17 15:41:14 140389166225216 [Note] Server socket created on IP: '127.0.0.1'.
2020-03-17 15:41:14 140389065262848 [Warning] InnoDB: Cannot open table mysql/gtid_slave_pos from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2020-03-17 15:41:14 140389065262848 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1932: Table 'mysql.gtid_slave_pos' doesn't exist in engine
2020-03-17 15:41:14 140389166225216 [Note] /opt/zbox/run/mysql/mysqld: ready for connections.
Version: '10.1.22-MariaDB' socket: '/opt/zbox/tmp/mysql/mysql.sock' port: 8089 Source distribution
2020-03-17 15:41:22 140389065062144 [Note] /opt/zbox/run/mysql/mysqld: Normal shutdown

2020-03-17 15:41:22 140389065062144 [Note] Event Scheduler: Purging the queue. 0 events
2020-03-17 15:41:22 140388480296704 [Note] InnoDB: FTS optimize thread exiting.
2020-03-17 15:41:22 140389065062144 [Note] InnoDB: Starting shutdown...
2020-03-17 15:41:23 140389065062144 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2020-03-17 15:41:24 140389065062144 [Note] InnoDB: Shutdown completed; log sequence number 1600909
2020-03-17 15:41:24 140389065062144 [Note] /opt/zbox/run/mysql/mysqld: Shutdown complete

2020-03-17 15:47:10 140455841105728 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-03-17 15:47:10 140455841105728 [Note] InnoDB: The InnoDB memory heap is disabled
2020-03-17 15:47:10 140455841105728 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-03-17 15:47:10 140455841105728 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2020-03-17 15:47:10 140455841105728 [Note] InnoDB: Compressed tables use zlib 1.2.3.4
2020-03-17 15:47:10 140455841105728 [Note] InnoDB: Using SSE crc32 instructions
2020-03-17 15:47:10 140455841105728 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-03-17 15:47:10 140455841105728 [Note] InnoDB: Completed initialization of buffer pool
2020-03-17 15:47:10 140455841105728 [Note] InnoDB: Highest supported file format is Barracuda.
2020-03-17 15:47:10 140455841105728 [Note] InnoDB: 128 rollback segment(s) are active.
2020-03-17 15:47:10 140455841105728 [Note] InnoDB: Waiting for purge to start
2020-03-17 15:47:10 140455841105728 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1600909
2020-03-17 15:47:10 140455382284032 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-03-17 15:47:10 140455841105728 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-17 15:47:10 140455841105728 [Note] Server socket created on IP: '127.0.0.1'.
2020-03-17 15:47:10 140455765849856 [Warning] InnoDB: Cannot open table mysql/gtid_slave_pos from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2020-03-17 15:47:10 140455765849856 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1932: Table 'mysql.gtid_slave_pos' doesn't exist in engine
2020-03-17 15:47:10 140455841105728 [Note] /opt/zbox/run/mysql/mysqld: ready for connections.
Version: '10.1.22-MariaDB' socket: '/opt/zbox/tmp/mysql/mysql.sock' port: 8089 Source distribution
2020-03-17 15:53:51 140455765649152 [Note] /opt/zbox/run/mysql/mysqld: Normal shutdown

2020-03-17 15:53:51 140455765649152 [Note] Event Scheduler: Purging the queue. 0 events
2020-03-17 15:53:51 140455161362176 [Note] InnoDB: FTS optimize thread exiting.
2020-03-17 15:53:51 140455765649152 [Note] InnoDB: Starting shutdown...
2020-03-17 15:53:52 140455765649152 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2020-03-17 15:53:53 140455765649152 [Note] InnoDB: Shutdown completed; log sequence number 1600919
2020-03-17 15:53:53 140455765649152 [Note] /opt/zbox/run/mysql/mysqld: Shutdown complete

2020-03-17 15:54:09 140217341257536 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-03-17 15:54:09 140217341257536 [Note] InnoDB: The InnoDB memory heap is disabled
2020-03-17 15:54:09 140217341257536 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-03-17 15:54:09 140217341257536 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2020-03-17 15:54:09 140217341257536 [Note] InnoDB: Compressed tables use zlib 1.2.3.4
2020-03-17 15:54:09 140217341257536 [Note] InnoDB: Using SSE crc32 instructions
2020-03-17 15:54:09 140217341257536 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-03-17 15:54:09 140217341257536 [Note] InnoDB: Completed initialization of buffer pool
2020-03-17 15:54:09 140217341257536 [Note] InnoDB: Highest supported file format is Barracuda.
2020-03-17 15:54:09 140217341257536 [Note] InnoDB: 128 rollback segment(s) are active.
2020-03-17 15:54:09 140217341257536 [Note] InnoDB: Waiting for purge to start
2020-03-17 15:54:09 140217341257536 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1600919
2020-03-17 15:54:09 140216882665216 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-03-17 15:54:09 140217341257536 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-17 15:54:09 140217341257536 [Note] Server socket created on IP: '127.0.0.1'.
2020-03-17 15:54:09 140217260717824 [Warning] InnoDB: Cannot open table mysql/gtid_slave_pos from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2020-03-17 15:54:09 140217260717824 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1932: Table 'mysql.gtid_slave_pos' doesn't exist in engine
2020-03-17 15:54:09 140217341257536 [Note] /opt/zbox/run/mysql/mysqld: ready for connections.
Version: '10.1.22-MariaDB' socket: '/opt/zbox/tmp/mysql/mysql.sock' port: 8089 Source distribution
2020-03-17 15:58:28 140216947848960 [Note] /opt/zbox/run/mysql/mysqld: Normal shutdown

2020-03-17 15:58:28 140216947848960 [Note] Event Scheduler: Purging the queue. 0 events
2020-03-17 15:58:28 140216790677248 [Note] InnoDB: FTS optimize thread exiting.
2020-03-17 15:58:28 140216947848960 [Note] InnoDB: Starting shutdown...
2020-03-17 15:58:29 140216947848960 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2020-03-17 15:58:30 140216947848960 [Note] InnoDB: Shutdown completed; log sequence number 1600929
2020-03-17 15:58:30 140216947848960 [Note] /opt/zbox/run/mysql/mysqld: Shutdown complete

2020-03-17 15:58:41 140402698639168 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-03-17 15:58:41 140402698639168 [Note] InnoDB: The InnoDB memory heap is disabled
2020-03-17 15:58:41 140402698639168 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-03-17 15:58:41 140402698639168 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2020-03-17 15:58:41 140402698639168 [Note] InnoDB: Compressed tables use zlib 1.2.3.4
2020-03-17 15:58:41 140402698639168 [Note] InnoDB: Using SSE crc32 instructions
2020-03-17 15:58:41 140402698639168 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-03-17 15:58:41 140402698639168 [Note] InnoDB: Completed initialization of buffer pool
2020-03-17 15:58:41 140402698639168 [Note] InnoDB: Highest supported file format is Barracuda.
2020-03-17 15:58:41 140402698639168 [Note] InnoDB: 128 rollback segment(s) are active.
2020-03-17 15:58:41 140402698639168 [Note] InnoDB: Waiting for purge to start
2020-03-17 15:58:41 140402698639168 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1600929
2020-03-17 15:58:41 140402170504960 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-03-17 15:58:41 140402698639168 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-17 15:58:41 140402698639168 [Note] Server socket created on IP: '127.0.0.1'.
2020-03-17 15:58:41 140402618656512 [Warning] InnoDB: Cannot open table mysql/gtid_slave_pos from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2020-03-17 15:58:41 140402618656512 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1932: Table 'mysql.gtid_slave_pos' doesn't exist in engine
2020-03-17 15:58:41 140402698639168 [Note] /opt/zbox/run/mysql/mysqld: ready for connections.
Version: '10.1.22-MariaDB' socket: '/opt/zbox/tmp/mysql/mysql.sock' port: 8089 Source distribution
2020-03-17 16:12:10 140402618455808 [Note] /opt/zbox/run/mysql/mysqld: Normal shutdown

2020-03-17 16:12:10 140402618455808 [Note] Event Scheduler: Purging the queue. 0 events
2020-03-17 16:12:10 140402153719552 [Note] InnoDB: FTS optimize thread exiting.
2020-03-17 16:12:10 140402618455808 [Note] InnoDB: Starting shutdown...
2020-03-17 16:12:10 140402618455808 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2020-03-17 16:12:12 140402618455808 [Note] InnoDB: Shutdown completed; log sequence number 1600939
2020-03-17 16:12:12 140402618455808 [Note] /opt/zbox/run/mysql/mysqld: Shutdown complete

2020-03-17 16:12:20 140385234130752 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-03-17 16:12:20 140385234130752 [Note] InnoDB: The InnoDB memory heap is disabled
2020-03-17 16:12:20 140385234130752 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-03-17 16:12:20 140385234130752 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2020-03-17 16:12:20 140385234130752 [Note] InnoDB: Compressed tables use zlib 1.2.3.4
2020-03-17 16:12:20 140385234130752 [Note] InnoDB: Using SSE crc32 instructions
2020-03-17 16:12:20 140385234130752 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-03-17 16:12:20 140385234130752 [Note] InnoDB: Completed initialization of buffer pool
2020-03-17 16:12:20 140385234130752 [Note] InnoDB: Highest supported file format is Barracuda.
2020-03-17 16:12:20 140385234130752 [Note] InnoDB: 128 rollback segment(s) are active.
2020-03-17 16:12:20 140385234130752 [Note] InnoDB: Waiting for purge to start
2020-03-17 16:12:20 140385234130752 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1600939
2020-03-17 16:12:20 140384775329536 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-03-17 16:12:20 140385234130752 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-17 16:12:20 140385234130752 [Note] Server socket created on IP: '127.0.0.1'.
2020-03-17 16:12:20 140385167304448 [Warning] InnoDB: Cannot open table mysql/gtid_slave_pos from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2020-03-17 16:12:20 140385167304448 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1932: Table 'mysql.gtid_slave_pos' doesn't exist in engine
2020-03-17 16:12:20 140385234130752 [Note] /opt/zbox/run/mysql/mysqld: ready for connections.
Version: '10.1.22-MariaDB' socket: '/opt/zbox/tmp/mysql/mysql.sock' port: 8089 Source distribution
2020-03-17 16:17:45 140385167103744 [Note] /opt/zbox/run/mysql/mysqld: Normal shutdown

2020-03-17 16:17:45 140385167103744 [Note] Event Scheduler: Purging the queue. 0 events
2020-03-17 16:17:45 140384688662272 [Note] InnoDB: FTS optimize thread exiting.
2020-03-17 16:17:45 140385167103744 [Note] InnoDB: Starting shutdown...
2020-03-17 16:17:45 140385167103744 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2020-03-17 16:17:46 140385167103744 [Note] InnoDB: Shutdown completed; log sequence number 1600949
2020-03-17 16:17:46 140385167103744 [Note] /opt/zbox/run/mysql/mysqld: Shutdown complete

2020-03-17 16:24:41 140375806191424 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-03-17 16:24:41 140375806191424 [Note] InnoDB: The InnoDB memory heap is disabled
2020-03-17 16:24:41 140375806191424 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-03-17 16:24:41 140375806191424 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2020-03-17 16:24:41 140375806191424 [Note] InnoDB: Compressed tables use zlib 1.2.3.4
2020-03-17 16:24:41 140375806191424 [Note] InnoDB: Using SSE crc32 instructions
2020-03-17 16:24:41 140375806191424 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-03-17 16:24:41 140375806191424 [Note] InnoDB: Completed initialization of buffer pool
2020-03-17 16:24:41 140375806191424 [Note] InnoDB: Highest supported file format is Barracuda.
2020-03-17 16:24:41 140375806191424 [Note] InnoDB: 128 rollback segment(s) are active.
2020-03-17 16:24:41 140375806191424 [Note] InnoDB: Waiting for purge to start
2020-03-17 16:24:41 140375806191424 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1600989
2020-03-17 16:24:41 140375347672832 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-03-17 16:24:41 140375806191424 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-17 16:24:41 140375806191424 [Note] Server socket created on IP: '127.0.0.1'.
2020-03-17 16:24:41 140375704672000 [Warning] InnoDB: Cannot open table mysql/gtid_slave_pos from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2020-03-17 16:24:41 140375704672000 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1932: Table 'mysql.gtid_slave_pos' doesn't exist in engine
2020-03-17 16:24:41 140375806191424 [Note] /opt/zbox/run/mysql/mysqld: ready for connections.
Version: '10.1.22-MariaDB' socket: '/opt/zbox/tmp/mysql/mysql.sock' port: 8089 Source distribution
2020-03-17 16:32:04 140375412856576 [Note] /opt/zbox/run/mysql/mysqld: Normal shutdown

2020-03-17 16:32:04 140375412856576 [Note] Event Scheduler: Purging the queue. 0 events
2020-03-17 16:32:04 140375330887424 [Note] InnoDB: FTS optimize thread exiting.
2020-03-17 16:32:04 140375412856576 [Note] InnoDB: Starting shutdown...
2020-03-17 16:32:05 140375412856576 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2020-03-17 16:32:06 140375412856576 [Note] InnoDB: Shutdown completed; log sequence number 1600999
2020-03-17 16:32:06 140375412856576 [Note] /opt/zbox/run/mysql/mysqld: Shutdown complete

2020-03-17 16:32:52 140289890887488 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-03-17 16:32:52 140289890887488 [Note] InnoDB: The InnoDB memory heap is disabled
2020-03-17 16:32:52 140289890887488 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-03-17 16:32:52 140289890887488 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2020-03-17 16:32:52 140289890887488 [Note] InnoDB: Compressed tables use zlib 1.2.3.4
2020-03-17 16:32:52 140289890887488 [Note] InnoDB: Using SSE crc32 instructions
2020-03-17 16:32:52 140289890887488 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-03-17 16:32:52 140289890887488 [Note] InnoDB: Completed initialization of buffer pool
2020-03-17 16:32:52 140289890887488 [Note] InnoDB: Highest supported file format is Barracuda.
2020-03-17 16:32:52 140289890887488 [Note] InnoDB: 128 rollback segment(s) are active.
2020-03-17 16:32:52 140289890887488 [Note] InnoDB: Waiting for purge to start
2020-03-17 16:32:52 140289890887488 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1600999
2020-03-17 16:32:52 140289360504576 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-03-17 16:32:52 140289890887488 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-17 16:32:52 140289890887488 [Note] Server socket created on IP: '127.0.0.1'.
2020-03-17 16:32:52 140289806149376 [Warning] InnoDB: Cannot open table mysql/gtid_slave_pos from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2020-03-17 16:32:52 140289806149376 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1932: Table 'mysql.gtid_slave_pos' doesn't exist in engine
2020-03-17 16:32:52 140289890887488 [Note] /opt/zbox/run/mysql/mysqld: ready for connections.
Version: '10.1.22-MariaDB' socket: '/opt/zbox/tmp/mysql/mysql.sock' port: 8089 Source distribution
2020-03-17 16:34:04 140289805948672 [Note] /opt/zbox/run/mysql/mysqld: Normal shutdown

2020-03-17 16:34:04 140289805948672 [Note] Event Scheduler: Purging the queue. 0 events
2020-03-17 16:34:04 140289268250368 [Note] InnoDB: FTS optimize thread exiting.
2020-03-17 16:34:04 140289805948672 [Note] InnoDB: Starting shutdown...
2020-03-17 16:34:04 140289805948672 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2020-03-17 16:34:06 140289805948672 [Note] InnoDB: Shutdown completed; log sequence number 1601009
2020-03-17 16:34:06 140289805948672 [Note] /opt/zbox/run/mysql/mysqld: Shutdown complete

2020-03-17 16:40:17 140565163145024 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-03-17 16:40:17 140565163145024 [Note] InnoDB: The InnoDB memory heap is disabled
2020-03-17 16:40:17 140565163145024 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-03-17 16:40:17 140565163145024 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2020-03-17 16:40:17 140565163145024 [Note] InnoDB: Compressed tables use zlib 1.2.3.4
2020-03-17 16:40:17 140565163145024 [Note] InnoDB: Using SSE crc32 instructions
2020-03-17 16:40:17 140565163145024 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-03-17 16:40:17 140565163145024 [Note] InnoDB: Completed initialization of buffer pool
2020-03-17 16:40:17 140565163145024 [Note] InnoDB: Highest supported file format is Barracuda.
2020-03-17 16:40:17 140565163145024 [Note] InnoDB: 128 rollback segment(s) are active.
2020-03-17 16:40:17 140565163145024 [Note] InnoDB: Waiting for purge to start
2020-03-17 16:40:17 140565163145024 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1601009
2020-03-17 16:40:17 140564704798464 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-03-17 16:40:17 140565163145024 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-17 16:40:17 140565163145024 [Note] Server socket created on IP: '127.0.0.1'.
2020-03-17 16:40:17 140564770539264 [Warning] InnoDB: Cannot open table mysql/gtid_slave_pos from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2020-03-17 16:40:17 140564770539264 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1932: Table 'mysql.gtid_slave_pos' doesn't exist in engine
2020-03-17 16:40:17 140565163145024 [Note] /opt/zbox/run/mysql/mysqld: ready for connections.
Version: '10.1.22-MariaDB' socket: '/opt/zbox/tmp/mysql/mysql.sock' port: 8089 Source distribution
2020/03/18
2018-04-13 10:30:55 140504566159168 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2018-04-13 10:30:55 140504566159168 [ERROR] Aborting
端口被占用了吧?修改端口试试

另外:
1. 先更新下服务器的时间,方便查看日志;
2. 日志内容多,可以联系下官网顶部的商务QQ,邀请加入技术交流群,发日志文件的。
🚢
2020-03-28 15:16:23

修改mysql端口可以参考下文档:

https://www.zentao.net/book/zentaopmshelp/90.html

修改端口需要避开服务器已占用端口

联系我们
联系人
高丽亚/高级客户经理
电话(微信)
17667930330
QQ号码
3645260865
联系邮箱
gaoliya@chandao.com
返回顶部
高丽亚
高级客户经理
17667930330
3645260865
统一服务热线 4006-8899-23
我要提问提问有任何问题,您都可以在这里提问。 问题反馈反馈点击这里,让我们聆听您的建议与反馈。