mysqld got signal 11; This could be because you hit a bug ....

[Mariella Di Giacomo]

Hello,

I am running mysql server (mysql-standard-4.0.5-beta-64bit) 64 bit on Sun Solaris 2.8 and I have got the binaries form the mysql web site.
The machine I am using has 32GB of RAM + 64GB of swap.

At the certain point I got :

__________________________________________________________________
/usr/local/mysql-standard-4.0.5-beta-64bit/bin/mysqld: ready for connections
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=11274285056
read_buffer_size=2093056
sort_buffer_size=2097144
max_used_connections=0
max_connections=16
threads_connected=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 11075515 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
__________________________________________________________________

I have tried also 4.0.8 and I have the same problem.
I do not think it is an hardware problem, because I have tried the same
task on a different Sun machine (with Solaris 2.8 and the same executable) and I get
the same problem after a while.

I have tested the memory allocation with mysqld through the creation of big HEAP
table and mysqld could allocate all the memory (32GB+64GB) for the heap table.
I have got an error after that because mysqld needed more memory for finishing
filling the heap table and it could not allocate more (xmalloc failed) of it.

So if mysqld can use all the Solaris Virtual memory of the system, why do I get that
problem, provided that I have more memory (32GB + 64GB) of what it is complaining ?

key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 11075515 K



Could someone help, please ?

Thanks in advance for your help,

Mariella


---------------------------------------------------------------------
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