What can I do to find the cause / correct the following problem?
More often I get the following with Connector/J:
error 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:1619)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1828)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2179)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1412)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1124)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:804)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1559)
at akey.util.cddb.CddbMysqlInterface.getGenreId(CddbMysqlInterface.java:245)
at akey.util.cddb.CddbDatabaseInterface.insertEntry(CddbDatabaseInterface.java:88)
at akey.jmbase.ImportWorker.construct(ImportPanel.java:271)
at akey.util.SwingWorker$2.run(SwingWorker.java:131)
at java.lang.Thread.run(Thread.java:534)
** END NESTED EXCEPTION **
This is not exactly reproducable, but it often happens. The server seems to have stopped. (must be restarted). Sometiomes, it only seems to loop and no connection is possible any more.
This happens with normal connects, also when using pipes. Mysql error log does not show anything.
Windows 2000 Connector/J is 3.1.1 alpha Mysql 5.0
Mysql.ini:
[mysqld] basedir=C:/mysql datadir=C:/mysql/data enable-named-pipe
key_buffer_size=16M read_buffer_size=1M sort_buffer=1M record_buffer=2M
log-error log-warnings
# bypass BDB table support skip-bdb
default-character-set=latin1 # multilingual latin1 default-collation=latin1_general_ci
language=german
transaction-isolation=REPEATABLE-READ
# settings for InnoDB innodb_data_home_dir = # Data files must be able to # hold your data and indexes innodb_data_file_path = C:/mysql/data/InnoDB_TableSpaces:10M:autoextend # Set buffer pool size to # 50 - 80 % of your computer's # memory, but make sure on Linux # x86 total memory usage is # < 2 GB innodb_buffer_pool_size=10M innodb_additional_mem_pool_size=3M innodb_log_group_home_dir = D:/mySQL_Logs/InnoDB # .._log_arch_dir must be the same # as .._log_group_home_dir innodb_log_arch_dir = D:/mySQL_Logs/InnoDB innodb_log_files_in_group=2 innodb_mirrored_log_groups=1 # Set the log file size to about # 15 % of the buffer pool size innodb_log_file_size=10M innodb_log_buffer_size=2M # Set ..flush_log_at_trx_commit to # 0 if you can afford losing # some last transactions innodb_flush_log_at_trx_commit=0 innodb_lock_wait_timeout=50 innodb_thread_concurrency=4
max_allowed_packet=17824768
Report: This Report was made using the WinMySQLAdmin 1.4 Tool
29.02.2004 17:16:15
Description :
How-To-Repeat :
Fix :
Synopsis :
Submitter-Id :
Originator :
Organization :
MySQL support : [none | licence | email support | extended email support ]
Severity : [non-critical | serious | critical ]
Priority : [low | medium | high ]
Category : [mysqld, mysql client, C, PHP, PERL, ...]
Class : [ sw-bug | doc-bug | change-request | support ]
OS Platform : Windows 2000 Service Pack 4
Machine description:
Compiler : VC++ 6.0
Architecture : i686
Total Memory : 523760 KB RAM
My.ini File
[mysqld] basedir=C:/mysql datadir=C:/mysql/data enable-named-pipe key_buffer_size=16M read_buffer_size=1M sort_buffer=1M record_buffer=2M log-error log-warnings skip-bdb default-character-set=latin1 default-collation=latin1_general_ci language=german transaction-isolation=REPEATABLE-READ innodb_data_home_dir= innodb_data_file_path=C:/mysql/data/InnoDB_TableSpaces:10M:autoextend innodb_buffer_pool_size=10M innodb_additional_mem_pool_size=3M innodb_log_group_home_dir=D:/mySQL_Logs/InnoDB innodb_log_arch_dir=D:/mySQL_Logs/InnoDB innodb_log_files_in_group=2 innodb_mirrored_log_groups=1 innodb_log_file_size=10M innodb_log_buffer_size=2M innodb_flush_log_at_trx_commit=0 innodb_lock_wait_timeout=50 innodb_thread_concurrency=4 max_allowed_packet=17824768
Server Status Values
Server Info 5.0.0-alpha-max-nt Host Info localhost via TCP/IP Client Info 5.0.0-alpha Proto Info 10 Aborted_clients 0 Aborted_connects 0 Bytes_received 857 Bytes_sent 82287 Com_admin_commands 0 Com_alter_db 0 Com_alter_table 0 Com_analyze 0 Com_backup_table 0 Com_begin 0 Com_change_db 0 Com_change_master 0 Com_check 0 Com_checksum 0 Com_commit 0 Com_create_db 0 Com_create_function 0 Com_create_index 0 Com_create_table 0 Com_delete 0 Com_delete_multi 0 Com_do 0 Com_drop_db 0 Com_drop_function 0 Com_drop_index 0 Com_drop_table 0 Com_drop_user 0 Com_flush 0 Com_grant 0 Com_ha_close 0 Com_ha_open 0 Com_ha_read 0 Com_help 0 Com_insert 0 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 3 Com_preload_keys 0 Com_purge 0 Com_purge_before_date 0 Com_rename_table 0 Com_repair 0 Com_replace 0 Com_replace_select 0 Com_reset 0 Com_restore_table 0 Com_revoke 0 Com_revoke_all 0 Com_rollback 0 Com_savepoint 0 Com_select 0 Com_set_option 1 Com_show_binlogs 0 Com_show_binlog_events 0 Com_show_charsets 0 Com_show_collations 0 Com_show_column_types 0 Com_show_create_table 0 Com_show_create_db 0 Com_show_databases 1 Com_show_errors 0 Com_show_fields 0 Com_show_grants 0 Com_show_innodb_status 0 Com_show_keys 0 Com_show_logs 0 Com_show_master_status 0 Com_show_new_master 0 Com_show_open_tables 0 Com_show_privileges 0 Com_show_processlist 22 Com_show_slave_hosts 0 Com_show_slave_status 0 Com_show_status 23 Com_show_storage_engines 0 Com_show_tables 0 Com_show_variables 1 Com_show_warnings 0 Com_slave_start 0 Com_slave_stop 0 Com_truncate 0 Com_unlock_tables 0 Com_update 0 Com_update_multi 0 Connections 3 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_commit 0 Handler_delete 0 Handler_read_first 1 Handler_read_key 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 0 Handler_read_rnd_next 11 Handler_rollback 0 Handler_update 0 Handler_write 0 Key_blocks_not_flushed 0 Key_blocks_used 14347 Key_read_requests 35231 Key_reads 35226 Key_write_requests 0 Key_writes 0 Max_used_connections 1 Not_flushed_delayed_rows 0 Open_tables 0 Open_files 0 Open_streams 0 Opened_tables 17 Questions 51 Qcache_queries_in_cache 0 Qcache_inserts 0 Qcache_hits 0 Qcache_lowmem_prunes 0 Qcache_not_cached 0 Qcache_free_memory 0 Qcache_free_blocks 0 Qcache_total_blocks 0 Rpl_status NULL Select_full_join 0 Select_full_range_join 0 Select_range 0 Select_range_check 0 Select_scan 0 Slave_open_temp_tables 0 Slave_running OFF Slow_launch_threads 0 Slow_queries 0 Sort_merge_passes 0 Sort_range 0 Sort_rows 0 Sort_scan 0 Table_locks_immediate 17 Table_locks_waited 0 Threads_cached 0 Threads_created 2 Threads_connected 2 Threads_running 1 Uptime 793
Variables Values
back_log 50
basedir C:\mysql\
bdb_cache_size 8388600
bdb_log_buffer_size 0
bdb_home bdb_max_lock 10000
bdb_logdir bdb_shared_data OFF
bdb_tmpdir binlog_cache_size 32768
bulk_insert_buffer_size 8388608
character_set_server latin1
character_set_system utf8
character_set_database latin1
character_set_client latin1
character_set_connection latin1
character-sets-dir C:\mysql\share\charsets/
character_set_results latin1
collation_connection latin1_general_ci
collation_database latin1_general_ci
collation_server latin1_general_ci
concurrent_insert ON
connect_timeout 5
datadir C:\mysql\data\
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 1800
ft_boolean_syntax + -><()~*:""&|
ft_min_word_len 4
ft_max_word_len 84
ft_query_expansion_limit 20
ft_stopword_file (built-in)
have_bdb DISABLED
have_crypt NO
have_compress YES
have_innodb YES
have_isam NO
have_raid NO
have_symlink YES
have_openssl NO
have_query_cache YES
init_file init_connect init_slave innodb_additional_mem_pool_size 3145728
innodb_buffer_pool_size 10485760
innodb_buffer_pool_awe_mem_mb 0
innodb_data_file_path C:/mysql/data/InnoDB_TableSpaces:10M:autoextend
innodb_data_home_dir innodb_file_io_threads 4
innodb_open_files 300
innodb_force_recovery 0
innodb_thread_concurrency 4
innodb_flush_log_at_trx_commit 0
innodb_fast_shutdown ON
innodb_file_per_table OFF
innodb_flush_method innodb_lock_wait_timeout 50
innodb_log_arch_dir D:\mySQL_Logs\InnoDB
innodb_log_archive OFF
innodb_log_buffer_size 2097152
innodb_log_file_size 10485760
innodb_log_files_in_group 2
innodb_log_group_home_dir D:\mySQL_Logs\InnoDB
innodb_mirrored_log_groups 1
innodb_max_dirty_pages_pct 90
interactive_timeout 28800
join_buffer_size 131072
key_buffer_size 16777216
key_cache_block_size 1024
key_cache_division_limit 100
key_cache_age_threshold 300
language C:\mysql\share\german\
large_files_support ON
local_infile ON
log OFF
log_update OFF
log_bin OFF
log_slave_updates OFF
log_slow_queries OFF
log_warnings ON
long_query_time 10
low_priority_updates OFF
lower_case_table_names ON
max_allowed_packet 17823744
max_binlog_cache_size 4294967295
max_binlog_size 1073741824
max_connections 100
max_connect_errors 10
max_error_count 64
max_delayed_threads 20
max_heap_table_size 16777216
max_join_size 4294967295
max_relay_log_size 0
max_seeks_for_key 4294967295
max_length_for_sort_data 1024
max_sort_length 1024
max_user_connections 0
max_tmp_tables 32
max_write_lock_count 4294967295
myisam_max_extra_sort_file_size 268435456
myisam_max_sort_file_size 2147483647
myisam_repair_threads 1
myisam_recover_options OFF
myisam_sort_buffer_size 8388608
named_pipe ON
net_buffer_length 16384
net_read_timeout 30
net_retry_count 10
net_write_timeout 60
new OFF
old_passwords OFF
open_files_limit 0
pid_file C:\mysql\data\pcmaster.pid
log_error .\pcmaster.err
port 3306
protocol_version 10
preload_buffer_size 32768
pseudo_thread_id 2
query_alloc_block_size 8192
query_cache_limit 1048576
query_cache_min_res_unit 4096
query_cache_size 0
query_cache_type ON
secure_auth OFF
query_prealloc_size 8192
range_alloc_block_size 2048
read_buffer_size 2093056
read_only OFF
read_rnd_buffer_size 262144
relay_log_purge ON
rpl_recovery_rank 0
shared_memory OFF
shared_memory_base_name MYSQL
server_id 0
slave_net_timeout 3600
read_only OFF
skip_external_locking ON
skip_networking OFF
skip_show_database OFF
slow_launch_time 2
sort_buffer_size 1048568
sql_mode storage_engine MyISAM
table_cache 64
table_type MyISAM
thread_cache_size 0
thread_stack 196608
tx_isolation REPEATABLE-READ
time_format %H:%i:%s
timezone Westeurop?ische Normalzeit
tmp_table_size 33554432
tmpdir transaction_alloc_block_size 8192
transaction_prealloc_size 4096
version 5.0.0-alpha-max-nt
version_bdb Sleepycat Software: Berkeley DB 4.1.24: (December 21, 2003)
version_comment Source distribution
version_compile_machine i32
version_compile_os NT
wait_timeout 28800
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]