Hi Heikki, thanks for replying so swiftly.

"Heikki Tuuri" <[EMAIL PROTECTED]> writes:

> this is probably a real bug. It is trying to allocate 1.5 GB of memory in
> one shot, which does not make sense. More probably the argument to the
> allocator is garbage.
> 
> What MySQL version you are running?

mysqld  Ver 3.23.49 for pc-linux-gnu on i686

MySQL is installed from a Debian Package (I am running Debian GNU/Linux
3.0) - package version 3.23.49-8.

> Can you compile MySQL yourself with
> 
> CFLAGS="-g -O3" ./configure --with-innodb
> 
> and run it inside gdb? Put a breakpoint to the code where it prints the
> error message, so that we get the stack trace with
> 
> gdb> bt full

Hmm. This is a production machine and I have a very limited window to
tinker around with things. The crash occures when the server is really
busy - I have so far failed to provoke this to happen.

I've modified innobase/ut/ut0mem.c to give a nice stack-trace when the
error occures, and recompiled with symbols. Hopefully (uhh ;) it will
crash again monday and I will have a nice stack-trace to show you.

Another question: As the server has some limitation (io kapasity) I am
running with innodb_flush_log_at_trx_commit set to "0". Would it be
unwise to try to sync the logs when we hit this kind of error? Does
syncing of logs require mallocing of memory?


For completeness; here is my innodb configuration:

# InnoDB

innodb_data_home_dir=/var/lib/mysql/innodb/
innodb_data_file_path=ibdata00:1G;ibdata01:1G;ibdata02:1G;ibdata03:1G;ibdata04:1G;ibdata05:1G;ibdata06:1G;ibdata07:1G;ibdata08:1G;ibdata09:1G;ibdata10:1G;ibdata11:1G;ibdata12:1G;ibdata13:1G;ibdata14:1G;ibdata15:1G;ibdata16:1G;ibdata17:1G;ibdata18:1G;ibdata19:1G

innodb_log_group_home_dir=/var/lib/mysql/innodb/
set-variable = innodb_log_files_in_group=3

innodb_log_arch_dir=/var/lib/mysql/innodb/

set-variable = innodb_log_file_size=32M
set-variable = innodb_log_buffer_size=96M

set-variable = innodb_buffer_pool_size=950M
set-variable = innodb_additional_mem_pool_size=64M

innodb_flush_method=O_DSYNC

innodb_flush_log_at_trx_commit=0



-- 
Per Andreas Buer


-- 
Per Andreas Buer

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to