Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-5484

mysql.json std_data files have wrong char_length for mysql.compression_dictionary.data

Details

    • Bug
    • Status: Done
    • Medium
    • Resolution: Fixed
    • 8.0.x, Not 5.6.x, Not 5.7.x
    • 8.0.15-6
    • None

    Description

      This shows up as

      90307  8:50:17 [ 55%] main.dd_upgrade_test                     w5  [ fail ]
              Test ended at 2019-03-07 08:50:17
      
      CURRENT_TEST: main.dd_upgrade_test
      mysqltest: At line 648: Command "diff_files" failed with error 1. my_errno=175.
      ...
      # Check SDI from mysql.ibd
      --- /tmp/results/PS/mysql-test/std_data/dd/sdi/upgrade/mysql.json	2019-03-07 10:36:44.000000000 +0300
      +++ /tmp/results/PS/mysql-test/var/tmp/5/sdi_dest//mysql.json	2019-03-07 11:50:14.748171220 +0300
      @@ -22959,7 +22959,7 @@
                       "is_virtual": false,
                       "hidden": 1,
                       "ordinal_position": 4,
      -                "char_length": 8,
      +                "char_length": 65535,
                       "numeric_precision": 0,
                       "numeric_scale": 0,
                       "numeric_scale_null": true,
      safe_process[26615]: Child process: 26616, exit: 1
      

      and

      190307  9:02:20 [ 68%] innodb.sdi                               w1  [ fail ]
              Test ended at 2019-03-07 09:02:20
      
      CURRENT_TEST: innodb.sdi
      mysqltest: At line 174: Command "diff_files" failed with error 1. my_errno=175.
      ...
      # Check SDI from mysql.ibd
      --- /tmp/results/PS/mysql-test/std_data/dd/sdi/innodb_sdi/mysql.json	2019-03-07 10:36:44.000000000 +0300
      +++ /tmp/results/PS/mysql-test/var/tmp/1/sdi_dest//mysql.json	2019-03-07 12:02:16.193581574 +0300
      @@ -22959,7 +22959,7 @@
                       "is_virtual": false,
                       "hidden": 1,
                       "ordinal_position": 4,
      -                "char_length": 8,
      +                "char_length": 65535,
                       "numeric_precision": 0,
                       "numeric_scale": 0,
                       "numeric_scale_null": true,
      safe_process[17520]: Child process: 17521, exit: 1
      ...
      

      The actual SDIs produced by test have the correct char_length for a BLOB field, thus, the std_data SDIs have to be updated to match.

      Attachments

        Activity

          People

            laurynas.biveinis Laurynas Biveinis (Inactive)
            laurynas.biveinis Laurynas Biveinis (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 14 minutes
                14m

                Smart Checklist