ubuntu mysql fail_ubuntu下处理mysql无法启动故障一例

故障现象：

mysql无法启动

1: dmesg |grep mysql

[101353.820000] init: mysql post-start process (9077) terminated with status 1

[101354.650000] init: mysql main process (9113) terminated with status 1

[101354.650000] init: mysql respawning too fast, stopped

2: grep mysql /var/log/syslog

213 Apr  1 19:35:33 Asiulo kernel: [101110.450000] init: mysql post-start process (8815) terminated with status 1

214 Apr  1 19:35:33 Asiulo kernel: [101110.590000] init: mysql main process (8846) terminated with status 1

215 Apr  1 19:35:33 Asiulo kernel: [101110.590000] init: mysql respawning too fast, stopped

3: tail -100 /var/log/mysql/error.log

1 130401 10:27:28 [Note] Plugin 'FEDERATED' is disabled.

2 130401 10:27:28 InnoDB: The InnoDB memory heap is disabled

3 130401 10:27:28 InnoDB: Mutexes and rw_locks use GCC atomic builtins

4 130401 10:27:28 InnoDB: Compressed tables use zlib 1.2.7

5 130401 10:27:28 InnoDB: Using Linux native AIO

6 130401 10:27:28 InnoDB: Initializing buffer pool, size = 128.0M

7 130401 10:27:28 InnoDB: Completed initialization of buffer pool

8 130401 10:27:28 InnoDB: highest supported file format is Barracuda.

9 InnoDB: The log sequence number in ibdata files does not match

10 InnoDB: the log sequence number in the ib_logfiles!

11 130401 10:27:28  InnoDB: Database was not shut down normally!

12 InnoDB: Starting crash recovery.

13 InnoDB: Reading tablespace information from the .ibd files...

14 InnoDB: Restoring possible half-written data pages from the doublewrite

15 InnoDB: buffer...

16 130401 10:27:28  InnoDB: Assertion failure in thread 3062129168 in file fsp0fsp.c line 2102

17 InnoDB: Failing assertion: inode

18 InnoDB: We intentionally generate a memory trap.

19 InnoDB: Submit a detailed bug report to http://bugs.mysql.com.

20 InnoDB: If you get repeated assertion failures or crashes, even

21 InnoDB: immediately after the mysqld startup, there may be

22 InnoDB: corruption in the InnoDB tablespace. Please refer to

23 InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html

24 InnoDB: about forcing recovery.

25 02:27:28 UTC - mysqld got signal 6 ;

26 This could be because you hit a bug. It is also possible that this binary

27 or one of the libraries it was linked against is corrupt, improperly built,

28 or misconfigured. This error can also be caused by malfunctioning hardware.

29 We will try our best to scrape up some info that will hopefully help

30 diagnose the problem, but since we have already crashed,

31 something is definitely wrong and this may fail.

32

33 key_buffer_size=16777216

34 read_buffer_size=131072

35 max_used_connections=0

36 max_threads=151

37 thread_count=0

38 connection_count=0

39 It is possible that mysqld could use up to

40 key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 346079 K  bytes of memory

41 Hope that's ok; if not, decrease some variables in the equation.

42

43 Thread pointer: 0x0

44 Attempting backtrace. You can use the following information to find out

45 where mysqld died. If you see no messages after this, something went

46 terribly wrong...

47 stack_bottom = 0 thread_stack 0x30000

48 The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains

49 information that should help you find out what is causing the crash.

核实是INNODB出现故障导致。根据红色链接中的方法：

you can add the following line to the [mysqld] section of your option file before restarting the server:

[mysqld]

innodb_force_recovery = 4

将这个设置加入到/etc/mysql/my.cnf, 后start mysql服务恢复正常。

注释：

4 (SRV_FORCE_NO_IBUF_MERGE)

Prevent insert buffer merge operations. If they would cause a crash, do not do them. Do not calculate table statistics.

前期处理重新安装mysql的过程也记录下：

重新安装mysql

删除mysql：

apt-get autoremove --purge mysql-server

apt-get remove mysql-common

清理残留数据：

dpkg -l |grep ^rc|awk '{print $2}' |sudo xargs dpkg -P

最后再执行下 apt-get autoremove

安装 mysql：

apt-get install mysql-server-5.5

apt-get install mysql-client-5.5  //正常情况，此步已经包含在上步中，无需再安装。

apt-get install php5-mysql

安装完毕执行

#dpkg-reconfigure重新配置

dpkg-reconfigure mysql-server-5.5

#quick mysql package check

dpkg -l *mysql*

禁止mysql做域名解析

[mysqld]

skip-name-resolve

完毕！

Ubuntu下安装MySQL 5.6.23

Ubuntu下安装MySQL 5.6.23 1.下载相应Linux-generic的源代码包.解压,将解压后的文件夹重命名为mysql.移动到/usr/local文件夹下: tar –xzf mysq ...

ubuntu下安装mysql和配置远程访问

ubuntu下安装mysql和配置远程访问   下载安装mysql sudo apt-get install mysql-client mysql-server 安装的时候会提示要设置root密码,如 ...

Ubuntu 下安装 Mysql

这里讲用Ubuntu下安装MySql ubuntu上安装mysql非常简单只需要几条命令就可以完成. 1. sudo apt-get install mysql-server   2. apt-get ...

ubuntu下修改mysql默认字符编码出现的Job failed to start解决办法

ubuntu下修改mysql默认字符编码出现的Job failed to start解决办法 前几天卸掉了用了好多年的Windows,安装了Ubuntu12.04,就开始各种搭环境.今天装好了MySQ ...

Ubuntu下安装mysql与mysql workbench

Ubuntu 安装jdk:[链接] Ubuntu安装eclipse:[链接] Ubuntu下安装MySQL与mysql workbench:[链接] Ubuntu配置tomcat9:[链接] 1.su ...

Ubuntu下执行mysql的sql文件

Ubuntu下执行mysql的.sql文件   方法一: 1.执行此命令,会提示输入mysql的root账户的密码,验证成功后,会在dbname这个数据库中执行filename.sql这个脚本,其中f ...

Ubuntu下删除mysql数据库

Ubuntu下删除mysql数据库 sudo apt-get autoremove --purge mysql-server-5.7 sudo apt-get remove mysql-server ...

解决ubuntu下安装mysql使用service无法启动问题

启动的时候发现service mysql start Rather than invoking init scripts through /etc/init.d, use the service(8) ...

随机推荐

GATK使用说明(一)

1. 官方网址 https://software.broadinstitute.org/gatk/ 2. 下载Latest version: 3.7 3. FileZilla 上传至服务器,解压 ta ...

pl/sql连接远程服务器

1.oracle提供了instantclient,下载instantclient-basic-win32-10.2.0.4.zip,将包解压存放到本地,如:D:\STUDY\instantclient ...

使用Python实现子区域数据分类统计

目录 前言 geopandas简介 子区域数据分类统计 总结 一.前言        最近碰到一个需求,需要统计某省内的所有市的某数据分布情况信息.现有该省的数据分布情况以及该省的行政区划数据.我通过 ...

abstract和interface的区别

abstract class和interface是Java语言中对于抽象类定义进行支持的两种机制,正是由于这两种机制的存在,才赋予了Java强大的面向对象能力. abstract class和inte ...

在桌面创建robotframework Ride的快捷方式启动RIDE

安装后robotframework-ride 后,每次启动时都要在Dos命令下启动 ,下面是创建快捷方式启动操作如下: 1.进入到python的安装目录的/Scripts目录下,找到ride.py文件 ...

day0315 迭代器

一. 迭代器 1.什么是可迭代器? 除了数字和布尔值之外,其他数据类型都是可迭代对象.(字符串,列表,元组,字典,集合) 2.可迭代协议 2.1 可以被迭代要满足的要求就叫可迭代协议,可迭代的定义非常 ...

const 内联 枚举 宏

const 常量   程序运行时在常量表中,系统为它分配内存,在堆栈分配了空间:const常量有数据类型:语句末有分号:有类型检查:可以限制范围 //将所有不希望改变的变量加const修饰 const ...

java8 Stream使用案例

1. 原理 Stream 不是集合元素,它不是数据结构并不保存数据,它是有关算法和计算的,它更像一个高级版本的 Iterator. 原始版本的 Iterator,用户只能显式地一个一个遍历元素并对其执 ...

HDU 1574 RP问题 (dp)

题目链接 Problem Description 在人类社会中,任何个体都具有人品,人品有各种不同的形式,可以从一种形式转换为另一种形式,从一个个体传递给另一个个体,在转换和传递的过程中,人品不会消失 ...

C语言中extern的用法--转

http://blog.sina.com.cn/s/blog_52deb9d50100ml6y.html 在C语言中,修饰符extern用在变量或者函数的声明前,用来说明“此变量/函数是在别处定义的, ...