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 MapReduce结果输出到HBase,一直连接不上MySQL
  • ¥15 扩散模型sd.webui使用时报错“Nonetype”
  • ¥15 stm32流水灯+呼吸灯+外部中断按键
  • ¥15 将二维数组,按照假设的规定,如0/1/0 == "4",把对应列位置写成一个字符并打印输出该字符
  • ¥15 NX MCD仿真与博途通讯不了啥情况
  • ¥15 win11家庭中文版安装docker遇到Hyper-V启用失败解决办法整理
  • ¥15 gradio的web端页面格式不对的问题
  • ¥15 求大家看看Nonce如何配置
  • ¥15 Matlab怎么求解含参的二重积分?
  • ¥15 苹果手机突然连不上wifi了?