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

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

Details

    • Bug
    • Status: Done
    • Medium
    • Resolution: Fixed
    • None
    • 3.0.6
    • 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'
      

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist