Hi,

MySQL-4.0.1 is still crashing for me.

How-to-repeat :

mysql> flush query cache; ERROR 2013: Lost connection to MySQL server during query mysql> Number of processes running now: 0 011214 15:39:02 mysqld restarted

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=268431360 record_buffer=258048 sort_buffer=262136 max_used_connections=79 max_connections=320 threads_connected=60 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 424697 K bytes of memory Hope that's ok; if not, decrease some variables in the equation.

Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x807839b _Z15handle_segfaulti + 571 0x8141238 pthread_sighandler + 160 0x80e3920 _ZN11Query_cache12move_by_typeEPPcPP17Query_cache_blockPmS3_ + 16 0x80e0b93 _ZN11Query_cache4packEmj + 99 0x808154e _Z20reload_acl_and_cacheP3THDmP13st_table_list + 158 0x807f52a _Z21mysql_execute_commandv + 14010 0x807b273 _Z16dispatch_command19enum_server_commandP3THDPcj + 1347 0x807a5c1 _Z21handle_one_connectionPv + 1169 Stack trace seems successful - bottom reached Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0x879fc28 = flush query cache thd->thread_id=683

Successfully dumped variables, if you ran with --log, take a look at the details of what thread 683 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid.

The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash.

Number of processes running now: 0 011214 15:39:02 mysqld restarted /usr/local/mysql/libexec/mysqld: ready for connections

mysql> show status; +--------------------------+----------+ | Variable_name | Value | +--------------------------+----------+ | Aborted_clients | 658 | | Aborted_connects | 0 | | Bytes_received | 3884258 | | Bytes_sent | 14297813 | | Com_admin_commands | 0 | | Com_alter_table | 0 | | Com_analyze | 0 | | Com_backup_table | 0 | | Com_begin | 0 | | Com_change_db | 1096 | | Com_change_master | 0 | | Com_check | 0 | | Com_commit | 0 | | Com_create_db | 0 | | Com_create_function | 0 | | Com_create_index | 0 | | Com_create_table | 0 | | Com_delete | 1751 | | Com_delete_multi | 0 | | Com_drop_db | 0 | | Com_drop_function | 0 | | Com_drop_index | 0 | | Com_drop_table | 0 | | Com_flush | 0 | | Com_grant | 0 | | Com_ha_close | 0 | | Com_ha_open | 0 | | Com_ha_read | 0 | | Com_insert | 400 | | Com_insert_select | 0 | | Com_kill | 0 | | Com_load | 0 | | Com_load_master_data | 0 | | Com_load_master_table | 0 | | Com_lock_tables | 0 | | Com_optimize | 0 | | Com_purge | 0 | | Com_rename_table | 0 | | Com_repair | 0 | | Com_replace | 922 | | Com_replace_select | 47 | | Com_reset | 0 | | Com_restore_table | 0 | | Com_revoke | 0 | | Com_rollback | 0 | | Com_select | 13671 | | Com_set_option | 0 | | Com_show_binlog_events | 0 | | Com_show_binlogs | 0 | | Com_show_create | 0 | | Com_show_databases | 0 | | Com_show_fields | 0 | | Com_show_grants | 0 | | Com_show_keys | 0 | | Com_show_logs | 0 | | Com_show_master_stat | 0 | | Com_show_new_master | 0 | | Com_show_open_tables | 0 | | Com_show_processlist | 0 | | Com_show_slave_hosts | 0 | | Com_show_slave_stat | 0 | | Com_show_status | 1039 | | Com_show_tables | 1 | | Com_show_variables | 0 | | Com_slave_start | 0 | | Com_slave_stop | 0 | | Com_truncate | 0 | | Com_unlock_tables | 0 | | Com_update | 1717 | | Connections | 731 | | Created_tmp_disk_tables | 0 | | Created_tmp_tables | 0 | | Created_tmp_files | 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Delayed_errors | 0 | | Flush_commands | 1 | | Handler_delete | 44 | | Handler_read_first | 835 | | Handler_read_key | 25759 | | Handler_read_next | 659255 | | Handler_read_prev | 98034 | | Handler_read_rnd | 9747 | | Handler_read_rnd_next | 315211 | | Handler_update | 1951 | | Handler_write | 3037 | | Key_blocks_used | 9866 | | Key_read_requests | 171734 | | Key_reads | 9827 | | Key_write_requests | 1859 | | Key_writes | 1779 | | Max_used_connections | 78 | | Not_flushed_key_blocks | 0 | | Not_flushed_delayed_rows | 0 | | Open_tables | 115 | | Open_files | 171 | | Open_streams | 0 | | Opened_tables | 121 | | Questions | 41035 | | Qcache_queries_in_cache | 2116 | | Qcache_inserts | 12963 | | Qcache_hits | 21418 | | Qcache_not_cached | 708 | | Qcache_free_memory | 13588828 | | Qcache_free_blocks | 75 | | Qcache_total_blocks | 4468 | | Rpl_status | NULL | | Select_full_join | 0 | | Select_full_range_join | 0 | | Select_range | 241 | | Select_range_check | 0 | | Select_scan | 1307 | | Slave_running | OFF | | Slave_open_temp_tables | 0 | | Slow_launch_threads | 0 | | Slow_queries | 0 | | Sort_merge_passes | 0 | | Sort_range | 48 | | Sort_rows | 9698 | | Sort_scan | 969 | | Table_locks_immediate | 18510 | | Table_locks_waited | 50 | | Threads_cached | 18 | | Threads_created | 79 | | Threads_connected | 61 | | Threads_running | 1 | | Uptime | 168 | +--------------------------+----------+

Best Regards,

Jocelyn Fournier Presence-PC