tidb report error: [tikv:8141]assertion failed
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Bug Report
Please answer these questions before submitting your issue. Thanks!
### 1. Minimal reproduce step (Required)
It's a internal endless case, you can find logs of all compomemts on internal tcms system with execution id(executions/plan/7795565)
### 2. What did you expect to see? (Required)
insert ok
### 3. What did you see instead (Required)
report error:
```
./tidb.log.1:[2025/06/10 14:55:56.714 +08:00] [INFO] [conn.go:1191] ["command dispatched failed"] [conn=3793759340] [session_alias=] [connInfo="id:3793759340, addr:10.200.38.217:43844 status:10, collation:utf8mb4_general_ci, user:root"] [command=Query] [status="inTxn:0, autocommit:1"] [sql="update dwm_yl_rt_ssmx_bill_detail set package_code=\"b8eGLsFmze1DJFVL93A8\",transfer_code=\"e288R0ecCEmfU45duSJ9\",latest_next_station_name=\"zM7qVojTp4o4RV9iIVSj\",latest_next_station_code=\"Swmx4rnhJ8a6zguDZSmG\",pick_network_code=\"WEzUcPK1sXuZ8BLnfqB5\",pick_network_name=\"WjQLXF1BSoK0HyuIi8nM\",pick_agent_code=\"ClX6yxPK2jAaAX3ZbhPG\",pick_agent_name=\"ulZuFWCoF5gxgoprUdGk\",pick_franchisee_code=\"QqZSKIxeAZa6ZbblVNyD\",pick_franchisee_name=\"E7B07Foa09yKOCDprMhE\",pick_date=\"xp8TNFNdp8E0lU226ImL\",latest_scan_date=\"2023-02-23 0:22:22\",latest_scan_type=21,latest_scan_code=\"hQFMqLfIg1c9T2oi50O3\",latest_scan_name=\"X6VZqoNkMznd7BaHVkhV\",latest_scan_agent_code=\"RHYitkOvPxWAEgzd4NEg\",latest_scan_agent_name=\"GYKXYV5i4s6dUQLxqY2E\",latest_scan_franchisee_code=\"3B9zMipctVdN04HgzhFJ\",latest_scan_franchisee_name=\"RAF1YyQqqTOMQBCjLd0e\",latest_scan_user_code=\"TAHNFVgzZS4yZUjALpzq\",latest_scan_user_name=\"NYgbw60Z9uJCKVQ9qpE5\",customer_code=\"7Dgg0XJObvwAIYMwNC3J\",customer_name=\"61FgbSM23eF93SOue6m7\",liable_network_type=1,liable_network_name=\"nt2\",liable_network_code=\"c6\",liable_agent_name=\"xfx2GPBGBSctqsBJ8gC4\",liable_agent_code=\"eIy5eMSinuwfsTgkVbf8\",liable_franchisee_name=\"EKM6BgM3XcRCrlSM3S1G\",liable_franchisee_code=\"9NVCSDXhMGbzeboybMhH\",difficult_info=\"RJAQZKAKMS8qPi1OCGQEG4jRjwMedTGQy82JSLewtlv0sfkYMeAn0cXc9kvpEczGuEOSX882l41J0Z2mdb2RzMOgyLgZUpeIF2RP\",not_valid=2,package_inside_charge_weight=\"0Y6vUjQ9nZumBzOtSNi3\",goods_name=\"OVOAJmSk43Gy5Bl2zCFd\",goods_type=\"z6Kx8JnMeuO4AVvgv0x58sDQZcyawfYnxhGKpAk8RW8Rzmp3lutpfM942KQvTrBL4XR4V6gFBDP5iWeerOmuuEmadIsldmTYCv6USRlffJM0SX9FBGwwMweies2TRAIcRHWcWHNkW14qillJe3i7aofDe7WvZTgmhuExOp3fD4idhsleiv537PEY6Rw3eJGjUEorerEr\" where bill_code='9880956_bill_9880956'"] [txn_mode=PESSIMISTIC] [timestamp=458631035406516248] [err="[tikv:8141]assertion failed: key: 7480000000000000745f698000000000000002015878797357374f30ff4d58733439413850ff595a334c00000000fb038000000077cad8240178446d456876306aff61465048496d7556ff7049583900000000fb038000000000971cd3, assertion: Exist, start_ts: 458631035406516248, existing start ts: 0, existing commit ts: 0\ngithub.com/pingcap/errors.(*Error).GenWithStackByArgs\n\t/root/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20250523034308-74f78ae071ee/normalize.go:177\ngithub.com/pingcap/tidb/pkg/session.(*session).handleAssertionFailure\n\t/workspace/source/tidb/pkg/session/session.go:612\ngithub.com/pingcap/tidb/pkg/session.(*session).doCommit\n\t/workspace/source/tidb/pkg/session/session.go:555\ngithub.com/pingcap/tidb/pkg/session.(*session).doCommitWithRetry\n\t/workspace/source/tidb/pkg/session/session.go:795\ngithub.com/pingcap/tidb/pkg/session.(*session).CommitTxn\n\t/workspace/source/tidb/pkg/session/session.go:926\ngithub.com/pingcap/tidb/pkg/session.autoCommitAfterStmt\n\t/workspace/source/tidb/pkg/session/tidb.go:278\ngithub.com/pingcap/tidb/pkg/session.finishStmt\n\t/workspace/source/tidb/pkg/session/tidb.go:240\ngithub.com/pingcap/tidb/pkg/session.runStmt\n\t/workspace/source/tidb/pkg/session/session.go:2369\ngithub.com/pingcap/tidb/pkg/session.(*session).ExecuteStmt\n\t/workspace/source/tidb/pkg/session/session.go:2200\ngithub.com/pingcap/tidb/pkg/server.(*TiDBContext).ExecuteStmt\n\t/workspace/source/tidb/pkg/server/driver_tidb.go:291\ngithub.com/pingcap/tidb/pkg/server.(*clientConn).handleStmt\n\t/workspace/source/tidb/pkg/server/conn.go:2041\ngithub.com/pingcap/tidb/pkg/server.(*clientConn).handleQuery\n\t/workspace/source/tidb/pkg/server/conn.go:1795\ngithub.com/pingcap/tidb/pkg/server.(*clientConn).dispatch\n\t/workspace/source/tidb/pkg/server/conn.go:1385\ngithub.com/pingcap/tidb/pkg/server.(*clientConn).Run\n\t/workspace/source/tidb/pkg/server/conn.go:1154\ngithub.com/pingcap/tidb/pkg/server.(*Server).onConn\n\t/workspace/source/tidb/pkg/server/server.go:740\nruntime.goexit\n\t/root/go/pkg/mod/golang.org/toolchain@v0.0.1-go1.23.10.linux-amd64/src/runtime/asm_amd64.s:1700"]
```
### 4. What is your TiDB version? (Required)
v9.0.0-beta.1.pre-907-g7049b68
7049b68ff933b6c3ee17511238ccb3b53f663bc6
Contributor guide
Assessment
This issue has not been assessed yet.