- 论坛徽章:
- 0
|
mysql自己会重启，但原进程没杀掉，所以重启就报错，结果mysql就宕了
操作系统：AS4, CPU 双智强2.8G，内存4G，硬盘scsi 三块 做raid5, Mysql 是4.0.24版本的，RPM安装的，运行从D4升级上来的D5论坛，web在另外一台，通过内网连接数据库
错误日志如下：
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=268435456
read_buffer_size=2093056
max_used_connections=324
max_connections=1000
threads_connected=12
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1183832 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
thd=0x917a9690
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=0xbe7bde38, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x8072da4
0x826d468
0x82684d4
0x80c15f0
0x80c1308
0x80c1178
0x80c0a5d
0x8098ff9
0x80999e8
0x8097ac9
0x80971b6
0x807e182
0x8081be5
0x807d1a3
0x807cbfe
0x807c428
0x826ac1c
0x82a0aca
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. Reso
lved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x98ba3a98 is invalid pointer
thd->thread_id=3217286
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.
Number of processes running now: 1
mysqld process hanging, pid 31733 - killed
061220 12:17:47 mysqld restarted
061220 12:17:48 Warning: Asked for 196608 thread stack, but got 126976
061220 12:17:48 Can't start server: Bind on TCP/IP port: Address already in use
061220 12:17:48 Do you already have another mysqld server running on port: 3306 ?
061220 12:17:48 Aborting
061220 12:17:48 /usr/sbin/mysqld: Shutdown Complete
061220 12:17:48 mysqld ended
061220 12:56:56 mysqld started
061220 12:56:56 Warning: Asked for 196608 thread stack, but got 126976
/usr/sbin/mysqld: ready for connections.
Version: '4.0.24-standard-log' socket: '/home/xxxxx/mysql.sock' port: 3306 Official MySQL RPM |
|
免费注册
发表于 2006-12-20 16:03
发表于 2006-12-20 21:04