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

tokudb.cluster_filter_unpack_varchar_hidden fails sporadically in buildbot

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.0(EOL), 10.1(EOL)
    • 10.0.25, 10.1.13
    • Tests
    • None

    Description

      http://buildbot.askmonty.org/buildbot/builders/bld-dan-release/builds/2379/steps/test/logs/stdio

      CURRENT_TEST: tokudb.cluster_filter_unpack_varchar_hidden
      		 
      --- /opt/buildbot-slave/mariadb/dan_demeter2/build/storage/tokudb/mysql-test/tokudb/r/cluster_filter_unpack_varchar_hidden.result	2015-03-24 18:33:33.114247391 +0200
      		 
      +++ /opt/buildbot-slave/mariadb/dan_demeter2/build/storage/tokudb/mysql-test/tokudb/r/cluster_filter_unpack_varchar_hidden.reject	2015-04-04 21:49:08.159777079 +0300
      		 
      @@ -182,14 +182,14 @@
      		 
       3	30	200	2000	20000	200000
      		 
       explain select * from t1 where b > "0";
      		 
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      		 
      -1	SIMPLE	t1	index	b	b	NULL	NULL	NULL;	Using where; Using index
      		 
      +1	SIMPLE	t1	range	b	b	NULL	NULL	NULL;	Using where; Using index
      		 
       select * from t1 where b > "0";
      		 
       a	b	c	d	e	f
      		 
       2	20	100	1000	10000	100000
      		 
       3	30	200	2000	20000	200000
      		 
       explain select * from t1 where d > "0";
      		 
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      		 
      -1	SIMPLE	t1	index	d	d	NULL	NULL	NULL;	Using where; Using index
      		 
      +1	SIMPLE	t1	range	d	d	NULL	NULL	NULL;	Using where; Using index
      		 
       select * from t1 where d > "0";
      		 
       a	b	c	d	e	f
      		 
       2	20	100	1000	10000	100000
      		 
       
      		 
      mysqltest: Result content mismatch

      So far it happened twice, on dan* builders (debug and non-debug, ps-protocol and normal).
      The change of plan doesn't look scary, but the test needs to be fixed eventually.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-7069 Fix buildbot failures in main server trees

          • Major - Major loss of function.
          • Stalled

          Activity

            Ascending order - Click to sort in descending order
            elenst Elena Stepanova created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 60353 ] MariaDB v3 [ 62002 ]
            elenst Elena Stepanova made changes -
            Affects Version/s 10.0 [ 16000 ]
            elenst Elena Stepanova made changes -
            Fix Version/s 10.0 [ 16000 ]
            elenst Elena Stepanova added a comment -

            4 times now, last two times on 10.0. Still only on dan* builders.

            elenst Elena Stepanova added a comment - 4 times now, last two times on 10.0. Still only on dan* builders.
            elenst Elena Stepanova added a comment -

            Still happens http://buildbot.askmonty.org/buildbot/builders/bld-dan-release/builds/3150

            elenst Elena Stepanova added a comment - Still happens http://buildbot.askmonty.org/buildbot/builders/bld-dan-release/builds/3150
            elenst Elena Stepanova made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            elenst Elena Stepanova added a comment -

            If I run it long enough, I can get in on my machine too. On some reason, it happens faster when runs on 10.1 with ps-protocol, although according to cross-reference 10.0 and non-ps-protocol are also affected.

            elenst Elena Stepanova added a comment - If I run it long enough, I can get in on my machine too. On some reason, it happens faster when runs on 10.1 with ps-protocol, although according to cross-reference 10.0 and non-ps-protocol are also affected.
            elenst Elena Stepanova added a comment -

            https://github.com/MariaDB/server/commit/e7d50efc458b95d5fad92f6020758d7c63b0dc0b

            elenst Elena Stepanova added a comment - https://github.com/MariaDB/server/commit/e7d50efc458b95d5fad92f6020758d7c63b0dc0b
            elenst Elena Stepanova made changes -
            Fix Version/s 10.0.25 [ 21701 ]
            Fix Version/s 10.1.13 [ 21803 ]
            Fix Version/s 10.0 [ 16000 ]
            Fix Version/s 10.1 [ 16100 ]
            Resolution Fixed [ 1 ]
            Status Confirmed [ 10101 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 62002 ] MariaDB v4 [ 148997 ]

            People

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