Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

bug: Master slave synchronization - Primary key conflict problem #819

Closed
2 of 3 tasks
konghaiya opened this issue Oct 26, 2022 · 0 comments
Closed
2 of 3 tasks

bug: Master slave synchronization - Primary key conflict problem #819

konghaiya opened this issue Oct 26, 2022 · 0 comments
Assignees
@konghaiya
Labels
A-bug Something isn't working prio: high High priority
Milestone
StoneDB_5.7_v1.0.2

Comments

@konghaiya
Copy link
Collaborator

Have you read the Contributing Guidelines on issues?

Please confirm if bug report does NOT exists already ?

  • I confirm there is no existing issue for this

Describe the problem

There will be primary key conflict when modifying data in the case of master slave synchronization

Expected behavior

No response

How To Reproduce

No response

Environment

No response

Are you interested in submitting a PR to solve the problem?

  • Yes, I will!
@konghaiya konghaiya added the A-bug Something isn't working label Oct 26, 2022
@konghaiya konghaiya added this to the stonedb_5.7_v1.0.2 milestone Oct 26, 2022
@konghaiya konghaiya self-assigned this Oct 26, 2022
konghaiya added a commit to konghaiya/stonedb that referenced this issue Oct 26, 2022
@konghaiya
fix(tianm) Fix problems related to master slave synchronization (ston…
2074c1e 
…eatom#819)

fix 1:stoneatom#818 Master slave synchronization - There will be too many tuples problem
Cause:
Tianmu::dbhandler::TianmuHandler::current_position This variable is not initialized. In some cases,
 a large value may cause too many tuples problem.
Solution: Initialize the variable
fix 2:stoneatom#819 Master slave synchronization - Primary key conflict problem
Solution: Modify the modification logic of master slave synchronization,
so that the delete and update operations do not follow the primary key logic
konghaiya added a commit to konghaiya/stonedb that referenced this issue Oct 26, 2022
@konghaiya
fix(tianm) Fix problems related to master slave synchronization (ston…
f22c03a 
…eatom#819)

fix 1:stoneatom#818 Master slave synchronization - There will be too many tuples problem
Cause:
Tianmu::dbhandler::TianmuHandler::current_position This variable is not initialized. In some cases,
 a large value may cause too many tuples problem.
Solution: Initialize the variable
fix 2:stoneatom#819 Master slave synchronization - Primary key conflict problem
Solution: Modify the modification logic of master slave synchronization,
so that the delete and update operations do not follow the primary key logic
@konghaiya konghaiya mentioned this issue Oct 26, 2022
Closed
15 tasks
@RingsC RingsC added the prio: high High priority label Oct 27, 2022
@hustjieke hustjieke moved this to In Progress in StoneDB for MySQL 5.7 Oct 27, 2022
@shangyanwen shangyanwen mentioned this issue Oct 31, 2022
Closed
3 tasks
konghaiya added a commit to konghaiya/stonedb that referenced this issue Oct 31, 2022
@konghaiya
fix(tianm): fix problems related to master slave synchronization (sto…
ff20667 
…neatom#819)

1. sql/sql_insert.cc Fix the problem that the insert statement will not generate binlog in the delayed insert mode
2. storage/tianmu/handler/tianmu_handler.cpp Fix the binlog error of the line format generated by the tianmu engine
konghaiya added a commit to konghaiya/stonedb that referenced this issue Oct 31, 2022
@konghaiya
fix(tianm): fix problems related to master slave synchronization (sto…
29065de 
…neatom#819)

1. sql/sql_insert.cc Fix the problem that the insert statement will not generate binlog in the delayed insert mode
2. storage/tianmu/handler/tianmu_handler.cpp Fix the binlog error of the line format generated by the tianmu engine
konghaiya added a commit to konghaiya/stonedb that referenced this issue Oct 31, 2022
@konghaiya
fix(tianm): fix problems related to master slave synchronization (sto…
8d32f51 
…neatom#819)

1. sql/sql_insert.cc Fix the problem that the insert statement will not generate binlog in the delayed insert mode
2. storage/tianmu/handler/tianmu_handler.cpp Fix the binlog error of the line format generated by the tianmu engine
konghaiya added a commit to konghaiya/stonedb that referenced this issue Oct 31, 2022
@konghaiya
fix(tianm): fix problems related to master slave synchronization (sto…
64dd1b6 
…neatom#819)

fix 1:stoneatom#818 Master slave synchronization - There will be too many tuples problem

Cause:
Tianmu::dbhandler::TianmuHandler::current_position This variable is not initialized. In some cases,
a large value may cause too many tuples problem.
Solution: Initialize the variable

fix 2:stoneatom#819 Master slave synchronization - Primary key conflict problem

Solution: Modify the modification logic of master slave synchronization, so that the delete and update operations do not follow the primary key logic

Supplement

sql/sql_insert.cc
Fix the problem that the insert statement will not generate binlog in the delayed insert mode
storage/tianmu/handler/tianmu_handler.cpp
Fix the binlog error of the line format generated by the tianmu engine
@konghaiya konghaiya mentioned this issue Oct 31, 2022
Closed
15 tasks
konghaiya added a commit to konghaiya/stonedb that referenced this issue Nov 1, 2022
@konghaiya
fix(tianm): fix problems related to master slave synchronization (sto…
833a8da 
…neatom#819)

fix 1:stoneatom#818 Master slave synchronization - There will be too many tuples problem

Cause:
Tianmu::dbhandler::TianmuHandler::current_position This variable is not initialized. In some cases,
a large value may cause too many tuples problem.
Solution: Initialize the variable

fix 2:stoneatom#819 Master slave synchronization - Primary key conflict problem

Solution: Modify the modification logic of master slave synchronization, so that the delete and update operations do not follow the primary key logic

Supplement

sql/sql_insert.cc
Fix the problem that the insert statement will not generate binlog in the delayed insert mode
storage/tianmu/handler/tianmu_handler.cpp
Fix the binlog error of the line format generated by the tianmu engine
konghaiya added a commit to konghaiya/stonedb that referenced this issue Nov 2, 2022
@konghaiya
fix(tianm): fix problems related to master slave synchronization (sto…
5445dd0 
…neatom#819)

fix 1:stoneatom#818 Master slave synchronization - There will be too many tuples problem

Cause:
Tianmu::dbhandler::TianmuHandler::current_position This variable is not initialized. In some cases,
a large value may cause too many tuples problem.
Solution: Initialize the variable

fix 2:stoneatom#819 Master slave synchronization - Primary key conflict problem

Solution: Modify the modification logic of master slave synchronization, so that the delete and update operations do not follow the primary key logic

Supplement

sql/sql_insert.cc
Fix the problem that the insert statement will not generate binlog in the delayed insert mode
storage/tianmu/handler/tianmu_handler.cpp
Fix the binlog error of the line format generated by the tianmu engine
@konghaiya konghaiya mentioned this issue Nov 2, 2022
Merged
15 tasks
konghaiya added a commit to konghaiya/stonedb that referenced this issue Nov 2, 2022
@konghaiya
fix(tianm): fix problems related to master slave synchronization (sto…
4eb5bf5 
…neatom#819)

fix 1:stoneatom#818 Master slave synchronization - There will be too many tuples problem

Cause:
Tianmu::dbhandler::TianmuHandler::current_position This variable is not initialized. In some cases,
a large value may cause too many tuples problem.
Solution: Initialize the variable

fix 2:stoneatom#819 Master slave synchronization - Primary key conflict problem

Solution: Modify the modification logic of master slave synchronization, so that the delete and update operations do not follow the primary key logic

Supplement

sql/sql_insert.cc
Fix the problem that the insert statement will not generate binlog in the delayed insert mode
storage/tianmu/handler/tianmu_handler.cpp
Fix the binlog error of the line format generated by the tianmu engine
konghaiya added a commit to konghaiya/stonedb that referenced this issue Nov 2, 2022
@konghaiya
fix(tianm): fix problems related to master slave synchronization (sto…
e77fea1 
…neatom#819)

fix 1:stoneatom#818 Master slave synchronization - There will be too many tuples problem

Cause:
Tianmu::dbhandler::TianmuHandler::current_position This variable is not initialized. In some cases,
a large value may cause too many tuples problem.
Solution: Initialize the variable

fix 2:stoneatom#819 Master slave synchronization - Primary key conflict problem

Solution: Modify the modification logic of master slave synchronization, so that the delete and update operations do not follow the primary key logic

Supplement

sql/sql_insert.cc
Fix the problem that the insert statement will not generate binlog in the delayed insert mode
storage/tianmu/handler/tianmu_handler.cpp
Fix the binlog error of the line format generated by the tianmu engine
konghaiya added a commit to konghaiya/stonedb that referenced this issue Nov 3, 2022
@konghaiya
fix(tianm): fix problems related to master slave synchronization (sto…
aad61f7 
…neatom#819)

fix 1:stoneatom#818 Master slave synchronization - There will be too many tuples problem

Cause:
Tianmu::dbhandler::TianmuHandler::current_position This variable is not initialized. In some cases,
a large value may cause too many tuples problem.
Solution: Initialize the variable

fix 2:stoneatom#819 Master slave synchronization - Primary key conflict problem

Solution: Modify the modification logic of master slave synchronization, so that the delete and update operations do not follow the primary key logic

Supplement

sql/sql_insert.cc
Fix the problem that the insert statement will not generate binlog in the delayed insert mode
storage/tianmu/handler/tianmu_handler.cpp
Fix the binlog error of the line format generated by the tianmu engine
konghaiya added a commit to konghaiya/stonedb that referenced this issue Nov 3, 2022
@konghaiya
fix(tianm): fix problems related to master slave synchronization (sto…
25cf2b1 
…neatom#819)

fix 1:stoneatom#818 Master slave synchronization - There will be too many tuples problem

Cause:
Tianmu::dbhandler::TianmuHandler::current_position This variable is not initialized. In some cases,
a large value may cause too many tuples problem.
Solution: Initialize the variable

fix 2:stoneatom#819 Master slave synchronization - Primary key conflict problem

Solution: Modify the modification logic of master slave synchronization, so that the delete and update operations do not follow the primary key logic

Supplement

sql/sql_insert.cc
Fix the problem that the insert statement will not generate binlog in the delayed insert mode
storage/tianmu/handler/tianmu_handler.cpp
Fix the binlog error of the line format generated by the tianmu engine
konghaiya added a commit to konghaiya/stonedb that referenced this issue Nov 3, 2022
@konghaiya
fix(tianmu): fix problems related to master slave synchronization (st…
d00a3fb 
…oneatom#819)

fix 1:stoneatom#818 Master slave synchronization - There will be too many tuples problem

Cause:
Tianmu::dbhandler::TianmuHandler::current_position This variable is not initialized. In some cases,
a large value may cause too many tuples problem.
Solution: Initialize the variable

fix 2:stoneatom#819 Master slave synchronization - Primary key conflict problem

Solution: Modify the modification logic of master slave synchronization, so that the delete and update operations do not follow the primary key logic

Supplement

sql/sql_insert.cc
Fix the problem that the insert statement will not generate binlog in the delayed insert mode
storage/tianmu/handler/tianmu_handler.cpp
Fix the binlog error of the line format generated by the tianmu engine
konghaiya added a commit to konghaiya/stonedb that referenced this issue Nov 3, 2022
@konghaiya
fix(tianmu): fix problems related to master slave synchronization (st…
2c8d24a 
…oneatom#819)

fix 1:stoneatom#818 Master slave synchronization - There will be too many tuples problem

Cause:
Tianmu::dbhandler::TianmuHandler::current_position This variable is not initialized. In some cases,
a large value may cause too many tuples problem.
Solution: Initialize the variable

fix 2:stoneatom#819 Master slave synchronization - Primary key conflict problem

Solution: Modify the modification logic of master slave synchronization, so that the delete and update operations do not follow the primary key logic

Supplement

sql/sql_insert.cc
Fix the problem that the insert statement will not generate binlog in the delayed insert mode
storage/tianmu/handler/tianmu_handler.cpp
Fix the binlog error of the line format generated by the tianmu engine
konghaiya added a commit to konghaiya/stonedb that referenced this issue Nov 3, 2022
@konghaiya
fix(tianmu): fix problems related to master slave synchronization (st…
04da0c4 
…oneatom#819)

fix 1:stoneatom#818 Master slave synchronization - There will be too many tuples problem

Cause:
Tianmu::dbhandler::TianmuHandler::current_position This variable is not initialized. In some cases,
a large value may cause too many tuples problem.
Solution: Initialize the variable

fix 2:stoneatom#819 Master slave synchronization - Primary key conflict problem

Solution: Modify the modification logic of master slave synchronization, so that the delete and update operations do not follow the primary key logic

Supplement

sql/sql_insert.cc
Fix the problem that the insert statement will not generate binlog in the delayed insert mode
storage/tianmu/handler/tianmu_handler.cpp
Fix the binlog error of the line format generated by the tianmu engine
konghaiya added a commit to konghaiya/stonedb that referenced this issue Nov 3, 2022
@konghaiya
fix(tianmu): fix problems related to master slave synchronization (st…
bacd9a7 
…oneatom#819)

fix 1:stoneatom#818 Master slave synchronization - There will be too many tuples problem

Cause:
Tianmu::dbhandler::TianmuHandler::current_position This variable is not initialized. In some cases,
a large value may cause too many tuples problem.
Solution: Initialize the variable

fix 2:stoneatom#819 Master slave synchronization - Primary key conflict problem

Solution: Modify the modification logic of master slave synchronization, so that the delete and update operations do not follow the primary key logic

Supplement

sql/sql_insert.cc
Fix the problem that the insert statement will not generate binlog in the delayed insert mode
storage/tianmu/handler/tianmu_handler.cpp
Fix the binlog error of the line format generated by the tianmu engine
mergify bot pushed a commit that referenced this issue Nov 3, 2022
@konghaiya @mergify
fix(tianmu): fix problems related to master slave synchronization (#819)
ca2d68f 
fix 1:#818 Master slave synchronization - There will be too many tuples problem

Cause:
Tianmu::dbhandler::TianmuHandler::current_position This variable is not initialized. In some cases,
a large value may cause too many tuples problem.
Solution: Initialize the variable

fix 2:#819 Master slave synchronization - Primary key conflict problem

Solution: Modify the modification logic of master slave synchronization, so that the delete and update operations do not follow the primary key logic

Supplement

sql/sql_insert.cc
Fix the problem that the insert statement will not generate binlog in the delayed insert mode
storage/tianmu/handler/tianmu_handler.cpp
Fix the binlog error of the line format generated by the tianmu engine
Repository owner moved this from In Progress to Done in StoneDB for MySQL 5.7 Nov 4, 2022
@hustjieke hustjieke mentioned this issue May 5, 2023
Closed
hustjieke added a commit to hustjieke/stonedb-8.0.30-upgrade that referenced this issue May 24, 2023
@hustjieke
fix(tianmu): disable primary key as tianmu engine did not support well
b5fde13 
[summary]
fix 1:stoneatom#818 Master slave synchronization - There will be too many tuples problem

Cause:
Tianmu::dbhandler::TianmuHandler::current_position This variable is not initialized. In some cases,
a large value may cause too many tuples problem.
Solution: Initialize the variable

fix 2:stoneatom#819 Master slave synchronization - Primary key conflict problem

Solution: Modify the modification logic of master slave synchronization, so that the delete and update operations do not follow the primary key logic

Supplement

sql/sql_insert.cc
Fix the problem that the insert statement will not generate binlog in the delayed insert mode
storage/tianmu/handler/tianmu_handler.cpp
Fix the binlog error of the line format generated by the tianmu engine
@hustjieke hustjieke mentioned this issue May 24, 2023
Merged
14 tasks
hustjieke added a commit that referenced this issue May 25, 2023
@hustjieke
fix(tianmu): disable primary key as tianmu engine did not support well
0ebbd11 
[summary]
fix 1:#818 Master slave synchronization - There will be too many tuples problem

Cause:
Tianmu::dbhandler::TianmuHandler::current_position This variable is not initialized. In some cases,
a large value may cause too many tuples problem.
Solution: Initialize the variable

fix 2:#819 Master slave synchronization - Primary key conflict problem

Solution: Modify the modification logic of master slave synchronization, so that the delete and update operations do not follow the primary key logic

Supplement

sql/sql_insert.cc
Fix the problem that the insert statement will not generate binlog in the delayed insert mode
storage/tianmu/handler/tianmu_handler.cpp
Fix the binlog error of the line format generated by the tianmu engine
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@konghaiya konghaiya

Labels
A-bug Something isn't working prio: high High priority
Projects
StoneDB for MySQL 5.7
Status: Done
Milestone
StoneDB_5.7_v1.0.2
2 participants
@RingsC @konghaiya