[Bug] odbc for mysql occur error

[hlh5]

Search before asking

• I had searched in the issues 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

• I agree to follow this project's Code of Conduct

[JoshTseeee]

I also encountered this problem before, is there any solution？