[MDEV-9248] mysqldump test is failing on Windows post MDEV-9001 Created: 2015-12-08  Updated: 2015-12-15  Resolved: 2015-12-15

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 5.5
Fix Version/s: 5.5.47

Type: Bug Priority: Major
Reporter: Vladislav Vaintroub Assignee: Sergey Vojtovich
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
is caused by MDEV-9001 [PATCH] Fix DB name quoting in mysqld... Closed

 Description   

This started after MDEV-9001. The test is consistentl failing on all Windows builds in 5.5

https://buildbot.askmonty.org/buildbot/builders/win32-debug2/builds/8699/steps/test/logs/stdio

main.mysqldump                           [ fail ]
        Test ended at 2015-12-08 03:28:53
 
CURRENT_TEST: main.mysqldump
mysqldump.exe: Couldn't find table: "non_existing"
mysqldump.exe: 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.exe: 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)
mysqldump.exe: Got error: 1083: "Field separator argument is not what is expected; check the manual" when executing 'SELECT INTO OUTFILE'
mysqldump.exe: Got error: 1083: "Field separator argument is not what is expected; check the manual" when executing 'SELECT INTO OUTFILE'
mysqldump.exe: Got error: 1083: "Field separator argument is not what is expected; check the manual" when executing 'SELECT INTO OUTFILE'
mysqldump.exe: user2 has insufficent privileges to SHOW CREATE PROCEDURE `sp1`!
mysqldump.exe: Got error: 1146: "Table 'test.???????????????????????' doesn't exist" when using LOCK TABLES
C:\bzr\bb-win32\win32-debug2\build\client\Debug\mysqlimport.exe: Error: 1146, Table 'test.words' doesn't exist, when using table: words
C:\bzr\bb-win32\win32-debug2\build\client\Debug\mysqlimport.exe: Error: 1045 Access denied for user '
mysqldump.exe: Got error: 1083: "Field separator argument is not what is expected; check the manual" when executing 'SELECT INTO OUTFILE'
mysqldump.exe: Got error: 1083: "Field separator argument is not what is expected; check the manual" when executing 'SELECT INTO OUTFILE'
mysqldump.exe: user1 has insufficent privileges to SHOW CREATE FUNCTION `hello1`!
mysqldump.exe: Got error: 2005: "Unknown MySQL server host 'unknownhost' (2)" when trying to connect
mysqldump.exe: Couldn't execute 'SHOW SLAVE STATUS': MySQL server has gone away (2006)
mysqldump.exe: Got error: 1049: "Unknown database 'a"\'\`b'" when selecting the database
mysqltest: At line 2505: exec of 'C:\bzr\bb-win32\win32-debug2\build\client\Debug\mysqldump.exe --defaults-file=C:/bzr/bb-win32/win32-debug2/build/mysql-test/var/my.cnf --defaults-group-suffix=.1 --routines --compact a\"\'\`b 2>&1' failed, error: 2, status: 2, errno: 0
Output from before failure:
ALTER DATABASE `a\"'``b` COLLATE utf8_general_ci;
 
 
 
The result from queries just before the failure was:
< snip >
1
2
SELECT * FROM t2;
a
3
4
DROP TABLE t1;
DROP TABLE t2;
DROP DATABASE db_20772273;
Usage: mysqldump [OPTIONS] database [tables]
OR     mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]
OR     mysqldump [OPTIONS] --all-databases [OPTIONS]
For more options, use mysqldump --help
#
# MDEV-9001 - [PATCH] Fix DB name quoting in mysqldump --routine
#
CREATE DATABASE `a\"'``b`;
USE `a\"'``b`;
CREATE PROCEDURE p1() BEGIN END;
ALTER DATABASE `a\"'``b` COLLATE utf8_general_ci;
 
More results from queries before failure can be found in C:\bzr\bb-win32\win32-debug2\build\mysql-test\var\log\mysqldump.log
 
 - saving 'C:/bzr/bb-win32/win32-debug2/build/mysql-test/var/log/main.mysqldump/' to 'C:/bzr/bb-win32/win32-debug2/build/mysql-test/var/log/main.mysqldump/'
 
Retrying test main.mysqldump, attempt(2/3)...



 Comments   
Comment by Sergey Vojtovich [ 2015-12-15 ]

Thanks serg for fixing this.

Generated at Thu Feb 08 07:33:15 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.