databasebigdataapache-doris

jdbc catalog query error: Can not connect to jdbc due to error: wait millis 5000, active 10, maxActive 10, creating 0, Catalog


I encountered an error while using Doris. I wanted to use JDBC catalog to connect to another database to perform a query, but the error occurred jdbc catalog query error: Can not connect to jdbc due to error: wait millis 5000, active 10, maxActive 10, creating 0, Catalog.

I encountered an error while using Doris and wanted to use JDBC catalog to connect to another database to perform a query. However, the error occurred. I searched the stack overflow community for some related issues, but there were no related questions. Therefore, I raised a question to see if anyone has encountered it


Solution

  • Jdbc catalog the connection limit is due to 10 by default. You need to modify the maximum number of connections in the connection pool or rebuild the catalog plus this parameter: alter catalog <catalog_name> set properties ('connection_pool_max_size' = '100')

    For details, please refer to the Doris doc post: https://doris.apache.org/docs/lakehouse/database/jdbc?_highlight=connection_pool_max_size#connection-pool-properties