Re: mysqldump locks dumping db "mysql" in 5.1.9
On Wednesday, 7 June 2006 at 11:35:56 -0700, James Barros wrote: > Hello, > > I've got 5.1.9 running on FreeBSD and I'm trying to do some backups, > but mysqldump is locking up on me. > > 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: > > > /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; > > and then it just freezes there till I +c out. > > Is this a legit bug I should report to the buglist or did I screw > something up? mysqldump should not hang, so it's a bug. The real question is how you managed to trip it. Please enter a bug report and I'll look at it as soon as possible. Greg -- Greg Lehey, Senior Software Engineer MySQL AB, http://www.mysql.com/ Echunga, South Australia Phone: +61-8-8388-8286 Mobile: +61-418-838-708 VoIP: sip:[EMAIL PROTECTED], sip:[EMAIL PROTECTED] Are you MySQL certified? http://www.mysql.com/certification/ pgprqsw4l2kvI.pgp Description: PGP signature
mysqldump locks dumping db "mysql" in 5.1.9
Hello, I've got 5.1.9 running on FreeBSD and I'm trying to do some backups, but mysqldump is locking up on me. 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: localhostDatabase: 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 +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? Other suggestions? Is this a legit bug I should report to the buglist or did I screw something up? Thanks :) -- James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]