Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-225

pt-table-checksum failed on virtual/stored generated columns

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.0.6
    • Component/s: None

      Description

      PS 5.7 1 master 2 slaves.

      With latest version of percona-toolkit:

      $ pt-table-checksum --user=root --socket=./socket.sock --recursion-method dsn=h=localhost,D=test,t=dsns --no-check-binlog-format
      
      11-22T15:29:41 Skipping table sysbench_test_db.sbtest1 because it has problems on these replicas:
      Table sysbench_test_db.sbtest1 on replica qaserver-02.ci.percona.com is missing these columns: json_test_v, json_test_s, json_test_index
      Table sysbench_test_db.sbtest1 on replica qaserver-02.ci.percona.com is missing these columns: json_test_v, json_test_s, json_test_index
      

      Checking on slaves:

      CREATE TABLE `sbtest1` (
        `id` int(11) NOT NULL AUTO_INCREMENT,
        `k` int(11) NOT NULL DEFAULT '0',
        `c` char(120) NOT NULL DEFAULT '',
        `pad` char(60) NOT NULL DEFAULT '',
        `json_test_v` json GENERATED ALWAYS AS (json_array(`k`,`c`,`pad`)) VIRTUAL,
        `json_test_s` json GENERATED ALWAYS AS (json_array(`k`,`c`,`pad`)) STORED,
        `json_test_index` varchar(255) GENERATED ALWAYS AS (json_array(`k`,`c`,`pad`)) STORED,
        PRIMARY KEY (`id`),
        KEY `k_1` (`k`),
        KEY `json_test_index` (`json_test_index`)
      ) ENGINE=InnoDB AUTO_INCREMENT=1001 DEFAULT CHARSET=latin1 COMPRESSION='lz4' ENCRYPTION='Y'
      

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                carlos.salguero Carlos Salguero
                Reporter:
                shahriyar.rzayev Shahriyar Rzayev (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: