pingcap / pingcap/tidb

Sometimes TiDB does not raise the first error it received from TiFlash mpp

Open
#37,792 1 comment 0 reactions 0 assignees View on GitHub
type/enhancement
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Enhancement
```
[2022/09/13 21:37:57.990 +08:00] [WARN] [mpp.go:438] ["other error"] [txnStartTS=435965467766554652] [storeAddr=tc-tiflash-0.tc-tiflash-peer.endless-htap-zto-tps-1261360-1-131.svc:3930] [error="other error for mpp stream: From MPP: Code: 0, e.displayText() = DB::TiFlashException: Table 72 schema version 2596 newer than query schema version 2595, e.what() = DB::TiFlashException,"]
[2022/09/13 21:37:57.992 +08:00] [WARN] [mpp.go:438] ["other error"] [txnStartTS=435965467766554652] [storeAddr=tc-tiflash-1.tc-tiflash-peer.endless-htap-zto-tps-1261360-1-131.svc:3930] [error="other error for mpp stream: Receive cancel request from TiDB"]
[2022/09/13 21:37:57.992 +08:00] [WARN] [mpp.go:438] ["other error"] [txnStartTS=435965467766554652] [storeAddr=tc-tiflash-1.tc-tiflash-peer.endless-htap-zto-tps-1261360-1-131.svc:3930] [error="other error for mpp stream: Receive cancel request from TiDB"]
[2022/09/13 21:37:57.993 +08:00] [WARN] [mpp.go:438] ["other error"] [txnStartTS=435965467766554652] [storeAddr=tc-tiflash-3.tc-tiflash-peer.endless-htap-zto-tps-1261360-1-131.svc:3930] [error="other error for mpp stream: Receive cancel request from TiDB"]
[2022/09/13 21:37:57.995 +08:00] [WARN] [mpp.go:438] ["other error"] [txnStartTS=435965467766554652] [storeAddr=tc-tiflash-3.tc-tiflash-peer.endless-htap-zto-tps-1261360-1-131.svc:3930] [error="other error for mpp stream: Receive cancel request from TiDB"]
[2022/09/13 21:37:57.995 +08:00] [WARN] [mpp.go:438] ["other error"] [txnStartTS=435965467766554652] [storeAddr=tc-tiflash-2.tc-tiflash-peer.endless-htap-zto-tps-1261360-1-131.svc:3930] [error="other error for mpp stream: Receive cancel request from TiDB"]
[2022/09/13 21:37:57.996 +08:00] [WARN] [mpp.go:438] ["other error"] [txnStartTS=435965467766554652] [storeAddr=tc-tiflash-0.tc-tiflash-peer.endless-htap-zto-tps-1261360-1-131.svc:3930] [error="other error for mpp stream: From MPP: Code: 0, e.displayText() = DB::TiFlashException: Table 72 schema version 2596 newer than query schema version 2595, e.what() = DB::TiFlashException,"]
[2022/09/13 21:37:57.996 +08:00] [WARN] [mpp.go:438] ["other error"] [txnStartTS=435965467766554652] [storeAddr=tc-tiflash-2.tc-tiflash-peer.endless-htap-zto-tps-1261360-1-131.svc:3930] [error="other error for mpp stream: Receive cancel request from TiDB"]
[2022/09/13 21:37:58.002 +08:00] [INFO] [coprocessor.go:870] ["[TIME_COP_PROCESS] resp_time:363.000187ms txnStartTS:435965464043847789 region_id:2634 store_addr:tc-tikv-3.tc-tikv-peer.endless-htap-zto-tps-1261360-1-131.svc:20160 kv_process_ms:347 kv_wait_ms:0 kv_read_ms:347 processed_versions:264819 total_versions:265050 rocksdb_delete_skipped_count:53 rocksdb_key_skipped_count:265058 rocksdb_cache_hit_count:762 rocksdb_read_count:0 rocksdb_read_byte:0"] [conn=5619032183516696081]
[2022/09/13 21:37:58.010 +08:00] [INFO] [conn.go:1137] ["command dispatched failed"] [conn=5619032183516696083] [connInfo="id:5619032183516696083, addr:10.233.99.234:35138 status:10, collation:utf8mb4_general_ci, user:root"] [command=Query] [status="inTxn:0, autocommit:1"] [sql="select\n t.earliest_rec_site_id site_id,\n DATE_FORMAT(t.earliest_rec_date,'%Y%m%d') site_date,\n count(1) overtime_cnt,\n 1 overtime_type\nfrom zto_ssmx_bill_detail t\nwhere t.earliest_rec_date>=DATE_FORMAT(DATE_ADD(now(),INTERVAL -7 DAY),'%Y-%m-%d 00:00:00')\nand t.earliest_rec_date=DATE_FORMAT(DATE_ADD(now(),INTERVAL -7 DAY),'%Y-%m-%d 00:00:00')\nand t.last_center_send_date: Code: 0, e.displayText() = DB::TiFlashException: Table 72 schema version 2596 newer than query schema version 2595, e.what() = DB::TiFlashException,`, but in `[2022/09/13 21:37:58.010 +08:00] [INFO] [conn.go:1137] ["command dispatched failed"]`, the error return to TiDB client is `other error for mpp stream: Receive cancel request from TiDB`

It should be improved so TiDB can always return the first error it received from TiFlash mpp.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.