TiDB 4.0 GA Release Notes
Release date: May 28, 2020
TiDB version: 4.0.0
Compatibility Changes
TiDB
- Optimize the error message of the large-sized transactions for easier troubleshooting #17219
TiCDC
Important Bug Fixes
TiKV
TiFlash
- Fix the possible data loss issue that occurs when the system panics because of incorrect processing logic of
Raft Admin Command
- Fix the possible data loss issue that occurs when the system panics because of incorrect processing logic of
New Features
TiDB
- Add the
committer-concurrencyconfiguration item to control the number ofgoroutinesin the retry-commit phase #16849 - Support the
show table partition regionssyntax #17294 - Add the
tmp-storage-quotaconfiguration item to limit the temporary disk space used by the TiDB server #15700 - Support checking whether the partitioned table uses a unique prefix index when creating and changing tables #17213
- Support the
insert/replace into tbl_name partition(partition_name_list) statement #17313 - Support checking the value of
collationswhen using theDistinctfunction #17240 - Support the
is nullfilter condition during the Hash partition pruning #17310 - Support
admin check index,admin cleanup index, andadmin recover indexin partitioned tables #17392 #17405 #17317 - Support range partition pruning for the
inexpressions #17320
- Add the
TiFlash
- Support filtering out the data corresponding to the qualified
TSOthrough themin commit tsvalue of theLock CFwhen the Learner reads the data - Add the feature that the system explicitly reports an error to avoid incorrect calculation results when the value of
TIMESTAMPtype is less than1970-01-01 00:00:00 - Support using flags in regular expressions when searching logs
- Support filtering out the data corresponding to the qualified
TiKV
- Support collation rules of
ascii_binandlatin1_binencoding #7919
- Support collation rules of
PD
- Support specifying the reverse proxy resource prefix for built-in TiDB Dashboard #2457
- Support returning the
pending peeranddown peerinformation in interfaces of the PD client Region #2443 - Add monitoring items such as
Direction of hotspot move leader,Direction of hotspot move peer, andHot cache read entry number#2448
Tools
- Backup & Restore (BR)
- Support the backup and restore of
SequenceandView#242
- Support the backup and restore of
- TiCDC
- Support checking the validity of
Sink URIwhen creatingChangefeed#561 - Support checking whether the PD and TiKV versions meet the system requirements during system startup #570
- Support scheduling multiple tables in the same scheduling task generation cycle #572
- Add information about node roles in HTTP API #591
- Support checking the validity of
- Backup & Restore (BR)
Bug Fixes
TiDB
- Fix the issue of unexpected timeouts when sending and receiving messages by disabling TiDB to send batch commands to TiFlash #17307
- Fix the issue of incorrectly distinguishing signed and unsigned integers during partition pruning, which improves performance #17230
- Fix the issue of upgrade failure from v3.1.1 to v4.0 because of the incompatible
mysql.usertable #17300 - Fix the issue of incorrect selection of the partition in the
updatestatement #17305 - Fix system panics when receiving an unknown error message from TiKV #17380
- Fix system panics caused by incorrect processing logic when creating the table that is
keypartitioned #17242 - Fix the issue that the wrong
Index Merge Joinplan is selected because of incorrect optimizer processing logic #17365 - Fix the issue of inaccurate
durationmonitoring metric of theSELECTstatement in Grafana #16561 - Fix the issue that the GC worker is blocked when the system error occurs #16915
- Fix the issue that the
UNIQUEconstraint on a boolean column results in an incorrect result in a comparison #17306 - Fix system panics caused by incorrect processing logic when
tidb_opt_agg_push_downis enabled and the aggregation function pushes down the partitioned table #17328 - Fix the issue of accessing failed TiKV nodes in some cases #17342
- Fix the issue that the
isolation-readconfiguration item intidb.tomldoes not take effect #17322 - Fix the issue of incorrect order of output results due to incorrect processing logic when
hintis used to enforce the stream aggregation #17347 - Fix the behavior that
insertprocesses DIV under differentSQL_MODE#17314
TiFlash
- Fix the issue that the matching behavior of regular expressions in the search log feature is inconsistent with other components
- Fix the issue of excessive restart time when nodes write large amounts of data by disabling the delay processing optimization of
Raft Compact Log Commandby default - Fix the issue that the system fails to start because TiDB incorrectly processes the
DROP DATABASEstatement in some scenarios - Fix the issue that the method of collecting CPU information in
Server_infois different from that in other components - Fix the issue that the error
Too Many Pingsis reported when theQuerystatement is executed ifbatch coprocessoris enabled - Fix the issue that Dashboard fails to display the correct
deploy pathinformation because TiFlash does not report the related information
TiKV
- Fix the
DefaultNotFounderror that occurs when backing up using BR #7937 - Fix system panics caused by out-of-order
ReadIndexpackets #7930 - Fix the issue that an unexpected error is returned because the read request callback function is not called #7921
- Fix system panics caused by incorrectly removing snapshot files when TiKV is restarted #7927
- Fix the issue that the
master keycannot be rotated due to incorrect processing logic in storage encryption #7898 - Fix the issue that the received
lock cffile of the snapshot is not encrypted when the storage encryption is enabled #7922
- Fix the
PD
Tools
- Backup & Restore (BR)
- Fix the issue that the data restoration fails due to network issues when BR restores data from cloud storage #298
- TiCDC
- Backup & Restore (BR)