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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 8.0.x, Not 5.6.x, Not 5.7.x
    • Fix Version/s: 8.0.15-6
    • Component/s: 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.

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              laurynas.biveinis Laurynas Biveinis (Inactive)
              Reporter:
              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