040401 06:21:02 mysqld started 040401 6:21:03 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 10 4036416 InnoDB: Doing recovery: scanned up to log sequence number 10 4036416 040401 6:21:03 InnoDB: Flushing modified pages from the buffer pool... 040401 6:21:03 InnoDB: Started /usr/local/mysql/libexec/mysqld: ready for connections 040401 6:21:04 InnoDB: Assertion failure in thread 7176 in file ../include/page0page.ic line 482 InnoDB: We intentionally generate a memory trap.
key_buffer_size=8388600 record_buffer=131072 sort_buffer=2097144 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 225791 K bytes of memory Hope that's ok, if not, decrease some variables in the equation 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=0x685406c8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x80c9d62 0x40027f75 0x8244028 0x81a44b9 0x8174c79 0x8171c4c 0x81721a8 0x8172b9a 0x81739d7 0x8173cfb 0x815a30e 0x81c673f 0x813dbed 0x40024fef 0x420e779a New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/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/C/r/Crashing.html contains information that should help you find out what is causing the crash Number of processes running now: 0 040401 06:21:04 mysqld restarted 040401 6:21:04 Can't start server: Bind on TCP/IP port: Address already in use 040401 6:21:04 Do you already have another mysqld server running on port: 3306 ? 040401 6:21:04 Aborting 040401 6:21:04 /usr/local/mysql/libexec/mysqld: Shutdown Complete what I can do for returning DB to online? thank you. --- Paizulaev Abdulla, Electrosvyaz close corp., Makhachkala, Daghestan, [EMAIL PROTECTED], icq 342000, +78722608210, +79034984708 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]