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.

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

bug: (Primary/Secondary)Tables that contain secondary indexes cannot be synchronized from the primary database to the secondary database. #1325

Closed
3 tasks done
haitaoguan opened this issue Feb 23, 2023 · 0 comments · Fixed by #1330
Assignees
Labels
A-bug Something isn't working

Comments

@haitaoguan
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

###master
mysql> create table ttt(id int primary key,name varchar(10),key idx_name(name));
Query OK, 0 rows affected (0.01 sec)

mysql> show tables;
+--------------+
| Tables_in_db |
+--------------+
| ttt          |
+--------------+
1 row in set (0.00 sec)


###slave
mysql> show variables like 'sql_mode';
+---------------+----------------------------------------------------------------------------------------------+
| Variable_name | Value                                                                                        |
+---------------+----------------------------------------------------------------------------------------------+
| sql_mode      | STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,MANDATORY_TIANMU,NO_KEY_ERROR |
+---------------+----------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> show tables;
Empty set (0.00 sec)

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!
@haitaoguan haitaoguan added the A-bug Something isn't working label Feb 23, 2023
@konghaiya konghaiya self-assigned this Feb 23, 2023
@konghaiya konghaiya added this to the stonedb_5.7_v1.0.3 milestone Feb 23, 2023
konghaiya added a commit to konghaiya/stonedb that referenced this issue Feb 23, 2023
…neatom#1325)

Modify points:
1. Fix the error of judgment logic
2. Fix the value problem of (sql_mode) in the slave thread
3. Delete the error filtering logic in the binlog logic. These error filtering logic can be controlled by (sql_mode)
konghaiya added a commit to konghaiya/stonedb that referenced this issue Feb 23, 2023
…neatom#1325)

Modify points:
1. Fix the error of judgment logic
2. Fix the value problem of (sql_mode) in the slave thread
3. Delete the error filtering logic in the binlog logic. These error filtering logic can be controlled by (sql_mode)
konghaiya added a commit to konghaiya/stonedb that referenced this issue Feb 23, 2023
…neatom#1325)

Modify points:
1. Fix the error of judgment logic
2. Fix the value problem of (sql_mode) in the slave thread
3. Delete the error filtering logic in the binlog logic. These error filtering logic can be controlled by (sql_mode)
konghaiya added a commit to konghaiya/stonedb that referenced this issue Feb 24, 2023
…neatom#1325)

Modify points:
1. Fix the error of judgment logic
2. Fix the value problem of (sql_mode) in the slave thread
konghaiya added a commit to konghaiya/stonedb that referenced this issue Feb 27, 2023
konghaiya added a commit to konghaiya/stonedb that referenced this issue Feb 27, 2023
@mergify mergify bot closed this as completed in #1330 Feb 28, 2023
mergify bot pushed a commit that referenced this issue Feb 28, 2023
Modify points:
1. Fix the error of judgment logic
2. Fix the value problem of (sql_mode) in the slave thread
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-bug Something isn't working
Projects
Development

Successfully merging a pull request may close this issue.

2 participants