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 2022/12/22 13:46:14 UTC
[GitHub] [doris] nextdreamblue opened a new issue, #15301: [Bug] (multi-catalog) close connection when use jdbc.db which table has unsupport type
nextdreamblue opened a new issue, #15301:
URL: https://github.com/apache/doris/issues/15301
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
### Version
master
### What's Wrong?
when use a db of jdbc catalog, if a table of mysql has a column with the type that can not convert to doris data type, will throw a exception and close this session
```
MySQL [test]> use jdbc.default;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MySQL [jdbc.default]> show tables;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 1
Current database: jdbc.default
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 2
Current database: jdbc.default
ERROR 2006 (HY000): MySQL server has gone away
MySQL [jdbc.default]>
```
### What You Expected?
client do not close the connection with doris server.
### How to Reproduce?
create a table with some special type, for example, enum、multipoint、point、multilinestring, that that can not convert to doris data type
create catalog of jdbc, and switch jdbc and use the database has the above table.
### Anything Else?
_No response_
### Are you willing to submit PR?
- [X] 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.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
[GitHub] [doris] nextdreamblue commented on issue #15301: [Bug] (multi-catalog) close connection when use jdbc.db which table has unsupport type
Posted by GitBox <gi...@apache.org>.
nextdreamblue commented on issue #15301:
URL: https://github.com/apache/doris/issues/15301#issuecomment-1362865444
其实这个问题大概有两种解法，
一种是把所有特殊的mysql类型都转为text类型，即获取schema的时候不抛出来异常
还有一种是走COM_FIELD_LIST这个协议类型的时候，不把异常抛到最外层，不去执行mysqlChannel.close()，关闭连接
目前采用的第二种方法
--
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
[GitHub] [doris] nextdreamblue closed issue #15301: [Bug] (multi-catalog) close connection when use jdbc.db which table has unsupport type
Posted by GitBox <gi...@apache.org>.
nextdreamblue closed issue #15301: [Bug] (multi-catalog) close connection when use jdbc.db which table has unsupport type
URL: https://github.com/apache/doris/issues/15301
--
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