You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2021/12/02 08:25:43 UTC
[GitHub] [incubator-doris] hlh5 opened a new issue #7279: [Bug] odbc for mysql occur error
hlh5 opened a new issue #7279:
URL: https://github.com/apache/incubator-doris/issues/7279
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
### Version
0.15.0-rc04
### What's Wrong?
eg:
#1. odbc config
more conf/odbcinst.ini
# Setup from the unixODBC package
[MySQL ODBC 8.0 Driver]
Description = ODBC for MySQL
Driver = /usr/local/lib/libmyodbc8w.so
FileUsage = 1
#2. sql
CREATE EXTERNAL RESOURCE `mysql55`
PROPERTIES (
"type" = "odbc_catalog",
"host" = "192.168.3.121",
"port" = "3306",
"user" = "root",
"password" = "xxx",
"odbc_type" = "mysql",
"driver" = "MySQL ODBC 8.0 Driver"
);
CREATE EXTERNAL TABLE `ext_test` (
`id` int(11) NOT NULL ,
`uid` int(11) DEFAULT NULL,
`ctime` datetime NOT NULL
) ENGINE=ODBC
PROPERTIES (
"odbc_catalog_resource" = "mysql55",
"database" = "hlh",
"table" = "tyy"
);
mysql> select * from ext_test;
ERROR 1064 (HY000): RpcException, msg: io.grpc.StatusRuntimeException: UNAVAILABLE: Network closed for unknown reason
#------------------------------------------------
doris 0.14 is run normal,but upgrade 0.15 encountered above error,then be node would crash
### What You Expected?
odbc for mysql run normal
### How to Reproduce?
eg:
#1. odbc config
more conf/odbcinst.ini
# Setup from the unixODBC package
[MySQL ODBC 8.0 Driver]
Description = ODBC for MySQL
Driver = /usr/local/lib/libmyodbc8w.so
FileUsage = 1
#2. sql
CREATE EXTERNAL RESOURCE `mysql55`
PROPERTIES (
"type" = "odbc_catalog",
"host" = "192.168.3.121",
"port" = "3306",
"user" = "root",
"password" = "xxx",
"odbc_type" = "mysql",
"driver" = "MySQL ODBC 8.0 Driver"
);
CREATE EXTERNAL TABLE `ext_test` (
`id` int(11) NOT NULL ,
`uid` int(11) DEFAULT NULL,
`ctime` datetime NOT NULL
) ENGINE=ODBC
PROPERTIES (
"odbc_catalog_resource" = "mysql55",
"database" = "hlh",
"table" = "tyy"
);
mysql> select * from ext_test;
ERROR 1064 (HY000): RpcException, msg: io.grpc.StatusRuntimeException: UNAVAILABLE: Network closed for unknown reason
#------------------------------------------------
doris 0.14 is run normal,but upgrade 0.15 encountered above error,then be node would crash
### Anything Else?
_No response_
### Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org