TiDB reports "Incorrect time value: '{0 0 0 0 0 0 0}'", followed by a surge in Duration, full load on TiKV, and cluster unavailability

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: TIDB报Incorrect time value: ‘{0 0 0 0 0 0 0}’"后,Duration暴涨,TIVK满载,集群不可用

| username: francislee

Recently, this situation occurs every Saturday at 11 o’clock. I’m wondering if there is a bug in the database?

| username: weixiaobing | Original post link

First, confirm if there are any special scheduled tasks, check the execution of slow queries, etc.

| username: wzf0072 | Original post link

Is there a scheduled task? Monitor the SQL executed during the problematic time period.

| username: 我是咖啡哥 | Original post link

Take a look at the slow SQL page on the Dashboard.

| username: WalterWj | Original post link

IO is a bit high :thinking:, is there any time to truncate many tables?
Have you recently used the lightning local mode to import data?