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

Create external table not work #4341

Closed
killme2008 opened this issue Jul 10, 2024 · 0 comments · Fixed by #4345
Closed

Create external table not work #4341

killme2008 opened this issue Jul 10, 2024 · 0 comments · Fixed by #4345
Assignees
Labels
C-bug Category Bugs

Comments

@killme2008
Copy link
Contributor

What type of bug is this?

Unexpected error

What subsystems are affected?

Storage Engine

Minimal reproduce step

Following the guide https://docs.greptime.com/user-guide/query-data/query-external-data

mysql> CREATE EXTERNAL TABLE taxi_zone_lookup with (location='/tmp/taxi+_zone_lookup.csv',format='csv');
ERROR 1815 (HY000): Internal error: Internal(1003)

What did you expect to see?

Create table success.

What did you see instead?

Unexpected error.

What operating system did you use?

Not relevant

What version of GreptimeDB did you use?

main branch

Relevant log output and stack trace

2024-07-10T22:15:17.904475Z ERROR on_query{protocol="mysql"}: servers::mysql::writer: Failed to handle mysql query err=0: Failed to execute query, at /Users/dennis/programming/rust/greptimedb/src/servers/src/query_handler/sql.rs:87:49
1: Table operation error, at src/frontend/src/instance.rs:232:14
2: Failed to execute ddl, at /Users/dennis/programming/rust/greptimedb/src/operator/src/statement/ddl.rs:978:14
3: Failed to wait procedure done, at src/common/meta/src/ddl_manager.rs:360:14
4: Failed to execute procedure, at /Users/dennis/programming/rust/greptimedb/src/common/procedure/src/watcher.rs:35:43
5: Failed to execute procedure due to external error
6: Failed to operate on datanode: peer-0(), at src/common/meta/src/ddl/utils.rs:36:27
7: External error, at src/frontend/src/instance/standalone.rs:87:14
8: Operation to region server failed, at src/frontend/src/instance/standalone.rs:69:14
9: Execute gRPC request error, at src/datanode/src/region_server.rs:361:22
10: Region engine file is not registered, at src/datanode/src/region_server.rs:522:22
fuck 0: Failed to execute query, at /Users/dennis/programming/rust/greptimedb/src/servers/src/query_handler/sql.rs:87:49
1: Table operation error, at src/frontend/src/instance.rs:232:14
2: Failed to execute ddl, at /Users/dennis/programming/rust/greptimedb/src/operator/src/statement/ddl.rs:978:14
3: Failed to wait procedure done, at src/common/meta/src/ddl_manager.rs:360:14
4: Failed to execute procedure, at /Users/dennis/programming/rust/greptimedb/src/common/procedure/src/watcher.rs:35:43
5: Failed to execute procedure due to external error
6: Failed to operate on datanode: peer-0(), at src/common/meta/src/ddl/utils.rs:36:27
7: External error, at src/frontend/src/instance/standalone.rs:87:14
8: Operation to region server failed, at src/frontend/src/instance/standalone.rs:69:14
9: Execute gRPC request error, at src/datanode/src/region_server.rs:361:22
10: Region engine file is not registered, at src/datanode/src/region_server.rs:522:22
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-bug Category Bugs
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants