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

Bug #28372	mysqldump test case fails with binlog disabled
Submitted:	11 May 2007 10:57	Modified:	12 Jun 2007 19:30
Reporter:	Daniel Fischer
Status:	Closed
Category:	Server: Tests	Severity:	S3 (Non-critical)
Version:	all current	OS:	Any
Assigned to:	Daniel Fischer	Target Version:

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.