TiDB 6.1.7 Release Notes

Release date: July 12, 2023

TiDB version: 6.1.7

Quick access: Quick start | Production deployment

Improvements

• TiDB

  • Use pessimistic transactions in internal transaction retry to avoid retry failure and reduce time consumption #38136 @jackysp

• Tools

  • TiCDC

    • Support batch UPDATE DML statements to improve TiCDC replication performance #8084 @amyangfei

  • TiDB Lightning

    • Verify checksum through SQL after the import to improve stability of verification #41941 @GMHDBJD

Bug fixes

• TiDB

  • Fix the panic issue caused by empty processInfo #43829 @zimulala
  • Fix the issue that resolve lock might hang when there is a sudden change in PD time #44822 @zyguan
  • Fix the issue that queries containing Common Table Expressions (CTEs) might cause insufficient disk space #44477 @guo-shaoge
  • Fix the issue that using CTEs and correlated subqueries simultaneously might result in incorrect query results or panic #44649 #38170 #44774 @winoros @guo-shaoge
  • Fix the issue that the query result of the SELECT CAST(n AS CHAR) statement is incorrect when n in the statement is a negative number #44786 @xhebox
  • Fix the query panic issue of TiDB in certain cases #40857 @Dousir9
  • Fix the issue that SQL compile error logs are not redacted #41831 @lance6716
  • Fix the issue that the SELECT statement returns an error for a partitioned table if the table partition definition uses the FLOOR() function to round a partitioned column #42323 @jiyfhust
  • Fix the issue that querying partitioned tables might cause errors during Region split #43144 @lcwangchao
  • Fix the issue of unnecessary memory usage during reading statistical information #42052 @xuyifangreeneyes
  • Fix the issue of excessive memory usage after creating a large number of empty partitioned tables #44308 @hawkingrei
  • Fix the issue that queries might return incorrect results when tidb_opt_agg_push_down is enabled #44795 @AilinKid
  • Fix the issue that the join result of common table expressions might be wrong #38170 @wjhuang2016
  • Fix the issue that in some rare cases, residual pessimistic locks of pessimistic transactions might affect data correctness when GC resolves locks #43243 @MyonKeminta
  • Fix the issue that after a new column is added in the cache table, the value is NULL instead of the default value of the column #42928 @lqs
  • Fix the issue that TiDB returns an error when the corresponding rows in partitioned tables cannot be found in the probe phase of index join #43686 @AilinKid @mjonss
  • Fix the issue that dropping a database causes slow GC progress #33069 @tiancaiamao
  • Fix the issue that data and indexes are inconsistent when the ON UPDATE statement does not correctly update the primary key #44565 @zyguan
  • Fix the issue that TiCDC might lose some row changes during table renaming #43338 @tangenta
  • Fix the behavior issue of Placement Rules in partitioned tables, so that the Placement Rules in deleted partitions can be correctly set and recycled #44116 @lcwangchao
  • Fix the issue that when tidb_scatter_region is enabled, Region does not automatically split after a partition is truncated #43174 #43028
  • Fix the issue of DDL retry caused by write conflict when executing TRUNCATE TABLE for partitioned tables with many partitions and TiFlash replicas #42940 @mjonss
  • Fix the issue of incorrect execution plans when pushing down window functions to TiFlash #43922 @gengliqi
  • Fix the issue that incorrect results might be returned when using a common table expression (CTE) in statements with non-correlated subqueries #44051 @winoros
  • Fix the issue that using memTracker with cursor fetch causes memory leaks #44254 @YangKeao
  • Fix the issue that the data length in the QUERY column of the INFORMATION_SCHEMA.DDL_JOBS table might exceed the column definition #42440 @tiancaiamao
  • Fix the issue that the min, max query result is incorrect #43805 @wshwsh12
  • Fix the issue that TiDB reports syntax errors when analyzing tables #43392 @guo-shaoge
  • Fix the issue that the SHOW PROCESSLIST statement cannot display the TxnStart of the transaction of the statement with a long subquery time #40851 @crazycs520
  • Fix the issue of missing table names in the ADMIN SHOW DDL JOBS result when a DROP TABLE operation is being executed #42268 @tiancaiamao
  • Fix the issue of displaying the incorrect TiDB address in IPv6 environment #43260 @nexustar
  • Fix the issue that the SQL statement reports the runtime error: index out of range error when using the AES_DECRYPT expression #43063 @lcwangchao
  • Fix the issue that there is no warning when using SUBPARTITION to create partitioned tables #41198 #41200 @mjonss
  • Fix the issue that the query with CTE causes TiDB to hang #43749 #36896 @guo-shaoge
  • Fix the issue that truncating a partition of a partitioned table might cause the Placement Rule of the partition to become invalid #44031 @lcwangchao
  • Fix the issue that CTE results are incorrect when pushing down predicates #43645 @winoros
  • Fix the issue that auto-commit change affects transaction commit behaviours #36581 @cfzjywxk

• TiKV

  • Fix the issue that TiDB Lightning might cause SST file leakage #14745 @YuJuncen
  • Fix the issue that encryption key ID conflict might cause the deletion of the old keys #14585 @tabokie
  • Fix the issue of file handle leakage in Continuous Profiling #14224 @tabokie

• PD

  • Fix the issue that gRPC returns errors with unexpected formats #5161 @HuSharp

• Tools

  • Backup & Restore (BR)

    • Fix the issue that resolved lock timeout is falsely reported in some cases #43236 @YuJuncen
    • Fix the issue of backup slowdown when a TiKV node crashes in a cluster #42973 @YuJuncen

  • TiCDC

    • Fix the issue that TiCDC cannot create a changefeed with a downstream Kafka-on-Pulsar #8892 @hi-rustin
    • Fix the issue that TiCDC cannot automatically recover when PD address or leader fails #8812 #8877 @asddongmen
    • Fix the issue that when the downstream is Kafka, TiCDC queries the downstream metadata too frequently and causes excessive workload in the downstream #8957 #8959 @hi-rustin
    • Fix the issue that TiCDC gets stuck when PD fails such as network isolation or PD Owner node reboot #8808 #8812 #8877 @asddongmen

  • TiDB Lightning

    • Fix the issue that in Logical Import Mode, deleting tables downstream during import might cause TiDB Lightning metadata not to be updated in time #44614 @dsdashun
    • Fix the issue that disk quota might be inaccurate due to competing conditions #44867 @D3Hunter
    • Fix the issue of write to tikv with no leader returned when importing a large amount of data #43055 @lance6716
    • Fix a possible OOM problem when there is an unclosed delimiter in the data file #40400 @buchuitoudegou
    • Fix the issue that OOM might occur when importing a wide table #43728 @D3Hunter

  • TiDB Binlog

    • Fix the issue that the etcd client does not automatically synchronize the latest node information during initialization #1236 @lichunzhu
    • Fix the panic issue of Drainer due to an old TiKV client version by upgrading the TiKV client #1170 @lichunzhu
    • Fix the issue that unfiltered failed DDL statements cause task errors #1228 @lichunzhu