Bug#315524: mysql-server-4.1: Lost connection to MySQL server during query
Package: mysql-server-4.1 Version: 4.1.12-1 Severity: normal while running a wikipedia database export as XML export the following error occurs reproducible: # time mysql -u root -p -X -e select cur_title, cur_text from cur wikidb wiki.xml Enter password: ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during query real3m21.155s user0m2.038s sys 0m3.446s The mysql log is not very helpfull: 050623 10:31:00 5 Connect [EMAIL PROTECTED] on wikidb 5 Query select cur_title, cur_text from cur /usr/sbin/mysqld, Version: 4.1.12-Debian_1-log. started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id CommandArgument The are reported problems with that specific error 2013 but it seems that it affects (only?) mysql 5. -- System Information: Debian Release: testing/unstable APT prefers unstable APT policy: (500, 'unstable') Architecture: i386 (i686) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.12 Locale: LANG=en_US.ISO-8859-15, LC_CTYPE=en_US.ISO-8859-15 (charmap=ISO-8859-15) Versions of packages mysql-server-4.1 depends on: ii adduser 3.64Add and remove users and groups ii debconf 1.4.51 Debian configuration management sy ii libc62.3.2.ds1-22GNU C Library: Shared libraries an ii libdbi-perl 1.48-1 Perl5 database interface by Tim Bu ii libgcc1 1:4.0.0-9 GCC support library ii libmysqlclient14 4.1.12-1mysql database client library ii libncurses5 5.4-7 Shared libraries for terminal hand ii libreadline4 4.3-15 GNU readline and history libraries ii libstdc++5 1:3.3.6-7 The GNU Standard C++ Library v3 ii libwrap0 7.6.dbs-8 Wietse Venema's TCP wrappers libra ii mailx1:8.1.2-0.20040524cvs-4 A simple mail user agent ii mysql-client-4.1 4.1.12-1mysql database client binaries ii mysql-common-4.1 4.1.12-1mysql database common files (e.g. ii passwd 1:4.0.3-35 change and administer password and ii perl 5.8.7-3 Larry Wall's Practical Extraction ii psmisc 21.6-1 Utilities that use the proc filesy ii zlib1g 1:1.2.2-4 compression library - runtime mysql-server-4.1 recommends no packages. -- debconf information: * mysql-server-4.1/start_on_boot: true mysql-server-4.1/postrm_remove_databases: false mysql-server-4.1/nis_warning: * mysql-server-4.1/mysql_install_db_notes: mysql-server-4.1/mysql_update_hints1: -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#315524: mysql-server-4.1: Lost connection to MySQL server during query
tags 315524 + moreinfo unreproducible thanks Hello Jörg On 2005-06-23 Joerg Rieger wrote: while running a wikipedia database export as XML export the following error occurs reproducible: # time mysql -u root -p -X -e select cur_title, cur_text from cur wikidb wiki.xml Enter password: ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during I've never encountered it and can't reproduce it with an arbitrary table. Does this problem only occur with a specific table? Does it continue after you do an REPAIR TABLE cur EXTENDED; on it? If you, could you send me a tabledump or a zipped database file so that I can give it to the MySQL developers for investigation? If you know about any anomalies like special charsets, binary data or table formats else than innodb/myisam for this table it could be good to know, too. bye, -christian-
Bug#315524: mysql-server-4.1: Lost connection to MySQL server during query
forwarded 315524 http://bugs.mysql.com/11528 tags 315524 + upstream thanks Hello Joerg I've submitted your report to the mysql bug tracking system. bye, -christian- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#315524: mysql-server-4.1: Lost connection to MySQL server during query
Hello Christian, On Thu, Jun 23, 2005 at 02:00:37PM +0200, Christian Hammers wrote: tags 315524 + moreinfo unreproducible thanks Hello Jörg On 2005-06-23 Joerg Rieger wrote: while running a wikipedia database export as XML export the following error occurs reproducible: # time mysql -u root -p -X -e select cur_title, cur_text from cur wikidb wiki.xml Enter password: ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during I've never encountered it and can't reproduce it with an arbitrary table. Does this problem only occur with a specific table? Does it continue after you do an REPAIR TABLE cur EXTENDED; on it? If you, could you send me a tabledump or a zipped database file so that I can give it to the MySQL developers for investigation? If you know about any anomalies like special charsets, binary data or table formats else than innodb/myisam for this table it could be good to know, too. It's a database dump of the german (de) wikipedia[1] database, like a month old or so. Because of that, the size of the database is quite huge (roughly 1,8 GB). If you still want the file, I could upload it to a server, but that'll take a while :-) Since they use InnoDB as storage engine a repair table doesn't work: mysql REPAIR TABLE cur EXTENDED; +++--+-- | Table | Op | Msg_type | Msg_text +++--+-- | wikidb.cur | repair | note | The storage engine for the table doesn't support repair | +++--+-- 1 row in set (0.00 sec) I also have a wikinews DB within the same mysql installation, XML export works fine with this one, short example: ?xml version=1.0? resultset statement=select cur_title, cur_text from cur row cur_titleHauptseite/cur_title . . . However the size is considerably less than the other wiki DB (only about 7,5 MB). As far as I can recall, I have made a successfull XML dump of that big wiki DB on the same machine a while ago. Maybe a feature backport from mysql 5? But changelog doesn't state anything like it, so probaply not. [1] http://download.wikimedia.org/ --