[prev in list] [next in list] [prev in thread] [next in thread]
List: mysql
Subject: Communication link failure - MySQL Server seems to stop
From: hl <hlein () inode ! at>
Date: 2004-02-29 16:18:24
Message-ID: 404210D0.3070309 () inode ! at
[Download RAW message or body]
Hi,
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/mysql?unsub=mysql@progressive-comp.com
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic