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.

Sign up for GitHub

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

Jump to bottom

[Bug][TubeMQ] In MySQL 5.7 initialize the database failure: Unknown collation 'utf8mb4_0900_ai_ci' #5087

Closed
2 tasks done
haibo-duan opened this issue Jul 17, 2022 · 1 comment · Fixed by #5089
Closed
2 tasks done

[Bug][TubeMQ] In MySQL 5.7 initialize the database failure: Unknown collation 'utf8mb4_0900_ai_ci' #5087

haibo-duan opened this issue Jul 17, 2022 · 1 comment · Fixed by #5089
Assignees
@haibo-duan
Labels
component/tubemq type/bug Something is wrong
Milestone
1.3.0

Comments

@haibo-duan
Copy link
Contributor

haibo-duan commented Jul 17, 2022 •
edited

What happened

In MySQL 5.7, I initialize the database through sql/apache_tube_manager.sql in the inlong-tubemq-manager directory. The following error occurred：
image

Mysql5.7 does not support utf8mb4_ 0900_ ai_ Ci.
I read the reference documents：
https://inlong.apache.org/docs/modules/tubemq/tubemq-manager/quick_start
If you want to support MySQL 5.7, utf8mb4_ 0900_ ai_ Ci needs to be deleted from the sql/apache_tube_manager.sql file.

What you expected to happen

no error

How to reproduce

In MySQL 5.7, initialize the database through sql/apache_tube_manager.sql in the inlong manager directory. An error occurred.

Environment

CentOS Linux release 7.9.2009 (Core)
Mysql 5.7.34

InLong version

1.2.0

InLong Component

InLong TubeMQ

Are you willing to submit PR?

  • Yes, I am willing to submit a PR!

Code of Conduct
@haibo-duan haibo-duan added the type/bug Something is wrong label Jul 17, 2022
@github-actions
Copy link

Thanks a lot for opening your first issue with us! 🧡 We'll get back to you shortly! ⏳

@haibo-duan haibo-duan changed the title [Bug][Sort][Manager] In MySQL 5.7 initialize the database failure: Unknown collation 'utf8mb4_0900_ai_ci' [Bug][TubeMQ][Manager] In MySQL 5.7 initialize the database failure: Unknown collation 'utf8mb4_0900_ai_ci' Jul 17, 2022
@haibo-duan haibo-duan mentioned this issue Jul 17, 2022
Merged
1 task
@healchow healchow added this to the 1.3.0 milestone Jul 17, 2022
@healchow healchow changed the title [Bug][TubeMQ][Manager] In MySQL 5.7 initialize the database failure: Unknown collation 'utf8mb4_0900_ai_ci' [Bug][TubeMQ] In MySQL 5.7 initialize the database failure: Unknown collation 'utf8mb4_0900_ai_ci' Jul 17, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@haibo-duan haibo-duan

Labels
component/tubemq type/bug Something is wrong
Projects
None yet
Milestone
1.3.0
Development

Successfully merging a pull request may close this issue.

[INLONG-5087][TubeMQ] Fix initialize the database failure in MySQL 5.7 haibo-duan/inlong
2 participants
@haibo-duan @healchow