duanzhi789 2016-08-31 09:10 采纳率: 0%
浏览 2608

mysql频繁重新启动,大神帮忙看看

160831 16:32:10 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160831 16:32:10 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
160831 16:32:10 InnoDB: Initializing buffer pool, size = 8.0M
160831 16:32:10 InnoDB: Completed initialization of buffer pool
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 35 row operations to undo
InnoDB: Trx id counter is 0 112437760
160831 16:32:10 InnoDB: Started; log sequence number 1 255213035
InnoDB: Starting in background the rollback of uncommitted transactions
InnoDB: Cleaning up trx with id 0 2496008
160831 16:32:10 InnoDB: Rollback of non-prepared transactions completed
160831 16:32:10 [Note] Event Scheduler: Loaded 0 events
160831 16:32:10 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
InnoDB: error in sec index entry update in
InnoDB: index history_uint_1 of table zabbix.history_uint
InnoDB: tuple DATA TUPLE: 3 fields;
0: len 8; hex 0000000000005fd2; asc _ ;; 1: len 4; hex d771e21f; asc q ;; 2: len 6; hex 000000219c60; asc ! `;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 32
0: len 8; hex 0000000000005fd2; asc _ ;; 1: len 4; hex d771e1e3; asc q ;; 2: len 6; hex 000000219a50; asc ! P;;

TRANSACTION 0 112437763, ACTIVE 0 sec, process no 17925, OS thread id 140519254370064 updating or deleting, thread declared inside InnoDB 497
mysql tables in use 1, locked 1
5 lock struct(s), heap size 1216, 5 row lock(s), undo log entries 2
MySQL thread id 4, query id 11 localhost zabbix updating
delete from history_uint where itemid=24530 and clock<1467095587

InnoDB: Submit a detailed bug report to http://bugs.mysql.com
InnoDB: error in sec index entry update in
InnoDB: index history_uint_1 of table zabbix.history_uint
InnoDB: tuple DATA TUPLE: 3 fields;
0: len 8; hex 0000000000005fd2; asc _ ;; 1: len 4; hex d771e25c; asc q \;; 2: len 6; hex 000000219e3e; asc ! >;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 32
0: len 8; hex 0000000000005fd2; asc _ ;; 1: len 4; hex d771e1e3; asc q ;; 2: len 6; hex 000000219a50; asc ! P;;

TRANSACTION 0 112437763, ACTIVE 0 sec, process no 17925, OS thread id 140519254370064 updating or deleting, thread declared inside InnoDB 495
mysql tables in use 1, locked 1
6 lock struct(s), heap size 1216, 7 row lock(s), undo log entries 3
MySQL thread id 4, query id 11 localhost zabbix updating
delete from history_uint where itemid=24530 and clock<1467095587

InnoDB: Submit a detailed bug report to http://bugs.mysql.com
InnoDB: error in sec index entry update in
InnoDB: index history_uint_1 of table zabbix.history_uint
InnoDB: tuple DATA TUPLE: 3 fields;
0: len 8; hex 0000000000005fd2; asc _ ;; 1: len 4; hex d771e297; asc q ;; 2: len 6; hex 000000219f65; asc ! e;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 32
0: len 8; hex 0000000000005fd2; asc _ ;; 1: len 4; hex d771e1e3; asc q ;; 2: len 6; hex 000000219a50; asc ! P;;

TRANSACTION 0 112437763, ACTIVE 0 sec, process no 17925, OS thread id 140519254370064 updating or deleting, thread declared inside InnoDB 493
mysql tables in use 1, locked 1
6 lock struct(s), heap size 1216, 9 row lock(s), undo log entries 4
MySQL thread id 4, query id 11 localhost zabbix updating
delete from history_uint where itemid=24530 and clock<1467095587

InnoDB: Submit a detailed bug report to http://bugs.mysql.com
InnoDB: error in sec index entry update in
InnoDB: index history_uint_1 of table zabbix.history_uint
InnoDB: tuple DATA TUPLE: 3 fields;
0: len 8; hex 0000000000005fd2; asc _ ;; 1: len 4; hex d771e2d3; asc q ;; 2: len 6; hex 00000021a125; asc ! %;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 32
0: len 8; hex 0000000000005fd2; asc _ ;; 1: len 4; hex d771e1e3; asc q ;; 2: len 6; hex 000000219a50; asc ! P;;

TRANSACTION 0 112437763, ACTIVE 0 sec, process no 17925, OS thread id 140519254370064 updating or deleting, thread declared inside InnoDB 491
mysql tables in use 1, locked 1
7 lock struct(s), heap size 1216, 11 row lock(s), undo log entries 5
MySQL thread id 4, query id 11 localhost zabbix updating
delete from history_uint where itemid=24530 and clock<1467095587

InnoDB: Submit a detailed bug report to http://bugs.mysql.com
InnoDB: error in sec index entry update in
InnoDB: index history_uint_1 of table zabbix.history_uint
InnoDB: tuple DATA TUPLE: 3 fields;
0: len 8; hex 0000000000005fd2; asc _ ;; 1: len 4; hex d771e310; asc q ;; 2: len 6; hex 00000021a31a; asc ! ;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 32
0: len 8; hex 0000000000005fd2; asc _ ;; 1: len 4; hex d771e1e3; asc q ;; 2: len 6; hex 000000219a50; asc ! P;;

  • 写回答

16条回答

  • autoDBA 2016-08-31 09:11
    关注

    你试试看看 进程书 show processlist; 看下最大连接数
    设置下

    评论

报告相同问题?

悬赏问题

  • ¥15 kafka 分区副本增加会导致消息丢失或者不可用吗?
  • ¥15 微信公众号自制会员卡没有收款渠道啊
  • ¥15 stable diffusion
  • ¥100 Jenkins自动化部署—悬赏100元
  • ¥15 关于#python#的问题:求帮写python代码
  • ¥20 MATLAB画图图形出现上下震荡的线条
  • ¥15 关于#windows#的问题:怎么用WIN 11系统的电脑 克隆WIN NT3.51-4.0系统的硬盘
  • ¥15 perl MISA分析p3_in脚本出错
  • ¥15 k8s部署jupyterlab,jupyterlab保存不了文件
  • ¥15 ubuntu虚拟机打包apk错误