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

同步数据到Starrocks报错 Unsupported command(COM_STMT_PREPARE) #279

Open
arcsun opened this issue Apr 12, 2024 · 2 comments
Open

同步数据到Starrocks报错 Unsupported command(COM_STMT_PREPARE) #279

arcsun opened this issue Apr 12, 2024 · 2 comments

Comments

@arcsun
Copy link

arcsun commented Apr 12, 2024

Version:

  • Bifrost Version: 2.3.5
  • Starrocks Version: 3.2.2

Describe the bug

从mysql同步数据到Starrocks,报错:
2024/04/12 19:02:44 mysql getStmt REPLACE_INSERT err: Error 1064: Unsupported command(COM_STMT_PREPARE) REPLACE INTO svnRedmine.YXZ_status_l36 (redmineNumber,root_redmine_id,redmineProject,trackerQA,comment,redmineStatus,redmine_title,author,all_tracker_qa,fixed_version) VALUES (?,?,?,?,?,?,?,?,?,?)
2024/04/12 19:02:44 e: Error 1064: Unsupported command(COM_STMT_PREPARE)

Expected behavior

Starrocks 3.2版本后是支持预准备语句的,但根据文档描述只支持在SELECT语句中使用:
https://docs.starrocks.io/zh/docs/sql-reference/sql-statements/prepared_statement/
希望能适配一个不使用预准备语句的版本

@arcsun
Copy link
Author

arcsun commented Apr 12, 2024

另外虽然页面上提示目标库为Starrocks时可自动建表,实测也是不行的会报错,需要先手动创建好

@liisaxin
Copy link

Version:

  • Bifrost Version: 2.3.5
  • Starrocks Version: 3.2.2

Describe the bug

从mysql同步数据到Starrocks,报错: 2024/04/12 19:02:44 mysql getStmt REPLACE_INSERT err: Error 1064: Unsupported command(COM_STMT_PREPARE) REPLACE INTO svnRedmine.YXZ_status_l36 (redmineNumber,root_redmine_id,redmineProject,trackerQA,comment,redmineStatus,redmine_title,author,all_tracker_qa,fixed_version) VALUES (?,?,?,?,?,?,?,?,?,?) 2024/04/12 19:02:44 e: Error 1064: Unsupported command(COM_STMT_PREPARE)

Expected behavior

Starrocks 3.2版本后是支持预准备语句的,但根据文档描述只支持在SELECT语句中使用: https://docs.starrocks.io/zh/docs/sql-reference/sql-statements/prepared_statement/ 希望能适配一个不使用预准备语句的版本

我也出现类类似问题,估计是starrocks版本3.2支持有问题。

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