Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

support diff tiflash mpp mode : err=unknown operator type ExchangeSender_22 #5

Open
glkappe opened this issue Jul 11, 2022 · 0 comments

Comments

@glkappe
Copy link

glkappe commented Jul 11, 2022

`tiup PCC capture --mode online --addr1 172.16.7.122 --port1 4000 --user1 root --ver2 v5.4.1  --query-file /root/qh/pcc/query.sql
tiup is checking updates for component PCC ...
Starting component `PCC`: /root/.tiup/components/PCC/1.0.1/bin/plan-change-capturer capture --mode online --addr1 172.16.7.122 --port1 4000 --user1 root --ver2 v5.4.1 --query-file /root/qh/pcc/query.sql
Try to start tidb:v5.4.1 ...
Starting component `tidb`: /root/.tiup/components/tidb/v5.4.1/tidb-server -P=37555 -status=45007 -path=/tmp/plan-change-capturer-instance/2022-07-11T12-19-01+08-00
Start tidb:v5.4.1 successfully with args: [-P=37555 -status=45007 -path=/tmp/plan-change-capturer-instance/2022-07-11T12-19-01+08-00]
export schema of test1.sbtest1 into /tmp/plan-change-capturer/2022-07-11T12-19-07+08-00/schema-test1-sbtest1.sql
export stats of test1.sbtest1 into /tmp/plan-change-capturer/2022-07-11T12-19-07+08-00/stats-test1-sbtest1.json
export schema of test1.sbtest2 into /tmp/plan-change-capturer/2022-07-11T12-19-07+08-00/schema-test1-sbtest2.sql
export stats of test1.sbtest2 into /tmp/plan-change-capturer/2022-07-11T12-19-07+08-00/stats-test1-sbtest2.json
import schemas from /tmp/plan-change-capturer/2022-07-11T12-19-07+08-00/schema-test1-sbtest1.sql successfully
import schemas from /tmp/plan-change-capturer/2022-07-11T12-19-07+08-00/stats-test1-sbtest1.json successfully
import schemas from /tmp/plan-change-capturer/2022-07-11T12-19-07+08-00/schema-test1-sbtest2.sql successfully
import schemas from /tmp/plan-change-capturer/2022-07-11T12-19-07+08-00/stats-test1-sbtest2.json successfully
begin to capture plan changes between  and v5.4.1
parse explain SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5017 AND 5116 ORDER BY c; err=unknown operator type ExchangeSender_31
=====================================================================
SQL:
explain SELECT c FROM sbtest1 WHERE id BETWEEN 5026 AND 5125;

Plan1:
Projection_4              |  100.00  |  root          |               test1.sbtest1.c
└─TableReader_8       |  100.00  |  root          |               data:TableRangeScan_7
  └─TableRangeScan_7  |  100.00  |  cop[tiflash]  |  table:sbtest1range:[5026,5125], keep order:false

Plan2:
Projection_4              |  100.00  |  root       |               test1.sbtest1.c
└─TableReader_6       |  100.00  |  root       |               data:TableRangeScan_5
  └─TableRangeScan_5  |  100.00  |  cop[tikv]  |  table:sbtest1range:[5026,5125], keep order:false

Reason:  different operators TableRangeScan_7 and TableRangeScan_5
=====================================================================
**parse explain SELECT SUM(K) FROM sbtest1 WHERE id BETWEEN 5035 AND 5134; err=unknown operator type ExchangeSender_22**
finish capturing plan changes
`
@glkappe glkappe changed the title support diff tiflash mpp mode support diff tiflash mpp mode : err=unknown operator type ExchangeSender_22 Jul 11, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant