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
