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

LP:784303 - Execution of the test case for bug #21261 fails in the ps-protocol mode

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      With the current LP tree maria-5.3-mwl106 execution of the test case for bug #21261 from
      mysql-test/t/view.test fails:

      igor@sophia:~/maria/maria-5.3-mwl148-mwl106-bugs/mysql-test> ./mysql-test-run --ps-protocol view
      Logging: ./mysql-test-run --ps-protocol view
      vardir: /home/igor/maria/maria-5.3-mwl148-mwl106-bugs/mysql-test/var
      Checking leftover processes...
      Removing old var directory...
      Creating var directory '/home/igor/maria/maria-5.3-mwl148-mwl106-bugs/mysql-test/var'...
      Installing system database...
      Checking supported features...
      MariaDB Version 5.3.0

      • skipping ndbcluster
      • SSL connections supported
      • binaries are debug compiled
        Collecting tests...
        Using server port 55279

      ==============================================================================

      TEST RESULT TIME (ms)
      ------------------------------------------------------------

      worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
      main.view [ fail ]
      Test ended at 2011-05-17 15:12:00

      CURRENT_TEST: main.view
      mysqltest: At line 2803: query 'INSERT INTO v1 VALUES (5)' failed: 1356: View 'bug21261DB.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

      The result from queries just before the failure was:
      < snip >
      ERROR 42S02: Unknown table 'v2'
      SHOW TABLES;
      Tables_in_test
      t1
      CREATE VIEW v1 AS SELECT id FROM t1;
      DROP VIEW t1,v1;
      ERROR HY000: 'test.t1' is not VIEW
      SHOW TABLES;
      Tables_in_test
      t1
      DROP TABLE t1;
      DROP VIEW IF EXISTS v1;
      CREATE DATABASE bug21261DB;
      USE bug21261DB;
      CREATE TABLE t1 (x INT);
      CREATE SQL SECURITY INVOKER VIEW v1 AS SELECT x FROM t1;
      GRANT INSERT, UPDATE ON v1 TO 'user21261'@'localhost';
      GRANT INSERT, UPDATE ON t1 TO 'user21261'@'localhost';
      CREATE TABLE t2 (y INT);
      GRANT SELECT ON t2 TO 'user21261'@'localhost';

      More results from queries before failure can be found in /home/igor/maria/maria-5.3-mwl148-mwl106-bugs/mysql-test/var/log/view.log

      Warnings from just before the error:
      Error 1143 SELECT command denied to user 'user21261'@'localhost' for column 'x' in table 't1'
      Error 1356 View 'bug21261DB.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

      • saving '/home/igor/maria/maria-5.3-mwl148-mwl106-bugs/mysql-test/var/log/main.view/' to '/home/igor/maria/maria-5.3-mwl148-mwl106-bugs/mysql-test/var/log/main.view/'
        ------------------------------------------------------------
        The servers were restarted 0 times
        Spent 0.000 of 9 seconds executing testcases

      Failure: Failed 1/1 tests, 0.00% were successful.

      Failing test(s): main.view

      The log files in var/log may give you some hint of what went wrong.

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            ratzpo Rasmus Johansson added a comment -

            Launchpad bug id: 784303

            Show
            ratzpo Rasmus Johansson added a comment - Launchpad bug id: 784303

              People

              • Assignee:
                sanja Oleksandr Byelkin
                Reporter:
                igor Igor Babaev
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: