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

Reply via email to