Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

[Manuel Arostegui]

2014/1/7 h...@tbbs.net

  2014/01/06 17:07 +0100, Reindl Harald 
 what about look in the servers logfiles
 most likely max_allowed_packet laughable low
 
 Is this then, too, likly when the server and the client are the same
 machine?

 I left this out, that it only then happens when the client has been idle,
 and right afterwards the client repeats the request and all goes well. The
 message is no more than an irritatind break between request and fulfillment.

 Hello,

That happens when you're trying to re-use an existing connection which
wasn't properly closed and as you said, it's been idle. When you repeat the
operation, the thread is created again and thus everything goes normal.

Review the following variables

wait_timeout
net_write_timeout
net_read_timeout


Manu

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

[hsv]

 2014/01/06 17:07 +0100, Reindl Harald 
what about look in the servers logfiles
most likely max_allowed_packet laughable low 

Is this then, too, likly when the server and the client are the same machine?

I left this out, that it only then happens when the client has been idle, and 
right afterwards the client repeats the request and all goes well. The message 
is no more than an irritatind break between request and fulfillment.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

[Reindl Harald]

Am 06.01.2014 15:36, schrieb h...@tbbs.net:
 Now that I installed 5.6.14 on our Vista machine, when using mysql I often 
 see that error-message, which under 5.5.8 I never saw. What is going on?

what about look in the servers logfiles
most likely max_allowed_packet laughable low



signature.asc
Description: OpenPGP digital signature

Re: ERROR 2013 (HY000): - Why ?

[Claudio Nanni]

On 11/19/2012 10:27 AM, walter harms wrote:

hi List,
i get occasionally the following error:
ERROR 2013 (HY000): Lost connection to MySQL server at 'sending authentication 
information', system error: 32

$ perror 32
OS error code  32:  Broken pipe

Just to start.

If you want help you should include more details:

 * client used
 * server version
 * network topology
 * protocol used
 * etc


-- Claudio

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

[Blog Tieng Viet]

If you did not work directly on mysql server (login
by mysql command), please try this. 
Using script (PHP, ...) may lose connection, as my experience.

Best

--- On Mon, 3/5/12, Singer X.J. Wang w...@singerwang.com wrote:

 From: Singer X.J. Wang w...@singerwang.com
 Subject: Re: ERROR 2013 (HY000): Lost connection to MySQL server during query
 To: javad bakhshi javadbakh...@yahoo.com
 Cc: mysql@lists.mysql.com mysql@lists.mysql.com
 Date: Monday, March 5, 2012, 10:40 PM
 Checking your firewall settings..
 
 S
 
 
 On Mon, Mar 5, 2012 at 08:39, javad bakhshi javadbakh...@yahoo.com
 wrote:
 
  Hi,
 
  Still have the same problem and changing
 connect_timeout didn't help.
  Any other Ideas? Is there even any solution to this?
 
  Best regards,
  Javad Bakhshi,
 
 
  
   From: mail...@securitylabs.it
 mail...@securitylabs.it
  To: mysql@lists.mysql.com
  Sent: Thursday, March 1, 2012 11:09 AM
  Subject: Re: ERROR 2013 (HY000): Lost connection to
 MySQL server during
  query
 
  Il 01/03/2012 11:03, javad bakhshi ha scritto:
   Hi,
  
   I am trying to load data into my table from a very
 large file but after
  some time I get this error:
  
   ERROR 2013 (HY000): Lost connection to MySQL
 server during query
  
  
   My file size is around 4G and I have 220M lines in
 my file which have to
  be loaded in to my table. I have 10 of these files
 which have to loaded in
  the same table. My MySQL version is 5.1.59, I have
 changed the
  max_allowed_packet to 346030080.
  
   any ideas how I can solve this problem?
     Best regards,
   Javad Bakhshi,
  In order to resolve the problem you may need to
 increase these two values
  in mysql.ini or my.cnf, and restart mysql:
 
  wait_timeout = 28800
  connect_timeout = 28800
 
  -- MySQL General Mailing List
  For list archives: http://lists.mysql.com/mysql
  To unsubscribe:    http://lists.mysql.com/mysql
 
 
 -- 
 --
 Pythian proud winner of Oracle North America Titan Award for
 Exadata 
 Solution...watch the video on pythian.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

[javad bakhshi]

Hi,

Still have the same problem and changing connect_timeout didn't help. 
Any other Ideas? Is there even any solution to this?
 
Best regards,
Javad Bakhshi,



 From: mail...@securitylabs.it mail...@securitylabs.it
To: mysql@lists.mysql.com 
Sent: Thursday, March 1, 2012 11:09 AM
Subject: Re: ERROR 2013 (HY000): Lost connection to MySQL server during query
 
Il 01/03/2012 11:03, javad bakhshi ha scritto:
 Hi,
 
 I am trying to load data into my table from a very large file but after some 
 time I get this error:
 
 ERROR 2013 (HY000): Lost connection to MySQL server during query
 
 
 My file size is around 4G and I have 220M lines in my file which have to be 
 loaded in to my table. I have 10 of these files which have to loaded in the 
 same table. My MySQL version is 5.1.59, I have changed the  
 max_allowed_packet to 346030080.
 
 any ideas how I can solve this problem?
   Best regards,
 Javad Bakhshi,
In order to resolve the problem you may need to increase these two values in 
mysql.ini or my.cnf, and restart mysql:

wait_timeout = 28800
connect_timeout = 28800

-- MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

[Singer X.J. Wang]

Checking your firewall settings..

S


On Mon, Mar 5, 2012 at 08:39, javad bakhshi javadbakh...@yahoo.com wrote:

 Hi,

 Still have the same problem and changing connect_timeout didn't help.
 Any other Ideas? Is there even any solution to this?

 Best regards,
 Javad Bakhshi,


 
  From: mail...@securitylabs.it mail...@securitylabs.it
 To: mysql@lists.mysql.com
 Sent: Thursday, March 1, 2012 11:09 AM
 Subject: Re: ERROR 2013 (HY000): Lost connection to MySQL server during
 query

 Il 01/03/2012 11:03, javad bakhshi ha scritto:
  Hi,
 
  I am trying to load data into my table from a very large file but after
 some time I get this error:
 
  ERROR 2013 (HY000): Lost connection to MySQL server during query
 
 
  My file size is around 4G and I have 220M lines in my file which have to
 be loaded in to my table. I have 10 of these files which have to loaded in
 the same table. My MySQL version is 5.1.59, I have changed the
 max_allowed_packet to 346030080.
 
  any ideas how I can solve this problem?
Best regards,
  Javad Bakhshi,
 In order to resolve the problem you may need to increase these two values
 in mysql.ini or my.cnf, and restart mysql:

 wait_timeout = 28800
 connect_timeout = 28800

 -- MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/mysql


-- 
--
Pythian proud winner of Oracle North America Titan Award for Exadata 
Solution...watch the video on pythian.com

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

[mail...@securitylabs.it]

Il 01/03/2012 11:03, javad bakhshi ha scritto:

Hi,

I am trying to load data into my table from a very large file but after some 
time I get this error:

ERROR 2013 (HY000): Lost connection to MySQL server during query


My file size is around 4G and I have 220M lines in my file which have to be loaded in to my table. 
I have 10 of these files which have to loaded in the same table. 
My MySQL version is 5.1.59, I have changed the  max_allowed_packet to 346030080.


any ideas how I can solve this problem?
  
Best regards,

Javad Bakhshi,
In order to resolve the problem you may need to increase these two 
values in mysql.ini or my.cnf, and restart mysql:


wait_timeout = 28800
connect_timeout = 28800

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: Error 2013 (Lost Connection to MySQL Server) On A Solaris 10 Box

[Baron Schwartz]

Rajesh Mehrotra wrote:

Hi,
 
We copied over a test copy of a multi-GB database to a new Sun V440 box

running Solaris 10 (64-bit) with a 64-bit MySQL install. When trying to
connect to the database, we consistently get Error 2013.
 
Any pointers?


Check the server's error log and see if there's anything in it.

Baron

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query, 061220 14:48:44 mysqld restarted

[Kieran Kelleher]

I left out URL to source compilation procedure and flags in original  
message. Here it is:
http://homepage.mac.com/kelleherk/iblog/C711669388/E20061121141451/ 
index.html


ANy advice would be really appreciated.

Regards, Kieran

On Dec 20, 2006, at 3:08 PM, Kieran Kelleher wrote:

I have MySQL 4.1.22 source installation on a 1.66 Intel Core Duo  
Mac Mini running OS X Server 10.4.8. It is a slave replicating to a  
master over ssl. Replication works fine, however I get this error  
always if I execute the STOP SLAVE statement

([EMAIL PROTECTED]) (none) stop slave;
ERROR 2013 (HY000): Lost connection to MySQL server during query
([EMAIL PROTECTED]) (none) 061220 14:48:44  mysqld restarted

Also, if I execute mysqladmin shutdown, it restarts also
slmini:/usr/local admin$ mysqladmin -u root -p shutdown
Enter password:
slmini:/usr/local admin$ 061220 14:59:19  mysqld restarted

The source has been compiled with SSL feature.

I have exact same installation on a single CPU powerpc G4 XServe  
with no problems.


My installation procedure/flags are here:

Any ideas what the problem might be? Should I just rebuild the OS  
from scratch? Could it be corrupt data that needs to be recopied  
form the master? I'm baffled at this point.


Regards, Kieran

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql? 
[EMAIL PROTECTED]





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query, 061220 14:48:44 mysqld restarted

[Kieran Kelleher]

Replying to myself again...

OK, some more light on the subject. I did a complete dump of the  
master and reloaded the slave thinking maybe I had corrupt tables or  
something. Having started the slave with skip-start-slave, I found  
that I could stop mysqld on command line using mysqladmin without  
problems. As soon as I started the slave and tried to issue a stop  
slave, then the crash happened again. So basically the crash only  
happens if we try and stop the slave threads. This wouls explain why  
mysaadmin shutdown crashed when slave IO was on, but not when slave  
IO was stopped. Here is error I got this time for stop slave:


 stop slave;
ERROR 2013 (HY000): Lost connection to MySQL server during query
([EMAIL PROTECTED]) (none) /usr/local/mysql/bin/mysqld_safe: line  
1:   401 Illegal instruction nohup /usr/local/mysql/libexec/ 
mysqld --defaults-extra-file=/usr/local/mysql/data/my.cnf --basedir=/ 
usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid- 
file=/usr/local/mysql/data/slmini.local.pid --socket=/tmp/mysql.sock  
--skip-slave-start /usr/local/mysql/data/slmini.local.err 21

061220 16:02:05  mysqld restarted

Any ideas what could be wrong here or is this possibly a bug?

Regards, Kieran

On Dec 20, 2006, at 3:08 PM, Kieran Kelleher wrote:

I have MySQL 4.1.22 source installation on a 1.66 Intel Core Duo  
Mac Mini running OS X Server 10.4.8. It is a slave replicating to a  
master over ssl. Replication works fine, however I get this error  
always if I execute the STOP SLAVE statement

([EMAIL PROTECTED]) (none) stop slave;
ERROR 2013 (HY000): Lost connection to MySQL server during query
([EMAIL PROTECTED]) (none) 061220 14:48:44  mysqld restarted

Also, if I execute mysqladmin shutdown, it restarts also
slmini:/usr/local admin$ mysqladmin -u root -p shutdown
Enter password:
slmini:/usr/local admin$ 061220 14:59:19  mysqld restarted

The source has been compiled with SSL feature.

I have exact same installation on a single CPU powerpc G4 XServe  
with no problems.


My installation procedure/flags are here:

Any ideas what the problem might be? Should I just rebuild the OS  
from scratch? Could it be corrupt data that needs to be recopied  
form the master? I'm baffled at this point.


Regards, Kieran

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql? 
[EMAIL PROTECTED]





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

[古雷]

Hello

That version is quite old and is an alpha version. I think you can download a 
release for production use.

Gu Lei
- Original Message - 
From: murthy gandikota [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, June 08, 2006 9:04 PM
Subject: ERROR 2013 (HY000): Lost connection to MySQL server during query


 Hi,
 I am getting this error. Can anyone please help?
 
 mysql create table sfgbackup.advEmail select * from sfg.advEmail;
 ERROR 2013 (HY000): Lost connection to MySQL server during query
 Bye
 [EMAIL PROTECTED] mgandikota]$ mysql -V
 mysql  Ver 14.7 Distrib 5.0.2-alpha, for pc-linux (i686)
 
 
 Thanks
 Murthy
 
 __
 Do You Yahoo!?
 Tired of spam?  Yahoo! Mail has the best spam protection around 
 http://mail.yahoo.com

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

[Heikki Tuuri]

Marten,

can you email the complete .err log from the server to 
[EMAIL PROTECTED]


I am interested in what caused the very first crash in the server. Now your 
database seems to be seriously corrupt, since the log sequence number in the 
log files is only 14 MB, while it is = 153 MB in a data file!


Did you move around or delete ib_logfiles or ibdata files or .ibd files, or 
edit my.cnf while mysqld was running?


Are you using some exotic file system?

The output looks like ib_logfiles and data files from different servers 
would be mixed.


Best regards,

Heikki

Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL

InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM 
tables

http://www.innodb.com/order.php




- Original Message - 
From: Marten Lehmann [EMAIL PROTECTED]

Newsgroups: mailing.database.myodbc
Sent: Monday, March 27, 2006 3:46 PM
Subject: ERROR 2013 (HY000): Lost connection to MySQL server during query



Hello,

again, I'm having problems with InnoDB tables. A certain table cannot be
dropped. If I'm issueing the drop table statement, the connection is
lost and I get the following in the logfile:

060327 14:38:11  InnoDB: error: space object of table 
db15670/mw_pagelinks,

InnoDB: space id 12 did not exist in memory. Retrying an open.
InnoDB: Error: trying to add tablespace 12 of name
'./db15670/mw_pagelinks.ibd'
InnoDB: to the tablespace memory cache, but tablespace
InnoDB: 12 of name './db15720/admin.ibd' already exists in the tablespace
InnoDB: memory cache!
060327 14:38:11  InnoDB: Error: page 3 log sequence number 0 153218641
InnoDB: is in the future! Current system log sequence number 0 14322402.
InnoDB: Your database may be corrupt.
060327 14:38:11InnoDB: Assertion failure in thread 196621 in file
fsp0fsp.c line 3202
InnoDB: Failing assertion: xdes_get_bit(descr, XDES_FREE_BIT,
buf_frame_get_page_no(header) % FSP_EXTENT_SIZE, mtr) == FALSE
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/mysql/en/Forcing_recovery.html
InnoDB: about forcing recovery.
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly 
built,
or misconfigured. This error can also be caused by malfunctioning 
hardware.

We will try our best to scrape up some info that will hopefully help
diagnose
the problem, but since we have already crashed, something is definitely
wrong
and this may fail.

key_buffer_size=402653184
read_buffer_size=2093056
max_used_connections=12
max_connections=1000
threads_connected=5
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections
= 290904 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd=0x8a000c18
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0xbe1fbe08, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x80a43b4
0x82bf71c
0x820a5fd
0x81b64f5
0x8169f26
0x81a4bc7
0x81a4224
0x81a36c2
0x817f332
0x817e57d
0x819376b
0x8125411
0x811ba68
0x812abe0
0x812a500
0x80b76b2
0x80bbb72
0x80b54bd
0x80b5102
0x80b48f9
0x82bb001
0x82ed89a
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html and
follow instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd-query at 0x8bb38e0 = drop table mw_pagelinks
thd-thread_id=220
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.

Number of processes running now: 0
060327 14:38:12  mysqld restarted
060327 14:38:12  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.

The whole mysql-server crashed just because something is wrong in one
innodb table. The force-recovery-hint didn't help at all, because it
just made it possible do drop the table, but nothing was fixed and I
couldn't create the table back then.

Why does this happen?

Regards
Marten

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: 
http://lists.mysql.com/[EMAIL PROTECTED]





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 2013: Lost connection to MySQL server during query

[Michael Gale]

Hello,
	
	Thanks to all who applied but I was able to get access to the log file 
today. The server was shutting down and it seemed to be a performance 
problem.

I increased the RAM in the server and adjusted the Innodb settings to 
take advantage of this.

Now everything is much better.
Michael
Daniel Kasak wrote:
Michael Gale wrote:

Hello,
Earlier today I tried to make some table alterations on a mysql server
(4.0.24) and kept on receiving this error:
ERROR 2013: Lost connection to MySQL server during query
I would login to the server, either through the socket or using the
IP. Then connect to a database and try the following:
CREATE INDEX hostdate ON syslog (machine,date1);
There are about 3 million rows .. about a minute or two into the
command I would get disconnected. Sometimes I could log back but not
others, I tried seaching google and the only answer I found was This
is fix the in the next release of 5.X.X.
This does not help as I am stuck with 4.0.X right now.
How can I fix this ?
Michael
Is the server crashing? What does your error log say? If you're using
4.0.x, then my first hunch would be table corruption. Have you checked
for that yet?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 2013: Lost connection to MySQL server during query

[Daniel Kasak]

Michael Gale wrote:

 Hello,

 Earlier today I tried to make some table alterations on a mysql server
 (4.0.24) and kept on receiving this error:

 ERROR 2013: Lost connection to MySQL server during query

 I would login to the server, either through the socket or using the
 IP. Then connect to a database and try the following:

 CREATE INDEX hostdate ON syslog (machine,date1);

 There are about 3 million rows .. about a minute or two into the
 command I would get disconnected. Sometimes I could log back but not
 others, I tried seaching google and the only answer I found was This
 is fix the in the next release of 5.X.X.

 This does not help as I am stuck with 4.0.X right now.

 How can I fix this ?

 Michael

Is the server crashing? What does your error log say? If you're using
4.0.x, then my first hunch would be table corruption. Have you checked
for that yet?

-- 
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Error 2013

[Dathan Vance Pattishall]

http://dev.mysql.com/doc/mysql/en/Error-handling.html

I would look at your wait_timeout settings, if the mysqldump slept for
greater then this setting then this could be the cause of your error.

Why would the connection sleep? It has to flush the buffer to disk or
STDOUT.



DVP

Dathan Vance Pattishall http://www.friendster.com


 -Original Message-
 From: Emmett Bishop [mailto:[EMAIL PROTECTED]
 Sent: Monday, September 13, 2004 8:25 AM
 To: [EMAIL PROTECTED]
 Subject: Error 2013
 
 Howdy all,
 
 I got this error while running a routine mysqldump
 last night: Error 2013: Lost connection to MySQL
 server during query when dumping table `contact_log`
 at row: 41245
 
 I didn't find any good information on this error at
 mysql. Is there a page there that lists all error
 codes? I found one such page just for INNODB errors,
 but that doesn't help me much.
 
 Google didn't seem to have much either (mainly people
 asking the same question I'm asking now).
 
 Any insight on how to trouble shoot this error would
 be greatly appreciated.
 
 Cheers,
 
 Tripp
 
 
 
 
 
 __
 Do you Yahoo!?
 New and Improved Yahoo! Mail - 100MB free storage!
 http://promotions.yahoo.com/new_mail
 
 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
 http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 2013: Lost connection to MySQL server during query

[Batara Kesuma]

 I am running Debian sarge with MySQL 4.0.20. My problem is I can
 connect from localhost, but when I try to connect from other host this
 error comes up:
 ERROR 2013: Lost connection to MySQL server during query

Sorry I found the answer. I have ALL:ALL in hosts.deny 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: error 2013 : Lost connection to MySQL server during query

[Daniel Whitener]

Ok, it seems I fixed my problem before anybody was available to help me. 
The error was due to bad code -- the program was trying to send multiple 
queries through the same connection.  Even though it was compiled as 
thread safe, you still have to find some way to prevent concurrent 
queries on the same connection.  Anybody writing server-side applications 
using the C api, please beware of this issue.  I can suggest a few 
workarounds if anybody else out there is having the same problem with their 
C program.

Daniel
Daniel Whitener wrote:
Hello all,
I'm getting the error message 2013 : Lost connection to MySQL server 
during query during inserts on a lightly-loaded mysql server.  I also 
noticed the following error in the error log...

Version: '4.0.20-standard-log'  socket: '/tmp/mysql.sock'  port: 3306
040603 16:25:48  Aborted connection 1 to db: 'milterdb' user: 
'milteruser' host: `localhost' (Got an error reading communication packets)

I am going nuts trying to fix this error!  I've done some googling and 
the only fixes I've heard of are fixing name resolution errors.  I'm 
thinking that has nothing to do with this setup since 1000s of other 
inserts/queries are fine.  One second it is working, the next second it 
stops with this error.

The application interfaces with a Sendmail mail server and archives all 
incoming/outgoing email traffic to the MySQL database.  The source is 
available if anybody thinks my poor coding is the problem.

Any help or ideas will be greatly appreciated.
Thanks in advance!
Daniel Whitener

basic config info is below.  I can provide more details if needed...
I'm using suse 9.1
uranus:~ # uname -a
Linux uranus 2.6.4-52-default #1 Wed Apr 7 02:08:30 UTC 2004 i686 i686 
i386 GNU/Linux
uranus:~ #

mysql status;
--
mysql  Ver 12.22 Distrib 4.0.20, for pc-linux (i686)
Connection id:  15
Current database:
Current user:   [EMAIL PROTECTED]
SSL:Not in use
Current pager:  less
Using outfile:  ''
Server version: 4.0.20-standard-log
Protocol version:   10
Connection: Localhost via UNIX socket
Client characterset:latin1
Server characterset:latin1
UNIX socket:/tmp/mysql.sock
Uptime: 55 min 51 sec
Threads: 2  Questions: 313  Slow queries: 1  Opens: 11  Flush tables: 1 
Open tables: 5  Queries per second avg: 0.093

mysqld section of the my.cnf file...
# The MySQL server
[mysqld]
port= 3306
socket  = /tmp/mysql.sock
wait_timeout = 7200
interactive_timeout = 28800
skip-locking
key_buffer = 64M
max_allowed_packet = 10M
table_cache = 128
sort_buffer_size = 1M
read_buffer_size = 1M
net_buffer_length = 8K
myisam_sort_buffer_size = 16M
user = mysql
thread_stack = 1M
thread_cache = 8
query_cache_size = 16M
thread_concurrency = 4
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 2013

[Egor Egorov]

Mauricio Pellegrini [EMAIL PROTECTED] wrote:
 I'm using MySql 4.0.18 on Linux (SuSE 8.2)
 and I'm getting this error 
 
  ERROR 2013: Lost connection to MySQL server during query
 
 a few seconds after launching 
 the following command
 
 LOAD DATA LOCAL INFILE '/root/hc.txt' into table af_afiliados ;
 
 soon after that I repeat the command 
 
   mysql load data local infile /root/hc.txt into table
 af_afiliados;
 
 and the error seems to be slightly different
 
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id:6
Current database: hrrg
 
ERROR 2013: Lost connection to MySQL server during query
 
 Could  ERROR 2013 be generated by some inconsistency in the data stored 
 in /root/hc.txt file ? (this is a ASCII file,Which has been working
 perfectly till now, nonetheless there had been some changes into its
 data)
 

Check that it's not max_allowed_packet or wait_timeout issue:
http://dev.mysql.com/doc/mysql/en/Gone_away.html



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: ERROR 2013

[mysql]

This is just a shot in the dark, but I recall getting similar behavior
(error...lost connection...reconnect) when I was trying to LOAD DATA that
happened to violate foreign key constraints in my InnoDB tables.

Hope that helps.

---
Fyodor Golos
Stockworm, Inc.
 

-Original Message-
From: Mauricio Pellegrini [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, May 26, 2004 5:03 PM
To: [EMAIL PROTECTED]
Subject: ERROR 2013

Hi, 
I'm using MySql 4.0.18 on Linux (SuSE 8.2)
and I'm getting this error 

  ERROR 2013: Lost connection to MySQL server during query

a few seconds after launching 
the following command

 LOAD DATA LOCAL INFILE '/root/hc.txt' into table af_afiliados ;

soon after that I repeat the command 
 
   mysql load data local infile /root/hc.txt into table
af_afiliados;

and the error seems to be slightly different

ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id:6
Current database: hrrg

ERROR 2013: Lost connection to MySQL server during query

Could  ERROR 2013 be generated by some inconsistency in the data stored 
in /root/hc.txt file ? (this is a ASCII file,Which has been working
perfectly till now, nonetheless there had been some changes into its
data)


Any hint would be greatly appreciated..

Thanks
 Mauricio




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 2013 at line 7: Lost connection to MySQL server during query

[Victor Pendleton]

What is your max packet size? Are you able to determine where the `error`
occurs in the process? During the load of the temporary table? During the query
of the temp table?

 On Wed, 07 Apr 2004, Ginger Cheng wrote:
 Hello, MySQL gurus,
   I have been trying to output the result of some large query to a temporary 
 table and then query from there. But all my trials ended up 'ERROR 2013 at 
 line 7: Lost connection to MySQL server during query' before creating the 
 temporary table. The version of MySQL is 3.23.54, for redhat-linux-gnu 
 (i386). Does anyone have any idea of how to prevent this from happening?
   Thank you for help
   ginger
 
 
 -- 
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 2013 at line 7: Lost connection to MySQL server during query

[Ginger Cheng]

Hi,
	The max packet site is 1048576. But I don't think it is a problem cuz I 
have successfully outputted the result of this query before. I checked 
mysqld.log. This is the tail I think might related to the problem:

Number of processes running now: 0
040406 22:22:01  mysqld restarted
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables, add to the [mysqld]
section, for example,
innodb_data_file_path = ibdata1:10M:autoextend
But to get good performance you should adjust for your hardware
the InnoDB startup options listed in section 2 at
http://www.innodb.com/ibman.html
Does that mean it tried to create the tmp table as an innoDB table instead 
of MyISAM and I need to get innodb_data_file_path set to correct it?
	Thank you for help
	ginger

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 2013 at line 7: Lost connection to MySQL server during query

[Ginger Cheng]

I think this is the problem (cited from mysqld.log)

Some pointers may be invalid and cause the dump to abort...
followed by my query to create the tmp table
But I am not sure how to fix it.

ginger

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 2013 when using mysql client, Version 12.21

[Victoria Reznichenko]

Bungarz, Kai [EMAIL PROTECTED] wrote:
 When i'm using mysql client, version 12.21 - Distrib: 4.0.15 / windows,
 for queries or loading data, i always get an error 2013 (lost
 connection...)=20
 after 30 seconds and the connection breaks down.
 This doesn't happen, when i use the older version 11.16 , Distrib: =
 4.0.0 /
 windows.
 There is no parameter set for mysql client in our my.ini.=20
 Does anybody know the reason?

There was a bug in Windows client 4.0.15 that caused Lost connection error.
You should upgrade client program.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 2013 while using load data

[Egor Egorov]

Bungarz, Kai [EMAIL PROTECTED] wrote:
 Hi!
 I get error 2013: Lost connection to mysql server during query, while
 loading
 data into a table using load data infile...
 This happens only, when load data needs much time and files are 
 rather
 big.
 Is there any time_out parameter i have to set/change?

Yes, there are wait_timeout and interactive_timeout variables (default value is 28800 
seconds). Check also value of max_allowed_packet variable:
http://www.mysql.com/doc/en/Gone_away.html
http://www.mysql.com/doc/en/SHOW_VARIABLES.html



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 2013 2369 SegmentationFault

[Victoria Reznichenko]

Alexander K?ppe [EMAIL PROTECTED] wrote:
 Hi,
 I have trouble to connect from a remote host to the mysql-server.
 On localhost works all right.
 But when I want to establish a connection with
 pre
 mysql --host=server --user=com75778 --database=com75778 --pass
 Enter password:
 ERROR 2013: Lost connection to MySQL server during query
 /pre
 
 from another host, as the server, this error Message appears on client's 
 console.
 
 On every (failed) try to connect, an error message also appears on server's 
 console:
 pre
 /usr/bin/safe_mysqld: line 273:  2369 Segmentation fault  $NOHUP_NICENESS 
 $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR 
 $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21
 
 Number of processes running now: 1
 mysqld process hanging, pid 2372 - killed
 031018 22:11:51  mysqld restarted
 /pre
 
 Do someone know this problem and can help me.

What OS do you use? What is the version of MySQL? Did you install MySQL from binary 
distribution?


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 2013 during query

[Prasad Budim Ram]

Check the connection timeout parameter. Increase it if it's  low and try..

 W. Bauer [EMAIL PROTECTED] 10/16/2003 6:20:44 PM 
Dear all

When I run a query on a table with about 22 Mio records and three columns of
type bigint, I get a Error 2013  Lost connection to MySQL server during
query. If I use limit x it works fine as long x70.

Is there anything I can do to circumvent this error?

Thanks, W. Bauer

-- 
NEU FÜR ALLE - GMX MediaCenter - für Fotos, Musik, Dateien...
Fotoalbum, File Sharing, MMS, Multimedia-Gruß, GMX FotoService

Jetzt kostenlos anmelden unter http://www.gmx.net 

+++ GMX - die erste Adresse für Mail, Message, More! +++


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql 
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 2013:Lost connection to MySQL server

[Fred van Engen]

Hi,

On Tue, Jul 01, 2003 at 02:13:23PM -0500, Miguel Perez wrote:
 I have the following problem, when I try to connect to my DB servicios
 I get connected succesfully, but when I try to access certain tables I get 
 the error
 ERROR 2013: Lost connection to MySQL server during query but only with 
 those certain tables, to be more specific there's only 2 tables that i 
 can't access, I get that error,
 the other ones works fine.
 

Which version, which OS?


 Any ideas or suggestions.
 

Maybe mysqld crashes? It restarts automatically, on unices at least.

Check the mysql error log to find out if it crashed.


Regards,

Fred.

-- 
Fred van Engen  XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC  Almere
fax: +31 36 5462424 The Netherlands

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 2013:Lost connection to MySQL server

[Miguel Perez]

The OS I'm using is Red Hat 7.3, and the mysql version is 4.0

The wierd thing is that I could access those tables but just after I 
rebooted my PC
I couldn't access the 2 tables.
The log files has the following:

030701 14:27:38  InnoDB: Assertion failure in thread 36874 in file 
dict0load.c line 677
InnoDB: We intentionally generate a memory trap.
InnoDB: Send a detailed bug report to [EMAIL PROTECTED]
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help 
diagnose
the problem, but since we have already crashed, something is definitely 
wrong
and this may fail. thd=0x8711eb8
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0xbfe7e0c8, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x80741ea
0x8286058
0x81193b5
0x8108df8
0x80cf9c9
0x80c9bf4
0x8096a76
0x809262b
0x8091ccf
0x8092989
0x80e1d18
0x807fdd6
0x8082638
0x807dd5d
0x8083b6e
0x807cf0f
0x828380c 0x82b6f1a
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://www.mysql.com/doc/en/Using_stack_trace.html and follow 
instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd-query at 0x87170a8 = show create table PEDIDOS
thd-thread_id=1


I have 500MB in ram.

Greetings

From: Fred van Engen [EMAIL PROTECTED]
To: Miguel Perez [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: ERROR 2013:Lost connection to MySQL server
Date: Tue, 1 Jul 2003 21:23:41 +0200
Hi,

On Tue, Jul 01, 2003 at 02:13:23PM -0500, Miguel Perez wrote:
 I have the following problem, when I try to connect to my DB servicios
 I get connected succesfully, but when I try to access certain tables I 
get
 the error
 ERROR 2013: Lost connection to MySQL server during query but only with
 those certain tables, to be more specific there's only 2 tables that i
 can't access, I get that error,
 the other ones works fine.


Which version, which OS?

 Any ideas or suggestions.

Maybe mysqld crashes? It restarts automatically, on unices at least.

Check the mysql error log to find out if it crashed.

Regards,

Fred.

--
Fred van Engen  XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC  Almere
fax: +31 36 5462424 The Netherlands
_
Charla con tus amigos en línea mediante MSN Messenger:  
http://messenger.microsoft.com/es

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 2013:Lost connection to MySQL server

[Heikki Tuuri]

Miguel,

what exact MySQL version you are running?

Have you created FOREIGN KEY constraints to those tables?

Have you downgraded to a lower MySQL version?

Regards,

Heikki

- Original Message - 
From: Miguel Perez [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, July 02, 2003 12:11 AM
Subject: Re: ERROR 2013:Lost connection to MySQL server


 The OS I'm using is Red Hat 7.3, and the mysql version is 4.0

 The wierd thing is that I could access those tables but just after I
 rebooted my PC
 I couldn't access the 2 tables.
 The log files has the following:

 030701 14:27:38  InnoDB: Assertion failure in thread 36874 in file
 dict0load.c line 677
 InnoDB: We intentionally generate a memory trap.
 InnoDB: Send a detailed bug report to [EMAIL PROTECTED]
 mysqld got signal 11;
 This could be because you hit a bug. It is also possible that this binary
 or one of the libraries it was linked against is corrupt, improperly
built,
 or misconfigured. This error can also be caused by malfunctioning
hardware.
 We will try our best to scrape up some info that will hopefully help
 diagnose
 the problem, but since we have already crashed, something is definitely
 wrong
 and this may fail. thd=0x8711eb8
 Attempting backtrace. You can use the following information to find out
 where mysqld died. If you see no messages after this, something went
 terribly wrong...
 Cannot determine thread, fp=0xbfe7e0c8, backtrace may not be correct.
 Stack range sanity check OK, backtrace follows:
 0x80741ea
 0x8286058
 0x81193b5
 0x8108df8
 0x80cf9c9
 0x80c9bf4
 0x8096a76
 0x809262b
 0x8091ccf
 0x8092989
 0x80e1d18
 0x807fdd6
 0x8082638
 0x807dd5d
 0x8083b6e
 0x807cf0f
 0x828380c 0x82b6f1a
 New value of fp=(nil) failed sanity check, terminating stack trace!
 Please read http://www.mysql.com/doc/en/Using_stack_trace.html and follow
 instructions on how to resolve the stack trace. Resolved
 stack trace is much more helpful in diagnosing the problem, so please do
 resolve it
 Trying to get some variables.
 Some pointers may be invalid and cause the dump to abort...
 thd-query at 0x87170a8 = show create table PEDIDOS
 thd-thread_id=1
 

 I have 500MB in ram.

 Greetings

 From: Fred van Engen [EMAIL PROTECTED]
 To: Miguel Perez [EMAIL PROTECTED]
 CC: [EMAIL PROTECTED]
 Subject: Re: ERROR 2013:Lost connection to MySQL server
 Date: Tue, 1 Jul 2003 21:23:41 +0200
 
 Hi,
 
 On Tue, Jul 01, 2003 at 02:13:23PM -0500, Miguel Perez wrote:
   I have the following problem, when I try to connect to my DB servicios
   I get connected succesfully, but when I try to access certain tables I
 get
   the error
   ERROR 2013: Lost connection to MySQL server during query but only
with
   those certain tables, to be more specific there's only 2 tables that i
   can't access, I get that error,
   the other ones works fine.
  
 
 Which version, which OS?
 
 
   Any ideas or suggestions.
  
 
 Maybe mysqld crashes? It restarts automatically, on unices at least.
 
 Check the mysql error log to find out if it crashed.
 
 
 Regards,
 
 Fred.
 
 --
 Fred van Engen  XB Networks B.V.
 email: [EMAIL PROTECTED]Televisieweg 2
 tel: +31 36 5462400 1322 AC  Almere
 fax: +31 36 5462424 The Netherlands

 _
 Charla con tus amigos en lnea mediante MSN Messenger:
 http://messenger.microsoft.com/es


 -- 
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 2013:Lost connection to MySQL server

[Fred van Engen]

On Tue, Jul 01, 2003 at 04:09:26PM -0500, Miguel Perez wrote:
 The OS I'm using is Red Hat 7.3, and the mysql version is 4.0
 
 The wierd thing is that I could access those tables but just after I 
 rebooted my PC
 I couldn't access the 2 tables.
 The log files has the following:
 
 030701 14:27:38  InnoDB: Assertion failure in thread 36874 in file 
 dict0load.c line 677

You don't write which exact version you use, but the changelist in the
MySQL documentation mentions a fix for an assertion in dict0load.c in
version MySQL/InnoDB-4.0.13.

mysql select version();

If you use an earlier version than 4.0.13, you could try to upgrade.


 InnoDB: We intentionally generate a memory trap.
 InnoDB: Send a detailed bug report to [EMAIL PROTECTED]

Well, you did that now :)

I don't use InnoDB currently, so maybe someone else will respond.


Regards,

Fred.

-- 
Fred van Engen  XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC  Almere
fax: +31 36 5462424 The Netherlands

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 2013:Lost connection to MySQL server

[Miguel Perez]

I am running  the 4.0.12 version
For those tables I don't have FOREIGN KEYS here is the table desc.
CREATE TABLE CLIENTE (
 FINGCIOID smallint(6) NOT NULL default '0',
 FINOTIENDA smallint(6) NOT NULL default '0',
 FICTEID int(11) NOT NULL default '0',
 FIDIGITOVER smallint(6) NOT NULL default '0',
 FIOCUID smallint(6) NOT NULL default '0',
 FCCTENOMBRE char(18) NOT NULL default '',
 FCCTEAPATERNO char(18) NOT NULL default '',
 FCCTEAMATERNO char(18) NOT NULL default '',
 FCCTEDIRCALLE char(25) NOT NULL default '',
 FCCTEDIRNOEXT char(5) NOT NULL default '',
 FCCTEDIRNOINT char(5) NOT NULL default '',
 FCCTECP char(5) NOT NULL default '',
 FCCTECOLONIA char(65) NOT NULL default '',
 FCCTESEXO char(1) NOT NULL default '',
 FCCTETEL char(15) NOT NULL default '',
 FCCTERFC char(14) NOT NULL default '',
 FCCTEFISMOR char(2) NOT NULL default '',
 FITDAATIENDE smallint(6) NOT NULL default '0',
 FDCTEFECALT datetime NOT NULL default '-00-00 00:00:00',
 FLCTEECO smallint(6) NOT NULL default '0',
 FIEDOCIVIL smallint(6) NOT NULL default '0',
 FNLINEACRED decimal(8,2) NOT NULL default '0.00',
 FDCTEFECNAC datetime NOT NULL default '-00-00 00:00:00',
 FCNOCOBRADOR char(6) NOT NULL default '',
 FITRANNO int(11) NOT NULL default '0',
 KEY cliente (FCCTENOMBRE,FCCTEAPATERNO,FCCTEAMATERNO,FINOTIENDA)
) TYPE=InnoDB;
CREATE TABLE PEDIDO (
 FISUCURSAL int(11) NOT NULL default '0',
 FINOPEDIDO int(11) NOT NULL default '0',
 FINGCIOID smallint(6) NOT NULL default '0',
 FICTEID int(11) NOT NULL default '0',
 FINOTIENDA smallint(6) NOT NULL default '0',
 FIDIGITOVER smallint(6) NOT NULL default '0',
 FCEMPNO char(6) NOT NULL default '',
 FITIPOVENTA smallint(6) NOT NULL default '0',
 FDPEDFEC datetime NOT NULL default '-00-00 00:00:00',
 FNPEDTOTAL decimal(12,2) NOT NULL default '0.00',
 FIPEDFACT int(11) NOT NULL default '0',
 FDFECFACT datetime NOT NULL default '-00-00 00:00:00',
 FIPEDSTAT smallint(6) NOT NULL default '0',
 FCUSERID char(10) NOT NULL default '',
 FCWS char(10) NOT NULL default '',
 FDFECSURT datetime NOT NULL default '-00-00 00:00:00',
 FNPEDSALDO decimal(12,2) NOT NULL default '0.00',
 FCFOLIOPARAM int(11) NOT NULL default '0',
 FDFECIMPFACTURA datetime NOT NULL default '-00-00 00:00:00',
 FIDIASSERV smallint(6) NOT NULL default '0'
) TYPE=InnoDB;
And I haven't tried to downgrade my version.

Greetings



From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: ERROR 2013:Lost connection to MySQL server
Date: Wed, 2 Jul 2003 00:35:09 +0300
Miguel,

what exact MySQL version you are running?

Have you created FOREIGN KEY constraints to those tables?

Have you downgraded to a lower MySQL version?

Regards,

Heikki

- Original Message -
From: Miguel Perez [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, July 02, 2003 12:11 AM
Subject: Re: ERROR 2013:Lost connection to MySQL server
 The OS I'm using is Red Hat 7.3, and the mysql version is 4.0

 The wierd thing is that I could access those tables but just after I
 rebooted my PC
 I couldn't access the 2 tables.
 The log files has the following:

 030701 14:27:38  InnoDB: Assertion failure in thread 36874 in file
 dict0load.c line 677
 InnoDB: We intentionally generate a memory trap.
 InnoDB: Send a detailed bug report to [EMAIL PROTECTED]
 mysqld got signal 11;
 This could be because you hit a bug. It is also possible that this 
binary
 or one of the libraries it was linked against is corrupt, improperly
built,
 or misconfigured. This error can also be caused by malfunctioning
hardware.
 We will try our best to scrape up some info that will hopefully help
 diagnose
 the problem, but since we have already crashed, something is definitely
 wrong
 and this may fail. thd=0x8711eb8
 Attempting backtrace. You can use the following information to find out
 where mysqld died. If you see no messages after this, something went
 terribly wrong...
 Cannot determine thread, fp=0xbfe7e0c8, backtrace may not be correct.
 Stack range sanity check OK, backtrace follows:
 0x80741ea
 0x8286058
 0x81193b5
 0x8108df8
 0x80cf9c9
 0x80c9bf4
 0x8096a76
 0x809262b
 0x8091ccf
 0x8092989
 0x80e1d18
 0x807fdd6
 0x8082638
 0x807dd5d
 0x8083b6e
 0x807cf0f
 0x828380c 0x82b6f1a
 New value of fp=(nil) failed sanity check, terminating stack trace!
 Please read http://www.mysql.com/doc/en/Using_stack_trace.html and 
follow
 instructions on how to resolve the stack trace. Resolved
 stack trace is much more helpful in diagnosing the problem, so please do
 resolve it
 Trying to get some variables.
 Some pointers may be invalid and cause the dump to abort...
 thd-query at 0x87170a8 = show create table PEDIDOS
 thd-thread_id=1
 

 I have 500MB in ram.

 Greetings

 From: Fred van Engen [EMAIL PROTECTED]
 To: Miguel Perez [EMAIL PROTECTED]
 CC: [EMAIL PROTECTED]
 Subject: Re: ERROR 2013:Lost connection to MySQL server
 Date: Tue, 1 Jul 2003 21:23:41 +0200
 
 Hi,
 
 On Tue, Jul 01, 2003 at 02:13:23PM -0500, Miguel Perez wrote:
   I

Re: ERROR 2013:Lost connection to MySQL server

[Heikki Tuuri]

Miguel,

the failing assertion is in dict_load_table():

ut_a(DB_SUCCESS == dict_load_foreigns(table-name));

Are you sure you do not have foreign keys which REFERENCE those tables?

4.0.13 has better diagnostics. Please upgrade to it if you are not using
MySQL replication.


Fixed a bug: if you dropped a table to which there was a FOREIGN KEY
reference, and later created the same table with non-matching
column types, InnoDB could assert in dict0load.c, in function
dict_load_table.

Regards,

Heikki

- Original Message - 
From: Miguel Perez [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, July 02, 2003 12:47 AM
Subject: Re: ERROR 2013:Lost connection to MySQL server


 I am running  the 4.0.12 version
 For those tables I don't have FOREIGN KEYS here is the table desc.

 CREATE TABLE CLIENTE (
   FINGCIOID smallint(6) NOT NULL default '0',
   FINOTIENDA smallint(6) NOT NULL default '0',
   FICTEID int(11) NOT NULL default '0',
   FIDIGITOVER smallint(6) NOT NULL default '0',
   FIOCUID smallint(6) NOT NULL default '0',
   FCCTENOMBRE char(18) NOT NULL default '',
   FCCTEAPATERNO char(18) NOT NULL default '',
   FCCTEAMATERNO char(18) NOT NULL default '',
   FCCTEDIRCALLE char(25) NOT NULL default '',
   FCCTEDIRNOEXT char(5) NOT NULL default '',
   FCCTEDIRNOINT char(5) NOT NULL default '',
   FCCTECP char(5) NOT NULL default '',
   FCCTECOLONIA char(65) NOT NULL default '',
   FCCTESEXO char(1) NOT NULL default '',
   FCCTETEL char(15) NOT NULL default '',
   FCCTERFC char(14) NOT NULL default '',
   FCCTEFISMOR char(2) NOT NULL default '',
   FITDAATIENDE smallint(6) NOT NULL default '0',
   FDCTEFECALT datetime NOT NULL default '-00-00 00:00:00',
   FLCTEECO smallint(6) NOT NULL default '0',
   FIEDOCIVIL smallint(6) NOT NULL default '0',
   FNLINEACRED decimal(8,2) NOT NULL default '0.00',
   FDCTEFECNAC datetime NOT NULL default '-00-00 00:00:00',
   FCNOCOBRADOR char(6) NOT NULL default '',
   FITRANNO int(11) NOT NULL default '0',
   KEY cliente (FCCTENOMBRE,FCCTEAPATERNO,FCCTEAMATERNO,FINOTIENDA)
 ) TYPE=InnoDB;

 CREATE TABLE PEDIDO (
   FISUCURSAL int(11) NOT NULL default '0',
   FINOPEDIDO int(11) NOT NULL default '0',
   FINGCIOID smallint(6) NOT NULL default '0',
   FICTEID int(11) NOT NULL default '0',
   FINOTIENDA smallint(6) NOT NULL default '0',
   FIDIGITOVER smallint(6) NOT NULL default '0',
   FCEMPNO char(6) NOT NULL default '',
   FITIPOVENTA smallint(6) NOT NULL default '0',
   FDPEDFEC datetime NOT NULL default '-00-00 00:00:00',
   FNPEDTOTAL decimal(12,2) NOT NULL default '0.00',
   FIPEDFACT int(11) NOT NULL default '0',
   FDFECFACT datetime NOT NULL default '-00-00 00:00:00',
   FIPEDSTAT smallint(6) NOT NULL default '0',
   FCUSERID char(10) NOT NULL default '',
   FCWS char(10) NOT NULL default '',
   FDFECSURT datetime NOT NULL default '-00-00 00:00:00',
   FNPEDSALDO decimal(12,2) NOT NULL default '0.00',
   FCFOLIOPARAM int(11) NOT NULL default '0',
   FDFECIMPFACTURA datetime NOT NULL default '-00-00 00:00:00',
   FIDIASSERV smallint(6) NOT NULL default '0'
 ) TYPE=InnoDB;

 And I haven't tried to downgrade my version.

 Greetings



 From: Heikki Tuuri [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Subject: Re: ERROR 2013:Lost connection to MySQL server
 Date: Wed, 2 Jul 2003 00:35:09 +0300
 
 Miguel,
 
 what exact MySQL version you are running?
 
 Have you created FOREIGN KEY constraints to those tables?
 
 Have you downgraded to a lower MySQL version?
 
 Regards,
 
 Heikki
 
 - Original Message -
 From: Miguel Perez [EMAIL PROTECTED]
 Newsgroups: mailing.database.mysql
 Sent: Wednesday, July 02, 2003 12:11 AM
 Subject: Re: ERROR 2013:Lost connection to MySQL server
 
 
   The OS I'm using is Red Hat 7.3, and the mysql version is 4.0
  
   The wierd thing is that I could access those tables but just after I
   rebooted my PC
   I couldn't access the 2 tables.
   The log files has the following:
  
   030701 14:27:38  InnoDB: Assertion failure in thread 36874 in file
   dict0load.c line 677
   InnoDB: We intentionally generate a memory trap.
   InnoDB: Send a detailed bug report to [EMAIL PROTECTED]
   mysqld got signal 11;
   This could be because you hit a bug. It is also possible that this
 binary
   or one of the libraries it was linked against is corrupt, improperly
 built,
   or misconfigured. This error can also be caused by malfunctioning
 hardware.
   We will try our best to scrape up some info that will hopefully help
   diagnose
   the problem, but since we have already crashed, something is
definitely
   wrong
   and this may fail. thd=0x8711eb8
   Attempting backtrace. You can use the following information to find
out
   where mysqld died. If you see no messages after this, something went
   terribly wrong...
   Cannot determine thread, fp=0xbfe7e0c8, backtrace may not be correct.
   Stack range sanity check OK, backtrace follows:
   0x80741ea
   0x8286058
   0x81193b5
   0x8108df8

Re: ERROR 2013:Lost connection to MySQL server

[Miguel Perez]

Heikki:

The only thing that I did  with those tables is that I renamed both of them.

And I didn't drop anything.  Do you think that the renamed thing did affect 
my tables?..

Greetings

From: Heikki Tuuri [EMAIL PROTECTED]
To: Miguel Perez [EMAIL PROTECTED],[EMAIL PROTECTED]
Subject: Re: ERROR 2013:Lost connection to MySQL server
Date: Wed, 2 Jul 2003 00:55:38 +0300
Miguel,

the failing assertion is in dict_load_table():

ut_a(DB_SUCCESS == dict_load_foreigns(table-name));

Are you sure you do not have foreign keys which REFERENCE those tables?

4.0.13 has better diagnostics. Please upgrade to it if you are not using
MySQL replication.

Fixed a bug: if you dropped a table to which there was a FOREIGN KEY
reference, and later created the same table with non-matching
column types, InnoDB could assert in dict0load.c, in function
dict_load_table.

Regards,
Heikki

- Original Message -
From: Miguel Perez [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, July 02, 2003 12:47 AM
Subject: Re: ERROR 2013:Lost connection to MySQL server
 I am running  the 4.0.12 version
 For those tables I don't have FOREIGN KEYS here is the table desc.

 CREATE TABLE CLIENTE (
   FINGCIOID smallint(6) NOT NULL default '0',
   FINOTIENDA smallint(6) NOT NULL default '0',
   FICTEID int(11) NOT NULL default '0',
   FIDIGITOVER smallint(6) NOT NULL default '0',
   FIOCUID smallint(6) NOT NULL default '0',
   FCCTENOMBRE char(18) NOT NULL default '',
   FCCTEAPATERNO char(18) NOT NULL default '',
   FCCTEAMATERNO char(18) NOT NULL default '',
   FCCTEDIRCALLE char(25) NOT NULL default '',
   FCCTEDIRNOEXT char(5) NOT NULL default '',
   FCCTEDIRNOINT char(5) NOT NULL default '',
   FCCTECP char(5) NOT NULL default '',
   FCCTECOLONIA char(65) NOT NULL default '',
   FCCTESEXO char(1) NOT NULL default '',
   FCCTETEL char(15) NOT NULL default '',
   FCCTERFC char(14) NOT NULL default '',
   FCCTEFISMOR char(2) NOT NULL default '',
   FITDAATIENDE smallint(6) NOT NULL default '0',
   FDCTEFECALT datetime NOT NULL default '-00-00 00:00:00',
   FLCTEECO smallint(6) NOT NULL default '0',
   FIEDOCIVIL smallint(6) NOT NULL default '0',
   FNLINEACRED decimal(8,2) NOT NULL default '0.00',
   FDCTEFECNAC datetime NOT NULL default '-00-00 00:00:00',
   FCNOCOBRADOR char(6) NOT NULL default '',
   FITRANNO int(11) NOT NULL default '0',
   KEY cliente (FCCTENOMBRE,FCCTEAPATERNO,FCCTEAMATERNO,FINOTIENDA)
 ) TYPE=InnoDB;

 CREATE TABLE PEDIDO (
   FISUCURSAL int(11) NOT NULL default '0',
   FINOPEDIDO int(11) NOT NULL default '0',
   FINGCIOID smallint(6) NOT NULL default '0',
   FICTEID int(11) NOT NULL default '0',
   FINOTIENDA smallint(6) NOT NULL default '0',
   FIDIGITOVER smallint(6) NOT NULL default '0',
   FCEMPNO char(6) NOT NULL default '',
   FITIPOVENTA smallint(6) NOT NULL default '0',
   FDPEDFEC datetime NOT NULL default '-00-00 00:00:00',
   FNPEDTOTAL decimal(12,2) NOT NULL default '0.00',
   FIPEDFACT int(11) NOT NULL default '0',
   FDFECFACT datetime NOT NULL default '-00-00 00:00:00',
   FIPEDSTAT smallint(6) NOT NULL default '0',
   FCUSERID char(10) NOT NULL default '',
   FCWS char(10) NOT NULL default '',
   FDFECSURT datetime NOT NULL default '-00-00 00:00:00',
   FNPEDSALDO decimal(12,2) NOT NULL default '0.00',
   FCFOLIOPARAM int(11) NOT NULL default '0',
   FDFECIMPFACTURA datetime NOT NULL default '-00-00 00:00:00',
   FIDIASSERV smallint(6) NOT NULL default '0'
 ) TYPE=InnoDB;

 And I haven't tried to downgrade my version.

 Greetings



 From: Heikki Tuuri [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Subject: Re: ERROR 2013:Lost connection to MySQL server
 Date: Wed, 2 Jul 2003 00:35:09 +0300
 
 Miguel,
 
 what exact MySQL version you are running?
 
 Have you created FOREIGN KEY constraints to those tables?
 
 Have you downgraded to a lower MySQL version?
 
 Regards,
 
 Heikki
 
 - Original Message -
 From: Miguel Perez [EMAIL PROTECTED]
 Newsgroups: mailing.database.mysql
 Sent: Wednesday, July 02, 2003 12:11 AM
 Subject: Re: ERROR 2013:Lost connection to MySQL server
 
 
   The OS I'm using is Red Hat 7.3, and the mysql version is 4.0
  
   The wierd thing is that I could access those tables but just after I
   rebooted my PC
   I couldn't access the 2 tables.
   The log files has the following:
  
   030701 14:27:38  InnoDB: Assertion failure in thread 36874 in file
   dict0load.c line 677
   InnoDB: We intentionally generate a memory trap.
   InnoDB: Send a detailed bug report to [EMAIL PROTECTED]
   mysqld got signal 11;
   This could be because you hit a bug. It is also possible that this
 binary
   or one of the libraries it was linked against is corrupt, improperly
 built,
   or misconfigured. This error can also be caused by malfunctioning
 hardware.
   We will try our best to scrape up some info that will hopefully help
   diagnose
   the problem, but since we have already crashed, something is
definitely
   wrong
   and this may

Re: ERROR 2013:Lost connection to MySQL server

[Heikki Tuuri]

Miguel,

best to upgrade to 4.0.13 because it has better diagnostics.

Regards,

Heikki

- Original Message - 
From: Miguel Perez [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, July 02, 2003 1:03 AM
Subject: Re: ERROR 2013:Lost connection to MySQL server



 Heikki:

 The only thing that I did  with those tables is that I renamed both of
them.

 And I didn't drop anything.  Do you think that the renamed thing did
affect
 my tables?..

 Greetings

 From: Heikki Tuuri [EMAIL PROTECTED]
 To: Miguel Perez [EMAIL PROTECTED],[EMAIL PROTECTED]
 Subject: Re: ERROR 2013:Lost connection to MySQL server
 Date: Wed, 2 Jul 2003 00:55:38 +0300
 
 Miguel,
 
 the failing assertion is in dict_load_table():
 
  ut_a(DB_SUCCESS == dict_load_foreigns(table-name));
 
 Are you sure you do not have foreign keys which REFERENCE those tables?
 
 4.0.13 has better diagnostics. Please upgrade to it if you are not using
 MySQL replication.
 
 
 Fixed a bug: if you dropped a table to which there was a FOREIGN KEY
 reference, and later created the same table with non-matching
 column types, InnoDB could assert in dict0load.c, in function
 dict_load_table.
 
 Regards,
 
 Heikki
 
 - Original Message -
 From: Miguel Perez [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Sent: Wednesday, July 02, 2003 12:47 AM
 Subject: Re: ERROR 2013:Lost connection to MySQL server
 
 
   I am running  the 4.0.12 version
   For those tables I don't have FOREIGN KEYS here is the table desc.
  
   CREATE TABLE CLIENTE (
 FINGCIOID smallint(6) NOT NULL default '0',
 FINOTIENDA smallint(6) NOT NULL default '0',
 FICTEID int(11) NOT NULL default '0',
 FIDIGITOVER smallint(6) NOT NULL default '0',
 FIOCUID smallint(6) NOT NULL default '0',
 FCCTENOMBRE char(18) NOT NULL default '',
 FCCTEAPATERNO char(18) NOT NULL default '',
 FCCTEAMATERNO char(18) NOT NULL default '',
 FCCTEDIRCALLE char(25) NOT NULL default '',
 FCCTEDIRNOEXT char(5) NOT NULL default '',
 FCCTEDIRNOINT char(5) NOT NULL default '',
 FCCTECP char(5) NOT NULL default '',
 FCCTECOLONIA char(65) NOT NULL default '',
 FCCTESEXO char(1) NOT NULL default '',
 FCCTETEL char(15) NOT NULL default '',
 FCCTERFC char(14) NOT NULL default '',
 FCCTEFISMOR char(2) NOT NULL default '',
 FITDAATIENDE smallint(6) NOT NULL default '0',
 FDCTEFECALT datetime NOT NULL default '-00-00 00:00:00',
 FLCTEECO smallint(6) NOT NULL default '0',
 FIEDOCIVIL smallint(6) NOT NULL default '0',
 FNLINEACRED decimal(8,2) NOT NULL default '0.00',
 FDCTEFECNAC datetime NOT NULL default '-00-00 00:00:00',
 FCNOCOBRADOR char(6) NOT NULL default '',
 FITRANNO int(11) NOT NULL default '0',
 KEY cliente (FCCTENOMBRE,FCCTEAPATERNO,FCCTEAMATERNO,FINOTIENDA)
   ) TYPE=InnoDB;
  
   CREATE TABLE PEDIDO (
 FISUCURSAL int(11) NOT NULL default '0',
 FINOPEDIDO int(11) NOT NULL default '0',
 FINGCIOID smallint(6) NOT NULL default '0',
 FICTEID int(11) NOT NULL default '0',
 FINOTIENDA smallint(6) NOT NULL default '0',
 FIDIGITOVER smallint(6) NOT NULL default '0',
 FCEMPNO char(6) NOT NULL default '',
 FITIPOVENTA smallint(6) NOT NULL default '0',
 FDPEDFEC datetime NOT NULL default '-00-00 00:00:00',
 FNPEDTOTAL decimal(12,2) NOT NULL default '0.00',
 FIPEDFACT int(11) NOT NULL default '0',
 FDFECFACT datetime NOT NULL default '-00-00 00:00:00',
 FIPEDSTAT smallint(6) NOT NULL default '0',
 FCUSERID char(10) NOT NULL default '',
 FCWS char(10) NOT NULL default '',
 FDFECSURT datetime NOT NULL default '-00-00 00:00:00',
 FNPEDSALDO decimal(12,2) NOT NULL default '0.00',
 FCFOLIOPARAM int(11) NOT NULL default '0',
 FDFECIMPFACTURA datetime NOT NULL default '-00-00 00:00:00',
 FIDIASSERV smallint(6) NOT NULL default '0'
   ) TYPE=InnoDB;
  
   And I haven't tried to downgrade my version.
  
   Greetings
  
  
  
   From: Heikki Tuuri [EMAIL PROTECTED]
   To: [EMAIL PROTECTED]
   Subject: Re: ERROR 2013:Lost connection to MySQL server
   Date: Wed, 2 Jul 2003 00:35:09 +0300
   
   Miguel,
   
   what exact MySQL version you are running?
   
   Have you created FOREIGN KEY constraints to those tables?
   
   Have you downgraded to a lower MySQL version?
   
   Regards,
   
   Heikki
   
   - Original Message -
   From: Miguel Perez [EMAIL PROTECTED]
   Newsgroups: mailing.database.mysql
   Sent: Wednesday, July 02, 2003 12:11 AM
   Subject: Re: ERROR 2013:Lost connection to MySQL server
   
   
 The OS I'm using is Red Hat 7.3, and the mysql version is 4.0

 The wierd thing is that I could access those tables but just after
I
 rebooted my PC
 I couldn't access the 2 tables.
 The log files has the following:

 030701 14:27:38  InnoDB: Assertion failure in thread 36874 in
file
 dict0load.c line 677
 InnoDB: We intentionally

Re: ERROR 2013:Lost connection to MySQL server

[Pete Harlan]

On Wed, Jul 02, 2003 at 12:55:38AM +0300, Heikki Tuuri wrote:
...
 4.0.13 has better diagnostics. Please upgrade to it if you are not using
 MySQL replication.

Is there something wrong with 4.0.13's replication, or does it not
replicate properly with 4.0.12?

--Pete

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 2013:Lost connection to MySQL server

[Heikki Tuuri]

Pete,

INSERT ... SELECT ... does not replicate properly with AUTO_INCREMENTs.

Regards,

Heikki

- Original Message - 
From: Pete Harlan [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, July 02, 2003 1:10 AM
Subject: Re: ERROR 2013:Lost connection to MySQL server


 On Wed, Jul 02, 2003 at 12:55:38AM +0300, Heikki Tuuri wrote:
 ...
  4.0.13 has better diagnostics. Please upgrade to it if you are not using
  MySQL replication.

 Is there something wrong with 4.0.13's replication, or does it not
 replicate properly with 4.0.12?

 --Pete



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 2013: Lost connection to MySQL server during query on LOAD LOCAL IN FILE

[miguel solórzano]

At 03:57 PM 6/20/2003 -0300, Dyego Souza do Carmo wrote:
Hi,
I wasn't able for to repeat with the last bk tree 4.0 on Linux
and Windows. The query was performed from a Linux machine and
also from a Windows machine.
c:\mysql\binmysql -uroot test --local-infile=1
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.0.14-max-debug-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql load data local infile c:\\temp\\bah.1d into table cfgimpressao;
Query OK, 3 rows affected (0.33 sec)
Records: 3  Deleted: 0  Skipped: 0  Warnings: 0
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 4.0.14-debug-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql load data local infile /share/bah.1D into table cfgimpressao;
Query OK, 3 rows affected (0.56 sec)
Records: 3  Deleted: 0  Skipped: 0  Warnings: 0
Something else I did wrong for to repeat your case ?

The bug is:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 257 to server version: 4.0.14-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql use sqlreg3;
Database changed
mysql LOAD DATA LOCAL INFILE 
'C:\\ProjetosD6\\MySQLBackup\\binario\\cfgimpressao.dat' INT
O TABLE cfgimpressao;
ERROR 2013: Lost connection to MySQL server during query
mysql



The Files of table are in FTP the names is:

cfgimpressao.dat.zip - The zipped Data of File ( saved with the
OUTFILE command, please unzip before run ! )
cfgimpressao.str - The Structure

cfgimpressao.ref - The references

cfgimpressao.idx - The Indexes

The files are in support.mysql.com in the secret dir.

My System is MySQL 4.0.14 + InnoDB running in Linux box kernel 2.4.21
with 768MB of ram
--
Regards,
For technical support contracts, visit https://order.mysql.com/
Are you MySQL certified?, http://www.mysql.com/certification/
Miguel Angel Solórzano [EMAIL PROTECTED]
São Paulo - Brazil
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 2013 - Lost connection to MySQL server during query

[Suporte]

Now, it's working fine !

Thanks a lot 

Nivaldo

- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, March 04, 2003 12:12 AM
Subject: Re: Error 2013 - Lost connection to MySQL server during query



 Suporte schrieb:
  Hi 
 
  I installed MySQL on a server running RedHat 8.0 and it's working fine.
But
  when I try to connect to MySQL from a remote station, using MySQL
Control
  Center, or even using the command-line mysql, I get the message:
 
  Error 2013 - Lost connection to MySQL server during query
 
  The remote station is running Windows XP Professional SP1
  The server is running RedHat 8.0 + MySQL 3.23.54
 

 i am not in the list

 you can try this one
 and please post it *in* the list if it could solve your problem



 https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=77467

   lost connection ...
 [mysqld]
 set-variable=thread_stack=256k


 -
 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




-
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 2013 - Lost connection to MySQL server during query

[[EMAIL PROTECTED]]

Suporte schrieb:
Hi 

I installed MySQL on a server running RedHat 8.0 and it's working fine. But
when I try to connect to MySQL from a remote station, using MySQL Control
Center, or even using the command-line mysql, I get the message:
Error 2013 - Lost connection to MySQL server during query

The remote station is running Windows XP Professional SP1
The server is running RedHat 8.0 + MySQL 3.23.54
i am not in the list

you can try this one
and please post it *in* the list if it could solve your problem


https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=77467

 lost connection ...
[mysqld]
set-variable=thread_stack=256k
-
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 2013 on rh8.0

[Markus Reger]

Heinz

great hint - poor success 

actually installed is 2.2.93

if i force it in maybe mysql functions - other thing will fail in bulk.

kr mr

 Stefan Hinz [EMAIL PROTECTED] 02/12/03 15:41 PM 
Markus,

If you're lucky, you might be able to use this RPM:

ftp://ftp.suse.com/pub/suse/i386/update/8.1/rpm/i586/glibc-2.2.5-161.i58

Once again, a broken or not compatible glibc, I guess.

Regards,
--
  Stefan Hinz [EMAIL PROTECTED]
  iConnect GmbH http://iConnect.de
  Heesestr. 6, 12169 Berlin (Germany)
  Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3



-
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 2013

[Egor Egorov]

mazin,
Friday, November 08, 2002, 5:50:55 PM, you wrote:

m I have been facing this problem since from many months.
m The problem is that when i try to connect mysql from the remote place using
m mysqld -h 192.168.1.1 -u temp -p
m it ends up with the error ERROR 2013: Lost connection to MySQL server during
m query 
m As in the list i have tried increasing the MAX_PACKET_ALLOWED but the
m problem remails same.
m When i execute  mysqladmin -i1 processlist status when the request from the
m remote client reaches the server the server dies.
m Since i am using the mysql fo accounting purpose please help me out to solve
m this problem which is severe.
m Thanks in advance

Do you use RedHat on server box? If so, seems you have the same
problem as many others in this mailing list:
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128

RedHat already updated glibc packages:
   https://rhn.redhat.com/errata/RHSA-2002-197.html



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   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

re: ERROR 2013: Lost connection to MySQL server during query

[Davide Pennica]

Thanks for your help, we have installed MySQL 2.23.53a on Red Hat 8.0.
The problem seems to be the version of RedHat. We have now installed the
same version of MySql on RedHat 7.3 and it seems to work fine. Can you
give me a confirmation of this problem?

Thanks 

Davide



On Fri, 2002-10-25 at 15:36, Egor Egorov wrote:
 Davide,
 Friday, October 25, 2002, 11:57:23 AM, you wrote:
 
 DP I'm new to MySQL. I am trying to set replication in MySQL but i get the
 DP error in the subject. 
 
 DP Can you help me please?
 
 Can you be more detailed?
 What OS? What versions of MySQL servers? What did you done before you got
 this error? You gave incomplete info ..
 
 
 
 -- 
 For technical support contracts, goto https://order.mysql.com/?ref=ensita
 This email is sponsored by Ensita.net http://www.ensita.net/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Egor Egorov
  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
 /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
___/   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



-
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: re: ERROR 2013: Lost connection to MySQL server during query

[Egor Egorov]

Davide,
Monday, October 28, 2002, 9:56:46 AM, you wrote:

DP Thanks for your help, we have installed MySQL 2.23.53a on Red Hat 8.0.
DP The problem seems to be the version of RedHat. We have now installed the
DP same version of MySql on RedHat 7.3 and it seems to work fine. Can you
DP give me a confirmation of this problem?

Lost connection on RedHat 7.x/8.0 was caused by RedHat glibc.

But 3.23.53a was compiled with statically linked glibc, so this
problem shouldn't occur ...

DP On Fri, 2002-10-25 at 15:36, Egor Egorov wrote:
 Davide,
 Friday, October 25, 2002, 11:57:23 AM, you wrote:
 
 DP I'm new to MySQL. I am trying to set replication in MySQL but i get the
 DP error in the subject. 
 
 DP Can you help me please?
 
 Can you be more detailed?
 What OS? What versions of MySQL servers? What did you done before you got
 this error? You gave incomplete info ..



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   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

re: ERROR 2013: Lost connection to MySQL server during query

[Egor Egorov]

Davide,
Friday, October 25, 2002, 11:57:23 AM, you wrote:

DP I'm new to MySQL. I am trying to set replication in MySQL but i get the
DP error in the subject. 

DP Can you help me please?

Can you be more detailed?
What OS? What versions of MySQL servers? What did you done before you got
this error? You gave incomplete info ..



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   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

Re: ERROR 2013: Lost connection to MySQL server during query

[//mikezero/]

are you getting this problem with an API like php or perl cgi.. or is 
this command line.  i was having a similar problem, but i couldn't 
access anything.  i was trying to remotely connect to the mysql via 
command line and it would boot me.  even on the server itself if i 
included the '-h hostname' flag it would boot me, they only way i could 
get in was with out the '-h'.

Animesh wrote:

Hi All,,
I am getting this error and mysqld is dying out while tring to access 
a particular table in a particular databae while others don't fail..
ERROR 2013: Lost connection to MySQL server during query
Plz Help as early as possible.
Regards,
Animesh
[EMAIL PROTECTED]
DeepRoot Linux Pvt. Ltd.
Bangalore, India

-
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




-
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 2013: Lost connection to MySQL server during query

[Eric]

Hi,

I know there is more than one reason that this error can occur, but I have 
not seen a good guide to debuging.
It might help, if you are using DBI to do a trace to a log file. I have 
this happen every once in a while, but can't track it down because it is 
one query out of hundreds and I can't reproduce it.  The same query 
executing over and over and over, but sometimes it chokes with the Lost 
connection error.  Isn't there a way to make the mysql error log a LOT more 
verbose?

Eric

At 11:56 AM 2002-10-18 -0400, //mikezero/ wrote:
[EMAIL PROTECTED]



-
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 2013: Lost connection to MySQL server during query

[Jocelyn Fournier]

Hi,

Run mysqld_safe with the --log-bin switch (it will recreate a new bin log at
each crash, so it's much more simple to see which query is responsible for
the crash).

Regards,
  Jocelyn Fournier

- Original Message -
From: Eric [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, October 18, 2002 6:37 PM
Subject: Re: ERROR 2013: Lost connection to MySQL server during query


 Hi,

 I know there is more than one reason that this error can occur, but I have
 not seen a good guide to debuging.
 It might help, if you are using DBI to do a trace to a log file. I have
 this happen every once in a while, but can't track it down because it is
 one query out of hundreds and I can't reproduce it.  The same query
 executing over and over and over, but sometimes it chokes with the Lost
 connection error.  Isn't there a way to make the mysql error log a LOT
more
 verbose?

 Eric

 At 11:56 AM 2002-10-18 -0400, //mikezero/ wrote:
 [EMAIL PROTECTED]


 -
 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




-
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 2013: Lost connection to MySQL server during query

[Eric]

Thanks for the reply.


-rw-rw   1 mysql  mysql  12766 Oct 10 12:16 bob-bin.072
-rw-rw   1 mysql  mysql 506213 Oct 15 09:11 bob-bin.073
-rw-rw   1 mysql  mysql   40391597 Oct 17 12:52 bob-bin.074
-rw-rw   1 mysql  mysql 98 Oct 17 12:53 bob-bin.075
-rw-rw   1 mysql  mysql 264824 Oct 18 09:57 bob-bin.076

I have been running with this in my my.cnf

log
log-slow-queries
log-bin


But the logs stop/starts of new files don't correspond to the lost 
connection errors at all.


Eric 


-
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 2013: Lost connection to MySQL server during query

[Will Merrell]

Hi, This is the same error that I am getting, except that in my case the
server does not die, I just cant connect from another machine. All I get is
this error, which seems to be because the server is not responding to the
3306 port. or something like that.

I don't know if this is the same problem or if Animesh has a different
problem that generates a similar response.

See the Connecting to MySQL on Linux from a Windows machine. thread for
more details on my situation.

Thanks,
--Will


 -Original Message-
 From: Animesh [mailto:animesh;deeproot.co.in]
 Sent: Friday, October 18, 2002 4:53 PM
 To: [EMAIL PROTECTED]
 Subject: ERROR 2013: Lost connection to MySQL server during query


 Hi All,,

 I am getting this error and mysqld is dying out while tring to access a
 particular table in a particular databae while others don't fail..

 ERROR 2013: Lost connection to MySQL server during query

 Plz Help as early as possible.
 Regards,
 Animesh

 [EMAIL PROTECTED]
 DeepRoot Linux Pvt. Ltd.
 Bangalore, India

 -
 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



-
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 2013: Lost connection to MySQL server during query

[Insanely Great]

I had similar problem in my case.

The solution was that maybe you are accessing the column which has data
which is greater then the specified in Max_data_allowed in my.cnf.

Change it to something more and I hope that the problem is solved ?

Insane
SQLyog - The Definative GUI For MySQL
http://www.sqlyog.com/
- Original Message -
From: Animesh [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, October 19, 2002 2:23 AM
Subject: ERROR 2013: Lost connection to MySQL server during query


 Hi All,,

 I am getting this error and mysqld is dying out while tring to access a
 particular table in a particular databae while others don't fail..

 ERROR 2013: Lost connection to MySQL server during query

 Plz Help as early as possible.
 Regards,
 Animesh

 [EMAIL PROTECTED]
 DeepRoot Linux Pvt. Ltd.
 Bangalore, India

 -
 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



-
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 2013: Lost connection to MySQL server during query

[Kurt Hansen]

Hi,

Here's a bit of a followup:

I've narrowed my problem down to one of our servers, the one running mySQL
3.22.27.

The server is listening to port 3306, but is taking a very long time to
respond to requests sent to that port. It seems to hang but it eventually
responds after a few minutes.

Any ideas why it would be taking so long? This is on a RH 6.0 system.

Thank you!

Kurt Hansen
[EMAIL PROTECTED]
  Subject: ERROR 2013: Lost connection to MySQL server during query
 
 
  Hello,
 
  I'm getting the error message above whenever I try to connect from a
 remote
  host to a MySQL server. I issue the following command:
 
   mysql --host=host_name -u user_name -ppass_word
 
  and get the ERROR 2013 back as a response.
 
  We have two servers, both running MySQL. I get the same message going
both
  ways. I have all the privileges set up properly. When I don't, I just
get
  the host_name not set up for access message. I've duplicated the setup
 on
  our local LAN, and I connect with no problem. It is only our Web servers
  that are having this problem.
 
  We are only having this problem after our ISP moved our servers to a
new,
  better network and gave us new IPs. The servers have been talking to
 each
  other with no problems for almost 1.5 years, but have not been able to
 since
  the move. I've updated the privilege information, but it appears that
the
  client is not getting a complete response from the server.
 
  Any ideas on what to do to fix this? Troubleshooting clues? The request
 from
  the remote server is not showing up in the log; anyway I could capture
 this?
 
  I can telnet between the systems so I'm pretty sure the TCP/IP is
working.
 
  MySQL versions are 3.22.27 on Linux RH 6.0 and 3.22.21 on Linux RH 5.2.
  The mysqld variables are set to their default except for
 max_allowed_packet,
  which has been increased to 10048512 on the 3.22.21 system in a vain
 attempt
  to solve the error.
 
  Thanks!
 
  Kurt Hansen
  [EMAIL PROTECTED]
`


-
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 2013: Lost connection to MySQL server during query

[Milos Rackov]

I had a similar problem recently. Try checking the /etc/hosts file to see if
the hosts/IPs are matching the current config.

Regards,

Milos Rackov

-Original Message-
From: Kurt Hansen [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 09, 2001 4:58 PM
To: [EMAIL PROTECTED]
Subject: ERROR 2013: Lost connection to MySQL server during query


Hello,

I'm getting the error message above whenever I try to connect from a remote
host to a MySQL server. I issue the following command:

 mysql --host=host_name -u user_name -ppass_word

and get the ERROR 2013 back as a response.

We have two servers, both running MySQL. I get the same message going both
ways. I have all the privileges set up properly. When I don't, I just get
the host_name not set up for access message. I've duplicated the setup on
our local LAN, and I connect with no problem. It is only our Web servers
that are having this problem.

We are only having this problem after our ISP moved our servers to a new,
better network and gave us new IPs. The servers have been talking to each
other with no problems for almost 1.5 years, but have not been able to since
the move. I've updated the privilege information, but it appears that the
client is not getting a complete response from the server.

Any ideas on what to do to fix this? Troubleshooting clues? The request from
the remote server is not showing up in the log; anyway I could capture this?

I can telnet between the systems so I'm pretty sure the TCP/IP is working.

MySQL versions are 3.22.27 on Linux RH 6.0 and 3.22.21 on Linux RH 5.2.
The mysqld variables are set to their default except for max_allowed_packet,
which has been increased to 10048512 on the 3.22.21 system in a vain attempt
to solve the error.

Thanks!

Kurt Hansen
[EMAIL PROTECTED]


-
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


-
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 2013: Lost connection to MySQL server during query

[Kurt Hansen]

Hi Milos,

Thanks for responding!

I had updated the /etc/hosts files already, but went and checked it after
getting your message. Still no luck.

Any other troubleshooting clues?

Thanks!

Kurt Hansen
[EMAIL PROTECTED]
- Original Message -
From: Milos Rackov [EMAIL PROTECTED]
To: Kurt Hansen [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, July 09, 2001 8:59 AM
Subject: RE: ERROR 2013: Lost connection to MySQL server during query


 I had a similar problem recently. Try checking the /etc/hosts file to see
if
 the hosts/IPs are matching the current config.

 Regards,

 Milos Rackov

 -Original Message-
 From: Kurt Hansen [mailto:[EMAIL PROTECTED]]
 Sent: Monday, July 09, 2001 4:58 PM
 To: [EMAIL PROTECTED]
 Subject: ERROR 2013: Lost connection to MySQL server during query


 Hello,

 I'm getting the error message above whenever I try to connect from a
remote
 host to a MySQL server. I issue the following command:

  mysql --host=host_name -u user_name -ppass_word

 and get the ERROR 2013 back as a response.

 We have two servers, both running MySQL. I get the same message going both
 ways. I have all the privileges set up properly. When I don't, I just get
 the host_name not set up for access message. I've duplicated the setup
on
 our local LAN, and I connect with no problem. It is only our Web servers
 that are having this problem.

 We are only having this problem after our ISP moved our servers to a new,
 better network and gave us new IPs. The servers have been talking to
each
 other with no problems for almost 1.5 years, but have not been able to
since
 the move. I've updated the privilege information, but it appears that the
 client is not getting a complete response from the server.

 Any ideas on what to do to fix this? Troubleshooting clues? The request
from
 the remote server is not showing up in the log; anyway I could capture
this?

 I can telnet between the systems so I'm pretty sure the TCP/IP is working.

 MySQL versions are 3.22.27 on Linux RH 6.0 and 3.22.21 on Linux RH 5.2.
 The mysqld variables are set to their default except for
max_allowed_packet,
 which has been increased to 10048512 on the 3.22.21 system in a vain
attempt
 to solve the error.

 Thanks!

 Kurt Hansen
 [EMAIL PROTECTED]


 -
 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



-
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