>Description: I can connect to mysqld and execute queries on the local system via the Unix socket, /tmp/mysql.sock. However, when I attempt to connect via a network connection, the connection fails, and the server restarts. I get the following failure message:
mysqladmin: connect to server at 'ballista.haightlife.com' failed error: 'Lost connection to MySQL server during query' My <hostname>.err file provides no indication of what is happening, just confirms that the server is restarting: ballista# tail -25 ballista.err /usr/local/libexec/mysqld: ready for connections 030202 00:53:01 mysqld restarted /usr/local/libexec/mysqld: ready for connections 030202 00:53:11 mysqld restarted [...] /usr/local/libexec/mysqld: ready for connections 030202 0:57:18 /usr/local/libexec/mysqld: Normal shutdown 030202 0:57:18 /usr/local/libexec/mysqld: Shutdown Complete 030202 00:57:18 mysqld ended 030202 00:58:09 mysqld started /usr/local/libexec/mysqld: ready for connections Nothing on the MySQL Manual page A.2.2, <http://www.mysql.com/doc/en/Gone_away.html>, appears to help me. My installation was a straight make/make install of the FreeBSD 4.7-STABLE port for MySQL 3.23.x (details below). My system *is* listening on the default port, and my client software can actually connect to a server running on a separate system -- just not to itself: ballista# netstat -an Active Internet connections (including servers) Proto Recv-Q Send-Q Local Address Foreign Address (state) tcp4 0 0 66.219.82.2.1061 66.219.82.3.3306 ESTABLISHED tcp4 0 0 *.3306 *.* LISTEN [...] >How-To-Repeat: <code/input/activities to reproduce the problem (multiple lines)> ballista# hostname ballista.haightlife.com ballista# mysqladmin -p -h `hostname` version Enter password: mysqladmin: connect to server at 'ballista.haightlife.com' failed error: 'Lost connection to MySQL server during query' ballista# mysqladmin -p -h 66.219.82.2 version Enter password: mysqladmin: connect to server at '66.219.82.2' failed error: 'Lost connection to MySQL server during query' ballista# mysqladmin -p --socket=/tmp/mysql.sock version Enter password: mysqladmin Ver 8.23 Distrib 3.23.53, for portbld-freebsd4.7 on i386 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.53 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 4 min 58 sec Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.003 Additional info: ballista# mysqladmin -p variables Enter password: +---------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+ | Variable_name | Value | +---------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+ | back_log | 50 | | basedir | /usr/local/ | | bdb_cache_size | 8388600 | | bdb_log_buffer_size | 32768 | | bdb_home | /var/db/mysql/ | | bdb_max_lock | 10000 | | bdb_logdir | | | bdb_shared_data | OFF | | bdb_tmpdir | /var/tmp/ | | bdb_version | Sleepycat Software: Berkeley DB 3.2.9a: (October 10, 2002) | | binlog_cache_size | 32768 | | character_set | latin1 | | character_sets | latin1 dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 | | concurrent_insert | ON | | connect_timeout | 5 | | datadir | /var/db/mysql/ | | delay_key_write | ON | | delayed_insert_limit | 100 | | delayed_insert_timeout | 300 | | delayed_queue_size | 1000 | | flush | OFF | | flush_time | 0 | | have_bdb | YES | | have_gemini | NO | | have_innodb | DISABLED | | have_isam | YES | | have_raid | NO | | have_openssl | NO | | init_file | | | innodb_additional_mem_pool_size | 1048576 | | innodb_buffer_pool_size | 8388608 | | innodb_data_file_path | | | innodb_data_home_dir | | | innodb_file_io_threads | 4 | | innodb_force_recovery | 0 | | innodb_thread_concurrency | 8 | | innodb_flush_log_at_trx_commit | 0 | | innodb_fast_shutdown | ON | | innodb_flush_method | | | innodb_lock_wait_timeout | 50 | | 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_mirrored_log_groups | 1 | | interactive_timeout | 28800 | | join_buffer_size | 131072 | | key_buffer_size | 8388600 | | language | /usr/local/share/mysql/english/ | | large_files_support | ON | | log | OFF | | log_update | OFF | | log_bin | OFF | | log_slave_updates | OFF | | log_long_queries | OFF | | long_query_time | 10 | | low_priority_updates | OFF | | lower_case_table_names | 0 | | max_allowed_packet | 1048576 | | max_binlog_cache_size | 4294967295 | | max_binlog_size | 1073741824 | | max_connections | 100 | | max_connect_errors | 10 | | max_delayed_threads | 20 | | max_heap_table_size | 16777216 | | max_join_size | 4294967295 | | max_sort_length | 1024 | | max_user_connections | 0 | | max_tmp_tables | 32 | | max_write_lock_count | 4294967295 | | myisam_max_extra_sort_file_size | 256 | | myisam_max_sort_file_size | 2047 | | myisam_recover_options | 0 | | myisam_sort_buffer_size | 8388608 | | net_buffer_length | 16384 | | net_read_timeout | 30 | | net_retry_count | 1000000 | | net_write_timeout | 60 | | open_files_limit | 0 | | pid_file | /var/db/mysql/ballista.pid | | port | 3306 | | protocol_version | 10 | | record_buffer | 131072 | | record_rnd_buffer | 131072 | | query_buffer_size | 0 | | safe_show_database | OFF | | server_id | 0 | | slave_net_timeout | 3600 | | skip_locking | OFF | | skip_networking | OFF | | skip_show_database | OFF | | slow_launch_time | 2 | | socket | /tmp/mysql.sock | | sort_buffer | 2097144 | | sql_mode | 0 | | table_cache | 64 | | table_type | MYISAM | | thread_cache_size | 0 | | thread_stack | 65536 | | transaction_isolation | READ-COMMITTED | | timezone | PST | | tmp_table_size | 33554432 | | tmpdir | /var/tmp/ | | version | 3.23.53 | | wait_timeout | 28800 | +---------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+ >Fix: None known. >Submitter-Id: <submitter ID> >Originator: Michael Alderete >Organization: Self. >MySQL support: none >Synopsis: mysqld restarts when connected at port 3306, fine on mysql.sock >Severity: serious >Priority: medium >Category: mysql >Class: support >Release: mysql-3.23.53 (FreeBSD port: mysql-server-3.23.53_4) >Environment: <machine, os, target, libraries (multiple lines)> System: FreeBSD ballista.haightlife.com 4.7-STABLE FreeBSD 4.7-STABLE #0: Thu Dec 5 03:23:36 PST 2002 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/GENERIC i386 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.4 20020320 [FreeBSD] Compilation info: CC='cc' CFLAGS='-O -pipe ' CXX='cc' CXXFLAGS='-O -pipe -felide-constructors -fno-rtti -fno-exceptions' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1223420 Dec 5 03:41 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Dec 5 03:41 /usr/lib/libc.so -> libc.so.4 -r--r--r-- 1 root wheel 577788 Dec 5 03:41 /usr/lib/libc.so.4 Configure command: ./configure --localstatedir=/var/db/mysql --without-perl --without-debug --without-readline --without-bench --with-mit-threads=no --with-libwrap --with-low-memory '--with-comment=FreeBSD port: mysql-server-3.23.53_4' --program-prefix= --with-innodb --enable-assembler --with-berkeley-db --prefix=/usr/local i386-portbld-freebsd4.7 'CFLAGS=-O -pipe ' CXX=cc host_alias=i386-portbld-freebsd4.7 build_alias=i386-portbld-freebsd4.7 target_alias=i386-portbld-freebsd4.7 CC=cc 'CXXFLAGS=-O -pipe -felide-constructors -fno-rtti -fno-exceptions' Perl: This is perl, version 5.005_03 built for i386-freebsd -- Michael A. Alderete <mailto:[EMAIL PROTECTED]> voice: (415) 861-5758 <http://www.michaelandrochelle.com/about/michael/blog> --------------------------------------------------------------------- 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
