免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 2502 | 回复: 5
打印 上一主题 下一主题

求助!mysqld 无法启动!!十万火急 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2010-10-02 20:16 |只看该作者 |倒序浏览
设备突然无法启动mysqld,
日志如下:Starting MySQLStarting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/lib/mysql/mysql.pid。后边就是在打点.......

101002 19:08:58 [Warning] Asked for 196608 thread stack, but got 126976
101002 19:08:58  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
101002 19:08:58  InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 25 3243784353.
InnoDB: Doing recovery: scanned up to log sequence number 25 3243784861
101002 19:08:58  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.

key_buffer_size=0
read_buffer_size=1044480
max_used_connections=0
max_connections=200
threads_connected=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 408798 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd=(nil)
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0xbff3ecb8, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x808fd07
0x82ee608
0x826ac19
0x8269835
0x82173d4
0x8218435
0x81fc791
0x823c303
0x81479e9
0x82ebdbc
0x831563a
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.
101002 19:08:58  mysqld ended

请高手帮忙 啊!!拜托了!

论坛徽章:
0
2 [报告]
发表于 2010-10-02 22:02 |只看该作者
innodb表坏了吧?

论坛徽章:
0
3 [报告]
发表于 2010-10-02 22:35 |只看该作者
大哥,innodb 如何恢复啊?

论坛徽章:
0
4 [报告]
发表于 2010-10-02 22:45 |只看该作者
我找到了一些资料,去试试看。谢谢!

论坛徽章:
0
5 [报告]
发表于 2010-10-08 19:59 |只看该作者
关注中。。

论坛徽章:
0
6 [报告]
发表于 2010-10-11 16:12 |只看该作者
关注
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP