Hello,
My MySQL keeps crashing and restarting, and I get this log, which repeats
indefinitely:
Number of processes running now: 0
070622 13:01:46 mysqld restarted
070622 13:01:46 InnoDB: Out of memory in additional memory pool.
InnoDB: InnoDB will start allocating memory from the OS.
InnoDB: You may get better performance if you configure a bigger
InnoDB: value in the MySQL my.cnf file for
InnoDB: innodb_additional_mem_pool_size.
070622 13:01:46 InnoDB: Starting an apply batch of log records to the
database...
InnoDB: Progress in percents: 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51
52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77
78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
070622 13:01:47 InnoDB: Started
/usr/libexec/mysqld: ready for connections
070622 13:01:48 InnoDB: Assertion failure in thread 114696 in file
fsp0fsp.c line 2945
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
record_buffer=131072
sort_buffer=2097144
max_used_connections=0
max_connections=80
threads_connected=0
It is possible that mysqld could use up to key_buffer_size + (record_buffer
+ sort_buffer)*max_connections = 182271 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=0x42d36f98, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x80ee059
0x4a50efd6
0x8273f32
0x8234054
0x8234654
0x8234874
0x823589b
0x82030ca
0x820338b
0x81f00e7
0x81efce7
0x8235d70
0x81f4c15
0x4a509cce
0x4a463b3a
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
070622 13:01:48 mysqld restarted
070622 13:01:48 InnoDB: Out of memory in additional memory pool.
InnoDB: InnoDB will start allocating memory from the OS.
InnoDB: You may get better performance if you configure a bigger
InnoDB: value in the MySQL my.cnf file for
InnoDB: innodb_additional_mem_pool_size.
070622 13:01:48 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 974975241
InnoDB: Doing recovery: scanned up to log sequence number 0 974975241
070622 13:01:48 InnoDB: Flushing modified pages from the buffer pool...
070622 13:01:48 InnoDB: Started
/usr/libexec/mysqld: ready for connections
070622 13:01:49 InnoDB: Assertion failure in thread 114696 in file
fsp0fsp.c line 2945
InnoDB: We intentionally generate a memory trap.
InnoDB: Send a detailed bug report to [email protected] mysqld got
signal 11;
..............................
When I comment out the InnoDB configuration line, InnoDB doesn't start and
MySQL can start normally.
But all the InnoDB tables can't be accessed...
Do you have an idea in how to fix this problem ? Sorry for my English, but
I'm French ^_^
Thanks :)
_____________________________________________________________________________
Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
