Here is my errors in my locahost.locaodomain.err: 071217 14:02:12 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data/ 2 071217 14:02:12 InnoDB: Started; log sequence number 0 46429 3 071217 14:02:13 [Warning] NDB: server id set to zero will cause any other mysqld with bin log to log with wrong server id 4 071217 14:02:13 [Note] Starting MySQL Cluster Binlog Thread 5 071217 14:02:13 [Note] Event Scheduler: Loaded 0 events 6 071217 14:02:13 [Note] /usr/local/mysql/bin/mysqld: ready for connections. 7 Version: '5.1.21-beta' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) 8 071217 14:02:14 - mysqld got signal 6; 9 This could be because you hit a bug. It is also possible that this binary 10 or one of the libraries it was linked against is corrupt, improperly built, 11 or misconfigured. This error can also be caused by malfunctioning hardware. 12 We will try our best to scrape up some info that will hopefully help diagnose 13 the problem, but since we have already crashed, something is definitely wrong 14 and this may fail. 15 16 key_buffer_size=8388600 17 read_buffer_size=131072 18 max_used_connections=2 19 max_threads=151 20 threads_connected=0 21 It is possible that mysqld could use up to 22 key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 337618 K 23 bytes of memory 24 Hope that's ok; if not, decrease some variables in the equation. 25 26 thd: 0x0 27 Attempting backtrace. You can use the following information to find out 28 where mysqld died. If you see no messages after this, something went 29 terribly wrong... 30 Cannot determine thread, fp=0xb7ff3b28, backtrace may not be correct. 31 Stack range sanity check OK, backtrace follows: 32 0x81fe0c9 33 0xad9402 34 0x4bf07451 35 0x8465f7f 36 0x8452aa4 37 0x8451929 38 0x84adb92 39 0x84b6d58 40 0x84b549d 41 0x84ae0cd 42 0x84adfb7 43 0x849d6b8 44 0x4c0502db 45 0x4bfaa12e 46 New value of fp=(nil) failed sanity check, terminating stack trace! 47 Please read http://dev.mysql.com/doc/refman/5.1/en/resolve-stack-dump.html 48 and follow instructions on how to resolve the stack trace. 49 Resolved stack trace is much more helpful in diagnosing the 50 problem, so please do resolve it 51 The manual page at http://www.mysql.com/doc/en/Crashing.htmlcontains 52 information that should help you find out what is causing the crash. 53 071217 14:02:14 mysqld_safe Number of processes running now: 0
[EMAIL PROTECTED] ~]# service mysqld status ERROR! MySQL is not running, but lock exists [EMAIL PROTECTED] ~]# ps aux | grep mysql root 2232 0.1 0.1 4596 1320 ? S 13:52 0:00 /bin/sh /usr/local/mysql//bin/mysqld_safe --datadir=/usr/local/mysql/data/ --pid-file=/usr/local/mysql/data//localhost.localdomain.pid nobody 4873 1.3 1.4 114512 14452 ? Sl 13:58 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --user=nobody --log-error=/usr/local/mysql/data//localhost.localdomain.err --pid-file=/usr/local/mysql/data//localhost.localdomain.pid --socket=/tmp/mysql.sock --port=3306 root 4889 0.0 0.0 4124 660 pts/0 D+ 13:58 0:00 grep mysql I don't know how to solve this,anybody can help me,thanks.