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