Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9248

mysqldump test is failing on Windows post MDEV-9001

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.5
    • Fix Version/s: 5.5.47
    • Component/s: Tests
    • Labels:
      None

      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)...

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              svoj Sergey Vojtovich
              Reporter:
              wlad Vladislav Vaintroub
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: