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

When the order of fields in the data table is changed, the binlog log is confused. #905

Open
ccke opened this issue Aug 8, 2024 · 2 comments

Comments

@ccke
Copy link

ccke commented Aug 8, 2024

Hello, when I perform the following steps:

  1. Start canal and monitor table A
  2. Change the field order of table A
  3. Debug binlog to change data and find that data confusion occasionally occurs.

I'm wondering what could be the reason for this? What needs to be done?

@ccke
Copy link
Author

ccke commented Aug 30, 2024

Table schema:
3fda74ce-9df4-40b4-8e06-aa48d1dd0c62

Canal table columns:
366b28a7-d91a-42ba-b446-99baec775cf5

Canal row values:
7be93867-e4d2-4907-898f-da2a61c76c99

@lance6716
Copy link
Collaborator

Change the field order of table A

This is done by a DDL? I think you can check if canal has captured this DDL and invalid the internal table structure. I'm not a user of canal interface, but I think it should be caused by table structure mismatch.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants