Important

You are viewing the documentation of TiDB v6.0 (DMR). PingCAP does not provide bug fixes for v6.0. Any bugs will be fixed in future releases.

For general purposes, please use the latest LTS version of the TiDB database.

TiDB 4.0.15 Release Notes

Release Date: September 27, 2021

TiDB version: 4.0.15

Compatibility changes

  • TiDB

    • Fix the issue that executing SHOW VARIABLES in a new session is slow. This fix reverts some changes made in #21045 and might cause compatibility issues. #24326
    • The following bug fixes change execution results, which might cause upgrade incompatibilities:
      • Fix the issue that greatest(datetime) union null returns empty string #26532
      • Fix the issue that the having clause might not work correctly #26496
      • Fix the wrong execution results that occur when the collations around the between expression are different #27146
      • Fix the result wrong that occurs when the argument of the extract function is a negative duration #27236
      • Fix the wrong execution results that occur when the column in the group_concat function has a non-bin collation #27429
      • Fix the issue that column information is missed when converting the Apply operator to Join #27233
      • Fix the issue of unexpected behavior when casting the invalid string to DATE #26762
      • Fix a bug that the count distinct result on multiple columns is wrong when the new collation is enabled #27091

Feature enhancement

  • TiKV

    • Support changing TiCDC configurations dynamically #10645

Improvements

  • TiDB

    • Trigger auto-analyze based on the histogram row count #24237
  • TiKV

    • Handle read ready and write ready separately to reduce read latency #10475
    • The slow log of TiKV coprocessor only considers the time spent on processing requests. #10841
    • Drop log instead of blocking threads when the slogger thread is overloaded and the queue is filled up #10841
    • Reduce the size of Resolved TS messages to save network bandwidth #2448
  • PD

    • Improve the performance of synchronizing Region information between PDs #3932
  • Tools

    • Backup & Restore (BR)

      • Split and scatter Regions concurrently to improve restore speed #1363
      • Retry BR tasks when encountering the PD request error or the TiKV I/O timeout error #27787
      • Reduce empty Regions when restoring many small tables to avoid affecting cluster operations after the restore #1374
      • Perform the rebase auto id operation while creating tables, which saves the separate rebase auto id DDL operation and speeds up restore #1424
    • Dumpling

      • Filter the skipped databases before getting the table information to improve the filtering efficiency of SHOW TABLE STATUS #337
      • Use SHOW FULL TABLES to get table information for tables to be exported, because SHOW TABLE STATUS cannot work properly in some MySQL versions #322
      • Support backing up MySQL-compatible databases that do not support the START TRANSACTION ... WITH CONSISTENT SNAPSHOT or the SHOW CREATE TABLE syntax #309
      • Refine the Dumpling warning log to avoid the misleading information that a dump fails #340
    • TiDB Lightning

      • Support importing data into tables that have expression index or the index that depends on virtual generated columns #1404
    • TiCDC

      • Always pulls old values from TiKV internally to improve usability #2397
      • Reduce the goroutine usage when a table's Regions are all transferred away from a TiKV node #2284
      • Optimize workerpool for fewer goroutines when concurrency is high #2211
      • Execute DDL statements asynchronously to avoid affecting other changefeeds #2295
      • Add a global gRPC connection pool and share gRPC connections among KV clients #2531
      • Fail fast for unrecoverable DML errors #1724
      • Optimize memory management when the Unified Sorter is using memory to sort data #2553
      • Add Prometheus metrics for DDL executions #2595 #2669
      • Prohibit operating TiCDC clusters across major or minor versions #2601
      • Remove file sorter #2325
      • Clean up changefeed metrics when a changefeed is removed, and clean up processor metrics when a processor exits #2156
      • Optimize the lock-resolving algorithm after a Region is initialized #2188

Bug fixes

  • TiDB

    • Fix a bug that collation is incorrectly set for binary literals when building ranges #23672

    • Fix the "index out of range" error that occurs when a query includes both GROUP BY and UNION #26553

    • Fix the issue that TiDB might fail to send requests if TiKV has tombstone stores #23676 #24648

    • Remove the undocumented /debug/sub-optimal-plan HTTP API #27264

    • Fix the issue of wrong character set and collation for the case when expression #26662

  • TiKV

    • Fix the issue that BR reports the "file already exists" error when TDE is enabled during data restore #1179
    • Fix the potential disk full issue caused by corrupted snapshot files #10813
    • Fix the issue that TiKV deletes stale Regions too frequently #10680
    • Fix the issue that TiKV frequently reconnects the PD client #9690
    • Check stale file information from the encryption file dictionary #9115
  • PD

    • Fix the issue that PD does not fix the down peers in time #4077
    • Fix a bug that PD might panic when scaling out TiKV #3868
  • TiFlash

    • Fix the potential issue of data inconsistency that occurs when TiFlash is deployed on multiple disks
    • Fix a bug of incorrect results that occurs when queries contain filters like CONSTANT, <, <=, >, >=, or COLUMN
    • Fix the issue that the store size in metrics is inaccurate under heavy writing
    • Fix a potential bug that TiFlash cannot restore data when deployed on multiple disks
    • Fix the potential issue that TiFlash cannot garbage-collect the delta data after running for a long time
  • Tools

    • Backup & Restore (BR)

      • Fix a bug that the average speed is inaccurately calculated for backup and restore #1405
    • TiCDC

      • Fix the ErrSchemaStorageTableMiss error that occurs when the DDL Job duplication is encountered in the integrated test #2422
      • Fix a bug that a changefeed cannot be removed if the ErrGCTTLExceeded error occurs #2391
      • Fix the issue that outdated capture might appear in the output of the capture list command #2388
      • Fix the deadlock issue in the TiCDC processor #2017
      • Fix a data inconsistency issue that occurs because multiple processors might write data to the same table when this table is being re-scheduled #2230
      • Fix a bug that the EtcdWorker snapshot isolation is violated in metadata management #2557
      • Fix the issue that the changefeed cannot be stopped due to the DDL sink error #2552
      • Fix the issue of TiCDC Open Protocol: TiCDC outputs an empty value when there is no change in a transaction #2612
      • Fix a bug that causes TiCDC to panic on the unsigned TINYINT type #2648
      • Decrease the gRPC window size to avoid the OOM that occurs when TiCDC captures too many Regions #2202
      • Fix the OOM issue that occurs when TiCDC captures too many Regions #2673
      • Fix the issue of process panic that occurs when encoding the data types such as mysql.TypeString, mysql.TypeVarString, mysql.TypeVarchar into JSON #2758
      • Fix the a memory leak issue that might occur when creating a new changefeed #2389
      • Fix a bug that DDL handling fails when a changefeed starts at the finish TS of a schema change #2603
      • Fix the issue of potential DDL loss when the owner crashes when executing DDL statements #1260
      • Fix the issue of insecure concurrent access to the map in SinkManager #2298
Was this page helpful?