TiDB 6.1.4 Release Notes

Release date: February 8, 2023

TiDB version: 6.1.4

Quick access: Quick start | Production deployment | Installation packages

Compatibility changes

  • TiDB

    • No longer support modifying column types on partitioned tables because of potential correctness issues #40620 @mjonss

Improvements

  • TiFlash

    • Reduce the IOPS by up to 95% and the write amplification by up to 65% for TiFlash instances under high update throughput workloads #6460 @flowbehappy
  • Tools

    • TiCDC

      • Add the DML batch operation mode to improve the throughput when SQL statements are generated in batches #7653 @asddongmen
      • Support storing redo logs to GCS- or Azure-compatible object storage #7987 @CharlesCheung96
    • TiDB Lightning

      • Change the severity of the precheck items clusterResourceCheckItem and emptyRegionCheckItem from Critical to Warning #37654 @niubell

Bug fixes

  • TiDB

    • Fix the issue that when you create a table, the default value and the type of a column are not consistent and are not automatically corrected #34881 @Lloyd-Pottiger @mjonss
    • Fix the data race issue in the LazyTxn.LockKeys function #40355 @HuSharp
    • Fix the issue that the INSERT or REPLACE statements might panic in long session connections #40351 @fanrenhoo
    • Fix the issue that reading data using the "cursor read" method might return an error because of GC #39447 @zyguan
    • Fix the issue that the pessimistic-auto-commit configuration item does not take effect for point-get queries #39928 @zyguan
    • Fix the issue that querying the INFORMATION_SCHEMA.TIKV_REGION_STATUS table returns an incorrect result #37436 @zimulala
    • Fix the issue that the IN and NOT IN subqueries in some patterns report the Can't find column error #37032 @AilinKid @lance6716
  • PD

    • Fix the issue that PD might unexpectedly add multiple Learners to a Region #5786 @HunDunDM
  • TiKV

    • Fix the issue that TiDB fails to start on Gitpod when there are multiple cgroup and mountinfo records #13660 @tabokie
    • Fix the issue that tikv-ctl is terminated unexpectedly when executing the reset-to-version command #13829 @tabokie
    • Fix the issue that TiKV mistakenly reports a PessimisticLockNotFound error #13425 @sticnarf
    • Fix the issue that TiKV might panic when the size of one single write exceeds 2 GiB #13848 @YuJuncen
    • Fix the data inconsistency issue caused by network failure between TiDB and TiKV during the execution of a DML after a failed pessimistic DML #14038 @MyonKeminta
    • Fix the issue that _ in the LIKE operator cannot match non-ASCII characters when new collation is not enabled #13769 @YangKeao @tonyxuqqi
  • TiFlash

    • Fix the issue that TiFlash global locks are blocked for a long time occasionally #6418 @SeaRise
    • Fix the issue that high throughput writes cause OOM #6407 @JaySon-Huang
  • Tools

    • Backup & Restore (BR)

      • Fix the issue that restore is interrupted due to failure in getting the Region size #36053 @YuJuncen
      • Fix the issue that causes panic when BR debugs the backupmeta file #40878 @MoCuishle28
    • TiCDC

      • Fix the issue that the checkpoint cannot advance when TiCDC replicates an excessively large number of tables #8004 @asddongmen
      • Fix the issue that transaction_atomicity and protocol cannot be updated via the configuration file #7935 @CharlesCheung96
      • Fix the issue that TiCDC mistakenly reports an error when the version of TiFlash is later than that of TiCDC #7744 @overvenus
      • Fix the issue that OOM occurs when TiCDC replicates large transactions #7913 @overvenus
      • Fix a bug that the context deadline is exceeded when TiCDC replicates data without splitting large transactions #7982 @hi-rustin
      • Fix the issue that sasl-password in the changefeed query result is not masked #7182 @dveeden
      • Fix the issue that data is lost when a user quickly deletes a replication task and then creates another one with the same task name #7657 @overvenus
    • TiDB Data Migration (DM)

      • Fix a bug that DM might raise an error during precheck when the downstream database name in SHOW GRANTS contains a wildcard ("*") #7645 @lance6716
      • Fix the issue that DM prints too many logs caused by "COMMIT" in binlog query events #7525 @liumengya94
      • Fix the issue that the DM task fails to start when only ssl-ca is configured for SSL #7941 @liumengya94
      • Fix a bug that when the expression filters of both "update" and "non-update" types are specified in one table, all UPDATE statements are skipped #7831 @lance6716
      • Fix a bug that when only one of update-old-value-expr or update-new-value-expr is set for a table, the filter rule does not take effect or DM panics #7774 @lance6716
    • TiDB Lightning

      • Fix the memory leakage issue when TiDB Lightning imports a huge source data file #39331 @dsdashun
      • Fix the issue that TiDB Lightning prechecks cannot find dirty data left by previously failed imports #39477 @dsdashun