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

Test failure on galera.query_cache

Details

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-amd64/builds/3924/steps/mtr/logs/stdio

      galera.query_cache 'xtradb'              w1 [ fail ]
      		 
              Test ended at 2018-04-07 13:43:12
      		 
       
      		 
      CURRENT_TEST: galera.query_cache
      		 
      --- /usr/share/mysql/mysql-test/suite/galera/r/query_cache.result	2018-04-07 12:59:53.000000000 -0400
      		 
      +++ /dev/shm/var/1/log/query_cache.reject	2018-04-07 13:43:11.566830604 -0400
      		 
      @@ -1535,7 +1535,7 @@
      		 
       Qcache_queries_in_cache	0
      		 
       show status like "Qcache_inserts";
      		 
       Variable_name	Value
      		 
      -Qcache_inserts	46
      		 
      +Qcache_inserts	45
      		 
       show status like "Qcache_hits";
      		 
       Variable_name	Value
      		 
       Qcache_hits	12
      		 
      @@ -1548,7 +1548,7 @@
      		 
       Qcache_queries_in_cache	1
      		 
       show status like "Qcache_inserts";
      		 
       Variable_name	Value
      		 
      -Qcache_inserts	47
      		 
      +Qcache_inserts	46
      		 
       show status like "Qcache_hits";
      		 
       Variable_name	Value
      		 
       Qcache_hits	13
      		 
       
      		 
      mysqltest: Result content mismatch

      Attachments

        Issue Links

          duplicates

          Task - A task that needs to be done. MDEV-18137 Galera test failure on query_cache

          • Major - Major loss of function.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13883 galera.query_cache fails in buildbot with wrong result

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            jplindst Jan Lindström (Inactive) added a comment -

            Could not find recent failure from cross reference so assuming as fixed.

            jplindst Jan Lindström (Inactive) added a comment - Could not find recent failure from cross reference so assuming as fixed.
            jplindst Jan Lindström (Inactive) added a comment -

            Not stable yet.

            jplindst Jan Lindström (Inactive) added a comment - Not stable yet.
            midenok Aleksey Midenkov added a comment -

            Still fails in 10.4:

            http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-ppc64le/builds/3418

            midenok Aleksey Midenkov added a comment - Still fails in 10.4: http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-ppc64le/builds/3418
            serg Sergei Golubchik added a comment -

            Latest failures in the main trees:

            2018-10-26 09:45:59 10.2 http://buildbot.askmonty.org/buildbot/builders/kvm-deb-trusty-amd64/builds/12649
            2018-10-20 16:34:01 10.3 http://buildbot.askmonty.org/buildbot/builders/kvm-deb-xenial-x86/builds/8405
            2018-10-25 01:40:04 10.4 http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-x86/builds/5230
            serg Sergei Golubchik added a comment - Latest failures in the main trees: 2018-10-26 09:45:59 10.2 http://buildbot.askmonty.org/buildbot/builders/kvm-deb-trusty-amd64/builds/12649 2018-10-20 16:34:01 10.3 http://buildbot.askmonty.org/buildbot/builders/kvm-deb-xenial-x86/builds/8405 2018-10-25 01:40:04 10.4 http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-x86/builds/5230
            jplindst Jan Lindström (Inactive) added a comment -

            mkaruza Can you have a look, for some reason there is consistent difference on results sometimes.

            jplindst Jan Lindström (Inactive) added a comment - mkaruza Can you have a look, for some reason there is consistent difference on results sometimes.
            midenok Aleksey Midenkov added a comment -

            Still fails in 10.3: http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-x86/builds/7034

            CURRENT_TEST: galera.query_cache
            		 
            --- /usr/share/mysql/mysql-test/suite/galera/r/query_cache.result	2019-08-11 05:40:48.000000000 -0400
            		 
            +++ /dev/shm/var/1/log/query_cache.reject	2019-08-11 07:43:35.203728955 -0400
            		 
            @@ -1347,7 +1347,7 @@
            		 
             Qcache_hits	12
            		 
             show status like "Qcache_inserts";
            		 
             Variable_name	Value
            		 
            -Qcache_inserts	36
            		 
            +Qcache_inserts	35
            		 
             drop table t1;
            		 
             #
            		 
             # Test of SQL_SELECT_LIMIT
            		 
            @@ -1378,7 +1378,7 @@
            		 
             Qcache_hits	12
            		 
             show status like "Qcache_inserts";
            		 
             Variable_name	Value
            		 
            -Qcache_inserts	38
            		 
            +Qcache_inserts	37
            		 
             SET SQL_SELECT_LIMIT=DEFAULT;
            		 
             # On node-2
            		 
             connection node_2;
            		 
            @@ -1425,7 +1425,7 @@
            		 
             Qcache_hits	12
            		 
             show status like "Qcache_inserts";
            		 
             Variable_name	Value
            		 
            -Qcache_inserts	40
            		 
            +Qcache_inserts	39
            		 
             lock table t1 write, t2 read;
            		 
             show status like "Qcache_queries_in_cache";
            		 
             Variable_name	Value
            		 
            @@ -1451,7 +1451,7 @@
            		 
             Qcache_hits	12
            		 
             show status like "Qcache_inserts";
            		 
             Variable_name	Value
            		 
            -Qcache_inserts	41
            		 
            +Qcache_inserts	40
            		 
             unlock table;
            		 
             drop view v1;
            		 
             set query_cache_wlock_invalidate=default;
            		 
            @@ -1533,7 +1533,7 @@
            		 
             Qcache_hits	12
            		 
             show status like "Qcache_inserts";
            		 
             Variable_name	Value
            		 
            -Qcache_inserts	43
            		 
            +Qcache_inserts	42
            		 
             set collation_connection=koi8r_bin;
            		 
             SELECT a,'Â','â'='Â' FROM t1;
            		 
             a	Â	'â'='Â'
            		 
            @@ -1547,7 +1547,7 @@
            		 
             Qcache_hits	12
            		 
             show status like "Qcache_inserts";
            		 
             Variable_name	Value
            		 
            -Qcache_inserts	44
            		 
            +Qcache_inserts	43
            		 
             set character_set_client=cp1251;
            		 
             SELECT a,'Â','â'='Â' FROM t1;
            		 
             a	�?	'�?'='�?'
            		 
            @@ -1561,7 +1561,7 @@
            		 
             Qcache_hits	12
            		 
             show status like "Qcache_inserts";
            		 
             Variable_name	Value
            		 
            -Qcache_inserts	45
            		 
            +Qcache_inserts	44
            		 
             set character_set_results=cp1251;
            		 
             SELECT a,'Â','â'='Â' FROM t1;
            		 
             a	�?	'â'='Â'
            		 
            @@ -1575,7 +1575,7 @@
            		 
             Qcache_hits	12
            		 
             show status like "Qcache_inserts";
            		 
             Variable_name	Value
            		 
            -Qcache_inserts	46
            		 
            +Qcache_inserts	45
            		 
             SET NAMES default;
            		 
             # On node-2
            		 
             connection node_2;

            midenok Aleksey Midenkov added a comment - Still fails in 10.3: http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-x86/builds/7034 CURRENT_TEST: galera.query_cache --- /usr/share/mysql/mysql-test/suite/galera/r/query_cache.result 2019-08-11 05:40:48.000000000 -0400 +++ /dev/shm/var/1/log/query_cache.reject 2019-08-11 07:43:35.203728955 -0400 @@ -1347,7 +1347,7 @@ Qcache_hits 12 show status like "Qcache_inserts"; Variable_name Value -Qcache_inserts 36 +Qcache_inserts 35 drop table t1; # # Test of SQL_SELECT_LIMIT @@ -1378,7 +1378,7 @@ Qcache_hits 12 show status like "Qcache_inserts"; Variable_name Value -Qcache_inserts 38 +Qcache_inserts 37 SET SQL_SELECT_LIMIT=DEFAULT; # On node-2 connection node_2; @@ -1425,7 +1425,7 @@ Qcache_hits 12 show status like "Qcache_inserts"; Variable_name Value -Qcache_inserts 40 +Qcache_inserts 39 lock table t1 write, t2 read; show status like "Qcache_queries_in_cache"; Variable_name Value @@ -1451,7 +1451,7 @@ Qcache_hits 12 show status like "Qcache_inserts"; Variable_name Value -Qcache_inserts 41 +Qcache_inserts 40 unlock table; drop view v1; set query_cache_wlock_invalidate=default; @@ -1533,7 +1533,7 @@ Qcache_hits 12 show status like "Qcache_inserts"; Variable_name Value -Qcache_inserts 43 +Qcache_inserts 42 set collation_connection=koi8r_bin; SELECT a,'Â','â'='Â' FROM t1; a  'â'='Â' @@ -1547,7 +1547,7 @@ Qcache_hits 12 show status like "Qcache_inserts"; Variable_name Value -Qcache_inserts 44 +Qcache_inserts 43 set character_set_client=cp1251; SELECT a,'Â','â'='Â' FROM t1; a �? '�?'='�?' @@ -1561,7 +1561,7 @@ Qcache_hits 12 show status like "Qcache_inserts"; Variable_name Value -Qcache_inserts 45 +Qcache_inserts 44 set character_set_results=cp1251; SELECT a,'Â','â'='Â' FROM t1; a �? 'â'='Â' @@ -1575,7 +1575,7 @@ Qcache_hits 12 show status like "Qcache_inserts"; Variable_name Value -Qcache_inserts 46 +Qcache_inserts 45 SET NAMES default; # On node-2 connection node_2;
            stepan.patryshev Stepan Patryshev (Inactive) added a comment -

            Closing as not reproduced.

            stepan.patryshev Stepan Patryshev (Inactive) added a comment - Closing as not reproduced.
            stepan.patryshev Stepan Patryshev (Inactive) added a comment -

            Reopening since it has not been reproduced because it is disabled.

            stepan.patryshev Stepan Patryshev (Inactive) added a comment - Reopening since it has not been reproduced because it is disabled.

            People

              jplindst Jan Lindström (Inactive)
              jplindst Jan Lindström (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              6 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.