Re: How to debug a mysqldump dropped connection error?
The wait_timeout and interactive_timeout global variables are set to 172800, and max_allowed_packet is set to 30M, and I am still getting the problem I am having debugging a problem I am seeing with mysqldump. While using mysqldump to make backups of my database, I will intermitently get the following error : mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table I am running the pre-compiled 64 bit linux 5.1.20 mysql binaries ( specifically, the Linux non RPM packages ) on a machine with 2 gigs of memory. The error has been seen (so far) in two tables. The first table is a myisam table, which takes up 15 gigs on disk, and has 534858129 rows. The second table is innodb, takes up 1.3 gigs on disk, and has 2055624 rows. The row the timeout error occurs on is always different. The error seems to show up regardless of database usage (sometimes it will show up when we are running intensive queries, other times it will show up when no queries are being run). The log-warnings option is enabled with a value of 2, but nothing shows up in the error log when the timeout occurs. I have set the interactive_timeout setting to a ridiculously high number (172800), but the timeouts still occur. I was experiencing this problem in version 5.1.18, and the upgrade to 5.1.20 has not eliminated the problem. How should I go about debugging this problem? I've created a bug for this problem (where there is more information on the table schema, command line options used with mysqldump, etc) - http://bugs.mysql.com/bug.php?id=30809 -- Aiton -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Aiton -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to debug a mysqldump dropped connection error?
I am having debugging a problem I am seeing with mysqldump. While using mysqldump to make backups of my database, I will intermitently get the following error : mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table I am running the pre-compiled 64 bit linux 5.1.20 mysql binaries ( specifically, the Linux non RPM packages ) on a machine with 2 gigs of memory. The error has been seen (so far) in two tables. The first table is a myisam table, which takes up 15 gigs on disk, and has 534858129 rows. The second table is innodb, takes up 1.3 gigs on disk, and has 2055624 rows. The row the timeout error occurs on is always different. The error seems to show up regardless of database usage (sometimes it will show up when we are running intensive queries, other times it will show up when no queries are being run). The log-warnings option is enabled with a value of 2, but nothing shows up in the error log when the timeout occurs. I have set the interactive_timeout setting to a ridiculously high number (172800), but the timeouts still occur. I was experiencing this problem in version 5.1.18, and the upgrade to 5.1.20 has not eliminated the problem. How should I go about debugging this problem? I've created a bug for this problem (where there is more information on the table schema, command line options used with mysqldump, etc) - http://bugs.mysql.com/bug.php?id=30809 -- Aiton -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A question about how to debug the error 2013, 'Lost connection to MySQL server during query'
I am running the 64 bit version of mysql server 5.1.18, and on the client side I am running python with the mysqldb module. While running a very large insert query I get the following error : 2013, 'Lost connection to MySQL server during query' I have --log-warnings set to 3, but I get no corresponding errors in the error log. The question is : how do I go about debugging this problem? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]