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

main.query_cache_debug failed in buildbot, Query cache is disabled

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.0
    • N/A
    • Query Cache, Tests
    • None

    Description

      http://buildbot.askmonty.org/buildbot/builders/winx64-debug/builds/7278/steps/test/logs/stdio

      main.query_cache_debug                   w3 [ fail ]
              Test ended at 2018-02-08 19:56:49
       
      CURRENT_TEST: main.query_cache_debug
      mysqltest: At line 371: query 'SEt GLOBAL query_cache_type= DEFAULT' failed: 1924: Query cache is disabled (resize or similar command in progress); repeat this command later
       
      The result from queries just before the failure was:
      < snip >
      `id` int(10) NOT NULL AUTO_INCREMENT,
      `k` int(10) default '0',
      PRIMARY KEY (`id`))
      ENGINE=MyISAM;
      INSERT IGNORE INTO t1 VALUES
      (NULL,1),(NULL,8),(NULL,NULL),(NULL,NULL),(NULL,4),(NULL,9),(NULL,7),
      (NULL,3),(NULL,NULL),(NULL,2),(NULL,3),(NULL,NULL),(NULL,2),(NULL,7),
      (NULL,1),(NULL,2),(NULL,4),(NULL,NULL),(NULL,1),(NULL,1),(NULL,4);
      SET GLOBAL query_cache_size= 1024*1024;
      SET GLOBAL query_cache_type= 1;
      set debug_sync="wait_in_query_cache_store_query SIGNAL parked WAIT_FOR go";
      SELECT DISTINCT id FROM t1 WHERE id BETWEEN 5603 AND 16218 ORDER BY k;
      set debug_sync="now WAIT_FOR parked";
      SET GLOBAL query_cache_type= 0;
      set debug_sync="now SIGNAL go";
      id
      set debug_sync= 'RESET';
      DROP TABLE t1;
      SEt GLOBAL query_cache_size= DEFAULT;
      SEt GLOBAL query_cache_type= DEFAULT;
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.