Are you using InnoDB tables? If so, have you properly configured the
directories?
-----Original Message-----
From: Jevos, Peter
To: '[EMAIL PROTECTED]'
Sent: 8/12/04 6:02 AM
Subject: Problem after crash
Hello
Please help me. Im newbie in the database and I got one crash after
outage.
Now my mysql.server cant start. Im my log is nothing . And in err log in
database directory is:
**************************************************************
040811 20:26:59 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
040811 20:27:02 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Error: all log files must be created at the same time.
InnoDB: All log files must be created also in database creation.
InnoDB: If you want bigger or smaller log files, shut down the
InnoDB: database and make sure there were no errors in shutdown.
InnoDB: Then delete the existing log files. Edit the .cnf file
InnoDB: and start the database again.
040811 20:27:03 Can't init databases
040811 20:27:03 Aborting
040811 20:27:04 InnoDB: Warning: shutting down a not properly started
InnoDB: or created database!
040811 20:27:04 /usr/local/mysql/libexec/mysqld: Shutdown Complete
040811 20:27:04 mysqld ended
040812 12:09:53 mysqld started
040812 12:09:53 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 0 50170
InnoDB: Doing recovery: scanned up to log sequence number 0 50170
InnoDB: Page directory corruption: supremum not pointed to
040812 12:09:53 InnoDB: Page dump in ascii and hex (16384 bytes):
040812 12:09:53 InnoDB: Page checksum 1575996416, prior-to-4.0.14-form
checksum 1371122432
InnoDB: stored checksum 0, prior-to-4.0.14-form stored checksum 0
InnoDB: Page lsn 0 0, low 4 bytes of lsn at page end 0
InnoDB: Error: trying to access a stray pointer c0cbbff8
InnoDB: buf pool start is at 404c8000, number of pages 512
040812 12:09:53 InnoDB: Assertion failure in thread 16384 in file
../../innobase/include/buf0buf.ic line 284
InnoDB: Failing assertion: 0
InnoDB: We intentionally generate a memory trap.
InnoDB: Send a detailed bug report to [EMAIL PROTECTED]
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=8388600
read_buffer_size=131072
max_used_connections=0
max_connections=100
threads_connected=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections
=
225791 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
thd=0x838c740
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...
Bogus stack limit or frame pointer, fp=0xbfffdcf8, stack_bottom=0x20,
thread_stack=196608, aborting backtrace.
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at (nil) is invalid pointer
thd->thread_id=-488513313
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.
040812 12:09:53 mysqld ended
************************************************************************
***
I look at this page but I cannot find an answer my problem
What can I do ?
Thanx a lot for any advice
pet
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
