Re: localhost vs. 127.0.0.1 error: 'Lost connection to MySQL server during query'
=20 | | slave_net_timeout | 3600 =20 | | slave_transaction_retries | 0=20 | | slow_launch_time| 2=20 | | socket | /var/run/mysqld/mysqld.sock =20 | | sort_buffer_size| 2097144 =20 | | sql_mode| =20 | | storage_engine | MyISAM =20 | | sql_notes | ON =20 | | sql_warnings| ON =20 | | sync_binlog | 0=20 | | sync_replication| 0=20 | | sync_replication_slave_id | 0=20 | | sync_replication_timeout| 0=20 | | sync_frm| ON =20 | | system_time_zone| EST =20 | | table_cache | 64 =20 | | table_type | MyISAM =20 | | thread_cache_size | 0=20 | | thread_stack| 131072 =20 | | time_format | %H:%i:%s =20 | | time_zone | SYSTEM =20 | | tmp_table_size | 33554432 =20 | | tmpdir | /tmp =20 | | transaction_alloc_block_size| 8192 =20 | | transaction_prealloc_size | 4096 =20 | | tx_isolation| REPEATABLE-READ =20 | | version | 4.1.11-Debian_4sarge2-log=20 | | version_bdb | Sleepycat Software: Berkeley DB 4.1.24: (April 1, 2005) | | version_comment | Source distribution =20 | | version_compile_machine | i386 =20 | | version_compile_os | pc-linux-gnu =20 | | wait_timeout| 28800=20 | +-+= --+ [EMAIL PROTECTED]:~# cat /etc/hosts 127.0.0.1 localhost localhost.localdomain [EMAIL PROTECTED]:~# iptables --list Chain INPUT (policy ACCEPT) target prot opt source destination Chain FORWARD (policy ACCEPT) target prot opt source destination Chain OUTPUT (policy ACCEPT) target prot opt source destination [EMAIL PROTECTED]:~# ipchains --list ipchains: Incompatible with this kernel [EMAIL PROTECTED]:~# telnet localhost 43306 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. Connection closed by foreign host. [EMAIL PROTECTED]:~# telnet 127.0.0.1 43306 Trying 127.0.0.1... Connected to 127.0.0.1. Escape character is '^]'. Connection closed by foreign host. [EMAIL PROTECTED]:~# netstat -an |grep LISTEN tcp0 0 0.0.0.0:22 0.0.0.0:* LISTEN tcp0 0 0.0.0.0:43306 0.0.0.0:* LISTEN Now for the fun part [EMAIL PROTECTED]:~# mysqladmin -h localhost -u root -p ping Enter password: mysqld is alive [EMAIL PROTECTED]:~# mysqladmin -h 127.0.0.1 -u root -p ping Enter password: mysqladmin: connect to server at '127.0.0.1' failed error: 'Lost connection to MySQL server during query' ok so my issue is the software that i am using is hardcoded to use 127.0.0.1 and not localhost. Even if i add the bind-address to my.cnf I still get the same error. If I bind it to an external ip address I then can still connect to localhost but not 127.0.0.1 nor the external IP adress
localhost vs. 127.0.0.1 error: 'Lost connection to MySQL server during query'
| | table_type | MyISAM | | thread_cache_size | 0 | | thread_stack| 131072 | | time_format | %H:%i:%s | | time_zone | SYSTEM | | tmp_table_size | 33554432 | | tmpdir | /tmp | | transaction_alloc_block_size| 8192 | | transaction_prealloc_size | 4096 | | tx_isolation| REPEATABLE-READ | | version | 4.1.11-Debian_4sarge2-log | | version_bdb | Sleepycat Software: Berkeley DB 4.1.24: (April 1, 2005) | | version_comment | Source distribution | | version_compile_machine | i386 | | version_compile_os | pc-linux-gnu | | wait_timeout| 28800 | +-+--+ [EMAIL PROTECTED]:~# cat /etc/hosts 127.0.0.1 localhost localhost.localdomain [EMAIL PROTECTED]:~# iptables --list Chain INPUT (policy ACCEPT) target prot opt source destination Chain FORWARD (policy ACCEPT) target prot opt source destination Chain OUTPUT (policy ACCEPT) target prot opt source destination [EMAIL PROTECTED]:~# ipchains --list ipchains: Incompatible with this kernel [EMAIL PROTECTED]:~# telnet localhost 43306 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. Connection closed by foreign host. [EMAIL PROTECTED]:~# telnet 127.0.0.1 43306 Trying 127.0.0.1... Connected to 127.0.0.1. Escape character is '^]'. Connection closed by foreign host. [EMAIL PROTECTED]:~# netstat -an |grep LISTEN tcp0 0 0.0.0.0:22 0.0.0.0:* LISTEN tcp0 0 0.0.0.0:43306 0.0.0.0:* LISTEN Now for the fun part [EMAIL PROTECTED]:~# mysqladmin -h localhost -u root -p ping Enter password: mysqld is alive [EMAIL PROTECTED]:~# mysqladmin -h 127.0.0.1 -u root -p ping Enter password: mysqladmin: connect to server at '127.0.0.1' failed error: 'Lost connection to MySQL server during query' ok so my issue is the software that i am using is hardcoded to use 127.0.0.1 and not localhost. Even if i add the bind-address to my.cnf I still get the same error. If I bind it to an external ip address I then can still connect to localhost but not 127.0.0.1 nor the external IP adress. Any ideas or point me to some good documentation on this would be great. I tried to search through several search engines but they all lead me nowhere, any help is appreciated. --Lance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error: Lost connection to MySQL Server during query AND MySQL has gone away
Client: MS Visual Basic 6.0 - ADO 2.5, Windows 2K Professional, Win 95, Win 98. Server: Redhat Linux 7.0, MySQL 3.23.41. For trouble shooting purposes, I've done the followings (as recommended by someone): 1) In Linux server, I run df - The useage for all filesystems are less than 50 %. 2) In Linux server, I run top - CPU and memory usage are low because I've only installed MySQL in Linux server. 3) In MySQL server, I run 'show processlist' - wait_timeout is 28800. I run VBasic in debug mode line by line. I noticed that the error message appeared (randomly) when I do the followings although the connection is still open (just before I open or insert a record): 1) open a recordset (small recordset with 1 record only) 2) do an 'Insert' record (of one record only) Before I open a recordset or insert a new record, I check the connection to make sure it's open. But when I open a recordset or insert a record, I got the above message. So When I got the error message, I immediately run 'show processlist' in the MySQL server. I noticed that the process ID was gone. I'm very sure no one manually kills the process id. It just went away. I also noticed the following: 1) In my RH Linux Server, when I ping my Windows clients, I got this message: 'Warning: time of day goes back, taking countermeasures.' I understand this is a Linux ping message and I've read the mailing list from Red Hat Linux. I'm just wondering if this ping is giving me a lead to something I've also read the MySQL mailing list regarding the above subject. It suggested 'wait_timeout', 'connection is close', etc. I've done that. Any hints? My colleage programmer and I are in trouble. We can't run our applications as scheduled! Thanks. John Chee - 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
Re: ERROR: Lost connection to MySQL server during query
Date |Fri, 24 Aug 2001 14:08:43 -0400 (EDT) From |boulat [EMAIL PROTECTED] Hello! B Hi group, B Im using the latest mySQL 3.23.41, ever since I installed the new B version I've been getting Lost connection to MySQL server during query B 50% of the time on my mySQL server. I have a load average of 247 queries B per second accordig to mysqladmin status. B Anyone experienced the same problem with mySQL? B Regards, B Boulat Looks like you need to increase queries packet buffer by start mysqld with -O max_alowed_packed=# http://www.mysql.com/doc/G/o/Gone_away.html ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ www.mysql.com - 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
ERROR: Lost connection to MySQL server during query
Hi group, Im using the latest mySQL 3.23.41, ever since I installed the new version I've been getting Lost connection to MySQL server during query 50% of the time on my mySQL server. I have a load average of 247 queries per second accordig to mysqladmin status. Anyone experienced the same problem with mySQL? Regards, Boulat - 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