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 report] 'ndbinfo','performance_schema','FEDERATED' engines are not supported in Gravitino MySQL catalog #5100

Closed
danhuawang opened this issue Oct 11, 2024 · 3 comments · Fixed by #6209
Assignees
Labels
0.8.0 Release v0.8.0 bug Something isn't working improvement Improvements on everything

Comments

@danhuawang
Copy link
Contributor

Version

main branch

Describe what's wrong

Some engines listed in the table are not support
https://gravitino.apache.org/docs/0.6.0-incubating/jdbc-mysql-catalog#table-properties

image

Error message and/or stacktrace

'''
"org.apache.gravitino.exceptions.GravitinoRuntimeException: Unknown storage engine 'FEDERATED'",
"\tat org.apache.gravitino.catalog.mysql.converter.MysqlExceptionConverter.toGravitinoException(MysqlExceptionConverter.java:47)",
"\tat org.apache.gravitino.catalog.jdbc.operation.JdbcTableOperations.create(JdbcTableOperations.java:109)",
"\tat org.apache.gravitino.catalog.jdbc.JdbcCatalogOperations.createTable(JdbcCatalogOperations.java:455)",
"\tat org.apache.gravitino.catalog.TableOperationDispatcher.lambda$internalCreateTable$23(TableOperationDispatcher.java:463)",
"\tat org.apache.gravitino.catalog.CatalogManager$CatalogWrapper.lambda$doWithTableOps$1(CatalogManager.java:132)",

'''
'''
[
"org.apache.gravitino.exceptions.GravitinoRuntimeException: Invalid performance_schema usage.",
"\tat org.apache.gravitino.catalog.mysql.converter.MysqlExceptionConverter.toGravitinoException(MysqlExceptionConverter.java:47)",
"\tat org.apache.gravitino.catalog.jdbc.operation.JdbcTableOperations.create(JdbcTableOperations.java:109)",
"\tat org.apache.gravitino.catalog.jdbc.JdbcCatalogOperations.createTable(JdbcCatalogOperations.java:455)",
"\tat org.apache.gravitino.catalog.TableOperationDispatcher.lambda$internalCreateTable$23(TableOperationDispatcher.java:463)",
"\tat org.apache.gravitino.catalog.CatalogManager$CatalogWrapper.lambda$doWithTableOps$1(CatalogManager.java:132)",
"\tat org.apache.gravitino.utils.IsolatedClassLoader.withClassLoader(IsolatedClassLoader.java:86)",
"\tat org.apache.gravitino.catalog.CatalogManager$CatalogWrapper.doWithTableOps(CatalogManager.java:127)",
"\tat org.apache.gravitino.catalog.TableOperationDispatcher.lambda$internalCreateTable$24(TableOperationDispatcher.java:461)",
"\tat org.apache.gravitino.
'''
'''
[
"org.apache.gravitino.exceptions.GravitinoRuntimeException: Unknown storage engine 'FEDERATED'",
"\tat org.apache.gravitino.catalog.mysql.converter.MysqlExceptionConverter.toGravitinoException(MysqlExceptionConverter.java:47)",
"\tat org.apache.gravitino.catalog.jdbc.operation.JdbcTableOperations.create(JdbcTableOperations.java:109)",
"\tat org.apache.gravitino.catalog.jdbc.JdbcCatalogOperations.createTable(JdbcCatalogOperations.java:455)",
"\tat org.apache.gravitino.catalog.TableOperationDispatcher.lambda$internalCreateTable$23(TableOperationDispatcher.java:463)",
"\tat org.apache.gravitino.catalog.CatalogManager$CatalogWrapper.lambda$doWithTableOps$1(CatalogManager.java:132)",
"\tat org.apache.gravitino.utils.IsolatedClassLoader.withClassLoader(IsolatedClassLoader.java:86)",
"\tat org.apache.gravitino.catalog.CatalogManager$CatalogWrapper.doWithTableOps(CatalogManager.java:127)",
"\tat org.apache.gravitino.catalog.TableOperationDispatcher.lambda$internalCreateTable$24(TableOperationDispatcher.java:461)",
"\tat org.apache.gravitino.catalog.OperationDispatcher.doWithCatalog(OperationDispatcher.java:117)",

'''

How to reproduce

N/A

Additional context

No response

@danhuawang danhuawang added the bug Something isn't working label Oct 11, 2024
@yuqi1129
Copy link
Contributor

yuqi1129 commented Oct 11, 2024

@danhuawang

Starting from MySQL 5.5, the FEDERATED engine is installed by default but is not enabled, so you need to enable the FEDERATED engine first.

@jerryshao
Copy link
Contributor

Is this still an issue, @yuqi1129 can you please confirm this and close the issue accordingly?

@jerryshao jerryshao added the 0.8.0 Release v0.8.0 label Jan 10, 2025
@yuqi1129
Copy link
Contributor

confirm this and close the issue accordingly?

Okay, I believe we may need to refine the documents, according tog the details from MySQL documents, there may be different behavior depending on the MySQL version, detailed configuration, and the installed plugin.

@yuqi1129 yuqi1129 added the improvement Improvements on everything label Jan 13, 2025
jerryshao pushed a commit that referenced this issue Jan 13, 2025
…type of MySQL catalog (#6209)

### What changes were proposed in this pull request?

Add more details about the usage of engine type for MySQL catalog. 

### Why are the changes needed?

The value of engine type may be influenced by many factors like MySQL
version, configurations and so on, we need to clarify it.

Fix: #5100 

### Does this PR introduce _any_ user-facing change?

N/A

### How was this patch tested?

N/A
github-actions bot pushed a commit that referenced this issue Jan 13, 2025
…type of MySQL catalog (#6209)

### What changes were proposed in this pull request?

Add more details about the usage of engine type for MySQL catalog. 

### Why are the changes needed?

The value of engine type may be influenced by many factors like MySQL
version, configurations and so on, we need to clarify it.

Fix: #5100 

### Does this PR introduce _any_ user-facing change?

N/A

### How was this patch tested?

N/A
jerryshao pushed a commit that referenced this issue Jan 13, 2025
…type of MySQL catalog (#6213)

### What changes were proposed in this pull request?

Add more details about the usage of engine type for MySQL catalog. 

### Why are the changes needed?

The value of engine type may be influenced by many factors like MySQL
version, configurations and so on, we need to clarify it.

Fix: #5100 

### Does this PR introduce _any_ user-facing change?

N/A

### How was this patch tested?

N/A

Co-authored-by: Qi Yu <[email protected]>
Abyss-lord pushed a commit to Abyss-lord/gravitino that referenced this issue Jan 14, 2025
…ngine type of MySQL catalog (apache#6209)

### What changes were proposed in this pull request?

Add more details about the usage of engine type for MySQL catalog. 

### Why are the changes needed?

The value of engine type may be influenced by many factors like MySQL
version, configurations and so on, we need to clarify it.

Fix: apache#5100 

### Does this PR introduce _any_ user-facing change?

N/A

### How was this patch tested?

N/A
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
0.8.0 Release v0.8.0 bug Something isn't working improvement Improvements on everything
Projects
None yet
3 participants