Hi, Can you send some more output from the MySQL error log (normally located at /var/lib/mysq/[hostname].err) . Have you tried myisamchk to check the tables that are giving the errors? Also you might want to take a look at http://dev.mysql.com/doc/mysql/en/gone-away.html
On Wednesday 01 June 2005 12:04, Amir Shay wrote: > Hello, > > Each time we run long queries (over around 5 seconds) the mySQL server > fails and restarts (you can see it in the error log that starts with > "Database page corruption on disk or a fail......" and then there is a > dump...) and the query return with "Lost connection to MySQL server > during query..." > > Using Linux 9 with mySQL 4.1.11-standard the tables are InnoDB > > The error is happening from everywhere: mysql command line, Query > browser, from local and remote computers, running selects, insert and > even check table, EMS client . Java (see below the log) > > The problem is probably not in the network parameters, see list of the > variables below > > The database is quit big around 5 GB > > After the error the server restart automatically and continue to run for > the short queries > > We found one place where long queries work - when we run from the query > browser the same "select * from <some big table>..... However running > from the same place "check table..." reproduce the error !!!!!. Again > running the same "select * from <some big table>" from all the other > palaces cause the server to fall > > > Amir > > > Server parameters > > 'back_log', '50' > 'basedir', '/' > 'binlog_cache_size', '32768' > 'bulk_insert_buffer_size', '8388608' > 'character_set_client', 'utf8' > 'character_set_connection', 'utf8' > 'character_set_database', 'hebrew' > 'character_set_results', 'utf8' > 'character_set_server', 'hebrew' > 'character_set_system', 'utf8' > 'character_sets_dir', '/usr/share/mysql/charsets/' > 'collation_connection', 'utf8_general_ci' > 'collation_database', 'hebrew_general_ci' > 'collation_server', 'hebrew_general_ci' > 'concurrent_insert', 'ON' > 'connect_timeout', '100' > 'datadir', '/var/lib/mysql/' > 'date_format', '%Y-%m-%d' > 'datetime_format', '%Y-%m-%d %H:%i:%s' > 'default_week_format', '0' > 'delay_key_write', 'ON' > 'delayed_insert_limit', '100' > 'delayed_insert_timeout', '300' > 'delayed_queue_size', '1000' > 'expire_logs_days', '0' > 'flush', 'OFF' > 'flush_time', '0' > 'ft_boolean_syntax', '+ -><()~*:""&|' > 'ft_max_word_len', '84' > 'ft_min_word_len', '4' > 'ft_query_expansion_limit', '20' > 'ft_stopword_file', '(built-in)' > 'group_concat_max_len', '1024' > 'have_archive', 'NO' > 'have_bdb', 'NO' > 'have_blackhole_engine', 'NO' > 'have_compress', 'YES' > 'have_crypt', 'YES' > 'have_csv', 'NO' > 'have_example_engine', 'NO' > 'have_geometry', 'YES' > 'have_innodb', 'YES' > 'have_isam', 'NO' > 'have_ndbcluster', 'NO' > 'have_openssl', 'NO' > 'have_query_cache', 'YES' > 'have_raid', 'NO' > 'have_rtree_keys', 'YES' > 'have_symlink', 'YES' > 'init_connect', '' > 'init_file', '' > 'init_slave', '' > 'innodb_additional_mem_pool_size', '14680064' > 'innodb_autoextend_increment', '8' > 'innodb_buffer_pool_awe_mem_mb', '0' > 'innodb_buffer_pool_size', '1073741824' > 'innodb_data_file_path', 'ibdata1:10M:autoextend' > 'innodb_data_home_dir', '/var/lib/mysql' > 'innodb_fast_shutdown', 'ON' > 'innodb_file_io_threads', '4' > 'innodb_file_per_table', 'OFF' > 'innodb_flush_log_at_trx_commit', '1' > 'innodb_flush_method', '' > 'innodb_force_recovery', '0' > 'innodb_lock_wait_timeout', '50' > 'innodb_locks_unsafe_for_binlog', 'OFF' > 'innodb_log_arch_dir', '' > 'innodb_log_archive', 'OFF' > 'innodb_log_buffer_size', '1048576' > 'innodb_log_file_size', '5242880' > 'innodb_log_files_in_group', '2' > 'innodb_log_group_home_dir', './' > 'innodb_max_dirty_pages_pct', '90' > 'innodb_max_purge_lag', '0' > 'innodb_mirrored_log_groups', '1' > 'innodb_open_files', '300' > 'innodb_table_locks', 'ON' > 'innodb_thread_concurrency', '8' > 'interactive_timeout', '1000000' > 'join_buffer_size', '131072' > 'key_buffer_size', '8388600' > 'key_cache_age_threshold', '300' > 'key_cache_block_size', '1024' > 'key_cache_division_limit', '100' > 'language', '/usr/share/mysql/english/' > 'large_files_support', 'ON' > 'license', 'GPL' > 'local_infile', 'ON' > 'locked_in_memory', 'OFF' > > 'long_query_time', '10' > 'low_priority_updates', 'OFF' > 'lower_case_file_system', 'OFF' > 'lower_case_table_names', '1' > 'max_allowed_packet', '1047552' > 'max_binlog_cache_size', '4294967295' > 'max_binlog_size', '1073741824' > 'max_connect_errors', '10' > 'max_connections', '100' > 'max_delayed_threads', '20' > 'max_error_count', '64' > 'max_heap_table_size', '16777216' > 'max_insert_delayed_threads', '20' > 'max_join_size', '4294967295' > 'max_length_for_sort_data', '1024' > 'max_relay_log_size', '0' > 'max_seeks_for_key', '4294967295' > 'max_sort_length', '1024' > 'max_tmp_tables', '32' > 'max_user_connections', '0' > 'max_write_lock_count', '4294967295' > > 'net_buffer_length', '16384' > 'net_read_timeout', '30' > 'net_retry_count', '10' > 'net_write_timeout', '60' > 'new', 'OFF' > 'old_passwords', 'OFF' > 'open_files_limit', '1024' > 'pid_file', '/var/lib/mysql/mendelson.lotonet.local.pid' > 'port', '3306' > 'preload_buffer_size', '32768' > 'protocol_version', '10' > 'query_alloc_block_size', '8192' > 'query_cache_limit', '67108864' > 'query_cache_min_res_unit', '4096' > 'query_cache_size', '67108864' > 'query_cache_type', 'ON' > 'query_cache_wlock_invalidate', 'OFF' > 'query_prealloc_size', '8192' > 'range_alloc_block_size', '2048' > 'read_buffer_size', '131072' > 'read_only', 'OFF' > 'read_rnd_buffer_size', '262144' > 'relay_log_purge', 'ON' > 'relay_log_space_limit', '0' > 'rpl_recovery_rank', '0' > 'secure_auth', 'OFF' > 'server_id', '0' > 'skip_external_locking', 'ON' > 'skip_networking', 'OFF' > 'skip_show_database', 'OFF' > 'slave_net_timeout', '3600' > 'slave_transaction_retries', '0' > 'slow_launch_time', '2' > 'socket', '/var/lib/mysql/mysql.sock' > 'sort_buffer_size', '2097144' > 'sql_mode', '' > 'storage_engine', 'MyISAM' > 'sql_notes', 'OFF' > 'sql_warnings', 'OFF' > > 'table_cache', '64' > 'table_type', 'MyISAM' > 'thread_cache_size', '0' > 'thread_stack', '131072' > > 'time_zone', 'SYSTEM' > 'tmp_table_size', '33554432' > 'tmpdir', '' > 'transaction_alloc_block_size', '8192' > 'transaction_prealloc_size', '4096' > 'tx_isolation', 'REPEATABLE-READ' > 'version', '4.1.11-standard-log' > 'version_comment', 'MySQL Community Edition - Standard (GPL)' > 'version_compile_machine', 'i686' > 'version_compile_os', 'pc-linux-gnu' > 'wait_timeout', '28800' > > > Java error log > > com.mysql.jdbc.CommunicationsException: Communications link failure due > to underlying exception: > > ** BEGIN NESTED EXCEPTION ** > > java.io.EOFException > > STACKTRACE: > > java.io.EOFException > at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1842) > at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2341) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2784) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:750) > at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1251) > at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2209) > at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:413) > at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:1899) > at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1347) -- Dobromir Velev [EMAIL PROTECTED] http://www.websitepulse.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]