Error:
statement count 5001 exceeds the transaction limitation, autocommit = false


-- Explanation.
stmt-count-limit
Limit on the maximum number of statements allowed in a TiDB transaction.
Default: 5000
TiDB will return statement count 5001 exceeds the transaction limitation if there is no rollback or commit after more than stmt-count-limit statements in a transaction, autocommit = false error.

-- Solution.
conf/tidb.yml
Modify the file parameters.

 txn_local_latches:
  # Enable local latches for transactions. Enable it when
  # there are lots of conflicts between transactions.
  # enabled: true
  # capacity: 1024000

Method 1: Comment out the parameter enabled: true and set it to false
Method 2: Set the parameter capacity: 1024000 to very

Restart tidb after the parameters are modified.

Read More:

• [Solved] Hadoop Mapreduce Error: GC overhead limit exceeded
• [Solved] kettle Error: GC overhead limit exceeded
• Hive Error: Error: GC overhead limit exceeded
• [Solved] “HttpSendRequest“ failed, Windows error code=12002 andretry limit (0) exceeded for URL
• IDEA Compile Project Error: GC overhead limit exceeded solution
• [Solved] Keil Error: *** ERROR L250: CODE SIZE LIMIT IN RESTRICTED VERSION EXCEEDED
• Impala Find Error: InternalException: Memory limit exceeded: Error occurred on backend
• Idea Error: java: java.lang.OutOfMemoryError: GC overhead limit exceeded
• Tidb-dm Synchronous error: binlog checksum mismatch, data may be corrupted
• How to Solve PageHelper.startPage count Error
• Max virtual memory areas vm.max_map_count [65530] is too low, increase to at least 
• [Solved] Error ‘false‘ undeclared (first use in this function)
• [Solved] PostgreSQL Error: ERROR: CURRENT TRANSACTION IS ABORTED, COMMANDS IGNORED UNTIL END OF TRANSA
• [Solved] Eval Error: Uncaught ReferenceError: False is not defined
• Hive Statement Error During Execution: Error while processing statement: FAILED: Execution Error, return code 2 from o
• [Solved] The “QtRunWork“ task returned false but did not log an error
• [Solved] Segyio Error: Runtime Error trace count inconsistent with file size, trace lengths … #401
• Opencv c++ Read Video Error: capture.isOpened() Return false
• Unity Error: Asset database transaction committed twice!
• Transaction check error during docker CE installation [How to Solve]