Bug #20345 Mysqldump hangs dumping "mysql" db
Submitted: 8 Jun 2006 15:54 Modified: 9 Jun 2006 15:14
Reporter: James Barros Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.1.9 OS:FreeBSD (FreeBSD)
Assigned to: Sveta Smirnova CPU Architecture:Any

[8 Jun 2006 15:54] James Barros 
Description:
when I run:
mysqldump -uroot --opt mysql
(and yes, it's a test box, so there is no root password. I can duplicate this behavior with other accounts with sufficient priv's specifying a password)

I get:

-- MySQL dump 10.10
--
-- Host: localhost    Database: mysql
-- ------------------------------------------------------
-- Server version       5.1.9-beta

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

and then it just freezes there till I <ctl>+c out.

It should be noted that I can dump all other db's just fine.

This version was installed using ports.

mysqldump -V returns:
mysqldump  Ver 10.10 Distrib 5.1.6-alpha, for portbld-freebsd6.1 (i386)

which appears to be 0.0.3 versions out of date compared to the server. Was there some change in DB structure that might cause this issue?

Also, before we upgraded from 5.1.

Other suggestions?

How to repeat:
mysqldump -uroot --opt mysql
[9 Jun 2006 15:14] Sveta Smirnova 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

I tested using last 5.1.11 sources on FreeBSD 6.0-RELEASE. All work fine.