Joseph Bueno writes:
> Hi,
>
> Problem description:
> Yesterday, mysqld died with following message in error log:
>
> mysqld got signal 11;
> The manual section 'Debugging a MySQL server' tells you how to use a
> stack trace and/or the core file to produce a readable backtrace that
> may
> help in finding out why mysqld died
> Attemping backtrace. You can use the following information to find out
> where mysqld died. If you see no messages after this, something went
> terribly wrong
> frame pointer (ebp) is NULL, did you compile with
> -fomit-frame-pointer? Aborting backtrace
>
> Since it seems that mysqld from binary RPM cannot print a stack
> backtrace, has somebody an idea of what could be the cause of
> this problem ?
>
> I assume that mysqld has got some kind of "out of memory" error.
> However, it is running on a dedicated server with 2Gb of RAM and
> top or vmstat report ~1Gb of free memory. Is it possible that this
> is due to some mysqld incorrect configuration variable ?
>
> Here is the output of 'mysqladmin variables':
>
> | ansi_mode | OFF
> | back_log | 50
> | basedir | /
> | binlog_cache_size | 32768
> | character_set | latin1
> | character_sets | latin1 big5 czech euc_kr gb2312
> | concurrent_insert | OFF
> | connect_timeout | 5
> | datadir | /msqldb/mysql/
> | delay_key_write | OFF
> | delayed_insert_limit | 100
> | delayed_insert_timeout | 300
> | delayed_queue_size | 1000
> | flush | OFF
> | flush_time | 0
> | have_bdb | NO
> | have_gemini | NO
> | have_innobase | NO
> | have_isam | YES
> | have_raid | NO
> | have_ssl | NO
> | init_file |
> | interactive_timeout | 28800
> | join_buffer_size | 131072
> | key_buffer_size | 536866816
> | language | /usr/share/mysql/english/
> | large_files_support | ON
> | locked_in_memory | OFF
> | log | OFF
> | log_update | OFF
> | log_bin | OFF
> | log_slave_updates | OFF
> | long_query_time | 10
> | low_priority_updates | OFF
> | lower_case_table_names | 0
> | max_allowed_packet | 1047552
> | max_binlog_cache_size | 4294967295
> | max_connections | 1000
> | max_connect_errors | 10
> | max_delayed_threads | 20
> | max_heap_table_size | 16777216
> | max_join_size | 4294967295
> | max_sort_length | 1024
> | max_tmp_tables | 32
> | max_write_lock_count | 4294967295
> | myisam_recover_options | OFF
> | myisam_sort_buffer_size | 8388608
> | net_buffer_length | 16384
> | net_read_timeout | 30
> | net_retry_count | 10
> | net_write_timeout | 60
> | open_files_limit | 0
> | pid_file | /var/lib/mysql/mysql.pid
> | port | 3306
> | protocol_version | 10
> | record_buffer | 131072
> | query_buffer_size | 0
> | safe_show_database | OFF
> | server_id | 0
> | skip_locking | ON
> | skip_networking | OFF
> | skip_show_database | OFF
> | slow_launch_time | 2
> | socket | /var/lib/mysql/mysql.sock
> | sort_buffer | 2097144
> | table_cache | 64
> | table_type | MYISAM
> | thread_cache_size | 0
> | thread_stack | 131072
> | timezone | CET
> | tmp_table_size | 1048576
> | tmpdir | /msqldb/mysql/tmp/
> | version | 3.23.30-gamma
> | wait_timeout | 28800
>
> Hardware platform :
> Dell PowerEdge 2450 bipro PIII/733
> (running in sigle CPU mode),
> 2Gb RAM,
> integrated hardware RAID crontroller (PERC3)
> with 2x18Gb disks configured
> in RAID1 (mirroring) mode.
>
> Operating system:
> Linux RedHat 6.2 (kernel 2.2.14)
>
> MySQL version:
> 3.23.32 from binary RPM (MySQL-3.23.30-1.i386.rpm)
>
> Thanks for your help
> --
> Joseph Bueno
> NetClub/Trader.com
Hi!
Signal 11 is SIGSEGV.
As you are using our binary, it would be nice if you could make a
reproducible test case that would always crash mysql.
If you succeed in it, please send your report to [EMAIL PROTECTED]
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
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
