I have followed your suggestion. I have installed mysql-debug-4.0.10-gamma-sun-solaris2.9-sparc-64bit on the Solaris 8 (Machine with 8 cpus, 32GB of Memory and 64 of swap) server. I have started the mysqld program as root I have specified the core-file in the /etc/my.cnf file.
Other info that could be interesting in the /etc/my.cnf are
_____________________________________________________
set-variable = max_connections=16 set-variable = max_tmp_tables=512 set-variable = table_cache=512 set-variable = key_buffer=16384M
set-variable = sort_buffer=1K set-variable = record_buffer=1K
set-variable = thread_cache_size=8 set-variable = thread_cache=512 set-variable = thread_concurrency=12
_____________________________________________________
I have started 7 concurrent mysql threads (7 OPTIMIZE TABLE from mysql command line)
and after 9 hours I got a segmentation fault
with Error
ERROR 2013: Lost connection to MySQL server during query ERROR 2013: Lost connection to MySQL server during query ERROR 2013: Lost connection to MySQL server during query ERROR 2013: Lost connection to MySQL server during query ERROR 2013: Lost connection to MySQL server during query ERROR 2013: Lost connection to MySQL server during query ERROR 2013: Lost connection to MySQL server during query Segmentation Fault 030223 16:11:05 mysqld restarted
I have looked at the mysqld error log file and this is the message
________________________________________________________________
030223 07:03:11 mysqld started
/usr/local/mysql-debug-4.0.10-gamma-sun-solaris2.9-sparc-64bit/bin/mysqld: ready for connections.
Version: '4.0.10-gamma-debug-debug-log' socket: '/tmp/mysql.sock' port: 3306
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=17179869184
read_buffer_size=8192
sort_buffer_size=32768
max_used_connections=7
max_connections=16
threads_connected=8
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 16777856 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Writing a core file 030223 16:11:05 mysqld restarted
______________________________________________________
I have looked for the core file, but I couldn't find it, even though in the error
log it says "Writing a core file".
Does this give you any clue about what is causing the error ? Could you help please about the "core file" Do I need to specify the option differently ?
Thanks in advance for your help,
Mariella
At 04:34 PM 1/29/03 +0200, Sinisa Milivojevic wrote:
On Tue, 28 Jan 2003 17:12:14 -0700 Mariella Di Giacomo <[EMAIL PROTECTED]> wrote:
> 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. > > Thanks in advance for your help, > > Mariella >
Hi!
The reason why MySQL is crashing is not due to the fact that your memory is exhausted.
It is possible that you have shell limits that are far below the available memory, but in your case
even that is not a problem.
What you should do is get a 4.0.10 debug binary for Solaris 2.8 from our site and send us a core
file that is created on the crash.
Also add --core-file to startup options.
--
Regards,
-- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com
--------------------------------------------------------------------- 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
