跳至主要内容

mysql error

某日重启mysql遇到以下错误
bash-3.00# /etc/rc3.d/S99mysql startStarting MySQL.... ERROR! Manager of
pid-file quit without updating file.

差错误日志
081211 11:02:41 InnoDB: Starting shutdown...081211 11:02:42 InnoDB:
Shutdown completed; log sequence number 0 46419081211 11:02:42 [Note]
/opt/mysql6/bin/mysqld: Shutdown complete
081211 11:02:42 mysqld_safe mysqld
from pid file /opt/mysql6/data/testenv.atu.pid ended081211 11:04:23 mysqld_safe
Starting mysqld daemon with databases from /opt/mysql6/data081211 11:04:23
InnoDB: Started; log sequence number 0 46419081211 11:04:24 [ERROR] mysqld: File './mysql-bin.000018' not found (Errcode:
13)
081211 11:04:24 [ERROR] Failed to open log (file './mysql-bin.000018',
errno 13)081211 11:04:24 [ERROR] Could not open log file081211 11:04:24 [ERROR]
Can't init tc log081211 11:04:24 [ERROR] Aborting
081211 11:04:24
InnoDB: Starting shutdown...081211 11:04:25 InnoDB: Shutdown completed;
log sequence number 0 46419081211 11:04:25 [Note] /opt/mysql6/bin/mysqld:
Shutdown complete
081211 11:04:25 mysqld_safe mysqld from pid file
/opt/mysql6/data/testenv.atu.pid ended


The error which had been highlighted.
Then
bash-3.00# ../bin/perror 13OS error code 13: Permission denied
bash-3.00#ls -la
-rw-rw---- 1 root root 126 Dec 10 14:53 mysql-bin.000016
-rw-rw---- 1 root root 952 Dec 11 11:04 mysql-bin.000017
-rw-rw---- 1 root root 684783 Dec 11 11:04 mysql-bin.000018

so you may find the three files the owner which is not mysql, so change the owner
bash-3.00# chown mysql:mysql mysql-bin.000016
bash-3.00# chown mysql:mysql mysql-bin.000017
bash-3.00# chown mysql:mysql mysql-bin.000018
bash-3.00# /etc/rc3.d/S99mysql startStarting MySQL... SUCCESS!

评论

此博客中的热门博文

Python学习笔记20100117

映射list   Dictionary 是用{}. list 是一那个[]. turple是用() 当你定义过dictionary后,你可以使用d.keys(), d.values(),d.items()将定义后的时候分别显示出来 当然可以将list里的值加减乘除,也可以如一般的定义直接重新复制这个list. 链接与分割字符串的 li=";", join(li) 则显示的就是 分隔符为;的数 如果使用li=li.split(";")则将刚刚;的分隔符删除,而split里也可定义域,如li.split(";",1)   自省 <---这是啥 之前在使用的时候发觉有些书本上的模块不能调用,很多是py脚本定义过的函数。 下载该脚本s,然后上传至指定位置。 >>>import sys >>>sys.path >>>sys.path.append("绝对位置")然后就能调用这些脚本和参数了。 删除 >>>sys.path.pop() 定义一个参数是 def info(test, test1=10.test2=12): info是函数名,test是必备参数,因为没有定义值,test1和test2是可选参数,定义了初始值   以上是外部函数的调用,下面转到内部函数 内部函数有type,str,dir及其他   ---type 返回任意字符的类型,模块也可以。types模块 >>> type(1) <type 'int'> >>> li=[] >>> type(li) <type 'list'> >>> import odbchelper >>> type(odbchelper) <type 'module'> >>> type(sys) <type 'module'> >>> import types ...

Setagaya park

  We visited Setagaya Park (世田谷区) yesterday. This park reminds us when we in Europe, which has a fancy fountain in the middle, and free entrance. People just laid down on the grass, enjoy the day time they can waste. people who have kids together,  play all different kinds of sports. you really can't image whether you are in Europe or  Japan. I would prefer to use a Bus instead of the metro, the metro is fast, but you only can see the dark, light, people sit or stand as Sardine, without any emotion. but on the bus, you can see the traffic, the shop, everything on the road. When we on our way to the park, we stop by a good chocolate shop named " craft chocolate works ",  this is a very good place to have ice cream, you probably can choose half & half, you can enjoy the feeling when you smell the chocolate smell and eat with it.  or you can enjoy beer or cake in "globe antiques (ザ グローブアン ティ ークス) .   also, we checked the Blue Bottle Coffee Sangenjaya ...