MySQL Bugs: #28372: mysqldump test case fails with binlog disabled

Bug #28372	mysqldump test case fails with binlog disabled
Submitted:	11 May 2007 8:57	Modified:	12 Jun 2007 17:30
Reporter:	Daniel Fischer	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Tests	Severity:	S3 (Non-critical)
Version:	all current	OS:	Any
Assigned to:	Daniel Fischer	CPU Architecture:	Any

Description:
The test case mysqldump fails with binlog disabled.

mysqldump                      [ fail ]

Errors are (from /shared/home/df/mysql/build/mysql-5.0/mysql-test/var/log/mysqltest-time) :
mysqldump: Couldn't find table: "non_existing"
mysqldump: Got error: 1356: View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them when using LOCK TABLES
mysqldump: Couldn't execute 'SHOW FIELDS FROM `v1`': View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqltest: At line 1320: query 'reset master' failed: 1186: Binlog closed, cannot RESET MASTER
(the last lines may be the most important ones)
Result from queries before failure can be found in r/mysqldump.log

How to repeat:
perl mysql-test-run.pl --mysqld=--skip-log-bin mysqldump

Thank you for the report.

Verified as described.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/26689

ChangeSet@1.2488, 2007-05-15 12:22:53+02:00, df@pippilotta.erinye.com +1 -0
  BUG#28372 mysqldump test case fails with binlog disabled

Queued for inclusion in 5.0 and 5.1.

Pushed into 5.1.20-beta

Pushed into 5.0.44

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 bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

Noted in the changelogs 5.1.20-beta and 5.0.44.

Review + approval ~ May 2007.