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

未知类型 72 #5391

Open
2 tasks
vipty opened this issue Jan 25, 2025 · 0 comments
Open
2 tasks

未知类型 72 #5391

vipty opened this issue Jan 25, 2025 · 0 comments

Comments

@vipty
Copy link

vipty commented Jan 25, 2025

  • I have searched the issues of this repository and believe that this is not a duplicate.
  • I have checked the FAQ of this repository and believe that this is not a duplicate.

environment

  • canal version
    *1.1.8
  • mysql version
  • polardb 8.0.2.2.27.1

Issue Description

Caused by: java.lang.IllegalArgumentException: unknow type : 72 table : center.tmp_task [{"array":false,"charset":0,"geoType":0,"meta":0,"nullable":false,"pk":false,"type":3,"unsigned":false,"visibility":false},{"array":false,"charset":0,"geoType":0,"meta":0,"nullable":false,"pk":false,"type":1,"unsigned":false,"visibility":false},{"array":false,"charset":0,"geoType":0,"meta":0,"nullable":false,"pk":false,"type":8,"unsigned":false,"visibility":false},{"array":false,"charset":0,"geoType":0,"meta":4,"nullable":false,"pk":false,"type":245,"unsigned":false,"visibility":false},{"array":false,"charset":0,"geoType":0,"meta":0,"nullable":false,"pk":false,"type":18,"unsigned":false,"visibility":false},{"array":false,"charset":0,"geoType":0,"meta":0,"nullable":false,"pk":false,"type":18,"unsigned":false,"visibility":false},{"array":false,"charset":0,"geoType":0,"meta":256,"nullable":false,"pk":false,"type":20,"unsigned":false,"visibility":false}]

Steps to reproduce

CREATE TABLE tmp_task (
plan_time int NOT NULL COMMENT '任务发送时间(以分钟为单位,秒为0)',
task_type tinyint NOT NULL COMMENT '业务类型 ',
index_id bigint NOT NULL DEFAULT '0' COMMENT '状态 0:可写入 其它: 不可写入',
json_data json DEFAULT NULL COMMENT '{"$uk":{"uk":"$uk"}}',
created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (plan_time,task_type,index_id) USING BTREE,
UNIQUE KEY platform_task_uk ((cast(json_extract(json_data,_utf8mb4'$.*.uk') as char(64) array)),task_type) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='任务调度表'
;

Expected behaviour

Actual behaviour

If there is an exception, please attach the exception trace:

Just put your stack trace here!
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

1 participant