pingcap / pingcap/ticdc

Meet `Duplicate entry` error in insert-only workload

Open
#1,095 0 comments 0 reactions 1 assignee View on GitHub

@hongyunyan is already working on this.

Since Mar 12, 2025.

Dominant language
Go
Stars
56
Forks
63
Avg merge
2d 20h
Merged PRs (30d)
34

Description

Run the bank2 workload in multi cdc servers, and always can meet the following errors sometimes.

[2025/03/12 09:58:15.371 +00:00] [ERROR] [mysql_writer_dml.go:659] ["execute DMLs with error, can not retry"] [error="Error 1062 (23000): Duplicate entry 'fmdfMTw3jHLAUPHH-1996-05-28-jB0-3013049778761807759' for key 'info.PRIMARY'"] [duration=1.524µs] [query="REPLACE INTO large.info (col_1,col2,col3,col4,col5,col6,col7,col8,col9,col10,col11,col12,col13,col14,col15,col16,col17,col188
,col19,col20,col21,col22,col23,col24,col25,col26,col27,col28,col29,col30,col31,col32,col33,col34,col35,col36,col37,col38,col39,col40,col41,col42,col43,col44,col45,col46,col47,col48,col49,col50,col51,col52,col53,col54,col55,col56,col57,col58,col59,col60,col61,col62,col63,col64,col65,col66,col67,col68,col69,col70,col71,col72,col73,col74,col75,col76,col77,col78,col79,col80,col81,col82,col83,col84,col85,col86,col87,col88,col89,col90,col91,col92,col93,col94,col95,col96,col97,col98,col99,col100,col101,col102,col103,col104,col105,col106,col107,col108,col109) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,"] [count=272] [changefeed=default/test-syncpoint] [2025/03/12 09:58:15.376 +00:00] [ERROR] [mysql_writer_dml.go:659] ["execute DMLs with error, can not retry"] [error="Error 1062 (23000): Duplicate entry 'fKENylGrVJJlIYa0-1988-11-21-7xU-8995966545352310903' for key 'info.PRIMARY'"] [duration=1.419µs] [query="REPLACE INTO large.info (col_1,col2,col3,col4,col5,col6,col7,col8,col9,col10,col11,col12,col13,col14,col15,col16,col17,col188,col19,col20,col21,col22,col23,col24,col25,col26,col27,col28,col29,col30,col31,col32,col33,col34,col35,col36,col37,col38,col39,col40,col41,col42,col43,col44,col45,col46,col47,col48,col49,col50,col51,col52,col53,col54,col55,col56,col57,col58,col59,col60,col61,col62,col63,col64,col65,col66,col67,col68,col69,col70,col71,col72,col73,col74,col75,col76,col77,col78,col79,col80,col81,col82,col83,col84,col85,col86,col87,col88,col89,col90,col91,col92,col93,col94,col95,col96,col97,col98,col99,col100,col101,col102,col103,col104,col105,col106,col107,col108,col109) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,"] [count=286] [changefeed=default/test-syncpoint] [2025/03/12 09:58:15.378 +00:00] [ERROR] [mysql_writer_dml.go:659] ["execute DMLs with error, can not retry"] [error="Error 1062 (23000): Duplicate entry 'fKUZBZdN9fPgd2ZP-2012-05-25-Bch-5684674676093767402' for key 'info.PRIMARY'"] [duration=1.113µs] [query="REPLACE INTO large.info (col_1,col2,col3,col4,col5,col6,col7,col8,col9,col10,col11,col12,col13,col14,col15,col16,col17,col188,col19,col20,col21,col22,col23,col24,col25,col26,col27,col28,col29,col30,col31,col32,col33,col34,col35,col36,col37,col38,col39,col40,col41,col42,col43,col44,col45,col46,col47,col48,col49,col50,col51,col52,col53,col54,col55,col56,col57,col58,col59,col60,col61,col62,col63,col64,col65,col66,col67,col68,col69,col70,col71,col72,col73,col74,col75,col76,col77,col78,col79,col80,col81,col82,col83,col84,col85,col86,col87,col88,col89,col90,col91,col92,col93,col94,col95,col96,col97,col98,col99,col100,col101,col102,col103,col104,col105,col106,col107,col108,col109) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,"] [count=281] [changefeed=default/test-syncpoint]

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.