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

mysql_client_test: test_ps_query_cache fails with group-concat-max-len=1M

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.1.18, 5.5, 10.0, 10.1
    • Fix Version/s: 10.1.19, 10.2.3
    • Component/s: Tests
    • Labels:
      None

      Description

      nirbhay@nirbhay-vbox:~/project/git-repo/mariadb/10.1/install/mysql-test$ perl mtr main.mysql_client_test --mysqld=--group-concat-max-len=1K
      Logging: mtr  main.mysql_client_test --mysqld=--group-concat-max-len=1K
      vardir: /home/nirbhay/project/git-repo/mariadb/10.1/install/mysql-test/var
      Checking leftover processes...
      Removing old var directory...
      Creating var directory '/home/nirbhay/project/git-repo/mariadb/10.1/install/mysql-test/var'...
      Checking supported features...
      MariaDB Version 10.1.19-MariaDB-debug
       - SSL connections supported
       - binaries are debug compiled
      Collecting tests...
      Installing system database...
       
      ==============================================================================
       
      TEST                                      RESULT   TIME (ms) or COMMENT
      --------------------------------------------------------------------------
       
      worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
      main.mysql_client_test                   [ pass ]  43368
      --------------------------------------------------------------------------
      The servers were restarted 0 times
      Spent 43.368 of 50 seconds executing testcases
       
      Completed: All 1 tests were successful.
       
      nirbhay@nirbhay-vbox:~/project/git-repo/mariadb/10.1/install/mysql-test$ perl mtr main.mysql_client_test --mysqld=--group-concat-max-len=1M
      Logging: mtr  main.mysql_client_test --mysqld=--group-concat-max-len=1M
      vardir: /home/nirbhay/project/git-repo/mariadb/10.1/install/mysql-test/var
      Checking leftover processes...
      Removing old var directory...
      Creating var directory '/home/nirbhay/project/git-repo/mariadb/10.1/install/mysql-test/var'...
      Checking supported features...
      MariaDB Version 10.1.19-MariaDB-debug
       - SSL connections supported
       - binaries are debug compiled
      Collecting tests...
      Installing system database...
       
      ==============================================================================
       
      TEST                                      RESULT   TIME (ms) or COMMENT
      --------------------------------------------------------------------------
       
      worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
      main.mysql_client_test                   [ fail ]
              Test ended at 2016-10-18 14:32:02
       
      CURRENT_TEST: main.mysql_client_test
      mysqltest: At line 19: exec of '/home/nirbhay/project/git-repo/mariadb/10.1/install/bin/mysql_client_test --defaults-file=/home/nirbhay/project/git-repo/mariadb/10.1/install/mysql-test/var/my.cnf --testcase --vardir=/home/nirbhay/project/git-repo/mariadb/10.1/install/mysql-test/var --getopt-ll-test=25600M >> /home/nirbhay/project/git-repo/mariadb/10.1/install/mysql-test/var/log/mysql_client_test.out.log 2>&1' failed, error: 256, status: 1, errno: 2
      Output from before failure:
      call mtr.add_suppression(" Error reading file './client_test_db/test_frm_bug.frm'");
       
       
       
      The result from queries just before the failure was:
      SET @old_general_log= @@global.general_log;
      SET @old_slow_query_log= @@global.slow_query_log;
      call mtr.add_suppression(" Error reading file './client_test_db/test_frm_bug.frm'");
       
       - saving '/home/nirbhay/project/git-repo/mariadb/10.1/install/mysql-test/var/log/main.mysql_client_test/' to '/home/nirbhay/project/git-repo/mariadb/10.1/install/mysql-test/var/log/main.mysql_client_test/'
      -------------------------------------------------------------------------
      The servers were restarted 0 times
      Spent 0.000 of 13 seconds executing testcases
       
      Failure: Failed 1/1 tests, 0.00% were successful.
       
      Failing test(s): main.mysql_client_test
      

      $cat var/log/mysql_client_test.out.log
      ...
      #####################################
      209 of (1/1): test_ps_query_cache
      #####################################
      ...
       row 2: 1, ii(2)
       row 3: 2, ii(2)/home/nirbhay/project/git-repo/mariadb/10.1/tests/mysql_client_test.c:2455: check failed: 'hits1-hits2 == 1'
      MySQL error 0:
      ...
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                elenst Elena Stepanova
                Reporter:
                nirbhay_c Nirbhay Choubey (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: