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

MariaRocks: rocksdb.rocksdb fails with a duplicate key error

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • N/A
    • OTHER
    • None

    Description

      rocksdb.rocksdb                          [ fail ]
      		 
              Test ended at 2016-10-24 12:02:33
      		 
       
      		 
      CURRENT_TEST: rocksdb.rocksdb
      		 
      mysqltest: At line 1196: query 'INSERT INTO t1 (i,t,s,m,b) VALUES (1,2,3,4,5),(1000,100,10000,1000000,1000000000000000000),(5,100,10000,1000000,100000000000000000),(2,3,4,5,6),(3,4,5,6,7),(101,102,103,104,105),
      		 
      (10001,103,10002,10003,10004),(10,11,12,13,14),(11,12,13,14,15),(12,13,14,15,16)' 
      failed: 1062: Duplicate entry '6-3' for key 'b_t'

      Attachments

        Issue Links

          is part of

          Task - A task that needs to be done. MDEV-9658 Make MyRocks in MariaDB stable

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            psergei Sergei Petrunia created issue -
            psergei Sergei Petrunia made changes -
            Field Original Value New Value
            psergei Sergei Petrunia made changes -
            Description
            {noformat}
            rocksdb.rocksdb [ fail ]
                    Test ended at 2016-10-24 12:02:33

            CURRENT_TEST: rocksdb.rocksdb
            mysqltest: At line 1196: query 'INSERT INTO t1 (i,t,s,m,b) VALUES (1,2,3,4,5),(1000,100,10000,1000000,1000000000000000000),(5,100,10000,1000000,100000000000000000),(2,3,4,5,6),(3,4,5,6,7),(101,102,103,104,105),(10001,103,10002,10003,10004),(10,11,12,13,14),(11,12,13,14,15),(12,13,14,15,16)' failed: 1062: Duplicate entry '6-3' for key 'b_t'
            {noformat}
            		{noformat}
            rocksdb.rocksdb [ fail ]
                    Test ended at 2016-10-24 12:02:33

            CURRENT_TEST: rocksdb.rocksdb
            mysqltest: At line 1196: query 'INSERT INTO t1 (i,t,s,m,b) VALUES (1,2,3,4,5),(1000,100,10000,1000000,1000000000000000000),(5,100,10000,1000000,100000000000000000),(2,3,4,5,6),(3,4,5,6,7),(101,102,103,104,105),
            (10001,103,10002,10003,10004),(10,11,12,13,14),(11,12,13,14,15),(12,13,14,15,16)'
            failed: 1062: Duplicate entry '6-3' for key 'b_t'
            {noformat}
            psergei Sergei Petrunia added a comment -

            .. and the reason of this is that in MariaDB, the function

            void Field::make_sort_key(uchar *buff,uint length)

            stores the NULL-indicator byte for the field. In MySQL, it does not. We store NULL-indicator bytes twice and screw up the comparison.

            psergei Sergei Petrunia added a comment - .. and the reason of this is that in MariaDB, the function void Field::make_sort_key(uchar *buff,uint length) stores the NULL-indicator byte for the field. In MySQL, it does not. We store NULL-indicator bytes twice and screw up the comparison.
            psergei Sergei Petrunia added a comment -

            Commit in MariaDB that introduced the change:
            0791692bdc311f39181b9df236981a2cb439638e
            MDEV-3875 Wrong result (missing row) on a DISTINCT query with the same subquery in the SELECT list and GROUP BY

            psergei Sergei Petrunia added a comment - Commit in MariaDB that introduced the change: 0791692bdc311f39181b9df236981a2cb439638e MDEV-3875 Wrong result (missing row) on a DISTINCT query with the same subquery in the SELECT list and GROUP BY
            psergei Sergei Petrunia added a comment -

            Fix pushed into MariaRocks tree.

            psergei Sergei Petrunia added a comment - Fix pushed into MariaRocks tree.
            psergei Sergei Petrunia made changes -
            Component/s OTHER [ 10125 ]
            Fix Version/s N/A [ 14700 ]
            Fix Version/s 10.2 [ 14601 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 78060 ] MariaDB v4 [ 132975 ]

            People

              psergei Sergei Petrunia
              psergei Sergei Petrunia
              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.