Nitin-Kashyap opened a new issue, #30188: URL: https://github.com/apache/doris/issues/30188
### 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 latest/dev ### What's Wrong? Adding JDBC type HMS catalog gives exception ```SQL CREATE CATALOG `test_jdbc_hive` PROPERTIES ( "user" = "hive", "type" = "hms", "password" = "*XXX", "jdbc_url" = "jdbc:postgresql://192.168.65.3:5432/metastore?useSSL=false", "ipc.client.fallback-to-simple-auth-allowed" = "true", "hive.metastore.type" = "jdbc", "driver_url" = "https://doris-build-hk-1308700295.cos.ap-hongkong.myqcloud.com/regression/jdbc_driver/postgresql-42.5.0.jar";, "driver_class" = "org.postgresql.Driver", "create_time" = "2024-01-20 14:45:30.287", "max_pool_size" = "10" ); ```  Exception stack: ```LOG 2024-01-20 20:38:43,893 INFO (Thread-72|144) [ReportHandler.taskReport():554] finished to handle task report from backend 11014, diff task num: 0. cost: 0 ms 2024-01-20 20:38:43,893 INFO (thrift-server-pool-1|155) [ReportHandler.handleReport():199] receive report from be 11014. type: TASK, current queue size: 1 2024-01-20 20:38:48,657 WARN (mysql-nio-pool-1|372) [StmtExecutor.executeByLegacy():845] execute Exception. stmt[7, 5fdb0a9675724e96-bd67e92d0d418ed9] java.lang.IllegalArgumentException: maxActive can't not set zero at com.alibaba.druid.pool.DruidDataSource.setMaxActive(DruidDataSource.java:703) ~[druid-1.2.5.jar:1.2.5] at org.apache.doris.datasource.jdbc.client.JdbcClient.initializeDataSource(JdbcClient.java:140) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.datasource.jdbc.client.JdbcClient.<init>(JdbcClient.java:116) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.datasource.hive.JdbcHMSCachedClient.<init>(JdbcHMSCachedClient.java:33) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.datasource.hive.PostgreSQLJdbcHMSCachedClient.<init>(PostgreSQLJdbcHMSCachedClient.java:60) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.datasource.hive.HMSCachedClientFactory.createCachedClient(HMSCachedClientFactory.java:37) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.datasource.HMSExternalCatalog.initLocalObjectsImpl(HMSExternalCatalog.java:185) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.datasource.ExternalCatalog.initLocalObjects(ExternalCatalog.java:188) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.datasource.ExternalCatalog.makeSureInitialized(ExternalCatalog.java:167) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.datasource.ExternalCatalog.getDbNames(ExternalCatalog.java:354) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.ShowExecutor.handleShowDb(ShowExecutor.java:771) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.ShowExecutor.execute(ShowExecutor.java:279) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.handleShow(StmtExecutor.java:2347) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.executeByLegacy(StmtExecutor.java:813) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:509) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:462) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:245) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.MysqlConnectProcessor.handleQuery(MysqlConnectProcessor.java:166) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.MysqlConnectProcessor.dispatch(MysqlConnectProcessor.java:193) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.MysqlConnectProcessor.processOnce(MysqlConnectProcessor.java:246) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52) ~[doris-fe.jar:1.2-SNAPSHOT] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) ~[?:1.8.0_131] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) ~[?:1.8.0_131] at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_131] 2024-01-20 20:38:50,661 INFO (WorkloadActionPublisher|63) [WorkloadActionPublishThread.runOneCycle():79] no workload action found, skip publish ``` ### What You Expected? Should not give exception ### How to Reproduce? _No response_ ### 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
