Hi Heikki and All, Yes, it seems to be a cache problem, it happens to both MyISAM and innodb table types but simply updating one row in the table maks the error go away. The table names also seems to change (supporting the cache idea) and it seems to be mostly readonly tables. Also it only seems to affect mysqldump! All other operations on the table seems fine I ran: select * from secmaster; worked fine show create table secmaster; worked fine! As do all other SQL at the command prompt, only mysqldump seems to be affected!
Here is the error one more time -bash-2.04$ mysqldump -uken -p --opt salep secmaster >salep.dump Enter password: mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table 'secmaster' at row: 0 The after a simple UPDATE (I change the spelling of a description) bash-2.04$ mysqldump -uken -p --opt salep secmaster >salep.dump Enter password: bash-2.04$ And it works! I am including all background as it has been a few days since I posted this. Ken ---- Original Message ----- From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, January 17, 2002 5:46 PM Subject: Re: Innodb funny error > Ken, > > the 'connection lost' error suggests some bug in the client or > communication. Since you are running 4.0.1-alpha, it could be something with > the query cache. I think Sanja has already fixed some bugs there since 4.0.1 > was released. The query cache is suspect since the error did not crash the > server, and it was restricted to one table. > > Well, the next time you get the problem you could try just inserting a > single additional row to the table. That should invalidate the query cache, > I think. ALTER TABLE certainly does that. > > I am forwarding this report to Monty and Sanja. > > Best regards, > > Heikki Tuuri > Innobase Oy > --- > Order technical MySQL/InnoDB support at https://order.mysql.com/ > See http://www.innodb.com for the online manual and latest news on InnoDB > > > "Ken Menzel" wrote in message ... > >Hi Heikki, > > Thought you might want to hear this one, I was trying to mysqldump > >our support database (all tables innodb) WHen I got the following > >error: > >bash-2.04$ mysqldump --opt -uken -p supportdb terms >supportdb.dump > >Enter password: > >mysqldump: Error 2013: Lost connection to MySQL server during query > >when dumping table 'terms' at row: 0 > > > >The server did not restart, all other tables would dump fine, but > >terms would not. I then altered the table type to myisam: > > > >alter table terms type=myisam ----------- then back to > >innodb > >alter table terms type=innodb > > > >And then the dump proceeded with no error! Are you aware of any > >problems like this? If it happens again would you like any other > >info? > > > > > >Ken > >P.S. Here is version info (running FreeBSD 4.4-stable) this is our > >internal test server > > > >bash-2.04$ mysqladmin -uken -p ver > >Enter password: > >mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for unknown-freebsdelf4.4 on > >i386 > >Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB > >This software comes with ABSOLUTELY NO WARRANTY. This is free > >software, > >and you are welcome to modify and redistribute it under the GPL > >license > > > >Server version 4.0.1-alpha-debug-log > >Protocol version 10 > >Connection Localhost via UNIX socket > >UNIX socket /tmp/mysql.sock > >Uptime: 19 hours 48 min 33 sec > > > >Threads: 34 Questions: 161144 Slow queries: 5 Opens: 719 Flush > >tables: 1 Open tables: 522 Queries per second avg: 2.260 > >bash-2.04$ > >----------------------------------------------------- > >Ken Menzel ICQ# 9325188 > >www.icarz.com [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
