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

SELECT from I_S.QUERY_CACHE_INFO produces ER_UNKNOWN_ERROR when query cache size is 0

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 5.5.31
    • 5.5.32
    • None
    • None

    Description

      MariaDB [test]> set global query_cache_size = 1024*1024;
      Query OK, 0 rows affected (0.00 sec)
       
      MariaDB [test]> select * from information_schema.query_cache_info;
      Empty set (0.00 sec)
       
      MariaDB [test]> set global query_cache_size = 0;
      Query OK, 0 rows affected (0.00 sec)
       
      MariaDB [test]> select * from information_schema.query_cache_info;
      ERROR 1105 (HY000): Unknown error

      bzr version-info

      revision-id: monty@askmonty.org-20130512082916-vjlzg3tjtlbvnowy
      revno: 3759
      branch-nick: 5.5

      Attachments

        Issue Links

          Activity

            ok MDEV-4576 and MDEV-4571
            thanks!

            rspadim roberto spadim added a comment - ok MDEV-4576 and MDEV-4571 thanks!

            set global query_cache_type=0, global query_cache_size=1000000;

            get the same error code
            /* Erro SQL (1105): Unknown error */

            rspadim roberto spadim added a comment - set global query_cache_type=0, global query_cache_size=1000000; get the same error code /* Erro SQL (1105): Unknown error */

            this is a "patch" (my first one in mariadb!! =) )
            diff -u qc_info.old.cc qc_info.cc > diff_qc_info.cc

            of mariadb 5.5.31 query cache plugin
            i did more checks about query_cache_size and query_cache_type
            i put more columns too (please review since i don't know very well what i'm doing)

            that's all =)

            rspadim roberto spadim added a comment - this is a "patch" (my first one in mariadb!! =) ) diff -u qc_info.old.cc qc_info.cc > diff_qc_info.cc of mariadb 5.5.31 query cache plugin i did more checks about query_cache_size and query_cache_type i put more columns too (please review since i don't know very well what i'm doing) that's all =)

            Thanks! But this particular bug is already fixed. Could you create a new issue — for adding more columns to the table — and attach your patch there please?

            serg Sergei Golubchik added a comment - Thanks! But this particular bug is already fixed. Could you create a new issue — for adding more columns to the table — and attach your patch there please?

            yes, it's: MDEV-4581

            rspadim roberto spadim added a comment - yes, it's: MDEV-4581

            People

              serg Sergei Golubchik
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.