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]: database level cdc test which include start-ts and end-ts failed #21159

Open
1 task done
heni02 opened this issue Jan 9, 2025 · 1 comment
Open
1 task done
Assignees
Labels
kind/bug Something isn't working phase/testing severity/s0 Extreme impact: Cause the application to break down and seriously affect the use
Milestone

Comments

@heni02
Copy link
Contributor

heni02 commented Jan 9, 2025

Is there an existing issue for the same bug?

  • I have checked the existing issues.

Branch Name

main

Commit ID

1b85136

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

创建pitr的时间(utc时间):
企业微信截图_cd3aa75a-52fd-47e4-b29e-ef1dd93ed3fc

创建database level同步任务指定时间,下游只创建了ddl,但没有收到同步数据:
企业微信截图_a570b744-7437-496d-b507-a6d205e7e387
企业微信截图_b1596015-44dc-4a9e-8724-87931f8206fa

同步时间mo log(创建开始到删除时间:14:28:59-15:01:12)
企业微信截图_24c3409a-0c68-41a7-9fa3-aa757fdcb500
https://shanghai.idc.matrixorigin.cn:30001/explore?panes=%7B%225wK%22:%7B%22datasource%22:%22loki%22,%22queries%22:%5B%7B%22refId%22:%22A%22,%22expr%22:%22%7Bnamespace%3D%5C%22mo-cdc-test%5C%22%7D%20%7C%3D%20%60cdc_database%60%22,%22queryType%22:%22range%22,%22datasource%22:%7B%22type%22:%22loki%22,%22uid%22:%22loki%22%7D,%22editorMode%22:%22builder%22%7D%5D,%22range%22:%7B%22from%22:%221736404138000%22,%22to%22:%221736406120000%22%7D%7D%7D&schemaVersion=1&orgId=1

Expected Behavior

No response

Steps to Reproduce

create  pitr pitr_db for database ac1_db range 24 'h';
./mo_cdc task create --task-name "cdc_database" --source-uri="mysql://ac1:admin:[email protected]:6001" --sink-type="mysql" --sink-uri="mysql://root:xxx@10.222.1.129:3306" --start-ts='2025-01-09 06:00:00' --end-ts='2025-01-09 14:30:00'  --databases="ac1_db:ac1_db_mysql" --level="database"

Additional information

No response

@heni02 heni02 added kind/bug Something isn't working severity/s0 Extreme impact: Cause the application to break down and seriously affect the use labels Jan 9, 2025
@heni02 heni02 added this to the 2.1.0 milestone Jan 9, 2025
@heni02
Copy link
Contributor Author

heni02 commented Jan 9, 2025

试了去掉指定start-ts,end-ts同步database级别到下游是预期的:
./mo_cdc task create --task-name "cdc_database" --source-uri="mysql://ac1:admin:[email protected]:6001" --sink-type="mysql" --sink-uri="mysql://root:[email protected]:3306" --databases="ac1_db:ac1_db_mysql" --level="database"
企业微信截图_091b9084-d123-43e9-8af0-22163625a08b
企业微信截图_733fd1f4-8806-43d4-a3e3-78b612d0c7ab

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
kind/bug Something isn't working phase/testing severity/s0 Extreme impact: Cause the application to break down and seriously affect the use
Projects
None yet
Development

No branches or pull requests

3 participants